R3load -testconnect exists with error code 2 during export preparation

[former_member233385]

Hi Basis Expert,

We are planning to do OS migration via SAP export/import method.

Here is our Source system details

OS - AIX 6.1

DB - Oracle 11.2.0.3

SAP System - SAP NW 740 SP6

Kernel details -  Kernel 741 SP 50.

When we run export prepartion via root user through SWPM it is throwing an error "R3load -testconnect exists with error code 2". The screen shot of the error is inserted below.

We have replaced the latest system copy files (R3*) & tp with the latest in the kernel directory during the uptime.

It looks like we will have to upgrade the entire kernel.

Please help us in fixing this issue.

Regards,

Anil

[former_member185239 · Accepted solution]

Hi Anil,

It is a issue with the environment variable as the root user shell is ksh and sidadm shell will be csh.

You need to set the environment variable for SAP in both the shell.

http://service.sap.com/sap/support/notes/1875902

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Anil,

Have you tried with sidadm and Is the issue resolved if yes mark the thread answered.

Regards,

Ram

[former_member233385]

Hi All,

The issue is because of the ENV.

Found SAP Note - 1875902 - R3load -testconnect fails during system export

@Sriram - Could you please let me know why export needs to be run from sidadm and not root user.

In past i have ran export via root user and not sidadm.

Regards,

Anil

[Sriram2009]

Hi Anil

Thanks for your information,

BR

[Former Member]

Hi anil,

You can run either ways, Sriam has recommended it to use sidadm as the environment variables are already in palce and you dont have to change anything. But as per SWPM guide we have to use root and then set all environment variables and for see some issue associated with those.

So normal recommendation is to use SIDadm and get the export done.

Also request to mark the thread answered if the issue has been resolved.

Regards,

Ram

[Former Member]

Hello Anil,

1. You have to start SWPM as "root".

"su - sidadm -c" will be performed during various steps.

2. If you decide to select the option "Start MIGMON Manually" in the SWPM dialog screen then you have to start MIGMON as "<sid>adm"

3. As part of my "pre flight" checks I always:

Use the latest MIGMON package

Use the latest R3load and dbsl.

Test R3load -testconnect before starting SWPM with both the default shell (which may not be csh depending on your environment) and also the csh.

I hope the above clears things up for you.

Kindest Regards,

Amerjit

[Sriram2009]

Hi Anil

You have to start the export using SIDADM  user id (not on root).

BR

SS

[former_member185954]

Well spotted.

[former_member185954]

Hello Anil,

Have you looked at the export logs, does it tell you anything else besides using the latest version of executables.

Regards,

Siddhesh.

[former_member182657]

Hi,

Could you share complete R3load.exe.log file ?

Thanks,

[Former Member]

Hi anil,

While using Root user have you set the dbms_type, Dbs_schema & LD_LIBRARY Path for the root user.

If not  then try  to set it and try it again. Also check while switching from root to your <SID>adm user your not seeing any issues.

Let us know the status.

regards,

Ram