\uff08\u96f6\uff09 RAC\u6570\u636e\u5e93\u5347\u7ea7\uff0810.2.0.1.0->10.2.0.5.0\uff09\u5e76\u6253\u8865\u4e01\uff08P12880299\uff09<\/p>\n
--\u539f\u59cb\u5e93\u4fe1\u606f
\nSQL> select * from v$version where rownum<5;<\/p>\n
BANNER
\n----------------------------------------------------------------
\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
\nPL\/SQL Release 10.2.0.1.0 - Production
\nCORE 10.2.0.1.0 Production
\nTNS for Linux: Version 10.2.0.1.0 - Production<\/p>\n
[oracle@rac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application ONLINE ONLINE rac1
\nora....C1.lsnr application ONLINE ONLINE rac1
\nora.rac1.gsd application ONLINE ONLINE rac1
\nora.rac1.ons application ONLINE ONLINE rac1
\nora.rac1.vip application ONLINE ONLINE rac1
\nora....SM2.asm application ONLINE ONLINE rac2
\nora....C2.lsnr application ONLINE ONLINE rac2
\nora.rac2.gsd application ONLINE ONLINE rac2
\nora.rac2.ons application ONLINE ONLINE rac2
\nora.rac2.vip application ONLINE ONLINE rac2
\nora.racdb.db application ONLINE ONLINE rac1
\nora....b1.inst application ONLINE ONLINE rac1
\nora....b2.inst application ONLINE ONLINE rac2<\/p>\n
\/*\uff08\u4e00\uff09\u5347\u7ea7 CRS*\/
\n--\u505c\u6b62\u6240\u6709\u8d44\u6e90
\n[oracle@rac1 ~]$ crs_stop -all
\nAttempting to stop `ora.rac1.gsd` on member `rac1`
\nAttempting to stop `ora.rac1.ons` on member `rac1`
\nAttempting to stop `ora.racdb.db` on member `rac1`
\nAttempting to stop `ora.rac2.ons` on member `rac2`
\nAttempting to stop `ora.rac2.gsd` on member `rac2`
\nStop of `ora.rac2.ons` on member `rac2` succeeded.
\nStop of `ora.rac2.gsd` on member `rac2` succeeded.
\nStop of `ora.rac1.gsd` on member `rac1` succeeded.
\nStop of `ora.rac1.ons` on member `rac1` succeeded.
\nStop of `ora.racdb.db` on member `rac1` succeeded.
\n`ora.racdb.racdb1.inst` is already OFFLINE.
\n`ora.racdb.racdb2.inst` is already OFFLINE.
\nAttempting to stop `ora.rac1.ASM1.asm` on member `rac1`
\nAttempting to stop `ora.rac2.ASM2.asm` on member `rac2`
\nStop of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
\nStop of `ora.rac2.ASM2.asm` on member `rac2` succeeded.
\nAttempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`
\nAttempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`
\nStop of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.
\nAttempting to stop `ora.rac2.vip` on member `rac2`
\nStop of `ora.rac2.vip` on member `rac2` succeeded.
\nStop of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.
\nAttempting to stop `ora.rac1.vip` on member `rac1`
\nStop of `ora.rac1.vip` on member `rac1` succeeded.
\nCRS-0216: Could not stop resource 'ora.racdb.racdb1.inst'.<\/p>\n
CRS-0216: Could not stop resource 'ora.racdb.racdb2.inst'.<\/p>\n
[oracle@rac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application OFFLINE OFFLINE
\nora....C1.lsnr application OFFLINE OFFLINE
\nora.rac1.gsd application OFFLINE OFFLINE
\nora.rac1.ons application OFFLINE OFFLINE
\nora.rac1.vip application OFFLINE OFFLINE
\nora....SM2.asm application OFFLINE OFFLINE
\nora....C2.lsnr application OFFLINE OFFLINE
\nora.rac2.gsd application OFFLINE OFFLINE
\nora.rac2.ons application OFFLINE OFFLINE
\nora.rac2.vip application OFFLINE OFFLINE
\nora.racdb.db application OFFLINE OFFLINE
\nora....b1.inst application OFFLINE OFFLINE
\nora....b2.inst application OFFLINE OFFLINE<\/p>\n
--\u505c\u6b62\u6240\u6709\u8282\u70b9\u7684CRS
\n[oracle@rac1 ~]$ su -
\nPassword:
\n[root@rac1 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl stop crs
\nStopping resources.
\nSuccessfully stopped CRS resources
\nStopping CSSD.
\nShutting down CSS daemon.
\nShutdown request successfully issued.
\n[root@rac1 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl check crs
\nFailure 1 contacting CSS daemon
\nCannot communicate with CRS
\nCannot communicate with EVM<\/p>\n
[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl stop crs
\nStopping resources.
\nSuccessfully stopped CRS resources
\nStopping CSSD.
\nShutting down CSS daemon.
\nShutdown request successfully issued.
\n[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl check crs
\nFailure 1 contacting CSS daemon
\nCannot communicate with CRS
\nCannot communicate with EVM<\/p>\n
--\u786e\u8ba4\u53c2\u6570\uff082\u4e2a\u8282\u70b9\u9700\u8981\u4fee\u6539\u90e8\u5206\u53c2\u6570\uff09
\n[root@rac2 ~]# vi \/etc\/sysctl.conf
\n#oracle set
\nkernel.shmall = 2097152
\n#kernel.shmmax = 536870912
\nkernel.shmmax = 1073741824
\nkernel.shmmni = 4096
\nkernel.sem = 250 32000 100 128
\n#fs.file-max = 65536
\nfs.file-max = 101365
\n#net.ipv4.ip_local_port_range = 1024 65000
\nnet.ipv4.ip_local_port_range = 9000 65500
\nnet.core.rmem_default = 1048576
\nnet.core.rmem_max = 1048576
\nnet.core.wmem_default = 262144
\nnet.core.wmem_max = 262144<\/p>\n
--\u6267\u884crunInstaller\u5347\u7ea7CRS
\n[oracle@rac1 ~]$ cd \/tmp\/p8202632_10205_LINUX\/Disk1\/
\n[oracle@rac1 Disk1]$ pwd
\n\/tmp\/p8202632_10205_LINUX\/Disk1
\n[oracle@rac1 Disk1]$ export DISPLAY=192.168.137.1:0.0
\n[oracle@rac1 Disk1]$ .\/runInstaller<\/p>\n
Starting Oracle Universal Installer...<\/p>\n
Checking installer requirements...<\/p>\n
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
\nPassed<\/p>\n
All installer requirements met.<\/p>\n
Preparing to launch Oracle Universal Installer from \/tmp\/OraInstall2012-09-11_04-47-48PM. Please wait ...<\/p>\n
--\u6309\u63d0\u793a\u6267\u884c\u811a\u672c
\n[root@rac1 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl stop crs
\nStopping resources.
\nError while stopping resources. Possible cause: CRSD is down.
\nStopping CSSD.
\nUnable to communicate with the CSS daemon.
\n[root@rac1 ~]# \/opt\/ora10g\/product\/crs\/install\/root102.sh
\nCreating pre-patch directory for saving pre-patch clusterware files
\nCompleted patching clusterware files to \/opt\/ora10g\/product\/crs
\nRelinking some shared libraries.
\nRelinking of patched files is complete.
\nWARNING: directory '\/opt\/ora10g\/product' is not owned by root
\nWARNING: directory '\/opt\/ora10g' is not owned by root
\nPreparing to recopy patched init and RC scripts.
\nRecopying init and RC scripts.
\nStartup will be queued to init within 30 seconds.
\nStarting up the CRS daemons.
\nWaiting for the patched CRS daemons to start.
\nThis may take a while on some systems.
\n.
\n.
\n10205 patch successfully applied.
\nclscfg: EXISTING configuration version 3 detected.
\nclscfg: version 3 is 10G Release 2.
\nSuccessfully deleted 1 values from OCR.
\nSuccessfully deleted 1 keys from OCR.
\nSuccessfully accumulated necessary OCR keys.
\nUsing ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
\nnode :
\nnode 1: rac1 rac1-priv rac1
\nCreating OCR keys for user 'root', privgrp 'root'..
\nOperation successful.
\nclscfg -upgrade completed successfully
\nCreating '\/opt\/ora10g\/product\/crs\/install\/paramfile.crs' with data used for CRS configuration
\nSetting CRS configuration values in \/opt\/ora10g\/product\/crs\/install\/paramfile.crs<\/p>\n
[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl stop crs
\nStopping resources.
\nError while stopping resources. Possible cause: CRSD is down.
\nStopping CSSD.
\nUnable to communicate with the CSS daemon.
\n[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/install\/root102.sh
\nCreating pre-patch directory for saving pre-patch clusterware files
\nCompleted patching clusterware files to \/opt\/ora10g\/product\/crs
\nRelinking some shared libraries.
\nRelinking of patched files is complete.
\nWARNING: directory '\/opt\/ora10g\/product' is not owned by root
\nWARNING: directory '\/opt\/ora10g' is not owned by root
\nPreparing to recopy patched init and RC scripts.
\nRecopying init and RC scripts.
\nStartup will be queued to init within 30 seconds.
\nStarting up the CRS daemons.
\nWaiting for the patched CRS daemons to start.
\nThis may take a while on some systems.
\n.
\n.
\n.
\n10205 patch successfully applied.
\nclscfg: EXISTING configuration version 3 detected.
\nclscfg: version 3 is 10G Release 2.
\nSuccessfully deleted 1 values from OCR.
\nSuccessfully deleted 1 keys from OCR.
\nSuccessfully accumulated necessary OCR keys.
\nUsing ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
\nnode :
\nnode 2: rac2 rac2-priv rac2
\nCreating OCR keys for user 'root', privgrp 'root'..
\nOperation successful.
\nclscfg -upgrade completed successfully
\nCreating '\/opt\/ora10g\/product\/crs\/install\/paramfile.crs' with data used for CRS configuration
\nSetting CRS configuration values in \/opt\/ora10g\/product\/crs\/install\/paramfile.crs<\/p>\n
--CRS\u5347\u7ea7\u5b8c\u6bd5\uff0c\u67e5\u770bCRS\u5f53\u524d\u7248\u672c
\n[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl query crs softwareversion
\nCRS software version on node [rac2] is [10.2.0.5.0]<\/p>\n
\/*\uff08\u4e8c\uff09\u5347\u7ea7DB software*\/
\n--\u9700\u8981\u5173\u95ed\u76f8\u5173\u8fdb\u7a0b\uff08\u5982\u4e0b\u6240\u793a\uff09
\n--\u6ce8\uff1a\u9700\u8981\u5173\u95ed\u6240\u6709\u8282\u70b9\u7684\u8d44\u6e90\u548cCRS\uff0c\u5e76\u4e14\u8981\u4fdd\u8bc1\u6570\u636e\u5e93\u6240\u6709\u8282\u70b9\u7528\u6237\u7b49\u6548\u548c\u65f6\u95f4\u540c\u6b65
\n[root@rac1 ~]# ps -ef | grep sqlplus
\noracle 12149 7832 0 18:45 pts\/0 00:00:00 rlwrap sqlplus \/nolog
\noracle 12152 12149 0 18:45 pts\/2 00:00:00 sqlplus
\nroot 14731 7723 0 18:51 pts\/1 00:00:00 grep sqlplus
\n[root@rac1 ~]# kill -9 12149 12152<\/p>\n
--\u6267\u884crunInstaller\u5347\u7ea7DB software
\n[oracle@rac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application OFFLINE OFFLINE
\nora....C1.lsnr application OFFLINE OFFLINE
\nora.rac1.gsd application OFFLINE OFFLINE
\nora.rac1.ons application OFFLINE OFFLINE
\nora.rac1.vip application OFFLINE OFFLINE
\nora....SM2.asm application OFFLINE OFFLINE
\nora....C2.lsnr application OFFLINE OFFLINE
\nora.rac2.gsd application OFFLINE OFFLINE
\nora.rac2.ons application OFFLINE OFFLINE
\nora.rac2.vip application OFFLINE OFFLINE
\nora.racdb.db application OFFLINE OFFLINE
\nora....b1.inst application OFFLINE OFFLINE
\nora....b2.inst application OFFLINE OFFLINE<\/p>\n
[root@rac1 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl stop crs
\nStopping resources. This could take several minutes.
\nSuccessfully stopped CRS resources.
\nStopping CSSD.
\nShutting down CSS daemon.
\nShutdown request successfully issued.
\n[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl stop crs
\nStopping resources. This could take several minutes.
\nSuccessfully stopped CRS resources.
\nStopping CSSD.
\nShutting down CSS daemon.
\nShutdown request successfully issued.<\/p>\n
[oracle@rac1 ~]$ cd \/tmp\/p8202632_10205_LINUX\/Disk1\/
\n[oracle@rac1 Disk1]$ pwd
\n\/tmp\/p8202632_10205_LINUX\/Disk1
\n[oracle@rac1 Disk1]$ export DISPLAY=192.168.137.1:0.0
\n[oracle@rac1 Disk1]$ .\/runInstaller<\/p>\n
Starting Oracle Universal Installer...<\/p>\n
Checking installer requirements...<\/p>\n
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
\nPassed<\/p>\n
All installer requirements met.<\/p>\n
Preparing to launch Oracle Universal Installer from \/tmp\/OraInstall2012-09-11_06-49-28PM. Please wait ...[oracle@rac1 Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
\nCopyright (C) 1999, 2010, Oracle. All rights reserved.<\/p>\n
--\u5728\u5404\u8282\u70b9\u6267\u884c\u6307\u5b9a\u811a\u672c
\n\u6ce8\uff1a\u5728\u5404\u4e2a\u8282\u70b9\u6267\u884c\u5b8c\u811a\u672c\u540e\uff0c\u9700\u8981\u6267\u884c\u6570\u636e\u5e93\u6570\u636e\u5b57\u5178\u548c\u76f8\u5173\u5305\u7684\u5347\u7ea7\u811a\u672c\uff0c\u6b64\u5904\u5fd8\u8bb0\u6309\u7167readme\u4e2d\u7684\u63d0\u793a\u8fdb\u884c2\u4e2asql\u811a\u672c\u7684\u6267\u884c\uff0c\u5bfc\u81f4\u540e\u8fb9\u6570\u636e\u5e93\u6b63\u5e38startup\u65f6\u7684\u62a5\u9519\u3002\u5177\u4f53\u89e3\u51b3\u53ca\u5904\u7406\u8fc7\u7a0b\u89c1\u540e\u8fb9\u3002\uff08\u4e5f\u662f\u540e\u8865\u811a\u672c\u7684\u6267\u884c\uff09
\n[root@rac1 ~]# \/opt\/ora10g\/product\/database\/root.sh
\nRunning Oracle 10g root.sh script...<\/p>\n
The following environment variables are set as:
\nORACLE_OWNER= oracle
\nORACLE_HOME= \/opt\/ora10g\/product\/database<\/p>\n
Enter the full pathname of the local bin directory: [\/usr\/local\/bin]:
\nThe file \"dbhome\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)
\n[n]: y
\nCopying dbhome to \/usr\/local\/bin ...
\nThe file \"oraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)
\n[n]: y
\nCopying oraenv to \/usr\/local\/bin ...
\nThe file \"coraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)
\n[n]: y
\nCopying coraenv to \/usr\/local\/bin ...<\/p>\n
Entries will be added to the \/etc\/oratab file as needed by
\nDatabase Configuration Assistant when a database is created
\nFinished running generic part of root.sh script.
\nNow product-specific root actions will be performed.<\/p>\n
[root@rac2 ~]# \/opt\/ora10g\/product\/database\/root.sh
\nRunning Oracle 10g root.sh script...<\/p>\n
The following environment variables are set as:
\nORACLE_OWNER= oracle
\nORACLE_HOME= \/opt\/ora10g\/product\/database<\/p>\n
Enter the full pathname of the local bin directory: [\/usr\/local\/bin]:
\nThe file \"dbhome\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)
\n[n]: y
\nCopying dbhome to \/usr\/local\/bin ...
\nThe file \"oraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)
\n[n]: y
\nCopying oraenv to \/usr\/local\/bin ...
\nThe file \"coraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)
\n[n]: y
\nCopying coraenv to \/usr\/local\/bin ...<\/p>\n
Entries will be added to the \/etc\/oratab file as needed by
\nDatabase Configuration Assistant when a database is created
\nFinished running generic part of root.sh script.
\nNow product-specific root actions will be performed.<\/p>\n
\/*\uff08\u4e09\uff09\u5b89\u88c5\u8865\u4e01p12880299_10205_LINUX.zip*\/
\n--\u67e5\u770b\u5f53\u524d\u8865\u4e01\u60c5\u51b5
\n[oracle@rac1 OPatch]$ .\/opatch lsinventory
\nInvoking OPatch 10.2.0.4.9<\/p>\n
Oracle Interim Patch Installer version 10.2.0.4.9
\nCopyright (c) 2009, Oracle Corporation. All rights reserved.<\/p>\n
Oracle Home : \/opt\/ora10g\/product\/database
\nCentral Inventory : \/opt\/ora10g\/oraInventory
\nfrom : \/etc\/oraInst.loc
\nOPatch version : 10.2.0.4.9
\nOUI version : 10.2.0.5.0
\nOUI location : \/opt\/ora10g\/product\/database\/oui
\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-12_01-12-58AM.log<\/p>\n
Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n
Lsinventory Output file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/lsinv\/lsinventory2012-09-12_01-12-58AM.txt<\/p>\n
--------------------------------------------------------------------------------
\nInstalled Top-level Products (2):<\/p>\n
Oracle Database 10g 10.2.0.1.0
\nOracle Database 10g Release 2 Patch Set 4 10.2.0.5.0a
\nThere are 2 products installed in this Oracle Home.<\/p>\n
There are no Interim patches installed in this Oracle Home.<\/p>\n
Rac system comprising of multiple nodes
\nLocal node = rac1
\nRemote node = rac2<\/p>\n
--------------------------------------------------------------------------------<\/p>\n
OPatch succeeded.<\/p>\n
--\u5b89\u88c5\u8865\u4e01
\n[oracle@rac1 12880299]$ pwd
\n\/tmp\/12880299
\n[oracle@rac1 12880299]$ \/opt\/ora10g\/product\/database\/OPatch\/opatch apply
\nInvoking OPatch 10.2.0.4.9<\/p>\n
Oracle Interim Patch Installer version 10.2.0.4.9
\nCopyright (c) 2009, Oracle Corporation. All rights reserved.<\/p>\n
Oracle Home : \/opt\/ora10g\/product\/database
\nCentral Inventory : \/opt\/ora10g\/oraInventory
\nfrom : \/etc\/oraInst.loc
\nOPatch version : 10.2.0.4.9
\nOUI version : 10.2.0.5.0
\nOUI location : \/opt\/ora10g\/product\/database\/oui
\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-12_01-15-11AM.log<\/p>\n
Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n
ApplySession applying interim patch '12880299' to OH '\/opt\/ora10g\/product\/database'<\/p>\n
Running prerequisite checks...<\/p>\n
OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.<\/p>\n
Backing up files and inventory (not for auto-rollback) for the Oracle Home
\nBacking up files affected by the patch '12880299' for restore. This might take a while...
\nBacking up files affected by the patch '12880299' for rollback. This might take a while...<\/p>\n
Patching component oracle.network.listener, 10.2.0.5.0...<\/p>\n
Patching component oracle.network.rsf, 10.2.0.5.0...
\nUpdating archive file \"\/opt\/ora10g\/product\/database\/network\/lib\/libnlsnr10.a\" with \"network\/lib\/libnlsnr10.a\/nsglsn.o\"
\nRunning make for target itnslsnr
\nRunning make for target tnslsnr
\nRunning make for target client_sharedlib
\nApplySession adding interim patch '12880299' to inventory<\/p>\n
Verifying the update...
\nInventory check OK: Patch ID 12880299 is registered in Oracle Home inventory with proper meta-data.
\nFiles check OK: Files from Patch ID 12880299 are present in Oracle Home.<\/p>\n
Patching in rolling mode.<\/p>\n
Updating nodes 'rac2'
\nApply-related files are:
\nFP = \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/copy_files.txt\"
\nDP = \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/copy_dirs.txt\"
\nMP = \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/make_cmds.txt\"
\nRC = \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/remote_cmds.txt\"<\/p>\n
Instantiating the file \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/copy_files.txt.instantiated\" by replacing $ORACLE_HOME in \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/copy_files.txt\" with actual path.
\nPropagating files to remote nodes...
\nInstantiating the file \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/copy_dirs.txt.instantiated\" by replacing $ORACLE_HOME in \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/copy_dirs.txt\" with actual path.
\nPropagating directories to remote nodes...
\nInstantiating the file \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/make_cmds.txt.instantiated\" by replacing $ORACLE_HOME in \"\/opt\/ora10g\/product\/database\/.patch_storage\/12880299_May_3_2012_20_16_10\/rac\/make_cmds.txt\" with actual path.
\nRunning command on remote node 'rac2':
\ncd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_server.mk itnslsnr ORACLE_HOME=\/opt\/ora10g\/product\/database || echo REMOTE_MAKE_FAILED::>&2<\/p>\n
Running command on remote node 'rac2':
\ncd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_server.mk tnslsnr ORACLE_HOME=\/opt\/ora10g\/product\/database || echo REMOTE_MAKE_FAILED::>&2<\/p>\n
Running command on remote node 'rac2':
\ncd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=\/opt\/ora10g\/product\/database || echo REMOTE_MAKE_FAILED::>&2<\/p>\n
There were relinks on remote nodes. Remember to check the binary size and timestamp on the nodes 'rac2' .
\nThe following make commands were invoked on remote nodes:
\n'cd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_server.mk itnslsnr ORACLE_HOME=\/opt\/ora10g\/product\/database
\ncd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_server.mk tnslsnr ORACLE_HOME=\/opt\/ora10g\/product\/database
\ncd \/opt\/ora10g\/product\/database\/network\/lib; \/usr\/bin\/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=\/opt\/ora10g\/product\/database
\n'<\/p>\n
OPatch succeeded.<\/p>\n
--\u67e5\u770b\u5b89\u88c5\u540e\u8865\u4e01\u60c5\u51b5
\n[oracle@rac1 12880299]$ \/opt\/ora10g\/product\/database\/OPatch\/opatch lsinventory
\nInvoking OPatch 10.2.0.4.9<\/p>\n
Oracle Interim Patch Installer version 10.2.0.4.9
\nCopyright (c) 2009, Oracle Corporation. All rights reserved.<\/p>\n
Oracle Home : \/opt\/ora10g\/product\/database
\nCentral Inventory : \/opt\/ora10g\/oraInventory
\nfrom : \/etc\/oraInst.loc
\nOPatch version : 10.2.0.4.9
\nOUI version : 10.2.0.5.0
\nOUI location : \/opt\/ora10g\/product\/database\/oui
\nLog file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch2012-09-12_01-16-58AM.log<\/p>\n
Patch history file: \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/opatch_history.txt<\/p>\n
Lsinventory Output file location : \/opt\/ora10g\/product\/database\/cfgtoollogs\/opatch\/lsinv\/lsinventory2012-09-12_01-16-58AM.txt<\/p>\n
--------------------------------------------------------------------------------
\nInstalled Top-level Products (2):<\/p>\n
Oracle Database 10g 10.2.0.1.0
\nOracle Database 10g Release 2 Patch Set 4 10.2.0.5.0a
\nThere are 2 products installed in this Oracle Home.<\/p>\n
Interim patches (1) :<\/p>\n
Patch 12880299 : applied on Wed Sep 12 01:15:39 CST 2012
\nUnique Patch ID: 14803344
\nCreated on 3 May 2012, 20:16:10 hrs PST8PDT
\nBugs fixed:
\n12880299<\/p>\n
Rac system comprising of multiple nodes
\nLocal node = rac1
\nRemote node = rac2<\/p>\n
--------------------------------------------------------------------------------<\/p>\n
OPatch succeeded.<\/p>\n
\/*\uff08\u9644\uff09\u68c0\u67e5\u6570\u636e\u5e93\u72b6\u6001*\/
\n--\u542f\u52a8RAC\u76f8\u5173\u8d44\u6e90\uff0c\u9a8c\u8bc1\u7ed3\u679c
\n[root@rac1 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl start crs
\nAttempting to start CRS stack
\nThe CRS stack will be started shortly
\n[root@rac2 ~]# \/opt\/ora10g\/product\/crs\/bin\/crsctl start crs
\nAttempting to start CRS stack
\nThe CRS stack will be started shortly<\/p>\n
SQL> conn \/as sysdba
\nConnected to an idle instance.
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1274716 bytes
\nVariable Size 272632996 bytes
\nDatabase Buffers 260046848 bytes
\nRedo Buffers 2916352 bytes
\nDatabase mounted.
\nORA-01092: ORACLE instance terminated. Disconnection forced<\/p>\n
--\u544a\u8b66\u65e5\u5fd7\u5982\u4e0b\uff08\u90e8\u5206\uff09
\nWed Sep 12 10:20:11 CST 2012
\nErrors in file \/opt\/ora10g\/admin\/racdb\/udump\/racdb1_ora_12504.trc:
\nORA-00704: bootstrap process failure
\nORA-39700: database must be opened with UPGRADE option
\nWed Sep 12 10:20:11 CST 2012
\nError 704 happened during db open, shutting down database
\nUSER: terminating instance due to error 704
\nInstance terminated by USER, pid = 12504
\nORA-1092 signalled during: ALTER DATABASE OPEN...<\/p>\n
--trace\u5982\u4e0b\uff08\u90e8\u5206\uff09
\nValidate domain 0
\nValidated domain 0, flags = 0x0
\nORA-00704: bootstrap process failure
\nORA-39700: database must be opened with UPGRADE option<\/p>\n
--\u6267\u884c\u811a\u672c
\n[oracle@rac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Sep 12 10:27:35 2012<\/p>\n
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.<\/p>\n
SQL> connect \/as sysdba
\nConnected to an idle instance.
\nSQL> startup nomount
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1274716 bytes
\nVariable Size 272632996 bytes
\nDatabase Buffers 260046848 bytes
\nRedo Buffers 2916352 bytes
\nSQL> alter system set cluster_database=false scope=spfile;<\/p>\n
System altered.<\/p>\n
SQL> shutdown immediate
\nORA-01507: database not mounted<\/p>\n
ORACLE instance shut down.
\nSQL> startup upgrade
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1274716 bytes
\nVariable Size 272632996 bytes
\nDatabase Buffers 260046848 bytes
\nRedo Buffers 2916352 bytes
\nDatabase mounted.
\nDatabase opened.
\nSQL> spool \/tmp\/patch.log append
\nSQL> @?\/rdbms\/admin\/catupgrd.sql
\n... ...
\nSQL> spool off
\nSQL> shutdown immediate
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1274716 bytes
\nVariable Size 293604516 bytes
\nDatabase Buffers 239075328 bytes
\nRedo Buffers 2916352 bytes
\nDatabase mounted.
\nDatabase opened.
\nSQL> spool \/tmp\/plsql_paks.log append
\nSQL> @?\/rdbms\/admin\/utlrp.sql
\n... ...
\nSQL> spool off
\nSQL> alter system set cluster_database=true scope=spfile;<\/p>\n
System altered.<\/p>\n
SQL> shutdown immediate
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1274716 bytes
\nVariable Size 293604516 bytes
\nDatabase Buffers 239075328 bytes
\nRedo Buffers 2916352 bytes
\nDatabase mounted.
\nDatabase opened.
\nSQL> !
\n[oracle@rac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application ONLINE ONLINE rac1
\nora....C1.lsnr application ONLINE ONLINE rac1
\nora.rac1.gsd application ONLINE ONLINE rac1
\nora.rac1.ons application ONLINE ONLINE rac1
\nora.rac1.vip application ONLINE ONLINE rac1
\nora....SM2.asm application ONLINE ONLINE rac2
\nora....C2.lsnr application ONLINE ONLINE rac2
\nora.rac2.gsd application ONLINE ONLINE rac2
\nora.rac2.ons application ONLINE ONLINE rac2
\nora.rac2.vip application ONLINE ONLINE rac2
\nora.racdb.db application ONLINE ONLINE rac2
\nora....b1.inst application ONLINE ONLINE rac1
\nora....b2.inst application OFFLINE OFFLINE
\n[oracle@rac1 ~]$ srvctl start instance -d racdb -i racdb2
\n[oracle@rac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application ONLINE ONLINE rac1
\nora....C1.lsnr application ONLINE ONLINE rac1
\nora.rac1.gsd application ONLINE ONLINE rac1
\nora.rac1.ons application ONLINE ONLINE rac1
\nora.rac1.vip application ONLINE ONLINE rac1
\nora....SM2.asm application ONLINE ONLINE rac2
\nora....C2.lsnr application ONLINE ONLINE rac2
\nora.rac2.gsd application ONLINE ONLINE rac2
\nora.rac2.ons application ONLINE ONLINE rac2
\nora.rac2.vip application ONLINE ONLINE rac2
\nora.racdb.db application ONLINE ONLINE rac2
\nora....b1.inst application ONLINE ONLINE rac1
\nora....b2.inst application ONLINE ONLINE rac2
\n[oracle@rac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Sep 12 14:10:23 2012<\/p>\n
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected.
\nSQL> select * from gv$version where rownum<\/p>\n
INST_ID BANNER
\n---------- ----------------------------------------------------------------
\n1 Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
\n1 PL\/SQL Release 10.2.0.5.0 - Production
\n1 CORE 10.2.0.5.0 Production
\n1 TNS for Linux: Version 10.2.0.5.0 - Production
\n1 NLSRTL Version 10.2.0.5.0 - Production
\n2 Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
\n2 PL\/SQL Release 10.2.0.5.0 - Production
\n2 CORE 10.2.0.5.0 Production
\n2 TNS for Linux: Version 10.2.0.5.0 - Production<\/p>\n
SQL> select * from test;<\/p>\n
ID NAME
\n---------- ----------
\n1 YALLONKING<\/p>\n","protected":false},"excerpt":{"rendered":"
\uff08\u96f6\uff09 RAC\u6570\u636e\u5e93\u5347\u7ea7\uff0810.2.0.1.0->10.2.0.5.0\uff09\u5e76\u6253\u8865\u4e01\uff08P12880299\uff09 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/285"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=285"}],"version-history":[{"count":8,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/285\/revisions"}],"predecessor-version":[{"id":653,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/285\/revisions\/653"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=285"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}