配置双动态监听，多端口监听和静态监听

我这里已经发存在了一个监听，如没有的话可oracle下执行netca或netmgr，和手动配置一个。

配置监听时需了解和注意的地方：

SERVICE_NAME

HOST

PORT

GLOBAL_DBNAME

ORACLE_HOME     

SID_NAME

增加一个动态监听

修改 listener.ora 增加以下内容 

$ORACLE_HOME/network/admin
$ vi listener.ora

LISTENER2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod1.us.oracle.com)(PORT = 1522))
    )
  )

修改tnsnames.ora 增加以下内容

$ vi tnsnames.ora
QQQQ =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prod1.us.oracle.com)(PORT = 1522))
    ) 
    (CONNECT_DATA =
      (SERVICE_NAME = PROD1.us.oracle.com)

WWWW =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = prod1.us.oracle.com)(PORT = 1521))
          (ADDRESS