Re: Oracle Names Server (error during the startup)

[Quoted] [Quoted] On 11 Jun 2002 08:22:48 -0700, frederic.lavoue_at_eu.rhodia.com (Frederic Lavoue) wrote:

>Hi,
>I installed an oracle names server (v 8.1.7) on Winnt 4.0 sp6 with
>java program provided by oracle.
>When I try to start oracle server names, the program return that there
>is an TNS 12560 error protocol adaptor and that it can't find the file
>...
>
>Here is the names.ora
># NAMES.ORA Network Configuration File:
>D:\oracle\ora81\NETWORK\ADMIN\names.ora
># Generated by Oracle configuration tools.
>NAMES.TRACE_UNIQUE = no
>NAMES.SERVER_NAME = NS1.sd-devsc
>NAMES.ADDRESSES =
> (ADDRESS = (PROTOCOL = TCP)(HOST = sd-devsc)(PORT = 1575))
>
>Here is the sqlnet.ora
># SQLNET.ORA Network Configuration File:
>D:\oracle\ora81NETWORK\ADMIN\sqlnet.ora
># Generated by Oracle configuration tools.
>NAMES.DEFAULT_DOMAIN = WORLD
>SQLNET.AUTHENTICATION_SERVICES= (NTS)
>NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES)
>NAMES.PREFERRED_SERVERS =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = sd-devsc)(PORT = 1575))
> (ADDRESS = (PROTOCOL = TCP)(HOST = P12320)(PORT = 1575))
> )
>
># P1230 is a secondary oracle server names
>
>Here is the listener.ora file
># LISTENER.ORA Network Configuration File:
>D:\oracle\ora81\network\admin\listener.ora
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = sd-devsc)(PORT = 1521))
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora81)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = o8itest)
> (ORACLE_HOME = D:\oracle\ora81)
> (SID_NAME = o8itest)
> )
> )
>
>
>Any help will be appreciated.
>Thanks

[Quoted] The names.addresses parameter in names.ora is incorrect. It should point to the regular port for connecting to the database, please replease 1575 by 1521.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 12 2002 - 00:02:36 CEST