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

[joo_migueldimas]

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?

[Former Member · Accepted solution]

@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 · Accepted solution]

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 · Accepted solution]

Hi,

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

Thanks,

Salman

[joo_migueldimas · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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