One Oracle instance is configured with multiple listener or multiple ports

One oracle instance Monitors multiple ports. Now we can create an oracle instance with two listening ports. There are two methods:

One oracle instance Monitors multiple ports. Now we can create an oracle instance with two listening ports. There are two methods:

One Oracle instance is configured with multiple listener or multiple ports

The content of the listener. ora file is as follows:

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 ))

)

)

The above configuration only configures One listener

Add another 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 _ Here It must be consistent with the LISTENER name.

SID_DESC registers the name of the database instance to provide services. In this way, LISTENER2 can provide services.

Start two more listener listeners.

[Oracle @ jingyong udump] $ lsnrctl stop listener

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

Copyright (c) 1991,200 5, Oracle. All rights reserved.

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

Copyright (c) 1991,200 5, Oracle. All rights reserved.

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

Copyright (c) 1991,200 5, Oracle. All rights reserved.

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

,