Re: tnsnames.ora entry doesn't work on new install

Please look in your sqlnet.ora file. If there is a row containing "names.default_domain = world" or another value than you have either to add this to your connect string or type in a "." (dot) behind the pwhse e.g.
sqlplus user/passw_at_pwhse.
or sqlplus user/passw_at_pwhse.world

Or you can drop this row from sqlnet.ora.

hth
Andy
"Stan Brown" <stanb_at_panix.com> schrieb im Newsbeitrag news:9qerh3$g8n$1_at_panix1.panix.com...
> I've installed 91 on Linux, and I'm trying to access a 7.3.4.5 remote
> instance. I tried this entry in tnsnames.ora:
>
>
> pwhse =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP_COMMUNITY.world)
> (PROTOCOL = TCP)
> (Host = phse6)
> (Port = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = pwhse)
> (GLOBAL_NAME = phwse)
> )
> )
>
> This is copied straihgt out of a working tnsnames.ora file on one of the
> V7 systems, but it doesn't work> I get ORA12154 TNS: Could not resolve
> service aname.
>
> Sugestiosn?
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
Received on Mon Oct 15 2001 - 09:33:11 CDT