Re: TNS...pls help.

[Quoted] Hi, Ellen,

  Yes, the SQLNET.ORA file is absolutely necessary and should be located in the same directory as the TNSNAMES.ORA and other network files. It is a simple text file, and the contents of an example file are given here:

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES, HOSTNAME) names.default_domain = world
name.default_zone = world
names.default_domain=world

The critical part is the names.directory_path variable. This example tells Oracle to use the TNSNAMES.ORA file to process SID requests and to use the local hosts file to match host names with IP addresses. Provided TNSNAMES.ORA is configured properly, the presence of the SQLNET.ORA file should eliminate your problems.

Cary

In article <36886C7C.FE8CEEF3_at_nettrack.com.au>,   Ellen Chiem <ellen_at_nettrack.com.au> wrote:
> This is a multi-part message in MIME format.
> --------------2A8D10A6EA70DA422F018E32
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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
> --------------2A8D10A6EA70DA422F018E32
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Ellen Chiem
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: Ellen Chiem
> n: Chiem;Ellen
> org: Nettrack Technical Solutions
> adr: Level 1, 80 Chandos Street;;St
 Leonards;Sydney;NSW;2065;Australia
> email;internet: ellen_at_nettrack.com.au
> tel;work: + 61 2 9438 4385
> tel;fax: + 61 2 9437 5297
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> version: 2.1
> end: vcard
>
> --------------2A8D10A6EA70DA422F018E32--
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 29 1998 - 00:00:00 CET