Oracle PRIMECLUSTERTM Wizard for 4.1 Benutzerhandbuch
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <logical IP
address>)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9i)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(SID_NAME = ora9i)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <logical IP
address>)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9i)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(SID_NAME = ora9i)
)
)
―
tnsnames.ora
Set up the “tnsnames.ora” file to monitor listener operation by executing the
“tnsping” command. Also, set up a network service name in the ”tnsnames.ora”
file and in the Oracle listener environment of Oracle Wizard. The ORACLE_SID, a
host (logical IP address) and a port number, which are all set up in this file, should
be the same as those of the listener of the ”listener.ora” file.
Set up the “tnsnames.ora” file to monitor listener operation by executing the
“tnsping” command. Also, set up a network service name in the ”tnsnames.ora”
file and in the Oracle listener environment of Oracle Wizard. The ORACLE_SID, a
host (logical IP address) and a port number, which are all set up in this file, should
be the same as those of the listener of the ”listener.ora” file.
Network service name =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <logical IP
address>)(PORT = 1521))
(CONNECT_DATA = (SID = ora9i))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <logical IP
address>)(PORT = 1521))
(CONNECT_DATA = (SID = ora9i))
)
●
Check Oracle operation
Check if Oracle is properly running by starting and stopping manually.
Check if Oracle is properly running by starting and stopping manually.
16