7 replies
by rmrsalisbury
This is an Oracle Names Service error - basically the connect string is not linked to a specific Oracle Listener service via a TNSNAMES.ORA file on the client.
You need to specify on the client the DB alias, protocol, service name and instance name using either SQL*Net EasyConfig or the Oracle Network Manager.
The error is documented in the Oracle Network Products Messages Manual:
ORA-12154 TNS:Could not resolve service name
Cause The service name specified is not defined in the TNSNAMES.ORA file.
Action Make the following checks and correct the error:
? Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.? Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
? Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters.
Any error in a TNSNAMES.ORA file makes it unusable. See Chapter 4 in the SQL*Net Administrator?s Guide. If possible regenerate the configuration files using the Oracle Network Manager.
by ktyfuller
Cause: Net8 could not locate the net service name specified in the tnsnames.ora configuration file.
Actions:
Verify that a tnsnames.ora file exists.
Verify that there are not multiple copies of the tnsnames.ora file.
In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor.
-------------------------------------------
NAMES.DEFAULT_DOMAIN
Purpose:
Sets the domain from which the client most often looks up names resolution requests. When this parameter is set, the default domain name is automatically appended to any unqualified net service name or service name.
For example, if the default domain is set to us.acme.com, the connect string CONNECT scott/tiger@sales gets searched as sales.us.acme.com. If the connect string includes the domain extension, (such as CONNECT scott/tiger@sales.acme.com), the domain is not appended.
Default:
NULL
Example:
names.default_domain=com
--------------------------------------------
Verify that there are no duplicate copies of the sqlnet.ora file.
If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain name in your connect string.
If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out.
If you are connecting from a login dialog box, verify that you arenot placing an "@" symbol before your connect net service name.
Activate client tracing and re-execute the operation
If it don't work, please tell me in what environment you are (Linux, NT, UNIX ...)
by ktyfuller
It seems that you have 2 problems:
1. tnsnames problem which can be solved using previous answer
2. oracle can't find the text of the error
I think that you have installed Oracle 8.0.5 on Linux 7.x or you don't apply compatibilty packages. I had this problem and the only solution was to install Oracle 8.0.5 on Linux 6.2 because installing compatibility packages wasn't enough for Linux 7.x because there was other libraries in Linux which cann't be downgraded. This kind of message: "Error while trying to retrieve text for error ora-..any number.." I know that appear only on Linux/UNIX. If you solve the problem with the Net8, you may occur the same message with another error anytime because Oracle cann't give you the text of error.
by ktyfuller
by ktyfuller
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending