Oracle一个实例配置多个listener或多个端口-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Oracle一个实例配置多个listener或多个端口

Jun 07, 2016 pm 05:25 PM

一个oracle实例对于多个监听，一个监听对于多个端口。现在我们可以创建一个oracle实例一个监听的两个端口。这一共有两种方法：

Oracle一个实例配置多个listener或多个端口

listener.ora文件的内容如下:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = jingyong)

(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db)

(SID_NAME = jingyong)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = jingyong)(PORT = 1521))

)

上面的配置只配置了一个listener

下面再增加一个listener_2

SID_LIST_LISTENER_2 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = jingyong)

(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db)

(SID_NAME = jingyong)

)

LISTENER_2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = jingyong)(PORT = 1522))

)

SID_LIST_ 这里的要和LISTENER名称一致。

SID_DESC则注册要提供服务的数据库实例名。这样LISTENER2 才能够提供服务。

再来启动两个listener

[oracle@jingyong udump]$ lsnrctl stop listener

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2013 18:06:21

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jingyong)(PORT=1521)))

The command completed successfully

[oracle@jingyong udump]$ lsnrctl start listener_2

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2013 18:06:37

Starting /u01/app/oracle/product/10.2.0/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/10.2.0/db/network/log/listener_2.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jingyong)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jingyong)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias listener_2

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 13-JAN-2013 18:06:37

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/db/network/log/listener_2.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jingyong)(PORT=1522)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "jingyong" has 1 instance(s).

Instance "jingyong", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@jingyong udump]$ lsnrctl start listener

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-JAN-2013 18:06:41

Starting /u01/app/oracle/product/10.2.0/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/10.2.0/db/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jingyong)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jingyong)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias listener

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 13-JAN-2013 18:06:41

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/10.2.0/db/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jingyong)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "jingyong" has 1 instance(s).

Instance "jingyong", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

linux

，

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn