Skip to Content
avatar image
Former Member

ERROR => CONNECT failed with sql error '1017'

Hi,

we are getting the following error when we run r3trans -dx.It is an windows system.

Here i have attached the trans.log.

4 ETW000 r3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 30.11.2010 - 08:58:12

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Nov 30 08:58:14 2010 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 3857 0.003857

4 ETW000 [dev trc ,00000] using "E:\usr\sap\TQ1\DVEBMGS10\exe\dboraslib.dll"

4 ETW000 22 0.003879

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 9 0.003888

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 18 0.003906

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.167)

4 ETW000 143 0.004049

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 16 0.004065

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 25 0.004090

4 ETW000 [dev trc ,00000] New connection 0 created 18 0.004108

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 29 0.004137

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 16 0.004153

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 15 0.004168

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 18 0.004186

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 223 0.004409

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 6714 0.011123

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 23 0.011146

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 2397 0.013543

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPRP1's password 16 0.013559

4 ETW000 [dev trc ,00000] Connecting as /@TQ1 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 22 0.013581

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 18 0.013599

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000006E6C090 000000000032AFF0 0000000006E7E378

4 ETW000 109 0.013708

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 6894 0.020602

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.020616

4 ETW000 [dev trc ,00000] Attaching to DB Server TQ1 (con_hdl=0,svchp=0000000006E7E238,srvhp=0000000006E80608)

4 ETW000 37 0.020653

4 ETW000 [dev trc ,00000] Assigning server context 0000000006E80608 to service context 0000000006E7E238

4 ETW000 21591 0.042244

4 ETW000 [dev trc ,00000] Allocating user session handle 32 0.042276

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000006E7E238,srvhp=0000000006E80608,usrhp=000000000032B808)

4 ETW000 32 0.042308

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 34551 0.076859

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 23657 0.100516

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 13 0.100529

4 ETW000 [dev trc ,00000] Try to connect with default password 12 0.100541

4 ETW000 [dev trc ,00000] Connecting as SAPRP1/<pwd>@TQ1 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 17 0.100558

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 16 0.100574

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000006E6C090 000000000032AFF0 0000000006E7E378

4 ETW000 18 0.100592

4 ETW000 [dev trc ,00000] Assigning username to user session 000000000032B808

4 ETW000 15 0.100607

4 ETW000 [dev trc ,00000] Assigning password to user session 000000000032B808

4 ETW000 23 0.100630

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000006E7E238,srvhp=0000000006E80608,usrhp=000000000032B808)

4 ETW000 18 0.100648

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 3281 0.103929

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 19 0.103948

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 10 0.103958

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#5 @ 431]

4 ETW000 10634 0.114592

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]

4 ETW000 17 0.114609

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TQ1'"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 01, 2010 at 11:24 AM

    No offense - but did you try to use the search function here in the SDN?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • In SQlnet.ora file,SQLNET.AUTHENTICATION_SERVICES = (NTS) .Should this be changed to None?

      No, Did you read note 400241? that info is there.... also if you are working on windows read Note 50088

      Regards

      Juan

  • avatar image
    Former Member
    Dec 01, 2010 at 12:49 PM

    Hi,

    LOG BY0=>ORA-01017: invalid username/password; logon denied

    You need to change your schema users password using "brconnect"

    Try as follow:

    1. Login as ora<sid>

    2. Use below command to reset SAPRP1 users password

    # brconnect  -u system -f chpass -o SAPRP1 -p <new password>

    If it still doesn't work... just set the password as "sap" (it is default password for schema user)

    # brconnect  -u system -f chpass -o SAPRP1 -p sap

    Hope, it helps you...

    Suggestions:

    Above thing will help even if OPS$ mechanism is not set correctly...

    But it is recommended to create and set permissions for OPS$ user. Else some BRTools function will produce errors...

    Relevant notes are already suggested by others...

    Please go through it word by word...

    Regards.

    Rajesh Narkhede

    Add comment
    10|10000 characters needed characters exceeded