How to set up 2 instance listener?
From: Mirwais Qader <mqader_at_facstaff.wisc.edu>
Date: 1996/09/01
Message-ID: <50cjei$2eik_at_news.doit.wisc.edu>#1/1
# Filename: SQLNET.ORA
TRACE_DIRECTORY_SERVER = /users/oracle/oraclebase/7.2.2.4/network/trace TRACE_FILE_SERVER = SERVER
TRACE_DIRECTORY_CLIENT = /users/oracle/oraclebase/7.2.2.4/network/trace TRACE_FILE_CLIENT = CLIENT
# Service: TNSNAMES
db1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
)
(CONNECT_DATA =
(SID=db1)
)
test=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
)
(CONNECT_DATA =
(SID=test)
)
)
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = labux )
(PORT = 1521)
)
)
STOP_LISTENER = YES
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0 SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = db1 )
(ORACLE_HOME = /users/oracle/oraclebase/product/7.2.2.4)
)
)
LOG_DIRECTORY_LISTENER = /users/oracle/oraclebase/product/7.2.2.4/network/log LOG_FILE_LISTENER = LISTENER AUTOMATIC_IPC=OFF Any help would be deeply appreciated! Received on Sun Sep 01 1996 - 00:00:00 CEST
Date: 1996/09/01
Message-ID: <50cjei$2eik_at_news.doit.wisc.edu>#1/1
I am in the process of running 2 instances on our HP9000 UNIX 9.04 running Oracle 7.2.2.4 server. I would like to be able to connect from any client to EITHER instance. My client configuration files are okay, I just don't know what to do with the server files, especially the listener.ora file. [This is an experiment]
The files are as follows:
/etc/services:
listener 1521/tcp # listener port listener2 1522/tcp # additional port ##################
# Filename: SQLNET.ORA
################## TRACE_LEVEL_SERVER = 16
TRACE_DIRECTORY_SERVER = /users/oracle/oraclebase/7.2.2.4/network/trace TRACE_FILE_SERVER = SERVER
LOG_LEVEL_SERVER = 16 LOG_DIRECTORY_SERVER = /users/oracle/oraclebase/7.2.2.4/network/log LOG_FILE_SERVER = SERVER TRACE_LEVEL_CLIENT = 16
TRACE_DIRECTORY_CLIENT = /users/oracle/oraclebase/7.2.2.4/network/trace TRACE_FILE_CLIENT = CLIENT
LOG_LEVEL_CLIENT = 16 LOG_DIRECTORY_CLIENT = /users/oracle/oraclebase/7.2.2.4/network/log LOG_FILE_CLIENT = CLIENT
AUTOMATIC_IPC = OFF
################### # Filename: TNSNAMES.ORA
# Service: TNSNAMES
###################
db1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=TCP)
(HOST=labux)
(PORT=1521)
)
)
(CONNECT_DATA =
(SID=db1)
)
test=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=TCP)
(HOST=labux)
(PORT=1522)
)
)
(CONNECT_DATA =
(SID=test)
)
)
This is the file that is confusing me. What should I be adding to allow for the 2 instance situation?
######### # LISTENER.ORA # Listener name = LISTENER and LISTENER2 #########
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = labux )
(PORT = 1521)
)
)
STOP_LISTENER = YES
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0 SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = db1 )
(ORACLE_HOME = /users/oracle/oraclebase/product/7.2.2.4)
)
)
TRACE_LEVEL_LISTENER=ADMIN TRACE_DIRECTORY_LISTENER = /users/oracle/oraclebase/product/7.2.2.4/network/trace TRACE_FILE_LISTENER = LISTENER LOG_LEVEL_LISTENER = ADMIN
LOG_DIRECTORY_LISTENER = /users/oracle/oraclebase/product/7.2.2.4/network/log LOG_FILE_LISTENER = LISTENER AUTOMATIC_IPC=OFF Any help would be deeply appreciated! Received on Sun Sep 01 1996 - 00:00:00 CEST