NW 731 Java, Oracle - sapinst hangs in Step "Create Database Schema"

[jochen_willeke]

Hello together,

I am just working on an Installation of an NW 731 Java with Oracle on SLES11 SP2 and having quite a hard time. I followed the Manual and to the best of my knowledge applied all patches. The installation hangs at the phase "Create Database Schema" and stays there for what seems like an eternity.

Here is what I do see:

- there is no more sapinstexe process, it fails shortly after the Phase "Create Database Schema" is entered

- the ora_sql_results.log from within sapinstdir shows:

@@ORA_CREATE_DBUSR.SQL
exit;
Output of SQL executing program:
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 4 18:11:12 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Connected.
old   4:   :sSchema := upper('&&1');
new   4:   :sSchema := upper('SAPSR3DB');
old   5:   :passwd := '&&2';
new   5:   :passwd := 'xxx';
old   6:   :defTablespace := upper('&&3');
new   6:   :defTablespace := upper('PSAPTEMP');

- and ora_create_dbusr.log shows:

old   4:   :sSchema := upper('&&1');
new   4:   :sSchema := upper('SAPSR3DB');
old   5:   :passwd := '&&2';
new   5:   :passwd := 'xxx';
old   6:   :defTablespace := upper('&&3');
new   6:   :defTablespace := upper('PSAPTEMP');
Enter value for 4:

Those logfiles are the last ones written in sapinstdir. When checking on the DB, user SAPSR3DB has not been created.

Has anybody ever come accross this issue or can help me where to start with further analysis?

Kind regards and thanks in advance,

Jochen

[Former Member · Accepted solution]

Hi Jochen,

Download latest SWPM from SMP and try, this issue is fixed.

Thanks & Regards,

V Srinivasan

[jochen_willeke · Accepted solution]

Thanks, but that didn't fix the issue.

Regards, Jochen

[jochen_willeke]

It seems that the SWPM was really the case, but I had to remove all Oracle and SAP stuff from the server and start a complete new installation from the scratch in order to be successfull.

Thanks a lot for all your time and helpfull advice.

Regards and a nice weekend,

Jochen

[Farid]

We had the same problem on NW 7.31/HP-UX, Giving full permission to the sapinst_instdir folder as well as it's sub folders solved the issue

[Former Member]

We had similar issue while doing sandbox installation from production export. Issue was fixed after creating SAPSR3DB user ID (taking production ID as a reference) and re-trying. Hope this helps

Thanks,

Chaitanya V

[jochen_willeke]

Hi,

here are the last logs beeing written...

- sapinst.log

INFO 2013-04-05 09:23:35.868
Creating file /WORK/SAP/CDS/tmp/dev_sap_kernel_test_05_Apr_2013_09_23_35.
INFO 2013-04-05 09:23:35.869
Removed file /WORK/SAP/CDS/tmp/dev_sap_kernel_test_05_Apr_2013_09_23_35.
INFO 2013-04-05 09:23:36.575
Real group ID set to 1007.
INFO 2013-04-05 09:23:38.212
Working directory changed to /WORK/SAP/CDS/tmp/sapinst_exe.13156.1365146612.
INFO 2013-04-05 09:23:38.214
Working directory changed to /WORK/SAP/CDS/NWJAVA73EHP01/SWPM10.
INFO 2013-04-05 09:23:38.731
Creating file /WORK/SAP/CDS/tmp/dev_sap_kernel_test_05_Apr_2013_09_23_38.
INFO 2013-04-05 09:23:38.731
Removed file /WORK/SAP/CDS/tmp/dev_sap_kernel_test_05_Apr_2013_09_23_38.
INFO 2013-04-05 09:23:39.125
Creating file /WORK/SAP/CDS/tmp/sapinst_instdir/x.
INFO 2013-04-05 09:23:39.126
Removed file /WORK/SAP/CDS/tmp/sapinst_instdir/x.
INFO 2013-04-05 09:23:39.142
Authorizations set for /WORK/SAP/CDS/tmp/sapinst_instdir.
INFO 2013-04-05 09:23:39.143
Working directory changed to /WORK/SAP/CDS/tmp/sapinst_exe.13156.1365146612.
INFO 2013-04-05 09:23:39.162
Working directory changed to /WORK/SAP/CDS/NWJAVA73EHP01/SWPM10.
INFO 2013-04-05 09:23:47.79
Authorizations set for /root/sapinstAuth.txt.
INFO 2013-04-05 09:24:00.573
Creating file /WORK/SAP/CDS/tmp/sapinst_instdir/NW731/ORA/INSTALL/NW731/ORA/STD/x.
INFO 2013-04-05 09:24:00.574
Removed file /WORK/SAP/CDS/tmp/sapinst_instdir/NW731/ORA/INSTALL/NW731/ORA/STD/x.
INFO 2013-04-05 09:24:02.983
Creating file /WORK/SAP/CDS/tmp/sapinst_instdir/x.
INFO 2013-04-05 09:24:02.984
Removed file /WORK/SAP/CDS/tmp/sapinst_instdir/x.
INFO 2013-04-05 09:24:02.989
Authorizations set for /WORK/SAP/CDS/tmp/sapinst_instdir.
INFO 2013-04-05 09:24:02.994
Removed file /WORK/SAP/CDS/tmp/sapinst_instdir/NW731/ORA/INSTALL/NW731/ORA/STD/dev_sap_kernel.
INFO 2013-04-05 09:24:02.996
Removed file /WORK/SAP/CDS/tmp/sapinst_instdir/NW731/ORA/INSTALL/NW731/ORA/STD/dev_sap_kernel.

