任务

1、静态注册LISTENER 1521

2、动态注册LSNR2 1526

注意事项
1、监听文件中的文本一定要正确（一定要统一格式，否则出错后，格式错误很难查出，而且监听可以启动，数据库注册不进去，原因不详，有高手可以指教一下，特别是配置1526动态注册时）。
2、host后面写主机名时，要在/etc/hosts文件中申明。




--静态注册LISTENER 1521
[oracle@prod1 admin]$ vi listener.ora
-----------------------------------------------------------------
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod1)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle


SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=ORA11GR2)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME=ORA11GR2)
    )
   )
-----------------------------------------------------------------
动态注册LSNR2 1526
[oracle@prod1 admin]$ vi listener.ora
-----------------------------------------------------------------
LSNR2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod1)(PORT = 1526))
    )
----------------------------------------------------------------

#vi tnsnames
-----------------------------------------------------------------
LSNR2 =(ADDRESS = (PROTOCOL = TCP)(HOST = prod1)(PORT = 1526))
-----------------------------------------------------------------
SQL>alter system set local_listener='LSNR2';