Skip to Content
author's profile photo Former Member
Former Member

Error installing SAP ECC v6.0 SR3 IDES

Hi Guys,

I am installing sap ides on windows server 2012 with oracle 11.2.0.3 installed and I am getting the following error on oracle database creation.

An error occurred while processing option Enhancement Package 4 for SAP ERP 6.0 > SAP Application Server ABAP > Oracle > Distributed System > Database Instance( Last error reported by the step :SQL statement or script failed. DIAGNOSIS: Error message: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 977113088 bytes Fixed Size 2261080 bytes Variable Size 499126184 bytes Database Buffers 473956352 bytes Redo Buffers 1769472 bytes Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options .

SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.). You can now:

Choose Retry to repeat the current step.

Choose View Log to get more information about the error.

Stop the option and continue with it later.

Someone gave the below solution but I cannot find the line on initSID to remove:

Problem 1 - Deprecated Parameters

When you run sapinst and a database is created, it will create the initial initSID.ora profile with the parameter remote_os_authent = true. At some point in the installation, sapinst restarts Oracle, which then returns an error like

DIAGNOSIS: Error message: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

When you see this, leave the sapinst message up, but edit initSID.ora and remove the line remove_os_authent = true. Restart Oracle with "shutdown immediate" and "startup nomount" and click "retry" in sapinst. This will cause its own problems later on, so you will need to add it back and restart Oracle once the database has been created.

Be sure that there are no other "deprecated parameter" messages after you do this. Any such message will cause sapinst to stop dead in its tracks. Other deprecated parameters include "user_dump_dest" and "background_dump_dest".

Help appreciated please,

Regards

Macdonald

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2015 at 10:01 AM

    Hi Guys,

    I wonder if anyone can help guys.

    I have done further investigation:

    I have realised the issue is on mounting the database created during install, if I use sqlplus to start the instance with mounting the database the instance get started but database not mounted with error ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

    ORACLE instance started. I am using pfile for startup.

    I have managed to locate the line remove_os_authent=true and removed it from init<SAPSID>.ora. I have managed to create database and can mount from sqlplus manually with no issues. But I am still having issue on the databse creation phase as below:

    Database Instance(last error reported by the step: caught SAPinstException in Modulecell:executable sqlplus returns 1. Please find below part of the ora_sql_results.log.


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

    2015-10-08, 17:04:59 SAPINST ORACLE start logging for

    SHUTDOWN ABORT;

    exit;

    Output of SQL executing program:

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 8 17:05:00 2015

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

    ERROR:

    ORA-12560: TNS:protocol adapter error

    SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

    SAPINST: End of output of SQL executing program D:\Product\OracleBase\OracleHome/bin/sqlplus.

    SAPINST found errors.

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

    2015-10-08, 17:05:00 SAPINST ORACLE stop logging

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

    2015-10-08, 17:05:17 SAPINST ORACLE start logging for

    SHUTDOWN IMMEDIATE;

    exit;

    Output of SQL executing program:

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 8 17:05:17 2015

    Copyright (c) 1982, 2011, 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 D:\Product\OracleBase\OracleHome/bin/sqlplus.

    SAPINST found errors.

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

    2015-10-08, 17:05:18 SAPINST ORACLE stop logging

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

    2015-10-08, 17:05:18 SAPINST ORACLE start logging for

    STARTUP NOMOUNT;

    exit;

    Output of SQL executing program:

    SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 8 17:05:18 2015

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

    Connected to an idle instance.

    ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

    ORACLE instance started.

    Total System Global Area 977113088 bytes

    Fixed Size 2261080 bytes

    Variable Size 499126184 bytes

    Database Buffers 473956352 bytes

    Redo Buffers 1769472 bytes

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SAPINST: End of output of SQL executing program D:\Product\OracleBase\OracleHome/bin/sqlplus.

    SAPINST found errors.

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

    2015-10-08, 17:05:31 SAPINST ORACLE stop logging

    Any help?

    Regards,

    Macdonald

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2015 at 05:20 PM

    Hello Guys..

    I have this problem while installing SAP ECC in Phase "Create DB"

    problem attached below :-

    if anyone can help please

    Where i can find file initSID.ora and which lines will replace and how to shutdown Service and start it again ..2 DAYS without sleep zzzzzz to solve this problem


    ERROR.jpg (119.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.