Re: Problem setting up Oracle Names server

Hi John,

This is a tough one, but let at least try to get some issues resolved. First of all: contacting the nameserver by an ordinary client (sqlplus or whatever) should use a different port than the default tcp/ip connection, the port number is 1575 (in Oracle 7 that was hardcoded in the software, Oracle admitted)
So this line
>names.preferred_servers = (address_list =
> (address=(protocol=ipc)(key=PNPKEY))
> (address=(protocol=tcp)(host=ons1)(port=1521))
> )

is incorrect
the first address should be deleted (IPC is InterProcess Communication, this will work only for local connections)
and it should read
>names.preferred_servers = (address_list =
> (address=(protocol=tcp)(host=ons1)(port=1575))
> )

This line is also incorrect
>names.addresses = (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))
It will work only when the nameserver is on the same server as the database. This should be an ordinary tcp/ip line, like this
>names.addresses = (ADDRESS=(PROTOCOL=TCP)(HOST=ons1)(PORT=1521))
The port number is 1521 here because that's what the database is listening on, right?
In the names.ora
>names.addresses = (address_list =
> (ADDRESS = (PROTOCOL=tcp)(HOST=ons1)(PORT=1521))
> (ADDRESS = (PROTOCOL=tcp)(HOST=oranamesrvr0)(PORT=1521))
> )

You should make sure oranamesrvr0 is a valid DNS alias for ons1 Then, the first domain block is empty, and probably only one domain is allowed, so delete the first domain block. If this doesn't help, could you make sure, your trace level is 16, and post both the checkpoint files and the trace files. It looks like your nameserver contents are invalid too. But maybe your current setup is causing related problems, so let's try to sort the ora files out first. I admit getting a nameserver up can be frustrating, but once you succeeded, you don't want to do without!

Hth,

Sybrand Bakker, Oracle DBA

John L. Center wrote in message <3742BC15.8D017D7F_at_email.villanova.edu>...
>Hi,
>
>I'm trying to set up an Oracle Names server (8.0.4) on a non-Oracle Sun
>Solaris 2.6 box. This is to provide names server redundancy within our
>network. I've installed and linked the Net8 software support, started
>namesctl and can start & ping the names server. But, if I quit
>namesctl, then run it again, namesctl can't communicate with the names
>server. It complains that I need to do a set server command, which I
>have tried, but it can't find the name it was given at startup -
>onames_ons1 - or the oranamesrvr0 alias or the server name itself -
>ons1.
>
>This has been a frustrating project. I'm not an Oracle DBA, but I
>volunteered for this. ;-{ It took some time for me to figure out that
>namesctl couldn't find the sqlnet.ora file. According to the docs, it
>should look in /var/opt/oracle before $ORACLE_HOME/network/admin, but I
>found out that if it isn't in the latter, it won't find it. Also, if I
>set up the names.ora in the same directory, namesctl can't start up the
>names server, so I assume that this is misconfigured also.
>
>Any help will be GREATLY appreciated!
>
>Thanks.
>
> -John
>
>John Center
>Villanova University
>
>
>Here is the sqlnet.ora file:
>
>names.default_domain = world
>names.initial_retry_timeout = 5
>names.message_pool_start_size = 10
>names.preferred_servers = (address_list =
> (address=(protocol=ipc)(key=PNPKEY))
> (address=(protocol=tcp)(host=ons1)(port=1521))
> )
>names.request_retries = 2
>names.directory_path = (ONAMES,TNSNAMES,HOSTNAME)
>names.addresses = (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))
>names.authority_required = False
>names.auto_refresh_expire = 259200
>names.auto_refresh_retry = 180
>names.cache_checkpoint_file = $ORACLE_HOME/network/names/cache.ckp
>names.cache_checkpoint_interval = 7200
>names.log_directory = $ORACLE_HOME/network/log
>names.log_file = names.log
>names.log_stats_interval = 3600
>names.log_unique = True
>names.max_open_connections = 10
>names.max_reforwards = 2
>names.message_pool_start_size = 24
>
>Here is the names.ora file:
>
>names.addresses = (address_list =
> (ADDRESS = (PROTOCOL=tcp)(HOST=ons1)(PORT=1521))
> (ADDRESS = (PROTOCOL=tcp)(HOST=oranamesrvr0)(PORT=1521))
> )
>names.server_name = onames_ons1
>names.domains = (DOMAIN_LIST=
> (DOMAIN=
> (NAME=)
> (MIN_TTL=86400)
> )
> (DOMAIN=
> (NAME=world)
> (MIN_TTL=86400)
> )
> )
>names.authority_required = False
>names.auto_refresh_expire = 259200
>names.auto_refresh_retry = 180
>names.cache_checkpoint_file = $ORACLE_HOME/network/names/cache.ckp
>names.cache_checkpoint_interval = 7200
>names.config_checkpoint_file = $ORACLE_HOME/network/names/config.ckp
>names.log_directory = $ORACLE_HOME/network/log
>names.log_file = names.log
>names.max_open_connections = 10
>names.max_reforwards = 2
>names.message_pool_start_size = 24
>names.no_modify_requests = False
>names.region_checkpoint_file = $ORACLE_HOME/network/names/region.ckp
>names.trace_directory = $ORACLE_HOME/network/trace
>names.trace_file = names.trc
>names.trace_unique = True
>
>Here is the names.log file without the names.ora:
>
>Oracle Names for Solaris: Version 8.0.4.0.0 - Production on 18-MAY-99
>17:30:46
>
>(c) Copyright 1995 Oracle Corporation. All rights reserved.
>
>Log messages written to /opt/oracle/8.0.4/network/log/names.log
>
>NNO-00268: warning: configuration database is not used, using checkpoint
>data instead
>NNO-00260: loading configuration data from checkpoint file
>"/opt/oracle/8.0.4/network/names/ckpcfg.ora"
>NNO-00315: server is listening on address
>(ADDRESS=(PROTOCOL=tcp)(HOST=ons1)(PORT=1521))
>NNO-00060: loading server topology from checkpoint file
>"/opt/oracle/8.0.4/network/names/ckpreg.ora"
>NNO-00065: loading cached data from checkpoint file
>"/opt/oracle/8.0.4/network/names/ckpcch.ora"
>18-MAY-99 17:30:46: NNO-00303: server "onames_ons1" started with process
>ID 20992
>18-MAY-99 17:31:18: NNO-00301: server will shut down in 0 seconds
>18-MAY-99 17:31:23: NNO-00302: server stopped
>
>Here is the names.log with the names.ora:
>
>Oracle Names for Solaris: Version 8.0.4.0.0 - Production on 18-MAY-99
>18:17:58
>
>(c) Copyright 1995 Oracle Corporation. All rights reserved.
>
>Log messages written to /opt/oracle/8.0.4/network/log/names.log
>
>NNO-00268: warning: configuration database is not used, using checkpoint
>data instead
>NNO-00260: loading configuration data from checkpoint file
>"/opt/oracle/8.0.4/network/names/ckpcfg.ora"
>NNO-00315: server is listening on address
>(ADDRESS=(PROTOCOL=tcp)(HOST=ons1)(PORT=1521))
>NNO-00060: loading server topology from checkpoint file
>"/opt/oracle/8.0.4/network/names/ckpreg.ora"
>NNO-00083: domain "[root]" server "ons1" has no addresses
>NNO-00050: serious errors in configuration data, server cannot run
>
>
>Here is the entries in the /etc/services file:
>listener 1521/tcp # Oracle Net8 listener
>listener 1575/tcp # Oracle Net8 listener
Received on Wed May 19 1999 - 13:24:00 CDT