Error while create database phase @installation step

[Former Member]

Hi All,

We are doing SAP ERP6.0 SR3 installation on HP-UX with oracle 12c.

We are stuck on phase create database.

Getting error "An error occurred while processing option SAP Business Suite 2005 > SAP ERP 6.0 Support Release 3 > SAP Application Server ABAP > Oracle > Central System > Central System( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: Executable /oracle/BCD/121/bin/sqlplus returns 1.. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.). You can now:"

Please find "ora_sql_results.log"

2015-10-16, 17:13:19 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 16 17:13:19 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-12547: TNS:lost contact

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

SAPINST: End of output of SQL executing program /oracle/BCD/121/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-10-16, 17:13:19 SAPINST ORACLE stop logging

================================================================================

2015-10-16, 17:13:19 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 16 17:13:19 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-12547: TNS:lost contact

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

SAPINST: End of output of SQL executing program /oracle/BCD/121/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-10-16, 17:13:19 SAPINST ORACLE stop logging"

===================================================================================

We have checked Listener and tnsping both working fine.

R3trans failed with error:

*** ERROR => CONNECT failed with SQL error '12537'

ORA-12537: TNS:connection closed

-----------------------------------------------------------------------------------------------------------

Kindly let me know if any one having solution?

Thanks

Siddhesh

[Mofizur]

Hi Siddhesh,

Please check below note.This can be useful..

2173485 - Installation - SAP Systems Based on SAP NetWeaver 7.0 including EHPs on UNIX/Windows: Oracle

AIX with Oracle 12c: Install Latest SBP Immediately after Installation of Oracle DB Software

Symptom:

With Oracle 12c and AIX, the installation hangs in the "create database" phase (while executing catproc.sql) if you have not installed the latest SAP bundle patch (SBP). The "create database" step can only complete successfully when you have applied the latest Oracle SAP Bundle Patch before.

If you did not apply the latest SBP, you see errors similar to the following in the ora_sql_results.log in the installation directory :

...

   Comment created.

   BEGIN CDBView.create_cdbview(false,'SYS','DBA_COL_PENDING_STATS','CDB_COL_PENDING_STATS'); END;

   *

   ERROR at line 1:

   ORA-03113: end-of-file on communication channel

   Process ID: 19660812

   Session ID: 339 Serial number: 47150

   ERROR:

   ORA-03114: not connected to ORACLE

   ERROR:

   ORA-03114: not connected to ORACLE

   .......

Solution:

To install the SAP system with Oracle 12c, make sure that you install the latest SBP immediately after the Oracle software installation. For more information, see SAP Note 1915316.

If you did not do this and the error described above has already occurred, proceed as follows:

1) Stop the installation with Software Provisioning Manager

2) Install the latest Oracle SAP Bundle Patch as described in SAP Note 1915316

3) Restart Software Provisioning Manager from the beginning.

Thanks,

Mofizur

[Former Member]

Hi,

Sorry for replying so late....Issue was resolve by replacing binary files.

[Mofizur]

HI Siddhesh,

Glad to know that your issue has been resolved.Kindly close the thread.

Thanks,

Mofizur