R3load -testconnect is failed at the time of abap import

[Former Member]

Dear All,

IMPORT ABAP is failed with the following below error R3load is failed with the test connection

system specifications:

ECC6.0, Oracle, Windows x64

D:\>R3load -testconnect

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3load: START OF LOG: 20100623171746

R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

R3load -testconnect

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1017

DbSl Trace: CONNECT failed with sql error '1017'

(DB) ERROR: db_connect rc = 256

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1017

Table SAPUSER is actually presented in the ops$sidadm, i have changed the password to default sap also

but still there is no use.

Could you please guide me , how to rectify this error

Thanks and Regards

Purna

[Former Member]

With the help of Note 400241-Problems with ops$ or sapr3 connect to Oracle i have solved my problem.

I had run the command "alter user sapsr3 identified by sap;" and just retry abap import had started.

Thanks

[former_member256254]

Hi,

After reading your error again, there is an oracle message ORA-01017, which means:

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Change both your DB & SAP password using brtools:

8. Additional Functions

3. Change password

<removed_by_moderator>

Edited by: Juan Reyes on Jul 6, 2010 12:08 PM

[former_member256254]

Try run R3trans -dw using <SID>adm.

If return code not 0000 which means OK, read trans.log to see what is the real problem.

Hope it helps.

[Former Member]

I am also getting the same error. I have checked listener is running and database is also up.

yes , this is fresh installation. But I am trying on lunix x86_64 and database oracle 10.2.0.4.0

Edited by: Jayant Kr. Sharma on Jul 5, 2010 1:50 PM

[Former Member]

HI,

Is this a fresh installation or system copy , also which password you have changed .

Just make sure that database and listener is up and running.

Additionaly you can check tnsping SID.

Regards,

[JPReyes]

Read SAP Note 400241.

Check the synonym for SAPServiceSID

Regards

Juan