OraFAQ Forum: Enterprise Manager » ORA - 12514 TNS: could not resolve SERVICE

Home » RDBMS Server » Enterprise Manager » ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179701]

Wed, 28 June 2006 08:16

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

Hello,

I have installed Oracle 9i server as well as client on my Windows XP machine. I created a service name using the Net configuration assitant. But when I perform the test inside the wizard, I am getting following error there:

ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior. The test did not succeed.

Attached also find the error message.

Can any one suggest me any solution for this?

Regards,
Reshma

Attachment: Oracle_Error_Msg.PNG
(Size: 704.74KB, Downloaded 1928 times)

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179702 is a reply to message #179701]

Wed, 28 June 2006 08:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you also configure the listener?

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179707 is a reply to message #179702]

Wed, 28 June 2006 08:24

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

I checked it using Net configuration assitant. The default listener named 'LISTENER' is configured.

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179713 is a reply to message #179707]

Wed, 28 June 2006 08:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

If the listener is started, goto command prompt and type

tnsping your_service_name

Which should return something like this

oracle@mutation#tnsping mutation

TNS Ping Utility for Solaris: Version 9.2.0.4.0 - Production on 28-JUN-2006 09:40:30

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mutation)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mutation)))
OK (2050 msec)

then you can try,

sqlplus username/password@mutation

If nothing works,
edit the sqlnet.ora, comment all entries and try again

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179718 is a reply to message #179701]

Wed, 28 June 2006 08:50

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

I tried it but no luck. Sad

I am getting following responses even though i commented entries in the sqlnet.ora file.

E:\oracle\ora92\bin>tnsping reshma

TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on 28-JUN-20
06 19:13:14

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=reshma))(A
DDRESS=(PROTOCOL=TCP)(HOST=reshma)(PORT=1521)))
OK (110 msec)

E:\oracle\ora92\bin>sqlplus.exe scott/tiger@reshma

SQL*Plus: Release 9.0.1.0.1 - Production on Wed Jun 28 19:13:38 2006

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179723 is a reply to message #179718]

Wed, 28 June 2006 08:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

post your tnsnames.ora entry.
what your ORACLE_SID?

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179727 is a reply to message #179723]

Wed, 28 June 2006 09:02

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

My ORACLE_SID entry is E:\oracle\ora92

My tnsnames.ora file is

####################################
# TNSNAMES.ORA Configuration File:E:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Wed Jun 28 17:44:28 GMT+05:30 2006
####################################

RESHMA.PERSISTENT.CO.IN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = reshma)(PORT = 1521))
    )
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME=reshma))
  )

RESHMA_RESHMA.PERSISTENT.CO.IN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = reshma)(PORT = 1521))
    )
    (CONNECT_DATA = (SERVER = DEDICATED)(SID = reshma))
  )

EXTPROC_CONNECTION_DATA.PERSISTENT.CO.IN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
  )

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora

[Updated on: Wed, 28 June 2006 09:03] by Moderator

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179728 is a reply to message #179727]

Wed, 28 June 2006 09:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Tnsservice names you have created are
RESHMA.PERSISTENT.CO.IN and RESHMA_RESHMA.PERSISTENT.CO.IN.
So you are supposed to use

sqlplus.exe scott/tiger@RESHMA.PERSISTENT.CO.IN
or
sqlplus.exe scott/tiger@RESHMA_RESHMA.PERSISTENT.CO.IN

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179730 is a reply to message #179701]

Wed, 28 June 2006 09:09

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

Sorry no luck

Its giving the same problem.

LOG:

E:\oracle\ora92\bin>sqlplus.exe scott/tiger@RESHMA.PERSISTENT.CO.IN

SQL*Plus: Release 9.0.1.0.1 - Production on Wed Jun 28 19:38:37 2006

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179744 is a reply to message #179730]

Wed, 28 June 2006 09:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> My ORACLE_SID entry is E:\oracle\ora92
That is not right.
did you create the database called RESHMA ?

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179827 is a reply to message #179744]

Wed, 28 June 2006 23:22

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

Hi,

How can I create a database when it not allowing me to login into the session? Do I need to login to Oracle Management Server using the Enterprise Manager Console. Then what is the username/password and the Management Server to which I need to login?

Can you please provide me the list of steps that need to be done?

Thanks and Regards,
Reshma

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179829 is a reply to message #179701]

Wed, 28 June 2006 23:32

reshma_prabhu
Messages: 8
Registered: June 2006

Junior Member

Also If try to start OMS using OEMCTL command I am getting following reply...

E:\oracle\ora92\bin>OEMCTL START OMS
The service name is invalid.

More help is available by typing NET HELPMSG 2185.

Can you please tell me the reason for this? Do I need to install anything else?

Reshma

Report message to a moderator

Re: ORA - 12514 TNS: could not resolve SERVICE_NAME given in connect descriptior [message #179903 is a reply to message #179829]

Thu, 29 June 2006 04:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> How can I create a database when it not allowing me to login into the session?
If you have not yet created a database/instance, then to what are you trying to connect ( in above steps)?
Use DBCA to create database (database configuration assistant).
http://www.examcram2.com/articles/article.asp?p=350920&seqNum=4&rl=1
http://www.oracle.com/pls/db102/portal.portal_db?selected=1

YOu no need to worry about OMS or whatever for now.

Report message to a moderator

Previous Topic:	connot login into oracle managememt server
Next Topic:	jobs are not submitted to Intelligent Agent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 16:47:18 CST 2024