cancel
Showing results for 
Search instead for 
Did you mean: 

Installation error in create database phase.

Former Member
0 Kudos

Hi Hi Experts,

I have installed SAP ECC 6.0 but I have error msg in in create database phase below.

msg in ora_sql_results.log

================================================================================

2015-11-26, 22:56:12 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.1.0 Production on พฤ. พ.ย. 26 22:56:12 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Disconnected

SAPINST: End of output of SQL executing program C:\app\Administrator\product\11.2.0\dbhome_1/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-11-26, 22:56:13 SAPINST ORACLE stop logging

================================================================================

2015-11-26, 22:56:13 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.1.0 Production on พฤ. พ.ย. 26 22:56:13 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-00401: the value for parameter compatible is not supported by this release

Disconnected

SAPINST: End of output of SQL executing program C:\app\Administrator\product\11.2.0\dbhome_1/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-11-26, 22:56:14 SAPINST ORACLE stop logging

Windows server 2008 SR2 64 bit

SAP ECC 6.0 SR3

Oracle: 11g2

------------------------------------------------------------------

Please suggest me how can I fix this issue.

Regards,

Thanut J.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello Thanut:

Your release is very old, you should at least apply Oracle patchset.  Please check note 1431800 it can help you.

Regards.

Pablo.

Former Member
0 Kudos

Hi Pablo

Thank for reply, It's test sap installation on VM and I will download IDES SAP ERP 6.0 EHP7.

Regards,

Thanut J.

0 Kudos

Hi Thanut,

Please check note 1431798, according with your error some parameters are wrong, please check too installation logs to get more details about your error.

Best regards.

Pablo.

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi all,

Thank you very much for help. I found that I had fill incorrect parameter.

After that I found error in import ABAP phase below.

Total 201 all failed. Please suggest me how can I fix this issue.

Regards,

Thanut J.

Former Member
0 Kudos

import_monitor and import_monitor.java in attached files, Thanks

Regards,

Thanut J.

former_member185031
Active Contributor
0 Kudos

Hello,

You should check these files which will have more details information about the reason of failure.

For mode details see 'VRSMODISRC.log' file.

For mode details see 'REPOSRC.log' file.

Regards,

Subhash

0 Kudos

Hi Thanut,

I have exactly the same error. My circumstances are:

w2k8 64 bit (on Amazon Web Services if it matters)

netweaver 7.3 installation

Oracle 11 Software

Oracle 12 Client

SL tools - downloaded yesterday

As sidadm I ran:

sqlplus / as sysdba

create spfile from pfile;

create pfile from pfile;

I could then find the init<SID>.ora file in the \database directory under <oracle home> and in the init<SID>.ora file was a parameter

*.compatible = 12.xxxx

I changed this using notepad - which I had to run as administrator to

*.compatible = 11.2.0.0.0


Then in sqlplus I ran


create spfile from pfile;


I could then start the database in sqlplus using


startup nomount


After this, the installation continued just fine...


I hope this is helpful, shout if you need more support.


All the best,


Ian

former_member215439
Participant
0 Kudos

Hi Thanut,

     hmm. did you just upgraded your database?

     I have encountered your error before. you need to recover and restore your pfile and spfile using database backup and brtools.

     5 - Restore and Recovery

     7 - Disaster Recovery

     If you have only recover spfile from brtools then you need to create pfile using spfile with sqlcommand

      SQL>create pfile from spfile;

then continue the installation

Regards,

James Elvin

Brindavan_M
Contributor
0 Kudos

Hi Jumriangrit,

The system requirement has not been set properly in VM. I have faced this kind of issue.

Follow the below steps.

1) stop the oracle database using force command" stop abort"

2) stop the oracle services as well.

2) got to /oracle/SID/11203/dbs/ and edit the iniSID.ora file.

3) increase the share pool size and SGA.

4) rename the  "SPFILE" to SPFILE.org.

5) go to command prompt excute " create SPFILE from pfile.

6) start the database & services

7) click retry

The installation phase should process...

Thanks,

Brindavan

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Thanut,

Login into OS with sidadm and try to start Database.

Then retry the the installation.

Regards,

V Srinivasan

JamesZ
Advisor
Advisor
0 Kudos

hi Thanut ,

Please also check listener.ora file to check if oracle_home is pointing to right location.

Best regards,
James

Former Member
0 Kudos

Hi James,

Thank for reply, Oracle home path in listener.ora is correct.

Regards,

Thanut J.

JamesZ
Advisor
Advisor
0 Kudos

Hi Thanut,

In that case, can you show me with the "lsnrctl status" result and the corresponding
listener.ora file?

Best regards,
James