User's Manual

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)
)
)
― 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.
Network service name =
(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.
16