srvctl新增新的監聽和埠並靜態註冊
[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
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28572479/viewspace-2150915/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RAC】srvctl管理工具新增新監聽和靜態註冊
- 【監聽】動態註冊和靜態註冊
- Oracle監聽的靜態註冊和動態註冊Oracle
- oracle監聽靜態註冊和動態註冊Oracle
- ORACLE 動態註冊,靜態註冊,多個監聽,一個監聽多個埠配置Oracle
- oracle監聽器的靜態和動態註冊Oracle
- Oracle監聽的動態註冊與靜態註冊Oracle
- oracle監聽之動態和靜態註冊Oracle
- oracle監聽動態註冊與靜態註冊Oracle
- 動態和靜態監聽註冊-小魚的理解
- 【LISTENER】修改 LISTENER的監聽埠為1526(靜態註冊)
- oracle監聽動態註冊與靜態註冊[轉帖]Oracle
- 轉載:oracle監聽器的靜態和動態註冊Oracle
- Oracle 靜態監聽註冊詳解Oracle
- oracle監聽器動態註冊於靜態註冊的區別Oracle
- oracle監聽【非1521埠】動態註冊Oracle
- 監聽動態註冊
- 動態註冊監聽
- 動態監聽註冊
- 動態監聽和靜態監聽
- Oracle監聽器的靜態註冊與動態註冊,以及DB_DOMAIN問題OracleAI
- oracle 監聽器動態與靜態註冊服務_listenerOracle
- 動態註冊和靜態註冊
- 靜態註冊和動態註冊
- 12c 如何為每個pdb對應一個靜態註冊的監聽埠
- oracle的靜態註冊和動態註冊Oracle
- oracle靜態監聽和動態監聽Oracle
- rac監聽動態註冊
- 動態註冊監聽Listener
- Oracle 動態監聽註冊Oracle
- 【LISTENER】修改 LISTENER的監聽埠為1526(動態註冊)
- Oracle listener靜態註冊和動態註冊Oracle
- rac監聽不能動態註冊
- 靜態註冊和動態註冊總結(zt)
- listener靜態註冊和動態註冊總結
- 【原創】Oracle的動態監聽註冊Oracle
- 【listener】oracle靜態監聽和動態監聽 【轉載】Oracle
- 動態監聽與靜態監聽