| TNS:listener does not currently know of service requested in connect [message #418924] |
Wed, 19 August 2009 03:44  |
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....
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
