溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
下面測試來至一次增加與刪除實例實驗，在10G RAC中知道監聽是通過netca來管理的，跟11G的機制不一樣。
當增加節點的時候，需要手動執行netca來注冊監聽服務。其實我們也可以通過crs_profile工具來手動注冊監聽服務。
歡迎大家加入ORACLE超級群：17115662 免費解決各種ORACLE問題
數據庫版本信息
| [oracle@www.htz.pw oracle] $sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sun May 11 17:06:26 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$version;
BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Solaris: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production |
1，配置tnsnames.ora與listener.ora文件
如下：
| [root@www.htz.pw admin] $ cat listener.ora # listener.ora.sol1 Network Configuration File: /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora.sol1 # Generated by Oracle configuration tools.
LISTENER_SOL1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.48)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.46)(PORT = 1521)(IP = FIRST)) ) ) #這里建議使用IP地址 SID_LIST_LISTENER_SOL1 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) )
[root@www.htz.pw app] $cd $ORACLE_HOME/network/admin [root@www.htz.pw admin] $ cat tnsnames.ora # tnsnames.ora.sol1 Network Configuration File: /oracle/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora.sol1 # Generated by Oracle configuration tools.
LISTENERS_SOL10G = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sol1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = sol2-vip)(PORT = 1521)) ) #這里建議使用IP地址，在10G中配置REMOTE_LISTENER的時候，默認會用到這里的東西 SOL10G2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sol2-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sol10g) (INSTANCE_NAME = sol10g2) ) )
SOL10G1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sol1-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sol10g) (INSTANCE_NAME = sol10g1) ) )
SOL10G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sol1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = sol2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sol10g) ) ) |
2，crs_register注冊監聽服務
注意監聽服務有兩種方法，1，利用現在的監聽的配置信息。2，使用crs_profile來創建
2.1 利用現有的監聽配置信息
| [oracle@www.htz.pw oracle] $ crs_stat -p ora.sol2.LISTENER_SOL2.lsnr >/tmp/listener.txt 這里導出正常節點的監聽配置信息
[oracle@www.htz.pw oracle] $ cat /tmp/listener.txt NAME=ora.sol1.LISTENER_SOL1.lsnr #這里需要注意的LISTENER_SOL1這個名字需要跟listener.ora中的監聽名一致 TYPE=application ACTION_SCRIPT=/oracle/app/oracle/product/10.2.0/db_1/bin/racgwrap ACTIVE_PLACEMENT=0 AUTO_START=1 CHECK_INTERVAL=600 DESCRIPTION=CRS application for listener on node FAILOVER_DELAY=0 FAILURE_INTERVAL=0 FAILURE_THRESHOLD=0 HOSTING_MEMBERS=sol1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES=ora.sol1.vip RESTART_ATTEMPTS=5 SCRIPT_TIMEOUT=600 START_TIMEOUT=0 STOP_TIMEOUT=0 UPTIME_THRESHOLD=7d USR_ORA_ALERT_NAME= USR_ORA_CHECK_TIMEOUT=0 USR_ORA_CONNECT_STR=/ as sysdba USR_ORA_DEBUG=0 USR_ORA_DISCONNECT=false USR_ORA_FLAGS= USR_ORA_IF= USR_ORA_INST_NOT_SHUTDOWN= USR_ORA_LANG= USR_ORA_NETMASK= USR_ORA_OPEN_MODE= USR_ORA_OPI=false USR_ORA_PFILE= USR_ORA_PRECONNECT=none USR_ORA_SRV= USR_ORA_START_TIMEOUT=0 USR_ORA_STOP_MODE=immediate USR_ORA_STOP_TIMEOUT=0 USR_ORA_VIP= 一共就3個地址需要修改 [oracle@www.htz.pw oracle]$ mv /tmp/listener.txt $ORA_CRS_HOME/crs/public/ora.sol1.LISTENER_SOL1.lsnr.cap [oracle@www.htz.pw oracle]$ crs_register ora.sol1.LISTENER_SOL1.lsnr [oracle@www.htz.pw oracle]$ crs_start ora.sol1.LISTENER_SOL1.lsnr Attempting to start `ora.sol1.LISTENER_SOL1.lsnr` on member `sol1` Start of `ora.sol1.LISTENER_SOL1.lsnr` on member `sol1` succeeded. 監聽能正常啟動 |
2.2 使用crs_profiler來手動創建監聽
不到萬不得以，不建議使用下面的方法
| [oracle@www.htz.pw oracle]$ crs_profile -create ora.sol1.LISTENER_SOL1.lsnr -t application -a /oracle/app/oracle/product/10.2.0/db_1/bin/racgwrap -d "CRS application for listener on node" -h sol1 -r ora.sol1.vip -p restricted -o as=1,ci=600,st=600,ra=5
[oracle@www.htz.pw oracle]$ cat ora.sol1.LISTENER_SOL1.lsnr.cap NAME=ora.sol1.LISTENER_SOL1.lsnr TYPE=application ACTION_SCRIPT=/oracle/app/oracle/product/10.2.0/db_1/bin/racgwrap ACTIVE_PLACEMENT=0 AUTO_START=1 CHECK_INTERVAL=600 DESCRIPTION=CRS application for listener on node FAILOVER_DELAY=0 FAILURE_INTERVAL=0 FAILURE_THRESHOLD=0 HOSTING_MEMBERS=sol1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES=ora.sol1.vip RESTART_ATTEMPTS=5 SCRIPT_TIMEOUT=600 START_TIMEOUT=0 STOP_TIMEOUT=0 UPTIME_THRESHOLD=7d USR_ORA_ALERT_NAME= USR_ORA_CHECK_TIMEOUT=0 USR_ORA_CONNECT_STR=/ as sysdba USR_ORA_DEBUG=0 USR_ORA_DISCONNECT=false USR_ORA_FLAGS= USR_ORA_IF= USR_ORA_INST_NOT_SHUTDOWN= USR_ORA_LANG= USR_ORA_NETMASK= USR_ORA_OPEN_MODE= USR_ORA_OPI=false USR_ORA_PFILE= USR_ORA_PRECONNECT=none USR_ORA_SRV= USR_ORA_START_TIMEOUT=0 USR_ORA_STOP_MODE=immediate USR_ORA_STOP_TIMEOUT=0 USR_ORA_VIP=
[oracle@www.htz.pw oracle]$ crs_register ora.sol1.LISTENER_SOL1.lsnr [oracle@www.htz.pw oracle]$ crs_start ora.sol1.LISTENER_SOL1.lsnr Attempting to start `ora.sol1.LISTENER_SOL1.lsnr` on member `sol1` Start of `ora.sol1.LISTENER_SOL1.lsnr` on member `sol1` succeeded
其實如果是VIP資源的時候，我們需要注意了，因為VIP資料的屬組是root [oracle@www.htz.pw oracle]$ crs_stat -ls Name Owner Primary PrivGrp Permission ----------------------------------------------------------------- ora....L1.lsnr oracle oinstall rwxrwxr-- ora.sol1.gsd oracle oinstall rwxr-xr-- ora.sol1.ons oracle oinstall rwxr-xr-- ora.sol1.vip root oinstall rwxr-xr-- ora.sol10g.db oracle oinstall rwxrwxr-- ora....g2.inst oracle oinstall rwxrwxr-- ora....SM2.asm oracle oinstall rwxrwxr-- ora....L2.lsnr oracle oinstall rwxrwxr-- ora.sol2.gsd oracle oinstall rwxr-xr-- ora.sol2.ons oracle oinstall rwxr-xr-- ora.sol2.vip root oinstall rwxr-xr |
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
