上海涛德顾问学院

查看: 5129|回复: 0

[Oracle数据库] 修改Oracle 11g R2 RAC 主机名(11g OCM学员作品)

[复制链接]

88

主题

0

好友

451

积分

管理员

Rank: 9Rank: 9Rank: 9

发表于 2014-4-16 18:41:58 |显示全部楼层
redhat linux 5.4 rac 修改主机名

0.配置信息
A.cluster安装用户是grid,设置 ORACLE_HOME=/u01/app/11.2.0/grid
B.RAC安装用户是oracle,设置   ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
C.VBox4.2.12+OEL6.4i386+Oracle11gR203+2节点Rac

1. 两个节点ora和orb,/etc/hosts的配置如下
192.168.11.101  ora
192.168.11.102  ora-vip
192.168.88.100  ora-priv

192.168.11.104  orb
192.168.11.105  orb-vip
192.168.88.101  orb-priv

192.168.11.103  ora-scan

2.CRS状态
Name                                    Type                         Target     State      Host      
----------------------------------- -------------------------- ---------- ---------  -------   
ora.CRS1.dg                    ora.diskgroup.type         ONLINE     ONLINE     ora       
ora.DATA.dg                    ora.diskgroup.type         ONLINE     ONLINE     ora       
ora.LISTENER.lsnr              ora.listener.type          ONLINE     ONLINE    ora       
ora.LISTENER_SCAN1.lsnr        ora.scan_listener.type     ONLINE     ONLINE    ora       
ora.asm                        ora.asm.type               ONLINE     ONLINE    ora       
ora.ck.db                      ora.database.type          OFFLINE    OFFLINE              
ora.cvu                        ora.cvu.type               ONLINE     ONLINE     ora       
ora.gsd                        ora.gsd.type               OFFLINE    OFFLINE              
ora.net1.network               ora.network.type           ONLINE     ONLINE     ora       
ora.oc4j                       ora.oc4j.type              ONLINE     ONLINE    ora      
ora.ons                        ora.ons.type               ONLINE     ONLINE     ora       
ora.ora.ASM1.asm               application                ONLINE     ONLINE     ora       
ora.ora.LISTENER_ORA.lsnr      application                ONLINE     ONLINE    ora      
ora.ora.gsd                    application                OFFLINE    OFFLINE              
ora.ora.ons                    application                ONLINE     ONLINE    ora       
ora.ora.vip                    ora.cluster_vip_net1.type  ONLINE     ONLINE    ora       
ora.orb.ASM2.asm               application                ONLINE     ONLINE    orb       
ora.orb.LISTENER_ORB.lsnr      application                ONLINE     ONLINE    orb       
ora.orb.gsd                    application                OFFLINE    OFFLINE              
ora.orb.ons                    application                ONLINE     ONLINE     orb      
ora.orb.vip                    ora.cluster_vip_net1.type  ONLINE     ONLINE    orb      
ora.orcl.db                    ora.database.type          ONLINE     ONLINE    ora       
ora.orcl.orcl.xj.com.svc       ora.service.type           ONLINE     ONLINE    ora       
ora.scan1.vip                  ora.scan_vip.type          ONLINE     ONLINE     ora

2.现在要把两个节点的主机名改为rac1和rac2,方法是:删除2节点,改2节点主机名,加2节点进入crs,删除1节点,改1节点主机名,加1节点进入crs

3.删除2节点

A.检查2节点是否是active和Unpinned ,如果是pinned的,用crsctl unpin css
olsnodes -s -t
ora     Active  Unpinned
orb     Active  Unpinned

B. root用户在2节点 GRID_HOME 上执行
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Network exists: 1/192.168.11.0/255.255.255.0/eth0, type static
VIP exists: /ora-vip/192.168.11.102/192.168.11.0/255.255.255.0/eth0, hosting node ora
VIP exists: /orb-vip/192.168.11.105/192.168.11.0/255.255.255.0/eth0, hosting node orb
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'orb'
CRS-2673: Attempting to stop 'ora.crsd' on 'orb'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'orb'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'orb'
CRS-2673: Attempting to stop 'ora.orcl.db' on 'orb'
CRS-2677: Stop of 'ora.orcl.db' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'orb'
CRS-2677: Stop of 'ora.DATA1.dg' on 'orb' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'orb'
CRS-2677: Stop of 'ora.asm' on 'orb' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'orb' has completed
CRS-2677: Stop of 'ora.crsd' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'orb'
CRS-2673: Attempting to stop 'ora.ctssd' on 'orb'
CRS-2673: Attempting to stop 'ora.evmd' on 'orb'
CRS-2673: Attempting to stop 'ora.asm' on 'orb'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'orb'
CRS-2677: Stop of 'ora.crf' on 'orb' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'orb' succeeded
CRS-2677: Stop of 'ora.evmd' on 'orb' succeeded
CRS-2677: Stop of 'ora.asm' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'orb'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'orb' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'orb'
CRS-2677: Stop of 'ora.cssd' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'orb'
CRS-2677: Stop of 'ora.gipcd' on 'orb' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'orb'
CRS-2677: Stop of 'ora.gpnpd' on 'orb' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'orb' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully deconfigured Oracle clusterware stack on this node

