installing SRM 7.01 oracle 10.2.0.4

[nicola_blasi]

Hello

I have a problem during this installation in a Solaris environment.

I started the sapinst and after it asked me for installing oracle , i did it with patches and bugfix (10.2.0.4).

After this i restarted the sapinst and i have an error in ora_sql_results :

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 11 15:55:51 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4714397696 bytes

Fixed Size 2145200 bytes

Variable Size 2379138128 bytes

Database Buffers 2332033024 bytes

Redo Buffers 1081344 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

The phase of sapinst is "create database" it stops immediately trying open db.

If i try with startup upgrade it works but the sapinst wants the startup only.

from alert i have:

Successful open of redo thread 1

Wed May 11 17:48:16 2011

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Wed May 11 17:48:16 2011

SMON: enabling cache recovery

Wed May 11 17:48:16 2011

Errors in file /oracle/DQM/saptrace/usertrace/dqm_ora_7601.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Wed May 11 17:48:16 2011

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 7601

ORA-1092 signalled during: alter database open...

Any ideas how to resolve this strange problem please?

Thanks

Nickk

[former_member204746]

read the 10.2.0.4 upgrade carefully, you must run a few SQL scripts (or run DBUA) to convert your database to 10.2.0.4.

or... you already have a database installed on that computer and it tries to use it.

[nicola_blasi]

Hy Eric

thanks for your answer.

This a first installation of a SRM . I've installed a new oracle 10.2.0 and the patch 10.2.0.5. There were no data before of previous database version.

I've done all post activity...anyway it stopped at the beginning of phase 'create database' .

Thanks

Nick

[Former Member]

Hi,

In /oracle/<SID>/102_64/rdbms/admin

you will get catpupgrd.sql script .. Please run that and logout and login back.

The system will be fine.

Thanks,

Deepthi

[nicola_blasi]

Hello

i solved the issue but , i think, there is some problem in sapinst .

During the 'create database' after first installation oracle through the package sap of SRM it tries to open the db in "startup".

It goes in error 1092.

looking for notes i've found a solution to start the catalog and catproc opening the db in startup upgrade. After this i could open the db in startup normal and continuing the installation.

I've seen from the log that installation after opening the db it starts catproc and catalog again. So i think there is some problems in the procedure of sapinst. i mean , i think the sapinst should open db first time in upgrade mode and then should starts the sql catalog and catproc.

What do you think

Thanks anyway for any helps.

Nick

[former_member204746]

this is strange, when you "create database", it does not need to go in upgrade mode. it usually creates the DB with the same version as your executables.

maybe you could have tried with latest SAPINST becasue this behavior is not normal.

[Former Member]

You are right about SAPINST having issues. I had this error a week back using the latest SWPM, thanks for your solution, it works great