srvctl新增新的監聽和埠並靜態註冊

raysuen發表於2018-02-07
[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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章