Re: Strange ORA-12545 message

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Fri, 10 Feb 2006 16:24:30 GMT
Message-ID: <Xns976655A1EE3D5ianalvistahotmailcom@70.169.32.36>

"durang" <durang_at_ureach.com> wrote in news:1139584974.471055.38660 @f14g2000cwb.googlegroups.com:

> (with dummy values inserted)
>
> SQLNET.ORA:
>
> # SQLNET.ORA Network Configuration File:
> X:\oracle\ora92\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> # NAMES.DEFAULT_DOMAIN = xx.xxxxx.edu
>
> # SQLNET.AUTHENTICATION_SERVICES= (NTS)
> SQLNET.AUTHENTICATION_SERVICES= (NONE)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> TNSNAMES.ORA
>
> # TNSNAMES.ORA Network Configuration File:
> X:\oracle\ora92\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> TESTDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = xxxxx.xxx.xxxxx.edu)
> )
> )
>
>

It might make things better by changing (SERVICE_NAME = xxxxx.xxx.xxxxx.edu)
to be
(SID = TESTDB)
(where "TESTDB" is the actual SID of the database) Received on Fri Feb 10 2006 - 10:24:30 CST