on 02-12-2011 7:15 PM
Hello gurus,
I´m facing with an error during the installation of Netweaver 7.0 Ehp2 (AS ABAP stack) in phase 12 - Create database.
The database version is the newest 11.2.0.2
In sapinst.log it shown the following errors:
ERROR 2011-02-12 18:50:44.590
CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Disconnected
. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.
ERROR 2011-02-12 18:50:44.592
MUT-03025 Caught ESAPinstException in module call: ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Disconnected
.
ERROR 2011-02-12 18:50:44.979
FCO-00011 The step createDatabase with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|createDatabase was executed with status ERROR ( Last error reported by the step :SQL statement or script failed. DIAGNOSIS: Error message: ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Disconnected
. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.).
I also checked the ora_sql_results.log file:
================================================================================
2011-02-12, 18:50:43 SAPINST ORACLE start logging for
SHUTDOWN IMMEDIATE;
exit;
Output of SQL executing program:
SQL*Plus: Release 11.2.0.2.0 Production on Sat Feb 12 18:50:43 2011
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
Linux-x86_64 Error: 2: No such file or directory
Disconnected
SAPINST: End of output of SQL executing program /oracle/BI1/112_64/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
2011-02-12, 18:50:43 SAPINST ORACLE stop logging
================================================================================
2011-02-12, 18:50:43 SAPINST ORACLE start logging for
STARTUP NOMOUNT;
exit;
Output of SQL executing program:
SQL*Plus: Release 11.2.0.2.0 Production on Sat Feb 12 18:50:43 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Disconnected
SAPINST: End of output of SQL executing program /oracle/BI1/112_64/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
2011-02-12, 18:50:44 SAPINST ORACLE stop logging
Can you help me please.?! I think this is because some environment or maybe some service is stopped, isn´t it?
@Nirmal, Below suggestion what you suggested is not a recommended one
Just comment out LOG_ARCHIVE_DEST and make sure that LOG_ARCHIVE_DEST_1 is active in your spfile
If you want to change any DB parameter, you have to use pfile for manual edits, spfile for alter system edits.
Direct correction is not a suggestable method.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Salman,
Sorry, the files of init.ora and initSID.ora I have them in that directory... but spfile doesn´t!
The content of $ORACLE_HOME/dbs is:
rw-rw---- 1 orabi1 dba 1544 Feb 13 22:26 hc_BI1.dat
-rw-r----- 1 root sapinst 3655 Feb 12 18:09 initBI1.1.ora
-rw-r-x--- 1 root sapinst 4517 Feb 12 18:09 initBI1.2.ora
-rw-r-xr-x 1 orabi1 dba 4657 Feb 12 18:09 initBI1.ora
-rw-r--r-- 1 orabi1 dba 2851 May 15 2009 init.ora
-rw-r----- 1 orabi1 dba 2048 Feb 12 18:09 orapwBI1
Kind regards,
Joao Dimas - Portugal
Hello,
Thank you very much for your help! The problem was solved What I did was editing the init<SID>.ora, I put the # in LOG_ARCHIVE_DEST parameter (comment the parameter), and after this change, I performed a retry to installation SAPINST and it ran without any problem!
So.. thank you very much for your help, to all of you!
Best regards,
JDimas - Portugal
I put # before log_archive_dest and started the sapinst again. It didnt work and showing the same error. Can anyone help me on this issue
Thanks
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
solution can be found in note 1527078:
Symptom:
The original installation master medium offers the database server selection for Oracle 11g Release 2 (11.2), but if you use it the installation step "Create Database" will end up with an error like the following:
ERROR 2011-11-05 01:00:14.750 [iaxxinscbk.cpp:244]
CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message:
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST
Solution:
Do not use the original installation master medium as listed in the Media List for your SAP NetWeaver 7.0 EHP2 / Business Suite 7i 2010 application for Oracle 11g Release 2 (11.2) installation. Instead, you have to use the installation master medium with the material number listed in SAP Note 1478350.
I am working on Unix platform
Thanks,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
can anyone explain me step by step how to lookup files in init.ora and initSID.ora because I am new to SAP and I dont know how to look up those files. I am also having the same problem. So kindly help by explaining step by step
Thanks,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This issue is solved!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just comment out LOG_ARCHIVE_DEST and make sure that LOG_ARCHIVE_DEST_1 is active in your spfile.
Restart the DB once this is done.
Regards,
Nirmal.K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1) Move your spfile to other location
2) Edit initSID.ora file (Change the log_archive_dest* parameters)
3) Open your database using sql> startup pfile=/oracle/SID/release/bin/initSID.ora
4) Create spfile from pfile using sql> create spfile from pfile
5) Proceed with your installation
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It looks like log_archive_dest_1 & log_archive_dest or log_archive_duplex_dest parameters are set together in the spfile
You cannot have both the parameters set.
Also, from the log it looks like the database is shut down.
Reset the parameter log_archive_dest & log_archive_duplex_dest and restart the installation.
You can do the following;
1. create pfile from spfile using the commands....sqlplus "/as sysdba" ; SQL>create pfile from spfile;
2. Open the pfile in the location $ORACLE_HOME/dbs (unix) or $ORACLE_HOME/database (win) init<sid>.ora
3. delete the parameters log_archive_dest & log_archive_duplex_dest
4. create spfile from pfile - SQL> create spfile from pfile
5. Restart the installation
Thanks,
Salman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Salman,
First at all, I forgot to mentioned, I´m doing this installation on a Linux RHEL X86_64. I checked the listener service and it is started.
Tell me one thing Salman... in this stage of the installation, is not supposed to be the wizard of sapinst itself to make the start of the database? ... Look, I think at this point, there is no database, I just install the software Oracle database 11.2.0.2 and its latest SAP Bundle Patch... so what you told me was that, in addition to redefine the parameters specific oracle, do a manual start to the database through SQL Plus, isn't was? But this is not an automatically procedure by sapinst?
Other question, which services should be running at this stage of installation... the listener service and what are the others?
After the SAP Bundle Patch installation in README file it refers: "Start up all instances, listeners, and other processes associated with the Oracle Home" Which ones?
Thank you
Kind regards,
João Dimas - Portugal
Hi João Dimas,
From the logs you posted earlier, it looks sapinst tried to start the database however due to the parameter misconfiguration issue, it aborted. Now, since the database was down, I just asked you delete the parameters from the spfile and not start the database.
Your other question, since this is a fresh installation, you can ignore and continue the installation.
Thanks,
Salman
Hello Salman,
I tried to reset the LOG_ARCHIVE_DEST through SQL Plus but without success, because for that action the database must have started! When I type startup command it show the same error!
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
SQL> alter system reset log_archive_dest;
alter system reset log_archive_dest
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Any tip how can I change that parameter?
I checked the ora_sql_result.log I see the following error:
================================================================================
2011-02-12, 18:50:43 SAPINST ORACLE start logging for
SHUTDOWN IMMEDIATE;
exit;
Output of SQL executing program:
SQL*Plus: Release 11.2.0.2.0 Production on Sat Feb 12 18:50:43 2011
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
Linux-x86_64 Error: 2: No such file or directory
Disconnected
SAPINST: End of output of SQL executing program /oracle/BI1/112_64/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
2011-02-12, 18:50:43 SAPINST ORACLE stop logging
I don´t know... what´s happen
Kind regards,
João Dimas - Portugal
User | Count |
---|---|
81 | |
25 | |
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.