Netweaver 742 install - Import ABAP failing / R3load -testconnect

[former_member228212]

Hi,

I'm doing an install of Netweaver 742 (will be used as NW gateway). I'm getting an error in the DB install which is on an Oracle 12 Exadata appliance. The DBa has already installed the Oracle Home and it's failing at the "Import ABAP" step of the DB install.

The error I'm seeing is "Process call '/usr/..... /R3load -testconnect' exits with error code 2.

The R3load.exe.log file shows this:

/usr/sap/GWQ/SYS/exe/uc/linuxx86_64/R3load: START OF LOG: 20151203175705

(BLD) INFO: sccsid "@(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#7 $ SAP"

(BLD) INFO: kernel release 742 [UNICODE]

(BLD) INFO: data format 1.8

(BLD) INFO: patch number 38

(BLD) INFO: compiled on "Mar 24 2015 16:14:38"

(PRC) INFO: called "/usr/sap/GWQ/SYS/exe/uc/linuxx86_64/R3load -testconnect"

(PRC) INFO: process id 59011

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 28

/usr/sap/GWQ/SYS/exe/uc/linuxx86_64/R3load: job finished with 1 error(s)

(STAT) DATABASE times: 0.002/0.000/0.001 100.0%/0.0%/100.0% real/usr/sys.

/usr/sap/GWQ/SYS/exe/uc/linuxx86_64/R3load: END OF LOG: 20151203175705

I have downloaded & swapped in the latest 742 Kernel and retried, but I still get the same errror. The database is up.

I can't see any obvious clues from the other log files. Can anyone suggest what might be going wrong? I can't even find a good source for db_connect / DbSlErrorMsg error codes!

Thanks in advance,

Richard

[Former Member · Accepted solution]

Hi Richard,

What is the Kernel version you Using.

Most of the Problem in this Phase occurs because of kernel.

If you are not using Latest Kernel.

KIndly download latest kernel and replace it in SYS/exe directory.

and again start the Installation.

Regards

Ismail Shadman

[former_member228212 · Accepted solution]

Thanks for the replies guys.

I had tried the latest kernel, with no changes. The R3trans -d output showed it unable to connect because the correct entry couldn't be found in the secure password file. This seemed strange as it was the install that had created this file itself.

My colleague deleted the file and recreated it with:

rsecssfx put DB_CONNECT/DEFAULT_DB_USER ${dbs_ora_schema} -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <pwd>

... and this fixed the issue.

Regards,

Richard

[Former Member · Accepted solution]

Hi Richard

Good to hear that your issue was resolved and thanks for sharing the solution.

Cheers

Raj Mohan

[Former Member]

Hi Richard

Please execute R3trans -d and paste contents of R3trans.log file.

BR

Raj Mohan

[Former Member]

Hi Richard,

Putting the fact that it's a Exadata appliance to one side for the moment.

1. Have you tried to manually run the R3load -testconnect as user gwqadm ?

2. As user gwqadm, could you please check that your environment variables are set correctly (upload output and post it here).

Even though it's a bit dated, did you have a look at the following guide as a starting basis:

http://www.oracle.com/us/products/database/sap-exadata-wp-409603.pdf

Let us know.

Cheers,

Amerjit