| Oracle 9206 [message #126580] |
Tue, 05 July 2005 14:49  |
kapil2005
Messages: 44
Registered: March 2005
|
Member |
|
|
I need to help here, I was trying to upgrade Oracle 9206 from oracle 9205. so when I applying Oracle patch set 9206, I encountered the following error message
The install touches a component that is patched by interim
patches ' Interim Patch# 4003006'. The interim patches
affect other components not included in the install. Rollback
the interim patches 'Interim Patch# 4003006' using Opatch
for consistency. Contact Support to check applicability and
availability of interim patches 'Interim Patch# 4003006' for
this install
So my question is do I need to install this patch 4003006 after un-installing and upgrading to 9206?
|
|
|
|
| Re: Oracle 9206 [message #126581 is a reply to message #126580] |
Tue, 05 July 2005 14:56  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Check Metalink and support, but my guess is no based on the understanding that interim patches are just that. They come out between major patches, and each subsequent major patch includes all fixes and functionality in the interim patches leading up to the major patch. In other words, in theory, the 9.2.0.6 major patch would include already the contents of the 'Interim Patch# 4003006'.
But, don't take my word for this, and hopefully you are doing all of this in development first.
Check the metalink documentation for the interim patch in question and verify that its functionality is included in 9206. Also read up on how oracle numbers and manages patches to make sure my understanding is correct and please someone correct me if I am wrong.
In general it is easier to not apply interim patches, just major ones. The exception is when there is an important bug or functionality (to your situation/system/environment) that you can't live without in the meantime before a new major patch is released.
[Updated on: Tue, 05 July 2005 15:00] Report message to a moderator |
|
|
|
| Re: Oracle 9206 [message #126585 is a reply to message #126581] |
Tue, 05 July 2005 15:26 |
kapil2005
Messages: 44
Registered: March 2005
|
Member |
|
|
Thanks for your quick response, i would appreciate if you could help me understand this. I was reading through the deinstallation steps in readme.txt file for patch 4003006 as follows
# Patch Deinstallation Instructions:
# ----------------------------------
# Issue the following commands:
#
# % cd 4003006
#
# Run the following commands to change permissions:
#
# % chmod 755 $ORACLE_HOME/lib/libjox9.sl
# % chmod 755 $ORACLE_HOME/oracore/lib/libcore9.sl
#
# Stop the Oracle HTTP Server,if Modplsql patch is installed;
#
# % opatch rollback -id 4003006
#
# Run the following commands to reset changed permissions:
#
# % chmod 555 $ORACLE_HOME/lib/libjox9.sl
# % chmod 555 $ORACLE_HOME/oracore/lib/libcore9.sl
#
# If Modplsql patch is installed do the following steps:
# For each database against which "sysobjects" option was run;
# cd $ORACLE_HOME/Apache/modplsql/owa
# sqlplus "/nolog"
# SQL > conn sys/sys_password@conn_str as sysdba
# > alter session set current_schema=SYS;
# > @privoolk.sql
#
# Start HTTP Server.
#
# If Oracle Text is installed:
# cd $ORACLE_HOME/ctx/admin
# sqlplus "/ as sysdba"
# > alter session set current_schema=CTXSYS;
# > @dr0out.plb
#
# For rdbms:
# cd $ORACLE_HOME/rdbms/admin
# sqlplus "/ as sysdba"
# > alter session set current_schema=SYS;
# > @prvtpexp.plb
# > @dbmslmd.sql
# > @prvtxdbz.plb
#
# If Oracle Ultra Search is installed, execute
# cd $ORACLE_HOME/ultrasearch/admin
# sqlplus "/ as sysdba"
# > alter session set current_schema=WKSYS;
# > @wk0snapshot.plb
#
# For SDO;
# cd $ORACLE_HOME/md/admin
# sqlplus "/ as sysdba"
# > alter session set current_schema=MDSYS;
# > @sdopatch.sql
#
# For OLAP;
# cd $ORACLE_HOME/cwmlite/admin
# sqlplus "/ as sysdba"
# > alter session set current_schema=OLAPSYS;
# > @cwm2utl2.plb
#
# For compiling any invalid PL/SQL objects;
# cd $ORACLE_HOME/rdbms/admin
# sqlplus "/ as sysdba"
# > @utlrp.sql
#
So my question is how will i know if Modplsql patch is installed on my server?
and some in the same readme.txt file i see
# For rdbms:
# cd $ORACLE_HOME/rdbms/admin
# sqlplus "/ as sysdba"
# > alter session set current_schema=SYS;
# > @prvtpexp.plb
# > @dbmslmd.sql
# > @prvtxdbz.plb
as far as i know we only have oracle database with no other options, so do I need to follow the above instructions?
|
|
|
|
| Re: Oracle 9206 [message #126734 is a reply to message #126580] |
Wed, 06 July 2005 07:31 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I don't know.
I can guess, but this is just a guess, so don't do anyhing in production. I'd take a full backup of your system before tryihng to uninstall the interim patch. Then, if you just have a basic database, assume you don't have anything but rdbms and modplsql sections to do. So do those two sections, assuming you actually have a ORACLE_HOME/Apache/modplsql/owa directory.
Before running them take a quick glance at the scripts. Log all activity you do and check it for errors after it is finished. Then try and install 9206 and see if it works.
Basically, I don't know, so my guess would be to try it and find out, but do so in a way that you can completely recover from if needed and try again with a different approach.
The best approach is to contact support, that is what they are for.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
