Quote Originally Posted by dbasan
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.
The database says thats the service name via show parameter service.

However I cannot connect locally if I reference the tnsnames entry.