oracle listener 靜態和動態註冊

靜態註冊兩個非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;