Installation error during Create Database Phase

[Former Member]

Dear All,

SAP 4.7E IDES , Oracle 9i ,Win 2003

I got the below error during the phase Create Database .

ving file C:/SAPinst ORACLE SAPINST/changed_init_ora_tmp.txt to: C:\oracle\ora92\database\initTST.ora.

INFO 2010-04-13 16:34:04

Removing file C:/SAPinst ORACLE SAPINST/orig_init_ora_tmp.txt.

INFO 2010-04-13 16:34:04

Creating file C:\SAPinst ORACLE SAPINST\oradim.log.

INFO 2010-04-13 16:34:04

See 'C:\oracle\ora92/bin/oradim -new -sid TST -STARTMODE auto' output in 'C:\SAPinst ORACLE SAPINST\oradim.log'.

INFO 2010-04-13 16:34:04

'C:\oracle\ora92/bin/oradim -new -sid TST -STARTMODE auto' returned with '20'.

INFO 2010-04-13 16:34:05

Changed working directory to C:\SAPinst ORACLE SAPINST.

INFO 2010-04-13 16:34:05

Changed working directory to C:\SAPinst ORACLE SAPINST.

INFO 2010-04-13 16:34:09

Changed working directory to C:\SAPinst ORACLE SAPINST.

ERROR 2010-04-13 16:34:16

CJS-00084 SQL Statement or Script failed. Error Message: ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR 2010-04-13 16:34:16

FJS-00012 Error when executing script.

INFO 2010-04-13 16:34:27

Changed working directory to C:\SAPinst ORACLE SAPINST.

INFO 2010-04-13 16:34:27

Changed working directory to C:\SAPinst ORACLE SAPINST.

INFO 2010-04-13 16:34:30

Changed working directory to C:\SAPinst ORACLE SAPINST.

ERROR 2010-04-13 16:34:37

CJS-00084 SQL Statement or Script failed. Error Message: ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR 2010-04-13 16:34:38

FJS-00012 Error when executing script.

INFO 2010-04-13 16:38:04

Changed working directory to C:\SAPinst ORACLE SAPINST.

INFO 2010-04-13 16:38:04

Changed working directory to C:\SAPinst ORACLE SAPINST.

INFO 2010-04-13 16:38:07

Changed working directory to C:\SAPinst ORACLE SAPINST.

ERROR 2010-04-13 16:38:15

CJS-00084 SQL Statement or Script failed. Error Message: ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR 2010-04-13 16:38:15

FJS-00012 Error when executing script.

Kindly suggest ...

[markus_doehr2]

> See 'C:\oracle\ora92/bin/oradim -new -sid TST -STARTMODE auto' output in 'C:\SAPinst ORACLE SAPINST\oradim.log'.

According the PATH displayed you did not install Oracle correctly with the sapserver.cmd script provided by the installation DVD but by executing setup.exe.

Markus

[Former Member]

Dear Markus

i had used sapserver.cmd script for Oracle 9i installation .

kindly suggest ...

[Former Member]

HI,

Please try to to run this command in command prompt and let us know the output

oradim -new -sid TST -STARTMODE auto

If this is working fine start the installation again.

Restart the installation process, paste some logs from alert file if still error is there.

Regards,

Gagan Deep Kaushal

[Former Member]

Hi Gagan Deep Kaushal

Kindly find the output.

C:\>cd C:\oracle\ora92\bin

C:\oracle\ora92\bin>oradim -new -sid DEV -STARTMODE auto

DIM-00020: A service for this SID is already created. Please enter a different S

ID name. No action has been taken

O/S-Error: (OS 1073) The specified service already exists.

C:\oracle\ora92\bin>

Changed working directory to C:\SAPinst ORACLE SAPINST.

ERROR 2010-04-13 16:38:15

CJS-00084 SQL Statement or Script failed. Error Message: ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR 2010-04-13 16:38:15

FJS-00012 Error when executing script.

Kindly suggest ....

[markus_doehr2]

> CJS-00084 SQL Statement or Script failed. Error Message: ORA-01092: ORACLE instance terminated. Disconnection forced

> ERROR 2010-04-13 16:38:15

Your Oracle is crashing.

Did you install the latest patches before you started sapinst for the first time? The SAP delievered version on the DVD (9.2.0.1) doesn't work and was never supported.

I also wonder why you install a version already out of support (9.2) - there are installation media sets available for Oracle 10g also.

Markus

[Former Member]

Hi,

Thanks it seems ID has been created, just check these quick fixes

1) You are installing SAP with windows administrator user.

2) check manually the user and group of windows user and add this manually to oradba related group and then retry.

Also check what is the output of sqlplus / as sysdba in your command prompt.

Regards,

Gagan Deep Kaushal

[Former Member]

Hi ,

Pls check the below information.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 571548360 bytes

Fixed Size 455368 bytes

Variable Size 226492416 bytes

Database Buffers 343932928 bytes

Redo Buffers 667648 bytes

ORA-01079: ORACLE database was not properly created, operation aborted

Kindly advise .

[Former Member]

HI ,

It seems your oracle DB is not created properly.

No way to escape , as mentioned in above post , please check with installed oracle patch .

I suggest you to restart the installation using oracle10g or any SAP certified oracle version , for which i am sure you will not receive any error.

But for now i can not see any way out if DB is crashing at this stage.

Regards,

Gagan Deep Kaushal

[former_member204746]

satheesh,

you did not read the installation guide.

you did not use SAPSERVER.CMD to isntall ORacle, you wrongly used SETUP.EXe

also, you used C:/SAPinst ORACLE SAPINST/ as your instalaltion directory.

you should use C:/SAPinstO or similar path without any spaces.

I would re-start from scratch and follow my 2 recommendations as it will also fail later in installation.