cancel
Showing results for 
Search instead for 
Did you mean: 

Installation error - NW 7.0 Ehp2 - Create database (phase 12 of 31)

joo_migueldimas
Active Participant
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

@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

joo_migueldimas
Active Participant
0 Kudos

Hello Nick Loy,

Ok... but how can I do that? Where are the pfile and spfile and init.ora files?! When I go to $ORACLE_HOME/dbs which is supposed to have them, I didn´t found them in there!!...

Thanks,

JDimas

Former Member
0 Kudos

Hi,

What files do you have in $ORACLE_HOME/dbs directory? Please do an ls -l and paste it here.

Thanks,

Salman

joo_migueldimas
Active Participant
0 Kudos

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

former_member204746
Active Contributor
0 Kudos

this means that you do not use an SPFILE. you use a PFILE.

so, simply edit file initBI1.ora and delete the unnecessary log* parameters. then ,restart your database.

Former Member
0 Kudos

Hi,

In this case, open the file initBI1.ora and perform the steps 2,3 & 5 from my first post.

Hopefully this should fix the issue.

Thanks,

Salman

joo_migueldimas
Active Participant
0 Kudos

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

Answers (7)

Answers (7)

Former Member
0 Kudos

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

ismaazir_auzir
Explorer
0 Kudos

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.

Former Member
0 Kudos

I am working on Unix platform

Thanks,

Kalyan

Former Member
0 Kudos

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

joo_migueldimas
Active Participant
0 Kudos

This issue is solved!

Former Member
0 Kudos

Hi João Dimas,

Thanks for giving the solution

we got the same error and it is resolved as per your solution

(after editing the file init.ora by comment the LOG_ARCHIVE_DEST using # sysmbol)

Regards,

Sandeep

nirmal_konchada
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

joo_migueldimas
Active Participant
0 Kudos

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

Former Member
0 Kudos

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

joo_migueldimas
Active Participant
0 Kudos

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