當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

oracle rac添加监听,【学习笔记】Oracle 10G RAC增加节点时手动注册监听服务的案例步骤...

發布時間：2025/3/21 编程问答 34 豆豆

生活随笔收集整理的這篇文章主要介紹了 oracle rac添加监听,【学习笔记】Oracle 10G RAC增加节点时手动注册监听服务的案例步骤... 小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

【學習筆記】Oracle 10G RAC增加節點時手動注冊監聽服務的案例步驟

時間:2016-10-22 22:53???來源:Oracle研究中心???作者:HTZ???點擊:

次

天萃荷凈

Oracle研究中心學習筆記：分享一篇關于Oracle數據庫RAC環境中在增加節點時需要手動注冊監聽服務，本文章通過crs_profile工具來手動注冊監聽服務。

下面測試來至一次增加與刪除實例實驗，在10G RAC中知道監聽是通過netca來管理的，跟11G的機制不一樣。

當增加節點的時候，需要手動執行netca來注冊監聽服務。其實我們也可以通過crs_profile工具來手動注冊監聽服務。

數據庫版本信息

[oracle@oracleplus.net oracle] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 – Production on Sun May 11 17:06:26 2014

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@oracleplus.net 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@oracleplus.net app] $cd $ORACLE_HOME/network/admin

[root@oracleplus.net 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@oracleplus.net oracle] $ crs_stat -p ora.sol2.LISTENER_SOL2.lsnr >/tmp/listener.txt

這里導出正常節點的監聽配置信息

[oracle@oracleplus.net 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=

Oracle о

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@oracleplus.net oracle]$ mv /tmp/listener.txt $ORA_CRS_HOME/crs/public/ora.sol1.LISTENER_SOL1.lsnr.cap

[oracle@oracleplus.net oracle]$ crs_register ora.sol1.LISTENER_SOL1.lsnr

[oracle@oracleplus.net 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@oracleplus.net 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@oracleplus.net 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@oracleplus.net oracle]$ crs_register ora.sol1.LISTENER_SOL1.lsnr

[oracle@oracleplus.net 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@oracleplus.net 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

本文固定鏈接: http://www.htz.pw/2014/05/11/10g-rac%e6%89%8b%e5%8a%a8%e6%b3%a8%e5%86%8c%e7%9b%91%e5%90%ac%e6%9c%8d%e5%8a%a1.html | 認真就輸

--------------------------------------ORACLE-DBA----------------------------------------

最權威、專業的Oracle案例資源匯總之【學習筆記】Oracle 10G RAC增加節點時手動注冊監聽服務的案例步驟

總結

以上是生活随笔為你收集整理的oracle rac添加监听,【学习笔记】Oracle 10G RAC增加节点时手动注册监听服务的案例步骤...的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： matlab命令fvtool,FVToo
下一篇： mongodb php代码实例,Mong