oracle 11g rac2 删除节点&添加节点

最新推荐文章于 2021-05-18 07:57:54 发布
最新推荐文章于 2021-05-18 07:57:54 发布
阅读量2.1k 收藏
点赞数
分类专栏： Study & Testing
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/itdba/article/details/40009375
版权
删除参考：

http://pandarabbit.blog.163.com/blog/static/20928414420136410848968/  

grid user------------------

rac2-> srvctl disable -l listener -n rac2
rac2-> $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={rac2}" -local
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 4094 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
The Oracle home '/u01/app/11.2.0/grid' could not be updated as it does not exist.
'UpdateNodeList' failed.


rac2-> more /etc/oraInst.loc
inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall
rac2-> su - oracle
Password: 
rac2-> $ORACLE_HOME/deinstall/deinstall -local
-bash: /u01/app/oracle/product/11.2.0/db_1/db10g/deinstall/deinstall: No such file or directory
rac2-> vi .bash_profile
# .bash_profile


# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi


# User specific environment and startup programs


PATH=$PATH:$HOME/bin


export PATH
export PS1="`/bin/hostname -s`-> "
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=node1.localdomain
export ORACLE_SID=d10g2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1/db11g
#export ORA_CRS_HOME=$ORACLE_BASE/product/11.2.0/db_1/crs10g
export ORACLE_UNQNAME=db10g
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH:$ORA_CRS_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export LANG=en_US
export NLS_LANG=american_america.AL32UTF8
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
umask 022
~
~
~
".bash_profile" 31L, 863C written                                                                                                  
rac2-> exit
logout
rac2-> su - oracle
Password: 
rac2-> $ORACLE_HOME/deinstall/deinstall -local
--原来我根本没有安装
[root@rac2 ~]# /u01/app/11.2.0/grid/   
[root@rac2 ~]# /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.2.0/255.255.255.0/eth1, type static
VIP exists: /rac1-vip/192.168.2.51/192.168.2.0/255.255.255.0/eth1, hosting node rac1
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
PRKO-2439 : VIP does not exist.


PRKO-2313 : VIP rac2 does not exist.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2'
CRS-2673: Attempting to stop 'ora.DATA11G.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.DG10.dg' on 'rac2'
CRS-2677: Stop of 'ora.DG10.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA11G.dg' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'
CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'
CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac2'
CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'
CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'
CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Removing Trace File Analyzer
Successfully deconfigured Oracle clusterware stack on this node
[root@rac2 ~]# ps -ef|grep grid
root      8516  5640  0 16:39 pts/1    00:00:00 grep grid

[root@rac2 ~]# 


--rac1
rac1-> id     
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper),1300(dba)
rac1-> $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={rac1}" CRS=true
Starting Oracle Universal Installer...


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



&&&&&&&&&&

rac1-> $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 "rac1"


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

WARNING: 
Node "rac2" already appears to be part of cluster

