on 11-26-2015 4:02 PM
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.
Hello Thanut:
Your release is very old, you should at least apply Oracle patchset. Please check note 1431800 it can help you.
Regards.
Pablo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thanut,
Login into OS with sidadm and try to start Database.
Then retry the the installation.
Regards,
V Srinivasan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Thanut ,
Please also check listener.ora file to check if oracle_home is pointing to right location.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.