Tns Entry Error

Monish — Sun, 28 Sep 2003 06:29:11 GMT

Hi,

I am getting any error ORA-12505. If I execute tnsping dbname it is successful. but as soon as I try to login it gives the above mentioned error.

Is there anything else that you can highlight to me for testing..

Thanks a ton

regards
monish

Re: Tns Entry Error

Jon Mattatall — Sun, 28 Sep 2003 07:25:50 GMT

Check the obvious first...

tnsnames.ora
listener.ora - Do the Oracle SID's match up?

Do "lsnrctl status listener_name" and "lsnrctl services listener_name" look okay? Is it running?

Are your environment variables ok? ORACLE_HOME, ORACLE_SID, NLS_LANG, etc?

Re: Tns Entry Error

Yogeeraj_1 — Sun, 28 Sep 2003 10:30:00 GMT

hi monish,
*
below a quote from metalink (note: 111910.1 )
*
see if this helps!
*

The SID being supplied by the client in unknown to the listener you are trying
to connect to. To begin troubleshooting, start at the server and issue a lsnrctl stat [listener_name] command. This will display a list of available SIDs. Make sure the instance you want to connect to is shown. If it is not, edit the listener.ora file to include your instance, restart the listener, and retry the operation.
*
On the client, open the TNSNAMES.ORA file and verify the SID in the CONNECT_DATA section of your Net Service Name is correct and matches the SID name on the listener side.
*
If the SID is correct, make sure the HOST in the address section is pointing to the correct server or IP address. If the HOST is pointing to an old address and the listener on the old server is not listening for the sid specified then the connection will fail with an ORA-12505.
*
If the configuration files look correct then you have a pathing problem where the wrong TNSNAMES.ORA file is being picked up. To verify this invoke SqlNet client tracing to level 16*. Check your SqlNet specific documentation for details.
*
Search for the word ï¿½tnsnames.oraï¿½ in the resulting trace file. You'll see where the TNSNAMES.ORA file is being loaded from. If the path is incorrect, either edit that specific TNSNAMES.ORA file or set the TNS_ADMIN* environment variable to point to the location of your configuration files.
*
If you are using a naming adapter other than TNSNAMES, such as Oracle Names or LDAP, generate a level 16 client trace and search for the word CONNECT_DATA. The value of CONNECT_DATA is what the client is using to connect. Make changes if necessary and retry the operation.

*
hope this helps!
*
regards
Yog

Re: Tns Entry Error

Monish — Sun, 28 Sep 2003 20:16:24 GMT

Thank you guys...i will check as specified..

topic Re: Tns Entry Error in Operating System - HP-UX

Tns Entry Error

Re: Tns Entry Error

Re: Tns Entry Error

Re: Tns Entry Error