Application of dynamic registration and parameter Local_listener for Oracle database

Starting with the Oracle8i version, in Oracle databases, where there is no special need for application, database monitoring does not need to be configured, and Oracle calls this method dynamic registration. The so-called dynamic registration, Oracle through the Pmon process based on the parameters instance_name and service_names content, the Oracle database information to the default 1521-port listener. Regardless of the number of listeners on the server side, Oracle defaults to the 1521 port listener, that is, for other port listeners, if you want to properly identify the information provided by the remote client, you need to make a configuration, that is, static registration. Under the LSNRCTL command, static registration or dynamic registration can be observed through the Services command. If it is static registration, Oracle Display service status is unknown, if it is dynamic registration, the status of the service display is ready. However, if a user wants to modify a dynamically registered port, this can be done by setting the database's Local_listener parameter.

Let's take a look at the following example, first of all, in the database by default, the Local_listener parameter is empty and not set.

[Oracle@ztj10 admin]$ Sqlplus/as SYSDBA

Sql*plus:release 10.2.0.1.0-production on Sun Apr 22 03:03:44 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Sql> Show Parameter local_l

NAME TYPE VALUE

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

Local_listener string

Sql> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

To view the service registered by the listener, ready indicates dynamic registration.

[Oracle@ztj10 admin]$ Lsnrctl

Lsnrctl for linux:version 10.2.0.1.0-production on 22-apr-2012 03:04:03

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

Welcome to Lsnrctl, type ' help ' for information.

Lsnrctl> Services

Connecting to (description= address= (PROTOCOL=IPC) (Key=extproc1))

Services Summary ...

Service "Plsextproc" has 1 instance (s).

Instance "Plsextproc", Status UNKNOWN, has 1 handler (s) for the This service ...

Handler (s):

"Dedicated" established:0 refused:0

Local SERVER

Service "DB01" has 1 instance (s).

Instance "Db01", Status READY, has 1 handler (s) for the This service ...

Handler (s):

"Dedicated" established:0 refused:0 State:ready

Local SERVER

Service "Db01xdb" has 1 instance (s).

Instance "Db01", Status READY, has 1 handler (s) for the This service ...

Handler (s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

DISPATCHER <machine:ztj10, pid:21629>

(Address= (PROTOCOL=TCP) (HOST=ZTJ10) (port=46550))

Service "DB01_XPT" has 1 instance (s).

Instance "Db01", Status READY, has 1 handler (s) for the This service ...

Handler (s):

"Dedicated" established:0 refused:0 State:ready

Local SERVER

The command completed successfully

Lsnrctl> Services Listener1

Connecting to (description= address= (protocol=tcp) (host=192.168.1.100) (port=1530))

Services Summary ...

Service "Dbtest" has 1 instance (s).

Instance "Db01", Status UNKNOWN, has 1 handler (s) for the This service ...

Handler (s):

"Dedicated" established:0 refused:0

Local SERVER

The command completed successfully

Lsnrctl> exit

According to the above information, we can see that now Oracle dynamically registers to 1521-port listener listener, while Listener1 is statically registered and the listener uses a port of 1530. Next we make a configuration that allows the Pmon process to dynamically register to the 1530-port listener.

Use the more command to get the contents of the Red section of the Listener.ora file

[Oracle@ztj10 admin]$ more Listener.ora

# Listener.ora Network Configuration File:/u01/app/oracle/product/10.2.0/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER1 =

(DESCRIPTION =

(address = (PROTOCOL = TCP) (HOST = 192.168.1.100) (PORT = 1530))

)

Sid_list_listener =

(Sid_list =

(Sid_desc =

(Sid_name = Plsextproc)

(Oracle_home =/u01/app/oracle/product/10.2.0)

(program = Extproc)

)

)

Sid_list_listener1 =

(Sid_list =

(Sid_desc =

(Global_dbname = dbtest)

(Oracle_home =/u01/app/oracle/product/10.2.0)

(Sid_name = db01)

)

)

LISTENER =

(Description_list =

(DESCRIPTION =

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/