Solman installation stuck with error - SLES 10 , Oracle 10.2.0.4

[Former Member]

Hi,

Solman 7.0 installation with ehp1 installation stuck with error - SLES 10 , Oracle 10.2.0.4

the error is at the step install DBA tools -> error is 'select status from v$instance did not match /^\s(\S+)\s$S/gNaNOPEN MIGRATE'.)

Just FYI : we had issue while installing Oracle , we have followed work arround 3 in the SAP Note 980426

Kindly help to proceed further

Thanks & regards,

Prabhakar Reddy.Y.C.

[Former Member]

I have same situation ,  I repatch Database . Problem is solved

[Former Member]

I have got the answer from other sources and it is always nice to be with this forum .. where people are helpful ... Thank you all who is part of this forum and let us hope to enjoy the same

Edited by: prabhakaryc on Nov 21, 2010 8:02 AM

[former_member227283]

Hi Prabhakar,

Login to sqlplus "/as sysdba" and run the command select status from v$instance

share the output of above command.

Thanks

Anil

[Former Member]

SQL> select status from v$instance;

STATUS

-

---

OPEN MIGRATE

SQL>

When i am starting in startup -> it is giving error

ORA-01092: ORACLE instance terminated. Disconnection forced

Hence i have started in upgrade -> startup upgrade

[Former Member]

sapinst.log

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-01092: ORACLE instance terminated. Disconnection forced

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.

ERROR 2010-11-21 06:55:22.502

MUT-03025 Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

.

ERROR 2010-11-21 06:55:22.533

FCO-00011 The step runSapdbaroleSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|

NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbaTools|ind|ind|ind|ind|11|0|

runSapdbaroleSql was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

.).

Edited by: prabhakaryc on Nov 21, 2010 7:01 AM

[Former Member]

Hi,

The issue is resolved ...

I have followed below steps

cd $ORACLE_HOME/rdbms/admin

sqlplus "/as sysdba"

SQL>startup upgrade;

SQL>@catupgrd.sql

SQL>shutdown immediate;

SQL>startup;

SQL>@utlrp.sql

[Former Member]

Hi,

yes that is the process need to follow after upgarde , but it should not happen as you are doing fresh installation directly on 10.2.0.4 ..

Any how its over

Regards,

[Former Member]

Hi,

Check if database is open ? if not try to open or check if any error is there.

Regards,