Oracle新增监听

1、oracle服务器端(这里演示增加的port为15210)：

[oracle@oracletestadmin]$ cd  $ORACLE_HOME/network/admin

 

在listener.ora增加如下内容(以下红色字体需要依实际情况修改)

[oracle@oracletestadmin]$ vi listener.ora

 

LISTENER210 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = oracletest)(PORT =15210))

  )

 

SID_LIST_LISTENER210=

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = ORCL)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

      (SID_NAME = ORCL)

    )

  )

 

2、启动新配置的监听listener210

[oracle@oracletestadmin]$ lsnrctl start listener210

LSNRCTL for Linux:Version 11.2.0.4.0 - Production on 16-MAR-2016 05:37:30

Copyright (c) 1991,2013, Oracle.  All rights reserved.

Starting/u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version11.2.0.4.0 - Production
System parameterfile is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messageswritten to /u01/app/oracle/diag/tnslsnr/oracletest/listener210/alert/log.xml
Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest)(PORT=15210)))

Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracletest)(PORT=15210)))
STATUS of theLISTENER
------------------------
Alias                     listener210
Version                   TNSLSNR for Linux: Version11.2.0.4.0 - Production
Start Date                16-MAR-2016 05:37:31
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener ParameterFile  /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener LogFile        /u01/app/oracle/diag/tnslsnr/oracletest/listener210/alert/log.xml
Listening EndpointsSummary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest)(PORT=15210)))
Services Summary...
Service"ORCL" has 1 instance(s).
  Instance "ORCL", status UNKNOWN,has 1 handler(s) for this service...
The commandcompleted successfully

 

3、oracle客户端配置tnsnames.ora，然后tnsping 一下，可以连接新的监听了