srvctl怎樣添加新的監聽和端口并靜態注冊

本篇文章給大家分享的是有關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

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

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:niceseo99@gmail.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

評論

日本韩欧美一级A片在线观看