error after upgrade the oracle patch

[Former Member]

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 "

[former_member204746 · Accepted solution]

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.

[Former Member · Accepted solution]

Hi ERic ,

Thank a lot .. i performed the DBUA .. the problem is rectified ..

[Former Member]

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

[markus_doehr2]

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

Markus

[Former Member]

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