Re: No TNSListener

On 17 Apr 2003 05:39:57 -0700, rvandehe_at_enzy.com (Randy) wrote:

>I have a new install of Oracle 8.1
>
>The instance service is running, but I cannot connect to it. The
>error is ORA-12154: TNS:could not resolve service name
>
>On my production server, I have a TNSListener service running. But on
>my new development install I do not. I think this is basis of my
>problem. How can I get the tnslistener service installed?
>
>-Randy

From the Error Messages manual:
<begin quote>
TNS-12154 TNS:could not resolve service name

Cause: The service name specified is not defined correctly 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 the SQL*Net V2 Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.
<end quote>

a 12154 has nothing to do with the listener. Remember, listeners are for servers, tnsnames is for clients. What the above message text doesn't explain -- and what catches many people -- is how the names.default_domain parameter in the sqlnet.ora file comes into play.

It's not clear if your 'new development install' is referring to a client or another database server. Received on Thu Apr 17 2003 - 12:32:23 CDT