on 10-08-2015 6:39 PM
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.