- sapinst_dev.log (only the tail, at it is quite long and seems to be not valuable to me)

TRACE      2013-04-05 09:28:57.660 [syuxctask.cpp:886]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 13442 returned 0
TRACE      2013-04-05 09:28:57.661 [iaxohsqlx.hpp:1026]
           COraSQLScriptExec<LoggingStrategy>::executeScript()
Executable started and waited successfully. Return code = 0
TRACE      2013-04-05 09:28:57.661 [iaxohsqlx.hpp:1046]
           COraSQLScriptExec<LoggingStrategy>::executeScript()
COraSQLScriptExec<LoggingStrategy>::executeScript: Script executed successfully.
TRACE      2013-04-05 09:28:57.663
OraSqlScript3.execute: Result of SQL:
{executionWasSuccessful: true}
TRACE      2013-04-05 09:28:57.685
this.ensureMinDbStatus statusOld: OPEN
TRACE      2013-04-05 09:28:57.685
this.ensureMinDbStatus status: OPEN
TRACE      2013-04-05 09:28:57.686
NWUsers.getAccountData(SAPSIDDB)
TRACE      2013-04-05 09:28:57.687
NWUsers.haveAccountData(SAPSIDDB)
TRACE      2013-04-05 09:28:57.688
NWUsers.haveAccountData() done: true
TRACE      2013-04-05 09:28:57.689
NWUsers._readAccountData(SAPSIDDB)
TRACE      2013-04-05 09:28:57.689
NWUsers._isSystemRead(SAPSIDDB, db)
TRACE      2013-04-05 09:28:57.705
NWUsers._isSystemRead() done: false
TRACE      2013-04-05 09:28:57.705
NWUsers._readAccountData() done
TRACE      2013-04-05 09:28:57.706
NWUsers.getMasterPassword()
TRACE      2013-04-05 09:28:57.706
NWUsers.getMasterPassword() done: XXXXX (master password

- ora_sql.log

set newpage 0
set space 0
set pagesize 0
set linesize 32767
set markup HTML off
set heading off
set verify off
set feedback off
set trimspool on
set sqlprompt SQL>
set termout on
set verify off
set echo off
spool ora_query3_tmporasp60_1.res
SELECT STATUS FROM V$INSTANCE;
spool off
exit;
Executed successfully.

Nothing looks like an error to me 😕

Regards,

Jochen

[Former Member]

Hi,

This is one of the bug in some installation master's.

You have to perform the following.

1. Stop the installation.

2.If you OS is like Unix or Linux, please execute ps -ef | grep orasid and kill the oracle process that has character like @*******

3. Give full permission to the sapinst_instdir folder as well as it's sub folders.

4. start the sapinst and continue with the old option.

This should fix your issue.

Thanks and Regards,

Vimal

[jochen_willeke]

Hi,

that din't fix it either. Thanks for your help.

I'll post further logs, may someone has any idea.

Regards,

Jochen

[AtulKumarJain]

Hi,

Please provide the error log from installation dir for further analysis.

Best Regards,

Atul

[former_member185239]

Ho Jochen,

Can you please paste the logs.

With Regards

Ashutosh Chaturvedi