sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle 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

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@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增加节点时手动注册监听服务的案例步骤

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1038.html

Oracle研究中心

关键词:

通过crs_profile工具来手动注册监听服务

10G RAC手动注册监听服务详细过程