| error 12154 [message #85084] |
Mon, 31 May 2004 07:47  |
Popol Victory KAYEMBE
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
Hi,
Good day,
I have Oracle Server in localhost and I sometimes connect to a remote oracle server with toad but still yesterday I have the 12154 error. And I can't be connect nether to my localhost oracle server or to my remote oracle server.
I have tried to resolve it but I can't do anything.
Could you help me.
Best regards.
|
|
|
|
| Re: error 12154 [message #85092 is a reply to message #85084] |
Tue, 01 June 2004 02:58  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
This is a Names server error.
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.
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 are not placing an "@" symbol before your connect net service name.
Activate client tracing and re-execute the operation.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
