Oracle 11GR2-RAC环境下修改主机名
来源:互联网 发布:linux 解压zip 重命名 编辑:程序博客网 时间:2024/06/05 19:09
Oracle 11GR2-RAC环境下修改主机名
aix 6106+oracle 11203
修改主机名:
第一个节点:从dbrac1修改为dbrac100
第二个节点:从dbrac2修改为dbrac200
一、先卸载CRS
在非最后一个节点运行/oracle/asm/crs/install/rootcrs.pl -verbose -deconfig -force
Using configuration parameter file: /oracle/asm/crs/install/crsconfig_params
Network exists: 1/8.8.6.0/255.255.255.0/en0, type static
VIP exists: /dbrac1-vip/8.8.6.11/8.8.6.0/255.255.255.0/en0, hosting node dbrac1
VIP exists: /dbrac2-vip/8.8.6.21/8.8.6.0/255.255.255.0/en0, hosting node dbrac2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'dbrac1'
CRS-2677: Stop of 'ora.registry.acfs' on 'dbrac1' succeeded
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbrac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'dbrac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dbrac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.ASMCRS.dg' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'dbrac1'
CRS-2677: Stop of 'ora.racdb.db' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.ASMVG1.dg' on 'dbrac1'
CRS-2677: Stop of 'ora.ASMVG1.dg' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'dbrac1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'dbrac2'
CRS-2676: Start of 'ora.oc4j' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.ASMCRS.dg' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac1'
CRS-2677: Stop of 'ora.asm' on 'dbrac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dbrac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.crf' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'dbrac1'
CRS-2677: Stop of 'ora.crf' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dbrac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbrac1'
CRS-2677: Stop of 'ora.cssd' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'dbrac1'
CRS-2677: Stop of 'ora.gipcd' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'dbrac1'
CRS-2677: Stop of 'ora.gpnpd' on 'dbrac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbrac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
This may take several minutes. Please wait ...
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
Successfully deconfigured Oracle clusterware stack on this node
在最后一个节点运行/oracle/asm/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode
Using configuration parameter file: /oracle/asm/crs/install/crsconfig_params
CRS resources for listeners are still configured
Network exists: 1/8.8.6.0/255.255.255.0/en0, type static
VIP exists: /dbrac2-vip/8.8.6.21/8.8.6.0/255.255.255.0/en0, hosting node dbrac2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'dbrac2'
CRS-2677: Stop of 'ora.registry.acfs' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'dbrac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dbrac2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.ASMCRS.dg' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'dbrac2'
CRS-2677: Stop of 'ora.racdb.db' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.ASMVG1.dg' on 'dbrac2'
CRS-2677: Stop of 'ora.ASMVG1.dg' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.ASMCRS.dg' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac2'
CRS-2677: Stop of 'ora.asm' on 'dbrac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dbrac2' has completed
CRS-2677: Stop of 'ora.crsd' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac2'
CRS-2677: Stop of 'ora.evmd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dbrac2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbrac2'
CRS-2677: Stop of 'ora.cssd' on 'dbrac2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'dbrac2'
CRS-2676: Start of 'ora.cssdmonitor' on 'dbrac2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'dbrac2'
CRS-2672: Attempting to start 'ora.diskmon' on 'dbrac2'
CRS-2676: Start of 'ora.diskmon' on 'dbrac2' succeeded
CRS-2676: Start of 'ora.cssd' on 'dbrac2' succeeded
CRS-4611: Successful deletion of voting disk +ASMCRS.
ASM de-configuration trace file location: /tmp/asmcadc_clean2012-11-20_10-05-15-AM.log
ASM Clean Configuration START
ASM Clean Configuration END
ASM with SID +ASM1 deleted successfully. Check /tmp/asmcadc_clean2012-11-20_10-05-15-AM.log for details.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbrac2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.crf' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac2'
CRS-2677: Stop of 'ora.mdnsd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.crf' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dbrac2'
CRS-2677: Stop of 'ora.ctssd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbrac2'
CRS-2677: Stop of 'ora.cssd' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'dbrac2'
CRS-2677: Stop of 'ora.gipcd' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'dbrac2'
CRS-2677: Stop of 'ora.gpnpd' on 'dbrac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbrac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
This may take several minutes. Please wait ...
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
Successfully deconfigured Oracle clusterware stack on this node
二、修改主机名
smitty tcpip修改主机名
第一节点:dbrac1修改为dbrac100
第一节点:dbrac2修改为dbrac200
三、修改/etc/hosts
# *** Oracle Scan IP ***
8.8.6.9 dbrac-scan
# *** Oracle Public IP ***
8.8.6.10 dbrac1
8.8.6.20 dbrac2
# *** Oracle Virtual IP ***
8.8.6.11 dbrac1-vip
8.8.6.21 dbrac2-vip
# *** Oracle Private IP ***
7.7.9.10 dbrac1-priv
7.7.9.20 dbrac2-priv
修改为:
# *** Oracle Scan IP ***
8.8.6.9 dbrac-scan
# *** Oracle Public IP ***
8.8.6.10 dbrac100
8.8.6.20 dbrac200
# *** Oracle Virtual IP ***
8.8.6.11 dbrac100-vip
8.8.6.21 dbrac200-vip
# *** Oracle Private IP ***
7.7.9.10 dbrac100-priv
7.7.9.20 dbrac200-priv
四、修改11g grid的参数文件
修改$ORACLE_HOME/crs/install/crsconfig_params中相关部分:
ORACLE_HOME=/oracle/asm
ORACLE_BASE=/oracle/grid
OLD_CRS_HOME=
JREDIR=/oracle/asm/jdk/jre/
JLIBDIR=/oracle/asm/jlib
VNDR_CLUSTER=false
OCR_LOCATIONS=NO_VAL
CLUSTER_NAME=dbrac-cluster
HOST_NAME_LIST=dbrac100,dbrac200
NODE_NAME_LIST=dbrac100,dbrac200
PRIVATE_NAME_LIST=
VOTING_DISKS=NO_VAL
#VF_DISCOVERY_STRING=%s_vfdiscoverystring%
ASM_UPGRADE=false
ASM_SPFILE=
ASM_DISK_GROUP=ASMCRS
ASM_DISCOVERY_STRING=
ASM_DISKS=/dev/rhdisk3
ASM_REDUNDANCY=EXTERNAL
CRS_STORAGE_OPTION=1
CSS_LEASEDURATION=400
CRS_NODEVIPS="dbrac100-vip/255.255.255.0/en0,dbrac200-vip/255.255.255.0/en0"
NODELIST=dbrac100,dbrac200
NETWORKS="en0"/8.8.6.0:public,"en1"/7.7.9.0:cluster_interconnect
SCAN_NAME=dbrac-scan
SCAN_PORT=1521
GPNP_PA=
OCFS_CONFIG=
# GNS consts
GNS_CONF=false
GNS_ADDR_LIST=
GNS_DOMAIN_LIST=
GNS_ALLOW_NET_LIST=
GNS_DENY_NET_LIST=
GNS_DENY_ITF_LIST=
#### Required by OUI add node
NEW_HOST_NAME_LIST=
NEW_NODE_NAME_LIST=
NEW_PRIVATE_NAME_LIST=
NEW_NODEVIPS="dbrac100-vip/255.255.255.0/en0,dbrac200-vip/255.255.255.0/en0"
############### OCR constants
# GPNPCONFIGDIR is handled differently in dev (T_HAS_WORK for all)
# GPNPGCONFIGDIR in dev expands to T_HAS_WORK_GLOBAL
GPNPCONFIGDIR=$ORACLE_HOME
GPNPGCONFIGDIR=$ORACLE_HOME
OCRLOC=
OLRLOC=
OCRID=
CLUSTER_GUID=
CLSCFG_MISSCOUNT=
#### IPD/OS
CRFHOME="/oracle/asm"
注:10g RAC的参数配置文件: $ORA_CRS_HOME/install/rootconfig
五、在各个节点依次运行root.sh脚本
节点1运行root.sh
另外一个节点运行root.sh
六、注册信息
1.grid用户asmca命令加载ASMVG1
2.oracle用户注册集群信息
./srvctl add database -d racdb -o /oracle/db/product/11.2
./srvctl add instance -d racdb -i racdb1 -n dbrac100
./srvctl add instance -d racdb -i racdb2 -n dbrac200
root用户
./srvctl add scan -n dbrac-scan -S 8.8.6.0/255.255.255.0
3.grid用户netca注册监听
七、完成检查状态
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ASMCRS.dg ora....up.type ONLINE ONLINE dbrac100
ora.ASMVG1.dg ora....up.type ONLINE ONLINE dbrac100
ora....ER.lsnr ora....er.type ONLINE ONLINE dbrac100
ora.asm ora.asm.type ONLINE ONLINE dbrac100
ora....SM1.asm application ONLINE ONLINE dbrac100
ora....00.lsnr application ONLINE ONLINE dbrac100
ora....100.gsd application OFFLINE OFFLINE
ora....100.ons application ONLINE ONLINE dbrac100
ora....100.vip ora....t1.type ONLINE ONLINE dbrac100
ora....SM2.asm application ONLINE ONLINE dbrac200
ora....00.lsnr application ONLINE ONLINE dbrac200
ora....200.gsd application OFFLINE OFFLINE
ora....200.ons application ONLINE ONLINE dbrac200
ora....200.vip ora....t1.type ONLINE ONLINE dbrac200
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE dbrac100
ora.ons ora.ons.type ONLINE ONLINE dbrac100
ora.racdb.db ora....se.type ONLINE ONLINE dbrac100
ora.scan1.vip ora....ip.type ONLINE ONLINE dbrac100
【作者按】转载请著名出处,谢谢。
Oracle 10G RAC修改主机名可参考DAVE大牛人的大作:http://blog.csdn.net/tianlesoftware/article/details/6055612
aix 6106+oracle 11203
修改主机名:
第一个节点:从dbrac1修改为dbrac100
第二个节点:从dbrac2修改为dbrac200
一、先卸载CRS
在非最后一个节点运行/oracle/asm/crs/install/rootcrs.pl -verbose -deconfig -force
Using configuration parameter file: /oracle/asm/crs/install/crsconfig_params
Network exists: 1/8.8.6.0/255.255.255.0/en0, type static
VIP exists: /dbrac1-vip/8.8.6.11/8.8.6.0/255.255.255.0/en0, hosting node dbrac1
VIP exists: /dbrac2-vip/8.8.6.21/8.8.6.0/255.255.255.0/en0, hosting node dbrac2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'dbrac1'
CRS-2677: Stop of 'ora.registry.acfs' on 'dbrac1' succeeded
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbrac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'dbrac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dbrac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.ASMCRS.dg' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'dbrac1'
CRS-2677: Stop of 'ora.racdb.db' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.ASMVG1.dg' on 'dbrac1'
CRS-2677: Stop of 'ora.ASMVG1.dg' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'dbrac1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'dbrac2'
CRS-2676: Start of 'ora.oc4j' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.ASMCRS.dg' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac1'
CRS-2677: Stop of 'ora.asm' on 'dbrac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dbrac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.crf' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'dbrac1'
CRS-2677: Stop of 'ora.crf' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'dbrac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dbrac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbrac1'
CRS-2677: Stop of 'ora.cssd' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'dbrac1'
CRS-2677: Stop of 'ora.gipcd' on 'dbrac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'dbrac1'
CRS-2677: Stop of 'ora.gpnpd' on 'dbrac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbrac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
This may take several minutes. Please wait ...
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
Successfully deconfigured Oracle clusterware stack on this node
在最后一个节点运行/oracle/asm/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode
Using configuration parameter file: /oracle/asm/crs/install/crsconfig_params
CRS resources for listeners are still configured
Network exists: 1/8.8.6.0/255.255.255.0/en0, type static
VIP exists: /dbrac2-vip/8.8.6.21/8.8.6.0/255.255.255.0/en0, hosting node dbrac2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'dbrac2'
CRS-2677: Stop of 'ora.registry.acfs' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'dbrac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'dbrac2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.ASMCRS.dg' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'dbrac2'
CRS-2677: Stop of 'ora.racdb.db' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.ASMVG1.dg' on 'dbrac2'
CRS-2677: Stop of 'ora.ASMVG1.dg' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.ASMCRS.dg' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac2'
CRS-2677: Stop of 'ora.asm' on 'dbrac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'dbrac2' has completed
CRS-2677: Stop of 'ora.crsd' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac2'
CRS-2677: Stop of 'ora.evmd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dbrac2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbrac2'
CRS-2677: Stop of 'ora.cssd' on 'dbrac2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'dbrac2'
CRS-2676: Start of 'ora.cssdmonitor' on 'dbrac2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'dbrac2'
CRS-2672: Attempting to start 'ora.diskmon' on 'dbrac2'
CRS-2676: Start of 'ora.diskmon' on 'dbrac2' succeeded
CRS-2676: Start of 'ora.cssd' on 'dbrac2' succeeded
CRS-4611: Successful deletion of voting disk +ASMCRS.
ASM de-configuration trace file location: /tmp/asmcadc_clean2012-11-20_10-05-15-AM.log
ASM Clean Configuration START
ASM Clean Configuration END
ASM with SID +ASM1 deleted successfully. Check /tmp/asmcadc_clean2012-11-20_10-05-15-AM.log for details.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbrac2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.crf' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'dbrac2'
CRS-2673: Attempting to stop 'ora.asm' on 'dbrac2'
CRS-2677: Stop of 'ora.mdnsd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.crf' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'dbrac2'
CRS-2677: Stop of 'ora.ctssd' on 'dbrac2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbrac2'
CRS-2677: Stop of 'ora.cssd' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'dbrac2'
CRS-2677: Stop of 'ora.gipcd' on 'dbrac2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'dbrac2'
CRS-2677: Stop of 'ora.gpnpd' on 'dbrac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbrac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
This may take several minutes. Please wait ...
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
Successfully deconfigured Oracle clusterware stack on this node
二、修改主机名
smitty tcpip修改主机名
第一节点:dbrac1修改为dbrac100
第一节点:dbrac2修改为dbrac200
三、修改/etc/hosts
# *** Oracle Scan IP ***
8.8.6.9 dbrac-scan
# *** Oracle Public IP ***
8.8.6.10 dbrac1
8.8.6.20 dbrac2
# *** Oracle Virtual IP ***
8.8.6.11 dbrac1-vip
8.8.6.21 dbrac2-vip
# *** Oracle Private IP ***
7.7.9.10 dbrac1-priv
7.7.9.20 dbrac2-priv
修改为:
# *** Oracle Scan IP ***
8.8.6.9 dbrac-scan
# *** Oracle Public IP ***
8.8.6.10 dbrac100
8.8.6.20 dbrac200
# *** Oracle Virtual IP ***
8.8.6.11 dbrac100-vip
8.8.6.21 dbrac200-vip
# *** Oracle Private IP ***
7.7.9.10 dbrac100-priv
7.7.9.20 dbrac200-priv
四、修改11g grid的参数文件
修改$ORACLE_HOME/crs/install/crsconfig_params中相关部分:
ORACLE_HOME=/oracle/asm
ORACLE_BASE=/oracle/grid
OLD_CRS_HOME=
JREDIR=/oracle/asm/jdk/jre/
JLIBDIR=/oracle/asm/jlib
VNDR_CLUSTER=false
OCR_LOCATIONS=NO_VAL
CLUSTER_NAME=dbrac-cluster
HOST_NAME_LIST=dbrac100,dbrac200
NODE_NAME_LIST=dbrac100,dbrac200
PRIVATE_NAME_LIST=
VOTING_DISKS=NO_VAL
#VF_DISCOVERY_STRING=%s_vfdiscoverystring%
ASM_UPGRADE=false
ASM_SPFILE=
ASM_DISK_GROUP=ASMCRS
ASM_DISCOVERY_STRING=
ASM_DISKS=/dev/rhdisk3
ASM_REDUNDANCY=EXTERNAL
CRS_STORAGE_OPTION=1
CSS_LEASEDURATION=400
CRS_NODEVIPS="dbrac100-vip/255.255.255.0/en0,dbrac200-vip/255.255.255.0/en0"
NODELIST=dbrac100,dbrac200
NETWORKS="en0"/8.8.6.0:public,"en1"/7.7.9.0:cluster_interconnect
SCAN_NAME=dbrac-scan
SCAN_PORT=1521
GPNP_PA=
OCFS_CONFIG=
# GNS consts
GNS_CONF=false
GNS_ADDR_LIST=
GNS_DOMAIN_LIST=
GNS_ALLOW_NET_LIST=
GNS_DENY_NET_LIST=
GNS_DENY_ITF_LIST=
#### Required by OUI add node
NEW_HOST_NAME_LIST=
NEW_NODE_NAME_LIST=
NEW_PRIVATE_NAME_LIST=
NEW_NODEVIPS="dbrac100-vip/255.255.255.0/en0,dbrac200-vip/255.255.255.0/en0"
############### OCR constants
# GPNPCONFIGDIR is handled differently in dev (T_HAS_WORK for all)
# GPNPGCONFIGDIR in dev expands to T_HAS_WORK_GLOBAL
GPNPCONFIGDIR=$ORACLE_HOME
GPNPGCONFIGDIR=$ORACLE_HOME
OCRLOC=
OLRLOC=
OCRID=
CLUSTER_GUID=
CLSCFG_MISSCOUNT=
#### IPD/OS
CRFHOME="/oracle/asm"
注:10g RAC的参数配置文件: $ORA_CRS_HOME/install/rootconfig
五、在各个节点依次运行root.sh脚本
节点1运行root.sh
另外一个节点运行root.sh
六、注册信息
1.grid用户asmca命令加载ASMVG1
2.oracle用户注册集群信息
./srvctl add database -d racdb -o /oracle/db/product/11.2
./srvctl add instance -d racdb -i racdb1 -n dbrac100
./srvctl add instance -d racdb -i racdb2 -n dbrac200
root用户
./srvctl add scan -n dbrac-scan -S 8.8.6.0/255.255.255.0
3.grid用户netca注册监听
七、完成检查状态
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.ASMCRS.dg ora....up.type ONLINE ONLINE dbrac100
ora.ASMVG1.dg ora....up.type ONLINE ONLINE dbrac100
ora....ER.lsnr ora....er.type ONLINE ONLINE dbrac100
ora.asm ora.asm.type ONLINE ONLINE dbrac100
ora....SM1.asm application ONLINE ONLINE dbrac100
ora....00.lsnr application ONLINE ONLINE dbrac100
ora....100.gsd application OFFLINE OFFLINE
ora....100.ons application ONLINE ONLINE dbrac100
ora....100.vip ora....t1.type ONLINE ONLINE dbrac100
ora....SM2.asm application ONLINE ONLINE dbrac200
ora....00.lsnr application ONLINE ONLINE dbrac200
ora....200.gsd application OFFLINE OFFLINE
ora....200.ons application ONLINE ONLINE dbrac200
ora....200.vip ora....t1.type ONLINE ONLINE dbrac200
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE dbrac100
ora.ons ora.ons.type ONLINE ONLINE dbrac100
ora.racdb.db ora....se.type ONLINE ONLINE dbrac100
ora.scan1.vip ora....ip.type ONLINE ONLINE dbrac100
The END.
- Oracle 11GR2-RAC环境下修改主机名
- Oracle RAC 环境下修改主机名
- Oracle RAC 环境下修改主机名
- Oracle RAC 环境下修改主机名
- Oracle RAC 环境下修改主机名
- Oracle RAC 11gR2 环境下的连接管理
- oracle RAC 11gR2 修改ip地址
- Oracle 11gR2 RAC修改SCAN IP
- Oracle 11gR2 RAC修改VIP
- Oracle 11gR2 RAC 修改监听器端口号的步骤
- Oracle 11gR2 RAC修改SCAN IP地址
- Oracle RAC 修改 IP 地址& 修改主机名
- Rhel5 oracle 11gr2 rac 环境 的安装
- rac 环境下修改oracle数据库字符集
- 在RAC环境下修改Oracle字符集
- oracle 11gR2 RAC 安装
- 卸载Oracle 11gR2 RAC
- AIX 5.3/6.1环境下安装Oracle 10gR2 RAC常见报错
- java关键字大全集
- ADO.NET中的DataReader与DataSet
- WinCE中的Data/ Prefetch Abort异常定位
- 自己学写爬虫之----CS240EXCEPTION(一)
- C语言数据结构之单向链表(已经调试可以实现相应的功能了,可是还是有几个问题现在还是不大理解,希望大家能够一起探讨)
- Oracle 11GR2-RAC环境下修改主机名
- YII 中使用Ueditor
- Android中的Audio播放:音量和远程播放控制
- Vim Essential Plugin: NERDTree
- 策略模式
- USACO:Prime Palindromes
- [LeetCode] Combinations
- Spring Blazeds integration
- Uva 10635 王子和公主(LCS转LIS+二分)