升级准备
我这里由于测试机限制,使用的是单节点的rac,流程有限次请理解。
另外,建议做12c测试的虚拟机,至少分100g的本地磁盘。。。
1、当前GI 12102需要打补丁,要求为21255373,建议为最新的PSU
2、升级GI 12201需要打补丁,需要修复Bug 27769638,见27769638.8,我这里下载的为p27769638_12201180116OCWJan2018RU_Linux-x86-64
但是在升级中还是遇到了CLSRSC-400,见另外处理的文档参考https://www.cndba.cn/q195136130/article/3151
3、软件安装空间需要20G左右(redhat7.5)
4、OCR磁盘组需要50G空间(当mgmt在OCR中时)
升级流程
12201的软件,GI是gridSetup.sh,DB还是runInstaller,27769638补丁要用特殊的命令,在安装时打上
升级GI
mkdir -p /u01/app/12.0.0/grid_1
unzip linuxx64_12201_grid_home.zip -d /u01/app/12.0.0/grid_1
cd /u01/app/12.0.0/grid_1/
运行gridsetup直接打上补丁
[grid@ora12c1 grid_1]$ ./gridSetup.sh -applyPSU /u01/soft/27769638/
关于cvudisk包,软件目录下/u01/app/12.0.0/grid_1/cv/rpm,本身带有。但是打上该包并不会令该错误消失,可能与打上的包的版本较低有关(自带的为1.0.10.9)
[root@ora12c1 3.10.0-862.el7.x86_64]# /u01/app/12.0.0/grid_1/rootupgrade.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/12.0.0/grid_1
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 contents of “coraenv” have not changed. No need to overwrite.
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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/12.0.0/grid_1/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/ora12c1/crsconfig/rootcrs_ora12c1_2018-11-16_01-14-58PM.log
2018/11/16 13:15:01 CLSRSC-595: Executing upgrade step 1 of 19: ‘UpgradeTFA’.
2018/11/16 13:15:01 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2018/11/16 13:15:01 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
2018/11/16 13:16:40 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.
2018/11/16 13:16:51 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2018/11/16 13:16:51 CLSRSC-595: Executing upgrade step 2 of 19: ‘ValidateEnv’.
2018/11/16 13:16:54 CLSRSC-595: Executing upgrade step 3 of 19: ‘GenSiteGUIDs’.
2018/11/16 13:16:59 CLSRSC-595: Executing upgrade step 4 of 19: ‘GetOldConfig’.
2018/11/16 13:16:59 CLSRSC-464: Starting retrieval of the cluster configuration data
2018/11/16 13:17:05 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2018/11/16 13:17:05 CLSRSC-595: Executing upgrade step 5 of 19: ‘UpgPrechecks’.
2018/11/16 13:17:06 CLSRSC-595: Executing upgrade step 6 of 19: ‘SaveParamFile’.
2018/11/16 13:17:07 CLSRSC-595: Executing upgrade step 7 of 19: ‘SetupOSD’.
2018/11/16 13:17:07 CLSRSC-595: Executing upgrade step 8 of 19: ‘PreUpgrade’.
2018/11/16 13:17:07 CLSRSC-595: Executing upgrade step 9 of 19: ‘CheckCRSConfig’.
2018/11/16 13:17:08 CLSRSC-595: Executing upgrade step 10 of 19: ‘UpgradeOLR’.
2018/11/16 13:17:09 CLSRSC-595: Executing upgrade step 11 of 19: ‘ConfigCHMOS’.
2018/11/16 13:17:54 CLSRSC-595: Executing upgrade step 12 of 19: ‘InstallAFD’.
2018/11/16 13:17:56 CLSRSC-595: Executing upgrade step 13 of 19: ‘createOHASD’.
2018/11/16 13:17:57 CLSRSC-595: Executing upgrade step 14 of 19: ‘ConfigOHASD’.
2018/11/16 13:18:12 CLSRSC-329: Replacing Clusterware entries in file ‘oracle-ohasd.service’
2018/11/16 13:18:33 CLSRSC-595: Executing upgrade step 15 of 19: ‘InstallACFS’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘ora12c1’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘ora12c1’
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘ora12c1’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘ora12c1’
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘ora12c1’
CRS-2677: Stop of ‘ora.gipcd’ on ‘ora12c1’ succeeded
CRS-2677: Stop of ‘ora.mdnsd’ on ‘ora12c1’ succeeded
CRS-2677: Stop of ‘ora.gpnpd’ on ‘ora12c1’ succeeded
CRS-2677: Stop of ‘ora.evmd’ on ‘ora12c1’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘ora12c1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2018/11/16 13:19:00 CLSRSC-595: Executing upgrade step 16 of 19: ‘InstallKA’.
2018/11/16 13:19:03 CLSRSC-595: Executing upgrade step 17 of 19: ‘UpgradeCluster’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘ora12c1’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘ora12c1’ 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.evmd’ on ‘ora12c1’
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘ora12c1’
CRS-2676: Start of ‘ora.mdnsd’ on ‘ora12c1’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘ora12c1’
CRS-2676: Start of ‘ora.gpnpd’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘ora12c1’
CRS-2676: Start of ‘ora.gipcd’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘ora12c1’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘ora12c1’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘ora12c1’
CRS-2676: Start of ‘ora.diskmon’ on ‘ora12c1’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.cluster_interconnect.haip’ on ‘ora12c1’
CRS-2672: Attempting to start ‘ora.ctssd’ on ‘ora12c1’
CRS-2676: Start of ‘ora.ctssd’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.drivers.acfs’ on ‘ora12c1’
CRS-2674: Start of ‘ora.drivers.acfs’ on ‘ora12c1’ failed
CRS-2676: Start of ‘ora.cluster_interconnect.haip’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘ora12c1’
CRS-2676: Start of ‘ora.asm’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.storage’ on ‘ora12c1’
CRS-2676: Start of ‘ora.storage’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.crf’ on ‘ora12c1’
CRS-2676: Start of ‘ora.crf’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘ora12c1’
CRS-2676: Start of ‘ora.crsd’ on ‘ora12c1’ succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: ora12c1
CRS-2672: Attempting to start ‘ora.ora12c1.vip’ on ‘ora12c1’
CRS-2672: Attempting to start ‘ora.scan1.vip’ on ‘ora12c1’
CRS-2672: Attempting to start ‘ora.ons’ on ‘ora12c1’
CRS-2672: Attempting to start ‘ora.MGMTLSNR’ on ‘ora12c1’
CRS-2676: Start of ‘ora.ora12c1.vip’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER.lsnr’ on ‘ora12c1’
CRS-2676: Start of ‘ora.scan1.vip’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN1.lsnr’ on ‘ora12c1’
CRS-2676: Start of ‘ora.MGMTLSNR’ on ‘ora12c1’ succeeded
CRS-2676: Start of ‘ora.ons’ on ‘ora12c1’ succeeded
CRS-2676: Start of ‘ora.LISTENER.lsnr’ on ‘ora12c1’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ‘ora12c1’ succeeded
CRS-2672: Attempting to start ‘ora.orcl.db’ on ‘ora12c1’
CRS-2676: Start of ‘ora.orcl.db’ on ‘ora12c1’ succeeded
CRS-6016: Resource auto-start has completed for server ora12c1
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2018/11/16 13:21:28 CLSRSC-343: Successfully started Oracle Clusterware stack
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 12c Release 1.
Successfully taken the backup of node specific configuration in OCR.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
2018/11/16 13:21:36 CLSRSC-595: Executing upgrade step 18 of 19: ‘UpgradeNode’.
2018/11/16 13:21:39 CLSRSC-474: Initiating upgrade of resource types
2018/11/16 13:22:15 CLSRSC-482: Running command: ‘srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p first’
2018/11/16 13:22:15 CLSRSC-475: Upgrade of resource types successfully initiated.
Start upgrade invoked..
2018/11/16 13:22:20 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded
2018/11/16 13:22:20 CLSRSC-482: Running command: ‘/u01/app/12.0.0/grid_1/bin/crsctl set crs activeversion’
Started to upgrade the active version of Oracle Clusterware. This operation may take a few minutes.
Started to upgrade CSS.
CSS was successfully upgraded.
Started to upgrade CRS.
CRS was successfully upgraded.
Successfully upgraded the active version of Oracle Clusterware.
Oracle Clusterware active version was successfully set to 12.2.0.1.0.
2018/11/16 13:23:25 CLSRSC-479: Successfully set Oracle Clusterware active version
2018/11/16 13:23:25 CLSRSC-476: Finishing upgrade of resource types
2018/11/16 13:23:42 CLSRSC-482: Running command: ‘srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p last’
2018/11/16 13:23:42 CLSRSC-477: Successfully completed upgrade of resource types
2018/11/16 13:24:01 CLSRSC-595: Executing upgrade step 19 of 19: ‘PostUpgrade’.
2018/11/16 13:24:06 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster … succeeded
升级DB
[oracle@ora12c1 database]$ unzip linuxx64_12201_database.zip
[oracle@ora12c1 database]$ cd database/
[oracle@ora12c1 database]$ ./runInstaller
选择升级,安装完成后自动运行dbua
后期扫尾
升级流程有瑕疵,导致MGMTDB没有升级,该组件是集群性能监控的组件,还有快速部署的功能。对集群使用没有影响,若需要其功能须重建。
版权声明:本文为博主原创文章,未经博主允许不得转载。
12c升级 12201 12102 rootupgrade
- 上一篇:12c打psu