Skip to Content

Post installation stpes after upgrading the patch


i am following the guide Oracle Upgrade 10g Release 2 on UNIX, and i have upgraded the Oracle patch from to after the SAP installation. But i am not sure about the post installation steps which i need to perform, becuase this guide describe the database upgrade from 9i to 10g, but i was already in 10g so i am not sure what exaclty i need to follow. Could you please suggest me.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 06:40 AM

    Hi Subhash,

    till what point you have done now ?

    Like if you are just finished with @?/rdbms/admin/catupgrd.sql, then

    1. do startup, and SQL> @?/rdbms/admin/utlrp.sql

    2. SQL>select count(*) from dba_objects where status<>u2019VALIDu2019; should show invalid objects as zero

    3. Run the sql u201Cselect * from dba_scheduler_jobs;u201D

    If ORA-01882 occurs then you have to run fix1882.sql supplied with the CPU patch

    4. SQL> SELECT count(1) FROM dba_objects WHERE status = 'INVALID'

    5. do shudown immediate and then startup

    6. Now to disable some of the dba_scheduler jobs:

    SQL> select owner, job_name, enabled from dba_scheduler_jobs;


    SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');

    SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');

    SQL>exec dbms_scheduler.disable('SYS.AUTO_SPACE_ADVISOR_JOB');

    Then Check the current version of the Oracle time zone definitions

    SQL> SELECT version FROM v$timezone_file;

    If doesn't return the value 4, then Information about 'Daylight Saving Time' (DST) is available in the patch set README, in SAP Note 1019133, or in the MetaLink Notes 553812.1 or 412160.1

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      and then you should apply all the interim patches like MOPatch, OPatch, CPUJan2009 or CPUApr2009

      1027012 u2013 MOPatch, version 19

      839182 u2013 Oracle Database 10g: OPatch, version 57

      1137346 u2013 Oracle Database 10g: Patches for Release, version 55

      1233304 u2013 CPU patches version 5

      and should not forget the recompilation. Check whether view recompilation has already been performed for the database, execute the following statement

      SQL>SELECT * FROM registry$history where ID = '6452863';

      If the view recompilation has been performed, this statement returns one or more rows.

      If the view recompilation has not been performed, this statement returns no rows

      If need to do recompilation, then you have to run recompile_precheck script and then recompilation script included with cpu patch

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 04:58 AM

    HI Subhash,

    See README file which is available in PatchSet if You in Windows .For Unix flavour see userGuide in

    Patch.For CPU set is required.

    If you have any confusion then write



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.