静态注册两个非1521 :
LISTENER2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm)(PORT=1522))
)
)
LISTENER3=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm)(PORT=1523))
)
)
SID_LIST_LISTENER2=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=PROD))
)
SID_LIST_LISTENER3=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=PROD))
)
动态注册两个非1521 端口:
1. allter listener.ora
add :
LSABC=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm)(PORT=1421))
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm)(PORT=1321))
)
)
2. alter tnsnames.ora
add:
LSABC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ocm)(PORT =1421))
(ADDRESS=(PROTOCOL=tcp)(HOST=ocm)(PORT=1321))
)
3 .alter parameter :
SQL> alter system set local_listener=LSABC;
System altered.
SQL> show parameter list;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LSABC
remote_listener string
SQL>alter system register;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/27036311/viewspace-750956/
,如需转载,请注明出处,否则将追究法律责任。