opatch auto in windows db in 11.2.0.4

--prapare:

1.

確定環境變量中的PATH,jave_home.JAVA* 是正确的

確定java home 已經安裝  C:\Program Files (x86)\Java\jdk1.7.**

2.

copy 192.168.63.83 D:\oracle_patch\1612 to 192.168.2.169 D:\oracle_patch\1612

cd D:\oracle_patch\1612

D:\app\Administrator\product\11.2.0\dbhome_1\OPatch\ocm\bin\emocmrsp.bat

set ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1

set PATH=%ORACLE_HOME%\OPatch;%PATH%

mkdir db

mkdir ojvm

unzip p23530402_112040_MSWIN-x86-64.zip -d db

unzip p23515277_112040_MSWIN-x86-64.zip -d ojvm

unzip p6880880_112000_MSWIN-x86-64.zip -d %ORACLE_HOME%

lsnrctl stop listener_testprd

sqlplus / as sysdba

shutdown immediate

exit

stop all oracle services

net stop msdtc

net stop winmgmt

--apply

kill process extjob.exe

kill process omtsreco.exe

kill process TNSLSNR.EXE

kill process  /vmtoolsd.exe/oravssw.exe 

kill process tree: dllhost.exe 

(issue windows : ddl 程序active in opatch

tasklist /m > tasks.txt

notepad tasks.txt

(check hold ddl process, and kill process following pid,根據程序号kill程序，不要kill 錯了。)

)

opatch rollback -id 19799291 -ocmrf ocm.rsp

opatch rollback -id  19651773 -ocmrf ocm.rsp

opatch apply  -silent db\23530402 -ocmrf ocm.rsp

opatch apply   -silent  ojvm\23515277 -ocmrf ocm.rsp

sc config Winmgmt start= auto

net start msdtc

net start winmgmt

net start OracleServicetestPROD

set ORACLE_SID=testPROD

cd %ORACLE_HOME%\rdbms\admin

sqlplus /nolog

CONNECT / AS SYSDBA

STARTUP

@catbundle.sql PSU apply

QUIT

/

cd %ORACLE_HOME%\sqlpatch\23515277

SHUTDOWN

STARTUP UPGRADE

@postinstall.sql

net start OracleOraDb11g_home1TNSListenerLISTENER_testPROD

--regress

opatch rollback -id 23530402 -ocmrf ocm.rsp

opatch rollback -id  23515277 -ocmrf ocm.rsp

--------------

windows : ddl 程序active in opatch

Workaround 2:

 -------------------

 When a specific dll is mentioned during installation:

 On Windows XP use the utility TASKLIST to list the currently opened files.

 When using TASKLIST with option /m, it will list all active processes with their opened files.

For example:

 1. tasklist /m > tasks.txt

 2. notepad tasks.txt

 3. Search for the specified dll in tasks.txt and identify the process.

 4. Stop the involved process or service. 停下oracle 程序

notepad

don't stop username=network-service  windows service .

重新啟動主機需要15-20分鐘。

---

opatch lsinventory -bugs_fixed|grep -i 'DATABASE PSU'
=select * from dba_registry_history;


sample 2:
rollback old and apply new
      

#####BEGIN

mkdir -p c:\app\software

mkdir -p c:\app\software\psu

mkdir -p c:\app\software\ojvm

xcopy \\tsclient\D\Mike\m\0509\更新檔分析\11.2.0.4\* c:\app\software\ /D /E /Y /H /K

###

set ORACLE_HOME=c:\app\Administrator\product\11.2.0\dbhome_1

####

%ORACLE_HOME%\OPatch\ocm\bin\emocmrsp.bat

#####

cd c:\app\software\

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%\

net stop OracleServicetestUAT

net stop OracleServicetestDEV

net stop OracleOraDb11g_home1TNSListenerLISTENER_testuat

net stop OracleOraDb11g_home1TNSListenerLISTENER_testdev

opatch rollback -id 19799291 -silent

opatch rollback -id 19651773 -silent

--opatch rollback -id 25590979 -silent

--opatch rollback -id 25632525 -silent

opatch apply -silent psu\26194138 -ocmrf ocm.rsp

opatch apply -silent ojvm\26182425 -ocmrf ocm.rsp

net start OracleServicetestUAT

net start OracleServicetestDEV

set ORACLE_SID=testuat

CONNECT sys/oracle123 AS SYSDBA

cd %ORACLE_HOME%\sqlpatch\26182425

CONNECT sys/oracle123 AS SYSDBA

set ORACLE_SID=testdev

start oracle service

net start OracleOraDb11g_home1TNSListenerLISTENER_testuat

net start OracleOraDb11g_home1TNSListenerLISTENER_testdev

opatch lsinventory

SELECT * FROM dba_registry_history;  (11g or 10g)

select substr(action_time,1,30) action_time,substr(id,1,10) id,substr(action,1,10) action,substr(version,1,8) version,substr(BUNDLE_SERIES,1,6) bundle,substr(comments,1,20) comments from registry$history;  (11g)

炊煙起了；夕陽下了；細雨來了

多調試,互動式程式設計體驗

記錄，獨立思考，對比

感謝轉載作者

修車

國産化

read and connect

匍匐前進,

講故事