Re: Oracle Names Server (error during the startup)

In article <gpscguo6sj2s1h0put5db4fugleslj4foe_at_4ax.com>, postbus_at_sybrandb.demon-verwijderdit.nl wrote:
>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
>
>
>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

No. That's the port that the names server is supposed to be listening on and 1575 is correct. It works for me anyway.

The one section I have in my names.ora that you don't and I'd question is the names.domain section. Check the docs and see if this might be important to your case. Received on Wed Jun 12 2002 - 15:40:59 CEST