共計 4194 個字符，預計需要花費 11 分鐘才能閱讀完成。

本篇文章給大家分享的是有關 srvctl 怎樣添加新的監聽和端口并靜態注冊，丸趣 TV 小編覺得挺實用的，因此分享給大家學習，希望大家閱讀完這篇文章后可以有所收獲，話不多說，跟著丸趣 TV 小編一起來看看吧。

[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 lsnr_name] [-s] [-p [TCP:] port [, …][/IPC: key][/NMP: pipe_name][/TCPS: s_port] [/SDP: port] ] [-o oracle_home] [-k net_num]

 -l lsnr_name  Listener name (default name is LISTENER)       #監聽名稱

 -o oracle_home  ORACLE_HOME path (default value is CRS_HOME)   #grid 的 home 目錄

 -k net_num  network number (default number is 1)  # 最開始查看的網絡號

 -s Skip the checking of ports

 -p [TCP:] port [, …][/IPC: key][/NMP: pipe_name][/TCPS: s_port] [/SDP: port]  Comma separated tcp ports or listener endpoints   #指定端口號

 -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

# 靜態注冊

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

SID_LIST_LISTENER2 = #對應的監聽名

 (SID_LIST =

 (SID_DESC =

 (GLOBAL_DBNAME = RACDB)

 (ORACLE_HOME = /u01/gridhome/11g)

 (SID_NAME = RACDB1) #節點對應的 SID

 )

 )

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

以上就是 srvctl 怎樣添加新的監聽和端口并靜態注冊，丸趣 TV 小編相信有部分知識點可能是我們日常工作會見到或用到的。希望你能通過這篇文章學到更多知識。更多詳情敬請關注丸趣 TV 行業資訊頻道。