Pre-check for node addition was successful. 
Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 4038 MB    Passed
Oracle Universal Installer, Version 11.2.0.4.0 Production
Copyright (C) 1999, 2013, 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.31GB : Available 9.97GB
Installed Products
   Product Names
      Oracle Grid Infrastructure 11g 11.2.0.4.0 
      Java Development Kit 1.5.0.51.10 
      Installer SDK Component 11.2.0.4.0 
      Oracle One-Off Patch Installer 11.2.0.3.4 
      Oracle Universal Installer 11.2.0.4.0 
      Oracle RAC Required Support Files-HAS 11.2.0.4.0 
      Oracle USM Deconfiguration 11.2.0.4.0 
      Oracle Configuration Manager Deconfiguration 10.3.1.0.0 
      Enterprise Manager Common Core Files 10.2.0.4.5 
      Oracle DBCA Deconfiguration 11.2.0.4.0 
      Oracle RAC Deconfiguration 11.2.0.4.0 
      Oracle Quality of Service Management (Server) 11.2.0.4.0 
      Installation Plugin Files 11.2.0.4.0 
      Universal Storage Manager Files 11.2.0.4.0 
      Oracle Text Required Support Files 11.2.0.4.0 
      Automatic Storage Management Assistant 11.2.0.4.0 
      Oracle Database 11g Multimedia Files 11.2.0.4.0 
      Oracle Multimedia Java Advanced Imaging 11.2.0.4.0 
      Oracle Globalization Support 11.2.0.4.0 
      Oracle Multimedia Locator RDBMS Files 11.2.0.4.0 
      Oracle Core Required Support Files 11.2.0.4.0 
      Bali Share 1.1.18.0.0 
      Oracle Database Deconfiguration 11.2.0.4.0 
      Oracle Quality of Service Management (Client) 11.2.0.4.0 
      Expat libraries 2.0.1.0.1 
      Oracle Containers for Java 11.2.0.4.0 
      Perl Modules 5.10.0.0.1 
      Secure Socket Layer 11.2.0.4.0 
      Oracle JDBC/OCI Instant Client 11.2.0.4.0 
      Oracle Multimedia Client Option 11.2.0.4.0 
      LDAP Required Support Files 11.2.0.4.0 
      Character Set Migration Utility 11.2.0.4.0 
      Perl Interpreter 5.10.0.0.1 
      PL/SQL Embedded Gateway 11.2.0.4.0 
      OLAP SQL Scripts 11.2.0.4.0 
      Database SQL Scripts 11.2.0.4.0 
      Oracle Extended Windowing Toolkit 3.4.47.0.0 
      SSL Required Support Files for InstantClient 11.2.0.4.0 
      SQL*Plus Files for Instant Client 11.2.0.4.0 
      Oracle Net Required Support Files 11.2.0.4.0 
      Oracle Database User Interface 2.2.13.0.0 
      RDBMS Required Support Files for Instant Client 11.2.0.4.0 
      RDBMS Required Support Files Runtime 11.2.0.4.0 
      XML Parser for Java 11.2.0.4.0 
      Oracle Security Developer Tools 11.2.0.4.0 
      Oracle Wallet Manager 11.2.0.4.0 
      Enterprise Manager plugin Common Files 11.2.0.4.0 
      Platform Required Support Files 11.2.0.4.0 
      Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 
      RDBMS Required Support Files 11.2.0.4.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.5 
      Deinstallation Tool 11.2.0.4.0 
      Oracle Java Client 11.2.0.4.0 
      Cluster Verification Utility Files 11.2.0.4.0 
      Oracle Notification Service (eONS) 11.2.0.4.0 
      Oracle LDAP administration 11.2.0.4.0 
      Cluster Verification Utility Common Files 11.2.0.4.0 
      Oracle Clusterware RDBMS Files 11.2.0.4.0 
      Oracle Locale Builder 11.2.0.4.0 
      Oracle Globalization Support 11.2.0.4.0 
      Buildtools Common Files 11.2.0.4.0 
      HAS Common Files 11.2.0.4.0 
      SQL*Plus Required Support Files 11.2.0.4.0 
      XDK Required Support Files 11.2.0.4.0 
      Agent Required Support Files 10.2.0.4.5 
      Parser Generator Required Support Files 11.2.0.4.0 
      Precompiler Required Support Files 11.2.0.4.0 
      Installation Common Files 11.2.0.4.0 
      Required Support Files 11.2.0.4.0 
      Oracle JDBC/THIN Interfaces 11.2.0.4.0 
      Oracle Multimedia Locator 11.2.0.4.0 
      Oracle Multimedia 11.2.0.4.0 
      Assistant Common Files 11.2.0.4.0 
      Oracle Net 11.2.0.4.0 
      PL/SQL 11.2.0.4.0 
      HAS Files for DB 11.2.0.4.0 
      Oracle Recovery Manager 11.2.0.4.0 
      Oracle Database Utilities 11.2.0.4.0 
      Oracle Notification Service 11.2.0.3.0 
      SQL*Plus 11.2.0.4.0 
      Oracle Netca Client 11.2.0.4.0 
      Oracle Advanced Security 11.2.0.4.0 
      Oracle JVM 11.2.0.4.0 
      Oracle Internet Directory Client 11.2.0.4.0 
      Oracle Net Listener 11.2.0.4.0 
      Cluster Ready Services Files 11.2.0.4.0 
      Oracle Database 11g 11.2.0.4.0 
-----------------------------------------------------------------------------




