- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Tns Entry Error
Operating System - HP-UX
1748246
Members
3434
Online
108760
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2003 11:29 PM
тАО09-27-2003 11:29 PM
Tns Entry Error
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
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
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2003 12:25 AM
тАО09-28-2003 12:25 AM
Re: Tns Entry Error
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?
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?
A little knowledge is dangerous - none is absolutely terrifying!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2003 03:30 AM
тАО09-28-2003 03:30 AM
Re: Tns Entry Error
hi monish,
*
below a quote from metalink (note: 111910.1 )
*
see if this helps!
*
*
hope this helps!
*
regards
Yog
*
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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2003 01:16 PM
тАО09-28-2003 01:16 PM
Re: Tns Entry Error
Thank you guys...i will check as specified..
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP