Oracle listener automatic registration of services

Starting with Oracle Database version 8i, need not be recorded BD services in the listener.ora file, the DB can automatically register.

This functionality works perfectly if we have the listener on port 1521 (default), if we make a change there’s no port to connect to the database. This is because the value of the parameter which defaults LOCAL_LISTENER:

Source   
LOCAL_LISTENER='(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521))'

Although we make a:

Source   
SHOW parameters LOCAL_LISTENER;

It appears empty.

If we change the listener port must change this, for example 1522:

Source   
ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1522))';

And register again the BD (something that can be ignored because it does every 10 minutes automatically):

Source   
ALTER SYSTEM REGISTER;

Now we can see that it is properly registered (in READY to automatically registered):

Source   
[oracle@clu01 admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-OCT-2011 14:21:14
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clu01)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                26-OCT-2011 14:16:30
Uptime                    0 days 0 hr. 4 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clu01)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PRUEBA" has 1 instance(s).
Instance "PRUEBA", status READY, has 1 handler(s) for this service...
Service "PRUEBAXDB" has 1 instance(s).
Instance "PRUEBA", status READY, has 1 handler(s) for this service...
Service "PRUEBA_XPT" has 1 instance(s).
Instance "PRUEBA", status READY, has 1 handler(s) for this service...
The command completed successfully

Registering the BD occurs in the listener to start the database and is automatically updated every 10 minutes.

Leave a Reply