C.从1节点上root执行
/u01/app/11.2.0/grid/bin/crsctl delete node -n orb
CRS-4661: Node orb successfully deleted.

D. 从2节点上grid用户执行
/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={orb}" CRS=TRUE -silent -local

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 2010 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.

E. 从2节点上grid用户执行
/u01/app/11.2.0/grid/deinstall/deinstall –local
期间会有交互,一直回车用默认值,最后产生一个脚本,用root在另一终端执行

F.从1节点上grid用户执行
/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={ora}" CRS=TRUE -silent -local
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1433 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.

G.在1节点上检查2节点是否被删除成功
cluvfy stage -post nodedel -n orb -verbose

H.节点2被正确删除后,修改节点2的主机名为rac2,修改两个节点的/etc/host
192.168.11.101  ora
192.168.11.102  ora-vip
192.168.88.100  ora-priv

192.168.11.104  rac2
192.168.11.105  rac2-vip
192.168.88.101  rac2-priv

192.168.11.103  ora-scan

I.加节点2到CRS
1.节点1上grid用户,检查节点2是否满足
cluvfy stage -pre nodeadd -n rac2 -fixup -fixupdir /tmp -verbose

Performing pre-checks for node addition

Checking node reachability...

Check: Node reachability from node "ora"
  Destination Node                      Reachable?              
  ------------------------------------  ------------------------
  rac2                                  yes                     
Result: Node reachability check passed from node "ora"


Checking user equivalence...

Check: User equivalence for user "grid"
  Node Name                             Status                  
  ------------------------------------  ------------------------
  rac2                                  failed                  
Result: PRVF-4007 : User equivalence check failed for user "grid"

ERROR:
User equivalence unavailable on all the specified nodes
Verification cannot proceed


Pre-check for node addition was unsuccessful on all the nodes.

因为主机名修改了,两节点间grid用户信任关系需要重建
/u01/app/11.2.0/grid/deinstall/sshUserSetup.sh -user grid -hosts ora rac2 -noPromptPassphrase

2.节点1上grid用户执行
$ORACLE_HOME/oui/bin/addNode.sh "CLUSTER_NEW_NODES={rac2}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac2-vip}"
一些无关紧要的小问题检查不通过,在图形界面安装时是可以忽略的,这里是不能直接忽略的,需要修改一下addNode.sh文件
#!/bin/sh
OHOME=/u01/app/11.2.0/grid
INVPTRLOC=$OHOME/oraInst.loc
EXIT_CODE=0
ADDNODE="$OHOME/oui/bin/runInstaller -addNode -invPtrLoc $INVPTRLOC ORACLE_HOME=$OHOME $*"
if [ "$IGNORE_PREADDNODE_CHECKS" = "Y" -o ! -f "$OHOME/cv/cvutl/check_nodeadd.pl" ]
then
        $ADDNODE
        EXIT_CODE=$?;
else
        CHECK_NODEADD="$OHOME/perl/bin/perl $OHOME/cv/cvutl/check_nodeadd.pl -pre ORACLE_HOME=$OHOME $*"
        $CHECK_NODEADD
        EXIT_CODE=$?;
EXIT_CODE=0   ##在这里添加一行,用于忽略一些小错误
        if [ $EXIT_CODE -eq 0 ]
        then
                $ADDNODE
                EXIT_CODE=$?;
        fi
fi
exit $EXIT_CODE ;

重新执行

$ORACLE_HOME/oui/bin/addNode.sh "CLUSTER_NEW_NODES={rac2}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac2-vip}"


Performing pre-checks for node addition

Checking node reachability...
Node reachability check passed from node "ora"


Checking user equivalence...
User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.11.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.11.0".
Subnet mask consistency check passed.

Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.11.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.11.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking CRS integrity...

Clusterware version consistency passed

CRS integrity check passed

Checking shared resources...

Checking CRS home location...
"/u01/app/11.2.0/grid" is shared
Shared resources check for node addition passed


Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.11.0"


