- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: TNS:could not resolve service name
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
тАО04-18-2001 07:04 PM
тАО04-18-2001 07:04 PM
TNS:could not resolve service name
There is a Oracle 8 database in the HP-UX server. And I have been trying to access the database from my NB base on Win98. I have all oracle client package installed including Sql*net easy config. and sqlplus,etc. I config the service name with sql*net easy config.which is correct as I can issue the command: tnsping service-name on my NB successfully. The problem is I can't access the database in sqlplus on my NB, I got the error message is: TNS: could not resolve service name. Pls. help.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2001 08:43 PM
тАО04-18-2001 08:43 PM
Re: TNS:could not resolve service name
Another 2 points that have to think about is
1. sqlnet.ora file for db domain.
2. oracle client version
first isolate problem by try sqlplus in db server , if this work , copy tnsnames.ora to NT.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2001 10:30 PM
тАО04-18-2001 10:30 PM
Re: TNS:could not resolve service name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2001 01:24 AM
тАО04-19-2001 01:24 AM
Re: TNS:could not resolve service name
By the way, your tnsnames.ora may be the one causing the problem. So would you be able to send me the sqlnet.log file as well as the tnsnames.ora?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2001 02:20 AM
тАО04-19-2001 02:20 AM
Re: TNS:could not resolve service name
Another thought is that could be something to do with versions or something. Other than that as far as I remember Oracle looks in two places.
1. If the registry key TNS_ADMIN is defined then it will look in that location.
2. Otherwise it will look in the location ORACLE_HOME/network/admin again where ORACLE_HOME is as defined by as the default Oracle Home.
Another option might be to switch on tracing in the sqlnet.ora file. Change the entry from
TRACE_LEVEL_CLIENT = OFF
to
TRACE_LEVEL_CLIENT = ADMIN
That might give you some more info.