Re: tnsnames.ora

From: Scott Shafer <scott.shafer_at_ildmail.com>
Date: Mon, 1 May 2000 16:03:09 -0500
Message-Id: <10484.104613@fatcity.com>

In your sqlnet.ora file set 'names.default_domain = world' (no quotes) or to whatever the default domain extension is you want in your tnsnames.ora.

Scott Shafer
Converse, TX

-----Original Message-----
From: Eric Fang <eric_fang_at_yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Monday, May 01, 2000 2:07 PM
Subject: tnsnames.ora

>I have a wierd problem to access the database today.
>If I use the following
>sqlplusw system/manager_at_orcl.world, it is ok to
>connect to the database. But if I use
>sqlplusw system/manager_at_orcl
>I have the ORA-12154: TNS:could not resolve service
>name error.
>I can change the service name to whatever like orcl.c,
>then I am still able to connect to the database by
>using sqlplusw system/manager_at_orcl.c
>I don't what's wrong with the service name. Any
>advice? The tnsnames.ora is listed as the follwing(the
>database is Oracle 8.1) :
>
>ORCL.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST =
>ticket.company.com)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORCL)
Received on Mon May 01 2000 - 16:03:09 CDT