Check: Node connectivity for interface "eth1"
Node connectivity passed for interface "eth1"
TCP connectivity check passed for subnet "192.168.88.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.11.0".
Subnet mask consistency check passed for subnet "192.168.88.0".
Subnet mask consistency check passed.

Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.11.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.11.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.168.88.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.88.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.
Total memory check failed
Check failed on nodes:
        rac2,ora
Available memory check passed
Swap space check passed
Free disk space check failed for "rac2:/u01/app/11.2.0/grid,rac2:/tmp"
Check failed on nodes:
        rac2
Free disk space check failed for "ora:/u01/app/11.2.0/grid,ora:/tmp"
Check failed on nodes:
        ora
Check for multiple users with UID value 1100 passed
User existence check passed for "grid"
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "make"
Package existence check passed for "binutils"
Package existence check passed for "gcc"
Package existence check passed for "gcc-c++"
Package existence check passed for "libaio"
Package existence check passed for "glibc"
Package existence check passed for "compat-libstdc++-33"
Package existence check passed for "elfutils-libelf"
Package existence check passed for "elfutils-libelf-devel"
Package existence check passed for "glibc-common"
Package existence check passed for "glibc-devel"
Package existence check passed for "glibc-headers"
Package existence check passed for "libaio-devel"
Package existence check passed for "libgcc"
Package existence check passed for "libstdc++"
Package existence check passed for "libstdc++-devel"
Package existence check passed for "sysstat"
Package existence check failed for "pdksh"
Check failed on nodes:
        rac2,ora
Check for multiple users with UID value 0 passed
Current group ID check passed

Starting check for consistency of primary group of root user

Check for consistency of root user's primary group passed

Checking OCR integrity...

OCR integrity check passed

Checking Oracle Cluster Voting Disk configuration...

Oracle Cluster Voting Disk configuration check passed
Time zone consistency check passed

Starting Clock synchronization checks using Network Time Protocol(NTP)...

NTP Configuration file check started...
No NTP Daemons or Services were found to be running

Clock synchronization check using Network Time Protocol(NTP) passed


User "grid" is not part of "root" group. Check passed
Checking consistency of file "/etc/resolv.conf" across nodes

File "/etc/resolv.conf" does not have both domain and search entries defined
domain entry in file "/etc/resolv.conf" is consistent across nodes
search entry in file "/etc/resolv.conf" is consistent across nodes
PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: ora

File "/etc/resolv.conf" is not consistent across nodes

Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.

Pre-check for node addition was unsuccessful on all the nodes.
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1395 MB    Passed
Oracle Universal Installer, Version 11.2.0.3.0 Production
Copyright (C) 1999, 2011, Oracle. All rights reserved.


Performing tests to see whether nodes rac2 are available
............................................................... 100% Done.

.
-----------------------------------------------------------------------------
Cluster Node Addition Summary
Global Settings
   Source: /u01/app/11.2.0/grid
   New Nodes
Space Requirements
   New Nodes
      rac2
         /: Required 3.80GB : Available 4.99GB
