Creare un Listener Dinamico

1) Modificare il file tnsnames.ora e aggiungere un nuovo listener

LISTENER2 =
(ADDRESS = (PROTOCOL = TCP)(HOST =test.com)(PORT = 1527))

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST =test.com)(PORT = 1521))

ORCL=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=test.com)
(PORT=1521))
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=orcl.com))
)

2) Modificare il file listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/18/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1527))

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

LOG_DIRECTORY_LISTENER=/u01/app/oracle/product/18/db_1/network/log

3) Modificare il parametro di sistema:

SQL> alter system set local_listener="LISTENER_ORCL ,LISTENER2";

SQL> show parameter local_listener

NAME TYPE VALUE

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

local_listener string LISTENER_ORCL ,LISTENER2

Collegarsi al listener e avviarlo

[oracle@test admin]$ lsnrctl

LSNRCTL> start listener2

LSNRCTL> status listener2

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1527)))

STATUS of the LISTENER

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

Alias listener2

Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production

Start Date 04-SEP-2020 15:34:01

Uptime 0 days 0 hr. 47 min. 18 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/18/db_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/test/listener2/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.com)(PORT=1527)))

The listener supports no services

The command completed successfully

Se il listerner non dovesse riconoscere i servizi allora usare la stringa di connesione completa invece del data entry.

SQL> alter system set local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1521)),(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1527))";

SQL> show parameter local_listener

NAME TYPE VALUE

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

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1521)), (ADDRESS= (PROTOCOL=TCP)(HOST=test.com)( PORT=1527))

Verifica che i serivizi sono agganciati al listener.