dbua from 11.2,0.2 to 11.2.0.4 need 2hours
升级结果：
步骤名 日志文件名 状态
升级前操作 PreUpgrade.log 成功
Oracle ServerOracle_Server.log 成功
升级后操作PostUpgrade.log 成功
*Enterprise Manager 配置emConfigUpgrade.log 失败*
生成概要 generateSummary.log 成功
http://jingyan.baidu.com/article/cd4c29790b3c2f756f6e6041.html
sample 1:
--prapare
stop all oracle process
set ORACLE_HOME=D:appproduct11.2.0.4dbhome_1
set PATH=%ORACLE_HOME%OPatch;%ORACLE_HOME%in;%PATH%
mkdir -p D:appproduct11.2.0.4dbhome_1
mkdir -p c:appsoftware
mkdir -p c:appsoftwareRSP
mkdir -p c:appsoftwaredatabase
mkdir -p C:apporaclearchivelog
xcopy \tsclientDOraCD11204_win64_templatep6880880_112000_MSWIN-x86-64.zip c:appsoftware /D /E /Y /H /K
xcopy \tsclientDOraCD11204_win64_templatep26182427_112040_MSWIN-x86-64.zip c:appsoftware /D /E /Y /H /K
xcopy \tsclientDOraCD11204_win64_templatep26194138_112040_MSWIN-x86-64.zip c:appsoftware /D /E /Y /H /K
xcopy \tsclientDOraCD11204_win64_templateRSPdb.rsp c:appsoftwareRSP /D /E /Y /H /K
xcopy \tsclientDOraCD11204_win64_templatep13390677_112040_MSWIN-x86-64_1of7.zip c:appsoftwaredatabase /D /E /Y /H /K
xcopy \tsclientDOraCD11204_win64_templatep13390677_112040_MSWIN-x86-64_2of7.zip c:appsoftwaredatabase /D /E /Y /H /K
---edit
hostname
c:appsoftwareRSPdb.rsp
--修改ORACLE_HOSTNAME主机名
检查oracle.install.OracleHomeUserPassword
--检查ORACLE_HOME
--检查ORACLE_BASE
cd c:appsoftwaredatabase
unzip p13390677_112040_MSWIN-x86-64_1of7.zip -d .
unzip p13390677_112040_MSWIN-x86-64_2of7.zip -d .
/
cd c:appsoftware
unzip p26194138_112040_MSWIN-x86-64.zip -d .psu
unzip p26182427_112040_MSWIN-x86-64.zip -d .ojvm
unzip -o p6880880_112000_MSWIN-x86-64.zip -d %ORACLE_HOME%
/
copy D:appAdministratorproduct11.2.0dbhome_1 etworkadmin*.ora %ORACLE_HOME% etworkadmin /D /E /Y /H /K
cd c:appsoftware
%ORACLE_HOME%OPatchocminemocmrsp.bat
--begin
cd C:appsoftwaredatabasedatabase
setup.exe -silent -debug -force -waitforcompletion -responseFile "C:appsoftwareRSPdb.rsp"
--check c:program filesoracleinventorylogsinstallaction*log
cd c:appsoftware
opatch apply -silent psu26194138 -ocmrf ocm.rsp
opatch apply -silent ojvm26182425 -ocmrf ocm.rsp
dbua
----升级时候勾选bakcup database
-- dbua -silent -dbname iypsdev
--> -oracleHome %ORACLE_HOME% -sysDBAUserName sys
--> -sysDBAPassword oracle123 -recompile_invalid_objects true -emConfiguration none
--check c:appproductcfgtoollogsdbuasidupgrede1 race.log(Oracle_server.log)
--because dbua will only apply psu sql file ,will not apply ovjm sql file, so will do it manaul.
cd %ORACLE_HOME%sqlpatch26182425
sqlplus /nolog
CONNECT sys/oracle123 AS SYSDBA
SHUTDOWN
STARTUP UPGRADE
@postinstall.sql
SHUTDOWN
STARTUP
QUIT
/
PS:
issue 1:MDSYS
PL/SQL: Statement ignored
CHECK Oracle_server.log , it can ignore
issue 2:
pls-00302 , because MDSYS delete_sdo,it can ignore
pls-00307
pls-00323
issue 3:
ora-00955 it can ignore (20 - 50 ignore)
enter
issue 4:
ora-01921 it can ignore
issue 5:
ORA-04043 object DROP_AW_ELIST_ALL does not exist
if no ogg ,it can ignore ,or If OGG is being used, then the fix for this issue is included in Patch: 22457613 and Patch:22576728 (for newer patches see Document 1557031.1).
http://blog.csdn.net/yaluo009/article/details/51836756
issue 5
回退方案
http://blog.itpub.net/26175573/viewspace-1256585/
1.Stop all oracle service
2 rollback id.
cd <OLD_ORAHOME>adminweixinprodackup
run weixinprod_restore.bat
--checklist
col comp_id for a15
col version for a15
col comp_name for a30
select comp_id,comp_name,version from dba_registry ;
select object_name,owner from dba_objects where status='INVALID';