Was applying PSU April 2012 on a
11.2.0.3 server recently, so that's 11.2.0.3.2 patch on a Linux x86_64bit
server running 11.2.0.3.1.
Didn't realize there wasn't enough space on Oracle
home file system, ran the opatch prereq check as below;
opatch prereq CheckConflictAgainstOHWithDetail -ph ./ came back OK,
succeeded with the below message.
Prereq "checkConflictAgainstOHWithDetail" passed.
Then went on to apply the patch using opatch apply, it failed due to
disk space errors after running for a few min's.
Stack Description: java.lang.RuntimeException: /usr/bin/ar: /.../.../.../...//lib/libgeneric11.a:
No space left on device
Oops...released some space and then tried to rerun opatch again...
This time around it failed to apply a few archives as below
Archive not applied /.../.../.../.../13696216/13696216/files/lib/libserver11.a/ksfd.o
to /u00/app/oracle/product/11.2.0/dbhome_1/lib/libserver11.a... ''
Archive not applied /.../.../.../.../13696216/13696216/files/rdbms/lib/libperfsrv11.a/qcodfdef_PERF.o
to /u00/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/libperfsrv11.a... ''
Archive not applied /.../.../.../.../13696216/13696216/files/lib/libordsdo11.a/mdopp.o
to /u00/app/oracle/product/11.2.0/dbhome_1/lib/libordsdo11.a... ''
Not looking good, then it finally ended with similar messages as
below...
OUI-67124:ApplySession failed
in system modification phase... 'Verification of patch failed: Error reading
files to verify "/.../13696216/13696216/files/lib/libordsdo11.a/mdopp.o"
== "/.../.../.../.../.patch_storage/verify/archive/lib/libordsdo11.a/mdopp.o". Can't verify.'
[Jun 28, 2012 7:21:33 PM] 3)
OUI-67124:
NApply restored the home. Please check your ORACLE_HOME to make sure:
-
files are restored properly.
-
binaries are re-linked correctly.
(use
restore.[sh,bat] and make.txt (Unix only) as a reference. They are located
under
"/.../.../.../...//.patch_storage/NApply/2012-06-28_19-17-23PM"
Then tried to use the restore.sh as suggested, that didn’t work
either. This is a worry now as the patch status is in a state of limbo.
Finally, restored those ../rdbms/lib/libserver11.a etc (4 in
total) files from the backup, ran the opatch again and it succeeded.
Challenge is not over yet, tried to bring up the database for running
the post psu sql scripts and now it fails with the below errors....
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size
2228784 bytes
Variable Size
402656720 bytes
Database Buffers
1191182336 bytes
Redo Buffers
7344128 bytes
ORA-00201: control file version 11.2.0.0.0 incompatible with
ORACLE version
10.2.0.3.0
ORA-00202: control file: '/.../.../.../control01.ctl'
This test env was upgraded recently to 11g and the compatible was
still at 10.2.0.3.
So did a shutdown abort, removed the compatible entry from the
pfile and restarted the instance, everything looks OK finally.
This db had PSU 11.2.0.3.1 applied at the time of 11g
upgrade and worked OK so it seems 11.2.0.3.2 doesn’t work with compatible at
10.2.0.3, which is another finding from this exercise.
This will be an issue if you’ve just upgraded to 11.2.0.3 from 10.2
and tried to apply this PSU with keeping the compatible at 10.2 for having that
ability to downgrade.
I think Oracle should also include some space checks into the prereq
section as that will save a lot of time if you happen to have a nearly full
Oracle home directory and do not realise it before running opatch.
