oracle 12c rac_opatchauto apply on suse linux 11 64bit sp3_记录1
介质:
OS平台:suse linux 11 64bit SP3
Grid Infrastructure:12.1.0.2
Oracle database:12.1.0.2
PSU:12.1.0.2.160419
2节点RAC
oracle 12c R1版本自动打补丁的命令发生了变化,命令为opatchauto apply,而 oracle 12c R1之前的 自动 打补丁的命令为 opatch auto。
在12c R1版本,根据操作系统平台的不同,打补丁的过程中有可能需要重启操作系统。
下面,以root用户使用 opatchauto appl y同时给grid和oracle打补丁,这里先给节点1打补丁。
DEVDB1:/oracle/orasoft # /oracle/app/grid/grid_home/OPatch/opatchauto apply /oracle/orasoft/22646084 -ocmrf /oracle/app/grid/grid_home/OPatch/ocm/bin/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /oracle/app/grid/grid_home
opatchauto log file: /oracle/app/grid/grid_home/cfgtoollogs/opatchauto/22646084/opatch_gi_2016-05-24_15-22-11_deploy.log
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /oracle/orasoft/22646084
Grid Infrastructure Patch(es): 21436941 22291127 22502518 22502555
DB Patch(es): 22291127 22502555
Patch Validation: Successful
Grid Infrastructure home:
/oracle/app/grid/grid_home
DB home(s):
/oracle/app/oracle/product/12.1.0/db_1
Performing prepatch operations on CRS Home... Successful
Applying patch(es) to "/oracle/app/oracle/product/12.1.0/db_1" ...
Patch "/oracle/orasoft/22646084/22291127" successfully applied to "/oracle/app/oracle/product/12.1.0/db_1".
Patch "/oracle/orasoft/22646084/22502555" successfully applied to "/oracle/app/oracle/product/12.1.0/db_1".
Applying patch(es) to "/oracle/app/grid/grid_home" ...
Patch "/oracle/orasoft/22646084/21436941" successfully applied to "/oracle/app/grid/grid_home".
Patch "/oracle/orasoft/22646084/22291127" successfully applied to "/oracle/app/grid/grid_home".
Patch "/oracle/orasoft/22646084/22502518" successfully applied to "/oracle/app/grid/grid_home".
Patch "/oracle/orasoft/22646084/22502555" successfully applied to "/oracle/app/grid/grid_home".
Performing postpatch operations on CRS Home... Failed
CLSRSC-400: A system reboot is required to continue installing.
--------------After fixing the cause of failure you have two options shown below:
Run 'opatchauto resume'
or
Manually run the commands listed below
---------------------------------------------------------------------------------
/oracle/app/grid/grid_home/perl/bin/perl -I/oracle/app/grid/grid_home/perl/lib -I/oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install /oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install/rootcrs.pl -postpatch (Run as root)
/bin/bash -c 'ORACLE_HOME=/oracle/app/oracle/product/12.1.0/db_1 ORACLE_SID=IVR1 /oracle/app/oracle/product/12.1.0/db_1/OPatch/datapatch' (Run as oracle)
-------------------------------------------------------------------------------
For more details, please refer to the log file "/oracle/app/grid/grid_home/cfgtoollogs/opatchauto/22646084/opatch_gi_2016-05-24_15-22-11_deploy.debug.log".
Apply Summary:
Following patch(es) are successfully installed:
GI Home: /oracle/app/grid/grid_home: 21436941,22291127,22502518,22502555
DB Home: /oracle/app/oracle/product/12.1.0/db_1: 22291127,22502555
Command failure exception
opatchauto failed with error code 2.
DEVDB1:/oracle/orasoft #
根据提示,要重启操作系统,然后再接着打补丁
可以以root用户执行opatchauto resume,
或者分步骤执行
/oracle/app/grid/grid_home/perl/bin/perl -I/oracle/app/grid/grid_home/perl/lib -I/oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install /oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install/rootcrs.pl -postpatch (Run as root)
/bin/bash -c 'ORACLE_HOME=/oracle/app/oracle/product/12.1.0/db_1 ORACLE_SID=IVR1 /oracle/app/oracle/product/12.1.0/db_1/OPatch/datapatch' (Run as oracle)
首先,以root用户reboot系统
重启操作系统后,这里采用分步骤执行脚本
以root用 户 执行 脚本
DEVDB1:~ # /oracle/app/grid/grid_home/perl/bin/perl -I/oracle/app/grid/grid_home/perl/lib -I/oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install /oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install/rootcrs.pl -postpatch
Using configuration parameter file: /oracle/app/grid/grid_home/OPatch/opatchautotemp_DEVDB1/patchwork/crs/install/crsconfig_params
2016/05/24 06:54:41 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2016/05/24 06:54:41 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
CRS-4123: Oracle High Availability Services has been started.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'DEVdb1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'devdb1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'devdb1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'devdb1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'devdb1'
CRS-2672: Attempting to start 'ora.evmd' on 'devdb1'
CRS-2676: Start of 'ora.mdnsd' on 'devdb1' succeeded
CRS-2676: Start of 'ora.evmd' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'devdb1'
CRS-2676: Start of 'ora.gpnpd' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'devdb1'
CRS-2676: Start of 'ora.gipcd' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'devdb1'
CRS-2676: Start of 'ora.cssdmonitor' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'devdb1'
CRS-2672: Attempting to start 'ora.diskmon' on 'devdb1'
CRS-2676: Start of 'ora.diskmon' on 'devdb1' succeeded
CRS-2676: Start of 'ora.cssd' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'devdb1'
CRS-2672: Attempting to start 'ora.ctssd' on 'devdb1'
CRS-2676: Start of 'ora.ctssd' on 'devdb1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'devdb1'
CRS-2676: Start of 'ora.asm' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'devdb1'
CRS-2676: Start of 'ora.storage' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'devdb1'
CRS-2676: Start of 'ora.crf' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'devdb1'
CRS-2676: Start of 'ora.crsd' on 'DEVdb1' succeeded
CRS-6017: Processing resource auto-start for servers: devdb1
CRS-2672: Attempting to start 'ora.net1.network' on 'devdb1'
CRS-2676: Start of 'ora.net1.network' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.ons' on 'devdb1'
CRS-2673: Attempting to stop 'ora.devdb1.vip' on 'devdb2'
CRS-2677: Stop of 'ora.DEVdb1.vip' on 'devdb2' succeeded
CRS-2672: Attempting to start 'ora.devdb1.vip' on 'devdb1'
CRS-2676: Start of 'ora.ons' on 'devdb1' succeeded
CRS-2676: Start of 'ora.devdb1.vip' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'devdb1'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'devdb1' succeeded
CRS-2672: Attempting to start 'ora.ivr.db' on 'devdb1'
CRS-2676: Start of 'ora.ivr.db' on 'devdb1' succeeded
CRS-6016: Resource auto-start has completed for server devdb1
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [0].
SQL Patching tool version 12.1.0.2.0 on Tue May 24 06:58:00 2016
Copyright (c) 2015, Oracle. All rights reserved.
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Determining current state...done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED IVR_CLUSTER
Nothing to roll back
The following patches will be applied:
22291127 (Database Patch Set Update : 12.1.0.2.160419 (22291127))
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
SQL Patching tool complete on Tue May 24 07:00:20 2016
DEVDB1:~ #
以oracle用 户 执行 脚本
oracle[DEVDB1]/home/oracle> /bin/bash -c 'ORACLE_HOME=/oracle/app/oracle/product/12.1.0/db_1 ORACLE_SID=IVR1 /oracle/app/oracle/product/12.1.0/db_1/OPatch/datapatch'
SQL Patching tool version 12.1.0.2.0 on Tue May 24 07:01:37 2016
Copyright (c) 2015, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
Nothing to roll back
Nothing to apply
SQL Patching tool complete on Tue May 24 07:03:11 2016
oracle[DEVDB1]/home/oracle>
打完psu后验证补丁是否打上
su - oracle
oracle[DEVDB1]/home/oracle> opatch lspatches
22502555;OCW Patch Set Update : 12.1.0.2.160419 (22502555)
22291127;Database Patch Set Update : 12.1.0.2.160419 (22291127)
OPatch succeeded.
o racle[DEVDB1]/home/oracle>
su - grid
grid[DEVDB1]/home/grid> opatch lspatches
22502555;OCW Patch Set Update : 12.1.0.2.160419 (22502555)
22502518;ACFS Patch Set Update : 12.1.0.2.160419 (22502518)
22291127;Database Patch Set Update : 12.1.0.2.160419 (22291127)
21436941;WLM Patch Set Update: 12.1.0.2.5 (21436941)
OPatch succeeded.
grid[DEVDB1]/home/grid>
通过验证,grid和oracle都已经打上了PSU 12.1.0.2.160419 补丁。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24626891/viewspace-2125246/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24626891/viewspace-2125246/