Instantiating scripts for add node (Saturday, October 11, 2014 5:26:07 PM CST)
.                                                                 1% Done.
Instantiation of add node scripts complete


Copying to remote nodes (Saturday, October 11, 2014 5:26:13 PM CST)
...............................................................................................                                 96% Done.
Home copied to new nodes


Saving inventory on nodes (Saturday, October 11, 2014 5:33:08 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.


[root@rac2 ~]# /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 file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: 
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: 


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
Installing Trace File Analyzer
OLR initialization - successful
Adding Clusterware entries to inittab
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node rac1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster


Last login: Sat Oct 11 17:24:51 2014 from 192.168.175.1
[root@rac2 ~]# ps -ef|grep grid
root      4550     1  2 17:43 ?        00:00:03 /u01/app/11.2.0/grid/bin/ohasd.bin reboot
grid      5098     1  0 17:43 ?        00:00:00 /u01/app/11.2.0/grid/bin/oraagent.bin
grid      5111     1  0 17:43 ?        00:00:00 /u01/app/11.2.0/grid/bin/mdnsd.bin
grid      5126     1  0 17:43 ?        00:00:00 /u01/app/11.2.0/grid/bin/gpnpd.bin
grid      5141     1  1 17:43 ?        00:00:01 /u01/app/11.2.0/grid/bin/gipcd.bin
root      5145     1  0 17:43 ?        00:00:01 /u01/app/11.2.0/grid/bin/orarootagent.bin
root      5182     1  3 17:43 ?        00:00:04 /u01/app/11.2.0/grid/bin/osysmond.bin
root      5187     1  2 17:43 ?        00:00:03 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/app/11.2.0/grid/tfa/rac2/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/rac2/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/rac2/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0/grid/tfa/rac2/tfa_home
root      5197     1  0 17:43 ?        00:00:01 /u01/app/11.2.0/grid/bin/cssdmonitor
root      5230     1  0 17:43 ?        00:00:01 /u01/app/11.2.0/grid/bin/cssdagent
grid      5244     1  1 17:43 ?        00:00:02 /u01/app/11.2.0/grid/bin/ocssd.bin 
root      5320     1  3 17:43 ?        00:00:03 /u01/app/11.2.0/grid/bin/ologgerd -m rac1 -r -d /u01/app/11.2.0/grid/crf/db/rac2
root      5365     1  0 17:43 ?        00:00:00 /u01/app/11.2.0/grid/bin/octssd.bin reboot
grid      5403     1  0 17:43 ?        00:00:00 /u01/app/11.2.0/grid/bin/evmd.bin
grid      5444     1  0 17:44 ?        00:00:00 asm_pmon_+ASM2
grid      5448     1  0 17:44 ?        00:00:00 asm_psp0_+ASM2
grid      5452     1  1 17:44 ?        00:00:00 asm_vktm_+ASM2
grid      5458     1  0 17:44 ?        00:00:00 asm_gen0_+ASM2
grid      5462     1  0 17:44 ?        00:00:00 asm_diag_+ASM2
grid      5466     1  0 17:44 ?        00:00:00 asm_ping_+ASM2
grid      5470     1  0 17:44 ?        00:00:00 asm_dia0_+ASM2
grid      5474     1  0 17:44 ?        00:00:00 asm_lmon_+ASM2
grid      5478     1  0 17:44 ?        00:00:00 asm_lmd0_+ASM2
grid      5482     1  0 17:44 ?        00:00:00 asm_lms0_+ASM2
grid      5488     1  0 17:44 ?        00:00:00 asm_lmhb_+ASM2
grid      5492     1  0 17:44 ?        00:00:00 asm_mman_+ASM2
grid      5496     1  0 17:44 ?        00:00:00 asm_dbw0_+ASM2
grid      5500     1  0 17:44 ?        00:00:00 asm_lgwr_+ASM2
grid      5504     1  0 17:44 ?        00:00:00 asm_ckpt_+ASM2
grid      5508     1  0 17:44 ?        00:00:00 asm_smon_+ASM2
grid      5512     1  0 17:44 ?        00:00:00 asm_rbal_+ASM2
grid      5516     1  0 17:44 ?        00:00:00 asm_gmon_+ASM2
grid      5520     1  0 17:44 ?        00:00:00 asm_mmon_+ASM2
grid      5524     1  0 17:44 ?        00:00:00 asm_mmnl_+ASM2
grid      5528     1  0 17:44 ?        00:00:00 asm_lck0_+ASM2
grid      5560     1  0 17:44 ?        00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root      5566     1  2 17:44 ?        00:00:01 /u01/app/11.2.0/grid/bin/crsd.bin reboot
grid      5578     1  0 17:44 ?        00:00:00 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      5583     1  0 17:44 ?        00:00:00 asm_asmb_+ASM2
grid      5588     1  0 17:44 ?        00:00:00 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      5592     1  0 17:44 ?        00:00:00 asm_o000_+ASM2
grid      5596     1  0 17:44 ?        00:00:00 oracle+ASM2_o000_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      5611     1  0 17:44 ?        00:00:00 asm_fd00_+ASM2
grid      5667  5403  0 17:44 ?        00:00:00 /u01/app/11.2.0/grid/bin/evmlogger.bin -o /u01/app/11.2.0/grid/evm/log/evmlogger.info -l /u01/app/11.2.0/grid/evm/log/evmlogger.log
grid      5706     1  1 17:44 ?        00:00:00 /u01/app/11.2.0/grid/bin/oraagent.bin
root      5710     1  1 17:44 ?        00:00:00 /u01/app/11.2.0/grid/bin/orarootagent.bin
grid      5754     1  0 17:44 ?        00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      5771     1  0 17:44 ?        00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      5775     1  0 17:44 ?        00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid      5801     1  0 17:44 ?        00:00:00 /u01/app/11.2.0/grid/opmn/bin/ons -d
grid      5802  5801  0 17:44 ?        00:00:00 /u01/app/11.2.0/grid/opmn/bin/ons -d
root      6037  5969  0 17:45 pts/1    00:00:00 grep grid
[root@rac2 ~]# su- grid


rac1->  ./addNode.sh "CLUSTER_NEW_NODES={rac2}"


Performing pre-checks for node addition 


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




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


WARNING: 
Node "rac2" already appears to be part of cluster


Pre-check for node addition was successful. 
Starting Oracle Universal Installer...


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




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


..
-----------------------------------------------------------------------------
Cluster Node Addition Summary
Global Settings
   Source: /u01/app/oracle/product/11.2.0/db_1/db11g
   New Nodes
Space Requirements
   New Nodes
      rac2
         /u01/app/oracle/product/11.2.0/db_1: Required 3.99GB : Available 11.28GB
Installed Products
   Product Names
      Oracle Database 11g 11.2.0.4.0 
      Java Development Kit 1.5.0.51.10 
      Installer SDK Component 11.2.0.4.0 
      Oracle One-Off Patch Installer 11.2.0.3.4 
      Oracle Universal Installer 11.2.0.4.0 
      Oracle USM Deconfiguration 11.2.0.4.0 
      Oracle Configuration Manager Deconfiguration 10.3.1.0.0 
      Oracle DBCA Deconfiguration 11.2.0.4.0 
      Oracle RAC Deconfiguration 11.2.0.4.0 
      Oracle Database Deconfiguration 11.2.0.4.0 
      Oracle Configuration Manager Client 10.3.2.1.0 
      Oracle Configuration Manager 10.3.8.1.0 
      Oracle ODBC Driverfor Instant Client 11.2.0.4.0 
      LDAP Required Support Files 11.2.0.4.0 
      SSL Required Support Files for InstantClient 11.2.0.4.0 
      Bali Share 1.1.18.0.0 
      Oracle Extended Windowing Toolkit 3.4.47.0.0 
      Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 
      Oracle Real Application Testing 11.2.0.4.0 
      Oracle Database Vault J2EE Application 11.2.0.4.0 
      Oracle Label Security 11.2.0.4.0 
      Oracle Data Mining RDBMS Files 11.2.0.4.0 
      Oracle OLAP RDBMS Files 11.2.0.4.0 
      Oracle OLAP API 11.2.0.4.0 
      Platform Required Support Files 11.2.0.4.0 
      Oracle Database Vault option 11.2.0.4.0 
      Oracle RAC Required Support Files-HAS 11.2.0.4.0 
      SQL*Plus Required Support Files 11.2.0.4.0 
      Oracle Display Fonts 9.0.2.0.0 
      Oracle Ice Browser 5.2.3.6.0 
      Oracle JDBC Server Support Package 11.2.0.4.0 
      Oracle SQL Developer 11.2.0.4.0 
      Oracle Application Express 11.2.0.4.0 
      XDK Required Support Files 11.2.0.4.0 
      RDBMS Required Support Files for Instant Client 11.2.0.4.0 
      SQLJ Runtime 11.2.0.4.0 
      Database Workspace Manager 11.2.0.4.0 
      RDBMS Required Support Files Runtime 11.2.0.4.0 
      Oracle Globalization Support 11.2.0.4.0 
      Exadata Storage Server 11.2.0.1.0 
      Provisioning Advisor Framework 10.2.0.4.3 
      Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0 
      Enterprise Manager Repository Core Files 10.2.0.4.5 
      Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0 
      Enterprise Manager Grid Control Core Files 10.2.0.4.5 
      Enterprise Manager Common Core Files 10.2.0.4.5 
      Enterprise Manager Agent Core Files 10.2.0.4.5 
      RDBMS Required Support Files 11.2.0.4.0 
      regexp 2.1.9.0.0 
      Agent Required Support Files 10.2.0.4.5 
      Oracle 11g Warehouse Builder Required Files 11.2.0.4.0 
      Oracle Notification Service (eONS) 11.2.0.4.0 
      Oracle Text Required Support Files 11.2.0.4.0 
      Parser Generator Required Support Files 11.2.0.4.0 
      Oracle Database 11g Multimedia Files 11.2.0.4.0 
      Oracle Multimedia Java Advanced Imaging 11.2.0.4.0 
      Oracle Multimedia Annotator 11.2.0.4.0 
      Oracle JDBC/OCI Instant Client 11.2.0.4.0 
      Oracle Multimedia Locator RDBMS Files 11.2.0.4.0 
      Precompiler Required Support Files 11.2.0.4.0 
      Oracle Core Required Support Files 11.2.0.4.0 
      Sample Schema Data 11.2.0.4.0 
      Oracle Starter Database 11.2.0.4.0 
      Oracle Message Gateway Common Files 11.2.0.4.0 
      Oracle XML Query 11.2.0.4.0 
      XML Parser for Oracle JVM 11.2.0.4.0 
      Oracle Help For Java 4.2.9.0.0 
      Installation Plugin Files 11.2.0.4.0 
      Enterprise Manager Common Files 10.2.0.4.5 
      Expat libraries 2.0.1.0.1 
      Deinstallation Tool 11.2.0.4.0 
      Oracle Quality of Service Management (Client) 11.2.0.4.0 
      Perl Modules 5.10.0.0.1 
      JAccelerator (COMPANION) 11.2.0.4.0 
      Oracle Containers for Java 11.2.0.4.0 
      Perl Interpreter 5.10.0.0.1 
      Oracle Net Required Support Files 11.2.0.4.0 
      Secure Socket Layer 11.2.0.4.0 
      Oracle Universal Connection Pool 11.2.0.4.0 
      Oracle JDBC/THIN Interfaces 11.2.0.4.0 
      Oracle Multimedia Client Option 11.2.0.4.0 
      Oracle Java Client 11.2.0.4.0 
      Character Set Migration Utility 11.2.0.4.0 
      Oracle Code Editor 1.2.1.0.0I 
      PL/SQL Embedded Gateway 11.2.0.4.0 
      OLAP SQL Scripts 11.2.0.4.0 
      Database SQL Scripts 11.2.0.4.0 
      Oracle Locale Builder 11.2.0.4.0 
      Oracle Globalization Support 11.2.0.4.0 
      SQL*Plus Files for Instant Client 11.2.0.4.0 
      Required Support Files 11.2.0.4.0 
      Oracle Database User Interface 2.2.13.0.0 
      Oracle ODBC Driver 11.2.0.4.0 
      Oracle Notification Service 11.2.0.3.0 
      XML Parser for Java 11.2.0.4.0 
      Oracle Security Developer Tools 11.2.0.4.0 
      Oracle Wallet Manager 11.2.0.4.0 
      Cluster Verification Utility Common Files 11.2.0.4.0 
      Oracle Clusterware RDBMS Files 11.2.0.4.0 
      Oracle UIX 2.2.24.6.0 
      Enterprise Manager plugin Common Files 11.2.0.4.0 
      HAS Common Files 11.2.0.4.0 
      Precompiler Common Files 11.2.0.4.0 
      Installation Common Files 11.2.0.4.0 
      Oracle Help for the  Web 2.0.14.0.0 
      Oracle LDAP administration 11.2.0.4.0 
      Buildtools Common Files 11.2.0.4.0 
      Assistant Common Files 11.2.0.4.0 
      Oracle Recovery Manager 11.2.0.4.0 
      PL/SQL 11.2.0.4.0 
      Generic Connectivity Common Files 11.2.0.4.0 
      Oracle Database Gateway for ODBC 11.2.0.4.0 
      Oracle Programmer 11.2.0.4.0 
      Oracle Database Utilities 11.2.0.4.0 
      Enterprise Manager Agent 10.2.0.4.5 
      SQL*Plus 11.2.0.4.0 
      Oracle Netca Client 11.2.0.4.0 
      Oracle Multimedia Locator 11.2.0.4.0 
      Oracle Call Interface (OCI) 11.2.0.4.0 
      Oracle Multimedia 11.2.0.4.0 
      Oracle Net 11.2.0.4.0 
      Oracle XML Development Kit 11.2.0.4.0 
      Oracle Internet Directory Client 11.2.0.4.0 
      Database Configuration and Upgrade Assistants 11.2.0.4.0 
      Oracle JVM 11.2.0.4.0 
      Oracle Advanced Security 11.2.0.4.0 
      Oracle Net Listener 11.2.0.4.0 
      Oracle Enterprise Manager Console DB 11.2.0.4.0 
      HAS Files for DB 11.2.0.4.0 
      Oracle Text 11.2.0.4.0 
      Oracle Net Services 11.2.0.4.0 
      Oracle Database 11g 11.2.0.4.0 
      Oracle OLAP 11.2.0.4.0 
      Oracle Spatial 11.2.0.4.0 
      Oracle Partitioning 11.2.0.4.0 
      Enterprise Edition Options 11.2.0.4.0 
-----------------------------------------------------------------------------




Instantiating scripts for add node (Saturday, October 11, 2014 6:11:22 PM CST)
.                                                                 1% Done.
Instantiation of add node scripts complete


Copying to remote nodes (Saturday, October 11, 2014 6:11:36 PM CST)
...............................................................................................                                 96% Done.
Home copied to new nodes


Saving inventory on nodes (Saturday, October 11, 2014 6:32:16 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/oracle/product/11.2.0/db_1/db11g/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/oracle/product/11.2.0/db_1/db11g was successful.
Please check '/tmp/silentInstall.log' for more details.




rac2-> exit
logout
You have new mail in /var/spool/mail/root
[root@rac2 ~]# /u01/app/oracle/product/11.2.0/db_1/db11g/root.sh
Performing root user operation for Oracle 11g 


The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1/db11g


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: 
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: 


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.
Finished product-specific root actions.




 01:16:28
 
 
srvctl add database -d d10g -o /u01/app/oracle/product/11.2.0/db_1/db11g -c RAC -p +DG10/d10g/spfiled10g.ora -y automatic -a DG10


Last login: Sat Oct 11 22:57:27 2014 from 192.168.175.1
[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl delete serverpool  ora.d10g 
[root@rac1 ~]# 


PRCS-1007 : Server pool d10g already exists
PRCR-1086 : server pool ora.d10g is already registered
rac1-> srvctl config database -d d10g
PRCD-1120 : The resource for database d10g could not be found.
PRCR-1001 : Resource ora.d10g.db does not exist
rac1-> srvctl add database -d d10g -o /u01/app/oracle/product/11.2.0/db_1/db11g -c RAC -p +DG10/d10g/spfiled10g.ora -y automatic 
PRCS-1007 : Server pool d10g already exists
PRCR-1086 : server pool ora.d10g is already registered
rac1-> srvctl add database -d d10g -o /u01/app/oracle/product/11.2.0/db_1/db11g -c RAC -p +DG10/d10g/spfiled10g.ora -y automatic 




srvctl add instance -d d10g1 -i devdb1 -n rac1
 
 
rac1-> srvctl add instance -d d10g -i d10g1 -n rac1
rac1-> srvctl add instance -d d10g -i d10g2 -n rac2

一个晚上的 实验思路。。

1ihj2015
关注
专栏目录
oracle11g rac 如何删除损坏节点并添加新节点
Rhys learn oracle！
10-25 5209
欢迎使用Markdown编辑器写博客本Markdown编辑器使用StackEdit修改而来，用它写博客，将会带来全新的体验哦： Markdown和扩展Markdown简洁的语法 代码块高亮 图片链接和图片上传 LaTex数学公式 UML序列图和流程图 离线写博客 导入导出Markdown文件 丰富的快捷键 快捷键 加粗 Ctrl + B 斜体 Ctrl + I 引用 Ctrl
oracle更换rac节点,oracle11g rac 如何删除损坏节点并添加新节点
weixin_39749243的博客
04-04 773
今天是2017年10月25日，之前遇到一个客户来电，大体问题是：aix 5.3+oracle 11.2.0.1 数据库为rac。其中节点一因为本地主机磁盘损坏，导致aix系统损坏进而导致了oracle rac集群只剩一个节点的故障”对于该问题，其实很简单，只要在存活节点删除之前数据库实例，在集群中删除故障节点信息后，新增节点即可。但在整个过程中遇到了各类问题(个人根据当时现状了解到，在我接手之前，...
11G R2 RAC添加删除节点
cuichanla2083的博客
12-26 263
11G R2 RAC添加删除节点参考链接： http://www.linuxidc.com/Linux/2012-11/74199.htmhttp://blog.csdn.net/ying0216/article/detai...
Oracle 11g rac 删除节点
weixin_34409357的博客
12-03 123
1适用场景1、被删除节点一切保留，需要从RAC中剔除，例如因为要更换服务器。2、被删除节点关于RAC的部分文件丢失，如GI、库软件误删除，需要重新安装GI或oracle库软件。实验场景：三节点RAC，主机名是rac1、rac2、rac3，现在需要删除rac3。2具体步骤2.1Unpinrac3节点[root@rac1~]#olsnodes-t–s在所有保留节...
oracle11gRAC添加删除节点
weixin_34025051的博客
08-02 239
删除前集群件状态[root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVE...
oracle 11g rac图文增加删除节点,Oracle 11gR2 RAC 删除节点最佳实践
weixin_39968760的博客
04-13 155
Oracle 11gR2 RAC 删除节点最佳实践[日期：2012-08-30]来源：Linux社区作者：YallonKing[字体：大 中 小]Oracle 11gR2 RAC 添加节点最佳实践可参见：http://www.linuxidc.com/Linux/2012-08/69270.htmOS信息:[grid@11grac1 ~]$ uname -aLinux 11grac1 2.6.32...
oracle 11g RAC<-->单机 高可用dataguard 主备正确切换步骤
12-07
Oracle 11g RAC高可用Dataguard 主备正确切换步骤 Oracle 11g RAC高可用Dataguard是Oracle公司推出的高可用解决方案，旨在提供高可用性和灾难恢复能力。本文将详细介绍Oracle 11g RAC高可用Dataguard 主备正确切换...
Oracle 11g RAC+DG安装配置
08-09
Oracle 11g RAC (Real Application Clusters) 和 Data Guard 是两个重要的 Oracle 数据库高可用性和灾难恢复解决方案。RAC 允许多个实例在同一个数据库上并行工作，提供故障切换和负载均衡，而 Data Guard 提供了...
oracle11g rac两节点集群所需的响应文件
09-02
Oracle 11g RAC（Real Application Clusters）是一种高可用性和可伸缩性的数据库解决方案，它允许多个实例在共享的物理硬件上并行处理数据。在这个场景中，"oracle11g rac两节点集群所需的响应文件"指的是在安装...
11g R2 节点系统重建后，删除节点及添加节点 过程和问题解决
热门推荐
badman250的专栏
07-05 3万+
11g R2 节点系统重建后，删除节点及添加节点 过程和问题解决    故障现象：   一个RAC数据库，两个节点，RedHat 6.3_X64的系统，因为业务问题，节点2的服务器的系统进行了重装。   现需要重建节点2 。 节点的重建   一：先从集群中清除节点2的信息
Oracle 11G RAC 删除节点
cs360_996688的博客
02-25 203
软硬件环境 数据库版本： 11.2.0.4 RAC 双节点 虚拟环境系统： Linux 6.5 一般对 CRS 层面数据结构做重要操作之前一...
oracle rac删除添加节点,11G RAC 节点删除与添加
weixin_26717737的博客
04-05 352
RAC删除节点并添加节点oracle用户更新Inventory$ORACLE_HOME/oui/bin/runInstaller -updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=zycdbtst3" -local删除db软件$ORACLE_HOME/deinstall/deinstall -local再在其他主机oracle 用户更新...
Oracle 11gR2 RAC 删除节点
ctez18865的博客
03-22 159
1. 概述 1.1 目标 2. 安装前准备 2.1 DBCA删除数据库实例 在节点1以oracle用户运行dbca 2.2 RAC层面...
Oracle 11g RAC添加一节点过程
weixin_33733810的博客
12-30 302
实验场景：两节点RAC，主机名是db1、db2，现在需要添加db2。 本文是接上一文删除节点后的添加节点的过整过程。查看Oracle 11g R2 RAC删除一节点过程。 本例是在刚上删除节点过程后做的，如果是全新节点，需要按照Oracle 11g RAC安装过程配置环境变量等前期安装配置信息，全文全程采用字符界面方式操作，也可以采用图形界面进行。 本文假定相...
oracle 11gR2 rac删除节点和增加节点
tpc4289的专栏
03-01 6658
你兴趣所在的地方，也就是你能力所在的地方。------------卡耐基环境：    双节点RAC，其中一个节点因为本地盘损坏，导致系统完全损坏，系统需要重新安装    操作系统：OracleLinux 6.5 x86_641，重新安装操作系统2，重新配置服务器环境   配置主机名   vi /etc/hosts   配置网络   vi /etc/sysconfig/network   vi /e...
RHEL6.5_Oracle_11.2.0.4 RAC 删除和添加节点
Lissen_Gan的博客
05-18 708
6.12 RHEL6.5_Oracle_11.2.0.4 RAC 删除和添加节点 6.12.1 RAC中删除和保留节点信息 保留节点： 节点1 删除的节点： 节点2 重新添加的节点： 节点2 6.12.2 删除节点 6.12.2.1 保留节点备份OCR ocrconfig -showbackup; ocrconfig -manualbackup; ocrconfig -local -manualbackup; ocrconfig -export “/u01/app/11.2.0.4/grid/cdata
ORACLE RAC加减节点时的注意事项
还不算晕的专栏
08-04 387
RAC加减节点，正常来说是一个较简单的动作，前期环境准备检查完成后，半小时内可以完成一个节点的增删动作。 近期某客户出现了两套RAC环境均出现一台主机物理硬件损坏问题，需要通过删除故障节点、添加新节点方式来修复RAC，在操作过程中遇到一些问题，记录如下： 1.前期环境检查阶段 –主机名修改不规范，cluvfy stage -pre nodeadd -n node2检测能通过，但是后面会出问题，因此...
一次打11.2.0.3.8 PSU时遇到的问题
chengluwei3014的博客
09-17 999
[oracle@y11 ~]$ /home/oracle/OPatch/opatch [oracle@y11 ~]$ [oracle@y11 ~]$ [oracle@y11 ~]$ cd 16902043/ [oracle@y11 16902043]$ ll total 104 drwxr...
oracle rac 删除disk,Oracle 11g R2 RAC删除一节点过程
weixin_35171603的博客
04-04 174
实验场景：两节点RAC，主机名是db1、db2，现在需要删除db2，本示例是在正常状态下删除。1. db1,db2节点检查CSS服务器是否正常，如下即为正常。[root@db1 ~]# su - grid[grid@db1 ~]$ olsnodes -t -sdb1 Active Unpinneddb2 Active Unpinned[grid@db1 ~]$如果pinned...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值