oracle外网监听端口,oracle 增加监听、端口-蒲公英云

oracle外网监听端口,oracle 增加监听、端口

冷不防 2023-01-18 05:27 278阅读 0赞

[grid@rac1 ~]$ srvctl add listener -l LISTENER5 -o $ORACLE_HOME -p 1588 -k 1

[grid@rac1 ~]$ srvctl start listener -l LISTENER5

[grid@rac1 ~]$ vim /u01/app/11.2.0.4/grid/network/admin/listener.ora

[grid@rac1 ~]$ srvctl stop listener -l LISTENER5

PRCC-1016 : LISTENER5 was already stopped

PRCR-1005 : Resource ora.LISTENER5.lsnr is already stopped

[grid@rac1 ~]$ srvctl start listener -l LISTENER5

[grid@rac1 ~]$ lsnrctl status LISTENER5

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 10-SEP-2020 05:56:23

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER5)))

STATUS of the LISTENER

-———————————-

Alias LISTENER5

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 10-SEP-2020 05:56:12

Uptime 0 days 0 hr. 0 min. 11 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/11.2.0.4/grid/network/admin/listener.ora

Listener Log File /u01/app/11.2.0.4/grid/log/diag/tnslsnr/rac1/listener5/alert/log.xml

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER5)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.29.151)(PORT=1588)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.29.130)(PORT=1588)))

Services Summary…

Service “testdb” has 1 instance(s).

Instance “testdb1”, status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

[grid@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac1

Listener LISTENER4 is enabled

Listener LISTENER4 is running on node(s): rac1

Listener LISTENER5 is enabled

Listener LISTENER5 is running on node(s): rac1

Listener LISTENER_ADG is enabled

Listener LISTENER_ADG is running on node(s): rac1

[grid@rac1 ~]$ su - oracle

Password:

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 10 05:57:15 2020

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> show parameter local_listener

NAME TYPE VALUE

-—————————————————- —————- ———————————————

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=1

92.168.29.130)(PORT=1521)), (A

DDRESS=(PROTOCOL=TCP)(HOST=192

.168.29.130)(PORT=1522)), (ADD

RESS=(PROTOCOL=TCP)(HOST=192.1

68.29.130)(PORT=1524))

SQL> alter system set local_listener=’(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.29.130)(PORT=1521))’,’(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.29.130)(PORT=1522))’,’(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.29.130)(PORT=1524))’,’(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.29.130)(PORT=1588))’;

System altered.

SQL> EXIT

[oracle@rac1 ~]$ su - grid

Password:

[grid@rac1 ~]$ srvctl stop scan_listener

PRCC-1016 : LISTENER4_SCAN1 was already stopped

PRCR-1005 : Resource ora.LISTENER4_SCAN1.lsnr is already stopped

[grid@rac1 ~]$ srvctl remove scan_listener

Remove scan listener? (y/[n]) y

[grid@rac1 ~]$ srvctl config scan_listener

PRCS-1026 : Could not find Single Client Access Name listener resources TYPE=ora.scan_listener.type

[grid@rac1 ~]$ srvctl add scan_listener -l LSNR5 -p 1588