单IP单端口监听多实例配置

# tnsnames.ora Network Configuration File: $ORACLE_HOME/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

N1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)

(CONNECT_DATA =
(SERVICE_NAME = N1)
)
)

N2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = N2)
)
)

LISTENER_N1 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

LISTENER_N2 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME =MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

# listener.ora Network Configuration File: $ORACLE_HOME/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.179.133)(PORT = 1521))
)
)
)

ADR_BASE_LISTENER = /path/to/apptop

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /path/to/oracle/home)
(PROGRAM = extproc)
)

(SID_DESC =
(GLOBAL DBNAME = N1)
(ORACLE_HOME = /path/to/oracle/home)
(SID_NAME = N1)
)

(SID_DESC =
(GLOBAL DBNAME = N2)
(ORACLE_HOME = /path/to/oracle/home)
(SID_NAME = N2)
)
)

发表评论

电子邮件地址不会被公开。 必填项已用*标注