Problem setting up Oracle Names server

From: John L. Center <jcenter_at_email.villanova.edu>
Date: Wed, 19 May 1999 09:26:45 -0400
Message-ID: <3742BC15.8D017D7F@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

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

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 - 08:26:45 CDT