Register Login

CONNECT failed with sql error '1017'

Updated May 18, 2018

How to resolve the issue with dispatcher 

Hi Team , I am facing issue with dispatcher .. below is R3trans -d log..

*** ERROR => ORA-1403 when accessing table SAPUSER 55 0.100284
4 ETW000 [ dev trc,00000] set_ocica() -> SQL code 1403 27 0.100311
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1403) 25 0.100336
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1403 201 0.100537
4 ETW000 [ dev trc,00000] ORA-01403: no data found
4 ETW000 47 0.100584
4 ETW000 [ dev trc,00000] Disconnecting from connection 0 ... 30 0.100614
4 ETW000 [ dev trc,00000] Rolling back transaction 34 0.100648
4 ETW000 [ dev trc,00000] Closing user session (con=0, svc=03B7ADC0, usr=03B8E490) 311 0.100959
4 ETW000 [ dev trc,00000] Disconnected (con=0) from ORACLE. 669 0.101628
4 ETW000 [ dev trc,00000] Info: 99=DBSL_ERR_DB, oerr=1403, try to connect with default password.
4 ETW000 63 0.101691
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls 0) ... (dbsl 720 200711, UNICODE[2])
4 ETW000 45 0.101736
4 ETW000 [ dev trc,00000] Assigning username to user session: con=0, usrhp= 03B8E490 31 0.101767
4 ETW000 [ dev trc,00000] Assigning password to user session: con=0, usrhp=03B8E490 47 0.101814
4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=03B7ADC0, srv=03B7F590, usr=03B8E490)
4 ETW000 207 0.102021
4 ETW000 [ dev trc,00000] Sat Aug 01 13:02:16 2015 10008401 10.110422
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 49 10.110471
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 194 10.110665
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 48 10.110713
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 61 10.110774
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 27 10.110801
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 24 10.110825
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 174 10.110999
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 45 10.111044
4 ETW000 [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 28 10.111072
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 76 10.111148
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 32 10.111180
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"


Comments

  • 06 Aug 2015 3:48 pm rekha

    ORA-01017 ---your sapsr3 schema got locked

    go through below

    sqlplus / as sysdba

    select username, account_status from dba_users;

    Here check the status of the user SAPSR3 is "Locked". or Not...

    if locked

    alter user SAPSR3 account unlock;

  • 06 Aug 2015 3:49 pm rekha

    try to reset the password for SAPSR3
    Try below
    login as sidadm

    sidadm>brconnect -u / -f chpass -o SAPSR3 -p PassW0rd123


×