ORA-01092: ORACLE instance terminated. Disconnection forced

[former_member184114]

Hi,

I m trying to install NW2004s SR2 on windows. In step 13th, I am getting the followng error

ORA-01092: ORACLE instance terminated. Disconnection forced

can any body help me?

Regards,

Faisal

[former_member184114]

Thanks all alot for your efforts. However, I have solved it by myself. However, I have given points.

SOLUTION: I have UnInstalled Oracle and re-Installed it. There after applied patch. Then run a fresh NW installation. It got through.

Regards,

FAisal

[Former Member]

Hmm, 10G and patch 1, this not supported for SAP, you need to patch to 10.2.0.2 at minimum. Also minimum SWAP are 20 GB (recomended 20 GB + 1*RAM). Regards.

[Former Member]

Hi Faisal,

Put last few lines of sapinst.log here.

Regards

Ashok

[Former Member]

Kindly look at the database alert.log in /saptrace/background to analyze.

or

Just check the patchset note for any needed post installation

tasks.

I think installing the patch set would help.

[former_member184114]

Hi,

I have installed Oracle and its patch there after. Which patch you are talking about?

Regards,

Faisal

[Former Member]

You can provide more information, or you think we can guess ?

Oracle version are ? Patch version are? The SWAP space are? Are you check alert_SID.log file for oracle ? Regards.

[former_member184114]

Hi,

Its oracle 10g, patch 1 and the swap space is 3GB.

Please tell me if you need any more infor.

Regards,

Faisal

[Former Member]

Hi Faisal

As per SAP Note 636475 - Secondary Oracle error codes, the error code you're getting is secondary and can be ignored.

Solution

Example, In the case of the ORA-01092 error, you must find a preceding ORA-01091 or less than that.

Please let us know the preceding ORA error. Anything that came before or after ORA-01092. Check in the alert log file.

Regards

Kaleem

[Former Member]

Hi,

Try DB start with UPGRADE option which

is needed for running any post install scripts.

See if it solves the problem.

Regards,

Kaushik

[former_member190272]

Its oracle 10g, patch 1 and the swap space is 3GB.

Hi ,

increase your swap space 3* RAM.

Regards,

Pankaj Kumar

[Former Member]

This solution worked for me, when installing SAP EHP4 in Linus SuSE SLES 11 SP2.

I did the following steps:

1. Started GONOME terminal and entered the commands:

> su orasob

> cd $ORACLE_HOME/rdbms/admin

> sqlplus / as sysdba

SQL> startup upgrade