Installed Products
   Product Names
      Oracle Grid Infrastructure 11.2.0.3.0
      Sun JDK 1.5.0.30.03
      Installer SDK Component 11.2.0.3.0
      Oracle One-Off Patch Installer 11.2.0.1.7
      Oracle Universal Installer 11.2.0.3.0
      Oracle USM Deconfiguration 11.2.0.3.0
      Oracle Configuration Manager Deconfiguration 10.3.1.0.0
      Enterprise Manager Common Core Files 10.2.0.4.4
      Oracle DBCA Deconfiguration 11.2.0.3.0
      Oracle RAC Deconfiguration 11.2.0.3.0
      Oracle Quality of Service Management (Server) 11.2.0.3.0
      Installation Plugin Files 11.2.0.3.0
      Universal Storage Manager Files 11.2.0.3.0
      Oracle Text Required Support Files 11.2.0.3.0
      Automatic Storage Management Assistant 11.2.0.3.0
      Oracle Database 11g Multimedia Files 11.2.0.3.0
      Oracle Multimedia Java Advanced Imaging 11.2.0.3.0
      Oracle Globalization Support 11.2.0.3.0
      Oracle Multimedia Locator RDBMS Files 11.2.0.3.0
      Oracle Core Required Support Files 11.2.0.3.0
      Bali Share 1.1.18.0.0
      Oracle Database Deconfiguration 11.2.0.3.0
      Oracle Quality of Service Management (Client) 11.2.0.3.0
      Expat libraries 2.0.1.0.1
      Oracle Containers for Java 11.2.0.3.0
      Perl Modules 5.10.0.0.1
      Secure Socket Layer 11.2.0.3.0
      Oracle JDBC/OCI Instant Client 11.2.0.3.0
      Oracle Multimedia Client Option 11.2.0.3.0
      LDAP Required Support Files 11.2.0.3.0
      Character Set Migration Utility 11.2.0.3.0
      Perl Interpreter 5.10.0.0.1
      PL/SQL Embedded Gateway 11.2.0.3.0
      OLAP SQL Scripts 11.2.0.3.0
      Database SQL Scripts 11.2.0.3.0
      Oracle Extended Windowing Toolkit 3.4.47.0.0
      SSL Required Support Files for InstantClient 11.2.0.3.0
      SQL*Plus Files for Instant Client 11.2.0.3.0
      Oracle Net Required Support Files 11.2.0.3.0
      Oracle Database User Interface 2.2.13.0.0
      RDBMS Required Support Files for Instant Client 11.2.0.3.0
      RDBMS Required Support Files Runtime 11.2.0.3.0
      XML Parser for Java 11.2.0.3.0
      Oracle Security Developer Tools 11.2.0.3.0
      Oracle Wallet Manager 11.2.0.3.0
      Enterprise Manager plugin Common Files 11.2.0.3.0
      Platform Required Support Files 11.2.0.3.0
      Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
      RDBMS Required Support Files 11.2.0.3.0
      Oracle Ice Browser 5.2.3.6.0
      Oracle Help For Java 4.2.9.0.0
      Enterprise Manager Common Files 10.2.0.4.3
      Deinstallation Tool 11.2.0.3.0
      Oracle Java Client 11.2.0.3.0
      Cluster Verification Utility Files 11.2.0.3.0
      Oracle Notification Service (eONS) 11.2.0.3.0
      Oracle LDAP administration 11.2.0.3.0
      Cluster Verification Utility Common Files 11.2.0.3.0
      Oracle Clusterware RDBMS Files 11.2.0.3.0
      Oracle Locale Builder 11.2.0.3.0
      Oracle Globalization Support 11.2.0.3.0
      Buildtools Common Files 11.2.0.3.0
      Oracle RAC Required Support Files-HAS 11.2.0.3.0
      SQL*Plus Required Support Files 11.2.0.3.0
      XDK Required Support Files 11.2.0.3.0
      Agent Required Support Files 10.2.0.4.3
      Parser Generator Required Support Files 11.2.0.3.0
      Precompiler Required Support Files 11.2.0.3.0
      Installation Common Files 11.2.0.3.0
      Required Support Files 11.2.0.3.0
      Oracle JDBC/THIN Interfaces 11.2.0.3.0
      Oracle Multimedia Locator 11.2.0.3.0
      Oracle Multimedia 11.2.0.3.0
      HAS Common Files 11.2.0.3.0
      Assistant Common Files 11.2.0.3.0
      PL/SQL 11.2.0.3.0
      HAS Files for DB 11.2.0.3.0
      Oracle Recovery Manager 11.2.0.3.0
      Oracle Database Utilities 11.2.0.3.0
      Oracle Notification Service 11.2.0.3.0
      SQL*Plus 11.2.0.3.0
      Oracle Netca Client 11.2.0.3.0
      Oracle Net 11.2.0.3.0
      Oracle JVM 11.2.0.3.0
      Oracle Internet Directory Client 11.2.0.3.0
      Oracle Net Listener 11.2.0.3.0
      Cluster Ready Services Files 11.2.0.3.0
      Oracle Database 11g 11.2.0.3.0
-----------------------------------------------------------------------------


Instantiating scripts for add node (Saturday, May 18, 2013 12:55:02 PM CST)
.                                                                 1% Done.
Instantiation of add node scripts complete

Copying to remote nodes (Saturday, May 18, 2013 12:55:05 PM CST)
...............................................................................................                                 96% Done.
Home copied to new nodes

Saving inventory on nodes (Saturday, May 18, 2013 12:58:24 PM CST)
.                                                               100% Done.
Save inventory complete
WARNING:
The following configuration scripts need to be executed as the "root" user in each new cluster node. Each script in the list below is followed by a list of nodes.
/u01/app/11.2.0/grid/root.sh #On nodes rac2
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts in each cluster node
   
The Cluster Node Addition of /u01/app/11.2.0/grid was successful.
Please check '/tmp/silentInstall.log' for more details.

按照提示在2节点上用root执行:/u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization - successful
Adding Clusterware entries to upstart
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node ora, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Preparing packages for installation...
cvuqdisk-1.0.9-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded

