Skip to Content
avatar image
Former Member

error after upgrade the oracle patch

HI sap gurus

I installed sap Development system ..It is success and working fine , but oracle version is 10.2.0.1 .. so i upgraded to 10.2.0.2 patch after the installation of SAP.. It got success .. But I am facing problem while stating the oracle database - i unable to start oracle... I am getting this error " ORA-01092 : Oracle instance terminated .disconnection forced "

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 18, 2010 at 04:14 PM

    you forgot to run SQL script (or DBUA) to upgrade your database to 10.2.0.2.

    read the upgrade guide of 10.2.0.2, it will tell you what scripts to run.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2010 at 01:00 PM

    Please check the oracle alert log, it is under ../oracle/SID/saptrace/background/alert_SID.log

    There should be more details on your problem, if you cannot solve it yourself, post the lines here.

    Cheers Michael

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 18, 2010 at 01:09 PM

    Did you also install the latest interim patches after you installed 10.2.0.2?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2010 at 04:48 PM

    Dear chittibabu,

    Run catproc.sql and catalog.sql as per the upgrade guide .... or best way to do it is Run DBUA Database Upgrade Asistance and then start your oracle.

    There are quite issues with Oracle 10.2.0.2 I recommend you to patch your DB to 10.2.0.4 as per the SAP Recommendation

    https://service.sap.com/sap/support/notes/871096

    https://service.sap.com/sap/support/notes/830576

    Please go through the Note.

    Regards

    Shailesh Mamidwar

    Add comment
    10|10000 characters needed characters exceeded