Re: Oracle Names Server (error during the startup)

[Quoted] On Wed, 12 Jun 2002 13:40:59 GMT, jeff_at_work.com (Jeff) wrote:

>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.

Seems you don't understand how Oracle Names work. You do agree with me Names does need to connect to a database, do you. There are NO references to any flat file in his names.ora. So how do you expect Oracle is going to make that connection? If you don't know what you are talking about, please don't reply in this fashion.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 12 2002 - 19:05:33 CEST