The name orcl.codc182.rqinet.com comes the way you have defined in the initfile.
When you are connecting locally you don't need the service name, you can connect trouble free.
When you do that from remote client/server you have troubles.
In your case the tnsping has identified the host and the the Listener was unable to connect to the database as it cannot recognize the SID thereafter.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Says to set the service_name right (to SID) in TNS file and connect.
Last edited by dbasan; 11-02-2005 at 04:26 PM.
"What is past is PROLOGUE"
Reply With Quote