一台server上 oracle用户下安装有两个实例 rlpd_pre , rltest , 端口不使用默认的 1521 ,两个实例使用不同的端口。
注意查看环境变量
$ env | grep TNS_ADMIN 是否指向正确的监听文件目录 /volume/r03/rlpd/testdb/10.2.0/network/admin
cat /volume/r03/rlpd/testdb/10.2.0/network/admin/listener.ora
# 因为listener.ora 文件中的监听名称不是默认的 LISTENER , 而是 RLTEST , 所以开启时需要
# 使用 lsnrctl start RLTEST
RLTEST =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCRLTEST))
(ADDRESS= (PROTOCOL= TCP)(Host= szxxmr54-ts.huawei.com )(Port= 1522))
(ADDRESS= (PROTOCOL= TCP)(Host= szxxmr54-ts.huawei.com )(Port= 1526))
)
SID_LIST_RLTEST =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /volume/r03/rlpd/testdb/10.2.0)
(SID_NAME = RLTEST)
)
(SID_DESC =
(ORACLE_HOME= /volume/r03/rlpd/testdb/10.2.0)
(SID_NAME = RLPD_PRE)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /volume/r03/rlpd/testdb/10.2.0)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_RLTEST = 0
CONNECT_TIMEOUT_RLTEST = 10
TRACE_LEVEL_RLTEST = OFF
LOG_DIRECTORY_RLTEST = /volume/r03/rlpd/testdb/10.2.0/network/admin
LOG_FILE_RLTEST = RLTEST
TRACE_DIRECTORY_RLTEST = /volume/r03/rlpd/testdb/10.2.0/network/admin
TRACE_FILE_RLTEST = RLTEST
ADMIN_RESTRICTIONS_RLTEST = ON
注意查看环境变量
$ env | grep TNS_ADMIN 是否指向正确的监听文件目录 /volume/r03/rlpd/testdb/10.2.0/network/admin
cat /volume/r03/rlpd/testdb/10.2.0/network/admin/listener.ora
# 因为listener.ora 文件中的监听名称不是默认的 LISTENER , 而是 RLTEST , 所以开启时需要
# 使用 lsnrctl start RLTEST
RLTEST =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCRLTEST))
(ADDRESS= (PROTOCOL= TCP)(Host= szxxmr54-ts.huawei.com )(Port= 1522))
(ADDRESS= (PROTOCOL= TCP)(Host= szxxmr54-ts.huawei.com )(Port= 1526))
)
SID_LIST_RLTEST =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /volume/r03/rlpd/testdb/10.2.0)
(SID_NAME = RLTEST)
)
(SID_DESC =
(ORACLE_HOME= /volume/r03/rlpd/testdb/10.2.0)
(SID_NAME = RLPD_PRE)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /volume/r03/rlpd/testdb/10.2.0)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_RLTEST = 0
CONNECT_TIMEOUT_RLTEST = 10
TRACE_LEVEL_RLTEST = OFF
LOG_DIRECTORY_RLTEST = /volume/r03/rlpd/testdb/10.2.0/network/admin
LOG_FILE_RLTEST = RLTEST
TRACE_DIRECTORY_RLTEST = /volume/r03/rlpd/testdb/10.2.0/network/admin
TRACE_FILE_RLTEST = RLTEST
ADMIN_RESTRICTIONS_RLTEST = ON
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-769443/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-769443/