Re: TNS...pls help.

HI Keith,
thank you for your prompt response.
Yes, I did check out the doco before I try this list. I 'll try your suggestion, and got this error "TNS-03505 Failed to resolve name". Do I also need SQLNET.ORA? Currently, all I have is the TNSNAME.ORA and LISTENER.ORA.
thanks
:-) ellen

Keith Gilbert wrote:
>
> Ellen Chiem wrote in message <36884EDA.C559284F_at_nettrack.com.au>...
> >Hi,
> >
> >Platform : AIX version 4.3.1, Oracle 7.3.2
> >
> >I'm very new to Oracle, so please bear with me. I have just install the
> >Oracle server and now are in the process if setting up a test database
> >to run a third party product call Netview. When I try to run the Netview
> >script I keep getting the same errro "ORA-12154 TNS:Could not resolve
> >service name". I have done everything that the troubleshoot book
> >advised, but alas still the same error. Basically, the script just
> >create another sql script to create some table.
> >
> >Am I missing something is my setup of the instance?. (The listener is up
> >and running.)
> >
> >Thanks very much for the help.
> >
> >:-) Ellen
>
> Ellen,
>
> I know you may have already checked the documentation on this error but just
> in case here it is:
>
> ORA-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 Chapter 4 in the SQL*Net V2
> Administrator's Guide. If possible, regenerate the configuration files using
> the Oracle Network Manager.
>
> There is also a neat little utility that may be installed called tnsping
> supplied by oracle that may assist with testing the resultant combination of
> TCP/IP hostname resolution, TNSNAMES.ORA and SQLNET.ORA files.
>
> Keith

Received on Mon Dec 28 1998 - 23:45:32 CST