- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Interesting Problem with Oracle
Categories
Company
Local Language
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
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
Community
Resources
Forums
Blogs
- 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
тАО05-03-2002 07:45 AM
тАО05-03-2002 07:45 AM
I am working D class HP9000 machine.
I am able to mount the database,able to start listener.
But when i try to connect with Database user with the tnsnames. It says "tns could not resolve service name"
I checked tnsnames.ora file ...the entries are there for same tnsname.
can somebody guide me ? how should i proceed?
Thanks
Ganesh
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 07:50 AM
тАО05-03-2002 07:50 AM
Re: Interesting Problem with Oracle
I think you are working on the new OS , how is the system able to resolve its name . Do a nslookup
Manoj Srivstava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 07:58 AM
тАО05-03-2002 07:58 AM
Re: Interesting Problem with Oracle
I checked nslookup for host and ip ..its working fine.
I am able to connect for database user without tnsname , but not with tnsname.
how should i do this?
ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:04 AM
тАО05-03-2002 08:04 AM
Re: Interesting Problem with Oracle
Some options:
1) Check the permission of tnsnames.ora file
2) Make sure that your SID is in the tnsnames.ora file
3) Make sure that the listener knows that the SID is in the tnsnames.ora file.
4) If you are using NNM, then there can be a problem while resolving the names. Then you need to edit the file -/home/dba/oracle/product/8.0.6/network/admin/sqlnet.ora - and comment out this line:
NAMES.DEFAULT_DOMAIN
HTH,
Shiju
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:04 AM
тАО05-03-2002 08:04 AM
Re: Interesting Problem with Oracle
can you tell me how should i check that on which IP,database is running as I have to IPs for one NIC in the same machine.
Is this tns error is related to that?
I checked group and and permissions for the unix user from which i was connecting to db ..all are correct.
please guide me.
ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:09 AM
тАО05-03-2002 08:09 AM
Re: Interesting Problem with Oracle
my guess would be just the opposite: you don't have a "sqlnet.ora" file and hence all your TNSnames are too complicated (having some kind of ".something" appended).
So check, wether you have a "sqlnet.ora" in "$ORACLE_HOME/network/admin" or "/etc" ("/etc" wins if both exist!).
HTH,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:16 AM
тАО05-03-2002 08:16 AM
Re: Interesting Problem with Oracle
I check sqlnet.ora file
It is in $ORACLE_HOME\network\admin
but not in \etc
so what next?
ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:41 AM
тАО05-03-2002 08:41 AM
Re: Interesting Problem with Oracle
I ensured that in ENV variables
1.TNS_ADMIN is set to
$ORACLE_HOME/network/admin
2.what about etc? what shall i check for etc?
ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 08:45 AM
тАО05-03-2002 08:45 AM
Re: Interesting Problem with Oracle
I checked for tnsnames.ora file it is only in
$ORACLE_HOME/network/admin directory.
ganesh