Help: manual config simple Oracle Names

From: bonminh lam <mailbox_at_online.de>
Date: Mon, 28 Aug 2000 01:34:50 +0200
Message-ID: <39A9A59A.5A66D833@online.de>

Hello,

For the sake of practice, I am trying to set up a second names server . My configuration is as below:

Server                             Platform          Hostname      SID
===========================================
8.0.4 DB server              WinNT           mar091999     tst1
8.1.5 DB server              Linux              feb2000          prd1

There is a Names Server up and running on mar091999, it is named oname_mar091999. I am trying to add the second names server on feb2000 and call it onames_feb2000. I tried to do this with netasst but the tool crashed miserably whenever I try to discover existing names server or create new ones. So decided to adapt the names.ora from mar091999 manually and start up names server on feb2000 using namesctl. However, namesctl does not seem to like the file and I am at a loss how to proceed. I would appreciate it if the experts on the field can spot what is wrong.

Below is how my sqlnet.ora and names.ora look like:

sqlnet.ora
NAME.DEFAULT_ZONE = world

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = feb2000)(PORT = 1575))
(ADDRESS = (PROTOCOL = TCP)(HOST = mar091999)(PORT = 1575))
)

NAMES.DEFAULT_DOMAIN = world

SQLNET.EXPIRE_TIME = 0 SQLNET.ENCRYPTION_SERVER = requested

SQLNET.ENCRYPTION_CLIENT = requested

NAMES.DIRECTORY_PATH= (ONAMES)

names. ora

NAMES.SERVER_NAME = onames_feb2000

NAMES.ADDRESSES =
(ADDRESS = (PROTOCOL = TCP)(HOST = feb2000)(PORT = 1575)) (ADDRESS = (PROTOCOL = TCP)(HOST = mar091999)(PORT = 1575))

NAMES.ADMIN_REGION =
(REGION =
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = mar091999)(PORT = 1521))
      (CONNECT_DATA = (SID = tst1)(Server = Dedicated))

)
(USERID = oranames)
(PASSWORD = oranames)
(NAME = LOCAL_REGION)
(REFRESH = 86400)
(RETRY = 60)
(EXPIRE = 600)
(VERSION = 134230016)

)

Btw, I am using a regional database which is hosted on tst1 on mar091999. When I entered namesctl, it decides to pick onames_mar091999 as the current server, apparently because onames_feb2000 has not been started yet. I tried to change the current server but that did not work:

[dba_at_feb2000 admin]$ namesctl

Oracle Names Control for Linux: Version 8.1.5.0.0 - Production on 27-AUG-00 23:5
2:17

Currently managing name server "onames_mar091999" Version banner is "Oracle Names for 32-bit Windows: Version 8.0.4.0.0 - Producti
on"

Welcome to NAMESCTL, type "help" for information.

NAMESCTL> set server onames_feb2000
NNL-00011: no server with name "onames_feb2000" exists NAMESCTL> I then removed the preferred server onames_mar091999 from sqlnet.ora for test and entered namesctl again. This time it complained about invalid server name:

[dba_at_feb2000 admin]$ namesctl

Oracle Names Control for Linux: Version 8.1.5.0.0 - Production on 28-AUG-00 00:0
3:20

NNL-00018: warning: could not contact default name server Welcome to NAMESCTL, type "help" for information.

NAMESCTL> start
Starting "/home/dba/u01/app/8.1.5/bin/names"...server not started, errors follow
"NO-00307: invalid server name "onames_feb2000 NAMESCTL> Does any one see how this could be fixed? Thanks in advance! Received on Sun Aug 27 2000 - 18:34:50 CDT