3. 检查CRS状态
crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.CRS.dg     ora....up.type ONLINE    ONLINE    ora         
ora.DATA1.dg   ora....up.type ONLINE    ONLINE    ora         
ora....ER.lsnr ora....er.type ONLINE    ONLINE    ora         
ora....N1.lsnr ora....er.type ONLINE    ONLINE    ora         
ora.asm        ora.asm.type   ONLINE    ONLINE    ora         
ora.cvu        ora.cvu.type   ONLINE    ONLINE    ora         
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    ora         
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    ora         
ora.ons        ora.ons.type   ONLINE    ONLINE    ora         
ora....SM1.asm application    ONLINE    ONLINE    ora         
ora....RA.lsnr application    ONLINE    ONLINE    ora         
ora.ora.gsd    application    OFFLINE   OFFLINE               
ora.ora.ons    application    ONLINE    ONLINE    ora         
ora.ora.vip    ora....t1.type ONLINE    ONLINE    ora         
ora.orcl.db    ora....se.type ONLINE    ONLINE    ora         
ora....SM3.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    OFFLINE   OFFLINE               
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    ora


##在旧节点名称上删除实例
srvctl remove instance -d orcl -i orcl2 -f -y
##加实例到新节点
srvctl add instance -d orcl -i orcl2 -n rac2 -f
##开始实例在新节点
srvctl start instance -d orcl -i orcl2
##查看数据库在节点上的状态
srvctl status database -d orcl
Instance orcl1 is running on node ora
Instance orcl2 is running on node rac2

J.删除节点1
1.这次删除节点1多测试一些步骤
#停止、删除节点1上的db实例
srvctl stop instance -d orcl -i orcl1
srvctl remove instance -d orcl -i orcl1 -f -y

2.检查2节点是否是active和Unpinned ,如果是pinned的,用crsctl unpin css
olsnodes -s -t
ora     Active  Unpinned
rac2     Active  Unpinned

3. root用户在1节点 GRID_HOME 上执行
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force

4.从2节点上root执行
/u01/app/11.2.0/grid/bin/crsctl delete node -n ora
CRS-4661: Node orb successfully deleted.

5. 从1节点上grid用户执行
/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={ora}" CRS=TRUE -silent -local

6. 从1节点上grid用户执行
/u01/app/11.2.0/grid/deinstall/deinstall -local
期间会有交互,一直回车用默认值,最后产生一个脚本,用root在节点1的另一终端执行

7.从2节点上grid用户执行
/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={rac2}" CRS=TRUE -silent -local
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 1433 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.

8.在2节点上检查1节点是否被删除成功
cluvfy stage -post nodedel -n ora -verbose

K.节点2被正确删除后,修改节点2的主机名为rac2,修改两个节点的/etc/host
192.168.11.101  rac1
192.168.11.102  rac1-vip
192.168.88.100  rac1-priv

192.168.11.104  rac2
192.168.11.105  rac2-vip
192.168.88.101  rac2-priv

192.168.11.103  ora-scan

L.加节点2到CRS
1.节点2上设置grid用户对等性
/u01/app/11.2.0/grid/deinstall/sshUserSetup.sh -user grid -hosts rac1 rac2 -noPromptPassphrase
2.节点2上grid用户,检查节点1是否满足
cluvfy stage -pre nodeadd -n rac1 -fixup -fixupdir /tmp -verbose
修改 $ORACLE_HOME/oui/bin/addNode.sh

M.加节点1到CRS
$ORACLE_HOME/oui/bin/addNode.sh "CLUSTER_NEW_NODES={rac1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac1-vip}"
按照提示在1节点上用root执行:/u01/app/11.2.0/grid/root.sh

N.
##在旧节点名称上删除实例
srvctl remove instance -d orcl -i orcl1 -f -y
##加实例到新节点
srvctl add instance -d orcl -i orcl1 -n rac1 -f
##开始实例在新节点
srvctl start instance -d orcl -i orcl1
##查看数据库在节点上的状态
srvctl status database -d orcl
Instance orcl1 is running on node rac1
Instance orcl2 is running on node rac2

O. 发现两节点ASM实例名被修改为+ASM3和+ASM4
涛德顾问学院
Oracle OCM 11g认证培训Oracle 12c OCP 全国独家推出
大数据,BI商业智能,数据库,ADF,中间件,EBS,ODI,ETL全产业链培训服务提供商
回复

使用道具 举报

上海涛德顾问学院 ( 沪ICP备14006824号 )  

GMT+8, 2018-6-18 16:04 , Processed in 0.313800 second(s), 29 queries , Gzip On.

Top Data World

回顶部