Shulou(Shulou.com)05/31 Report--

What this article shares with you is about how srvctl adds new monitoring and ports and registers statically. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

[grid@cent6-ora11-ip16] $/ u01/gridhome/11g/bin/srvctl add listener-h

Adds a listener configuration to the Oracle Clusterware.

Usage: srvctl add listener [- l] [- s] [- p "[TCP:] [,...] [/ IPC:] [/ NMP:] [/ TCPS:] [/ SDP:]"] [- o] [- k]

-l Listener name (default name is LISTENER) # listener name

-o ORACLE_HOME path (default value is CRS_HOME) # grid's home directory

-k network number (default number is 1) # the network number that was initially viewed

-s Skip the checking of ports

-p "[TCP:] [,...] [/ IPC:] [/ NMP:] [/ TCPS:] [/ SDP:]" Comma separated tcp ports or listener endpoints # specifies the port number

-h Print usage

[grid@cent6-ora11-ip16] $/ u01/gridhome/11g/bin/srvctl add listener-l LISTENER2-o $ORACLE_HOME-p 3521-k 1

[grid@cent6-ora11-ip16 ~] $/ u01/gridhome/11g/bin/srvctl start listener-l LISTENER2

[grid@cent6-ora11-ip16 admin] $ls-lh

Total 32K

-rw-r--r-- 1 grid oinstall 413 Feb 7 09:04 endpoints_listener.ora

-rw-r--r--. 1 grid oinstall 206 Sep 15 14:24 endpoints_listener.ora.bak.cent6-ora11-ip16

-rw-r--r--. 1 grid oinstall 184 Sep 15 14:24 listener1709152PM2404.bak

-rw-r--r-- 1 grid oinstall 519 Feb 7 09:04 listener.ora

-rw-r--r--. 1 grid oinstall 350 Sep 15 14:24 listener.ora.bak.cent6-ora11-ip16

Drwxr-xr-x. 2 grid oinstall 4.0K Sep 15 13:29 samples

-rw-r--r--. 1 grid oinstall 381 Dec 17 2012 shrept.lst

-rw-r--r--. 1 grid oinstall 229 Sep 15 14:24 sqlnet.ora

[grid@cent6-ora11-ip16 admin] $cat listener.ora

LISTENER2= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER2) # line added by Agent

LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER) # line added by Agent

LISTENER_SCAN1= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER_SCAN1) # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER2=ON # line added by Agent

[grid@cent6-ora11-ip16 admin] $cat endpoints_listener.ora

LISTENER2_CENT6-ORA11-IP16= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=cent6-ora11-ip16-vip) (PORT=3521)) (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.56.16) (PORT=3521) (IP=FIRST) # line added by Agent

LISTENER_CENT6-ORA11-IP16= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=cent6-ora11-ip16-vip) (PORT=1521)) (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.56.16) (PORT=1521) (IP=FIRST) # line added by Agent

# static registration

[grid@cent6-ora11-ip16 admin] $vi listener.ora

SID_LIST_LISTENER2 = # corresponding listener name

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = RACDB)

(ORACLE_HOME = / u01/gridhome/11g)

(SID_NAME = RACDB1) # SID corresponding to the node

)

)

LISTENER2= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER2) # line added by Agent

LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER) # line added by Agent

LISTENER_SCAN1= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER_SCAN1) # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER2=ON # line added by Agent

[grid@cent6-ora11-ip16 admin] $srvctl stop listener-l LISTENER2

[grid@cent6-ora11-ip16 admin] $srvctl start listener-l LISTENER2

[grid@cent6-ora11-ip16 admin] $lsnrctl status LISTENER2

LSNRCTL for Linux: Version 11.2.0.4.0-Production on 07-FEB-2018 09:21:14

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

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

STATUS of the LISTENER

-

Alias LISTENER2

Version TNSLSNR for Linux: Version 11.2.0.4.0-Production

Start Date 07-FEB-2018 09:20:46

Uptime 0 days 0 hr. 0 min. 28 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File / u01/gridhome/11g/network/admin/listener.ora

Listener Log File / u01/gridhome/11g/log/diag/tnslsnr/cent6-ora11-ip16/listener2/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.56.16) (PORT=3521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.56.18) (PORT=3521))

Services Summary...

Service "RACDB" has 1 instance (s).

Instance "RACDB1", status UNKNOWN, has 1 handler (s) for this service...

The command completed successfully

This is how srvctl adds new listeners and ports and registers statically. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.