Skip to Content
avatar image
Former Member

R3load -testconnect is failed at the time of abap import

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jun 23, 2010 at 03:49 PM

    Read SAP Note 400241.

    Check the synonym for SAPServiceSID

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2010 at 03:54 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2010 at 11:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 05, 2010 at 03:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 05, 2010 at 03:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2010 at 10:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded