Home » Infrastructure » Unix » TNS:listener does not currently know of service requested in connect (Unix)
TNS:listener does not currently know of service requested in connect [message #418924] Wed, 19 August 2009 03:44 Go to next message
Saikirupa
Messages: 10
Registered: August 2009
Junior Member
Hi All,

Oracle 11G server is installed in my local windows machine. I want to access an instance in 11G in one of our unix machines which has ORACLE 10G installation.
I made an entry in tnsnames.ora for facilitating the above said connection.
Entry in tnsnames.ora file
---------------------------
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP Address )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
I did tnsping and the result is :
----------------------------------
tnsping ORCL

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IP Address )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)

But when i tried to connect to one of the schemas in my local machine I am getting the following error :

sqlplus TEST/TEST@ORCL

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
________________________________________________________________

Does it mean that the connection is established but the way i am trying to access is wrong?
Solution please....

Re: TNS:listener does not currently know of service requested in connect [message #418929 is a reply to message #418924] Wed, 19 August 2009 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
HOST = IP Address

Do you really have "IP Address" or do you have a real address which is not localhost?

Regards
Michel
Re: TNS:listener does not currently know of service requested in connect [message #418943 is a reply to message #418929] Wed, 19 August 2009 05:01 Go to previous messageGo to next message
Saikirupa
Messages: 10
Registered: August 2009
Junior Member
I have an IP Address other than local host.

In unix, if i give local host instead of windows IP Address, will it work??
Re: TNS:listener does not currently know of service requested in connect [message #418945 is a reply to message #418943] Wed, 19 August 2009 05:09 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You give the host of the database server.
And check if server is listening for a service named orcl.

Regards
Michel


[Edit: fix typos]

[Updated on: Wed, 19 August 2009 08:40]

Report message to a moderator

Re: TNS:listener does not currently know of service requested in connect [message #418960 is a reply to message #418924] Wed, 19 August 2009 05:54 Go to previous message
Saikirupa
Messages: 10
Registered: August 2009
Junior Member
Problem Solved.

I dint mention the Domain name along with the SID in the tnsnames.ora file.

Michel,

Thanks for your reply.
Previous Topic: HP-UX cdrom - - - Invisible setup file
Next Topic: Input for password in the UNIX Shell script (merged)
Goto Forum:
  


Current Time: Sat Apr 19 13:30:12 CDT 2014

Total time taken to generate the page: 0.05261 seconds