ERROR => CONNECT failed with sql error '28000'

[Former Member]

Hello,

I have restored Backup of DEV server on a new system with SID = PRD.

Now after offline backup restore on target. database is started from SQL prompt but STARTSAP is failing where Error details are :

PLEASE HELP .................

********

isrdserver:prdadm 4> R3trans -x

This is R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

unicode enabled version

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

R3trans finished (0012).

************

TRANS.LOG is ***********************************************

isrdserver:prdadm 6> more tarns.log

tarns.log: A file or directory in the path name does not exist.

isrdserver:prdadm 7> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 22.05.2008 - 17:30:48

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Thu May 22 17:30:48 2008 67 0.000067

4 ETW000 [dev trc ,00000] db_con_init called 19 0.000086

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.o' ...

4 ETW000 47 0.000169

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000 6978 0.007147

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.o' loaded

4 ETW000 31 0.007178

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 34 0.007212

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.107)

4 ETW000 172 0.007384

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 34 0.007418

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 57 0.007475

4 ETW000 [dev trc ,00000] New connection 0 created 24 0.007499

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

55, con_opt = 255, occ = NO

4 ETW000 39 0.007538

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

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

4 ETW000 31 0.007605

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

5, con_opt = 255, occ = NO

4 ETW000 37 0.007642

4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/PRD/SYS/exe/run:/oracle/client/10x_64/instantclient from environment

4 ETW000 332 0.007974

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 70 0.008044

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1758 0.009823

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 25 0.009848

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

4 ETW000 32 0.009880

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

4 ETW000 36 0.009916

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f97820 0x110fafc98 0x110faf548

4 ETW000 45 0.009961

trans.log (50%)

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f97820 0x110fafc98 0x110faf548

4 ETW000 45 0.009961

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

4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.010010

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x110fb2e38,srvhp=0x110fb3058)

4 ETW000 70 0.010080

4 ETW000 [dev trc ,00000] Assigning server context 0x110fb3058 to service context 0x110fb2e38

4 ETW000 50122 0.060202

4 ETW000 [dev trc ,00000] Allocating user session handle 31 0.060233

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110fb2e38,srvhp=0x110fb3058,usrhp=0x110f9f600)

4 ETW000 41 0.060274

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

4 ETW000 8383 0.068657

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

4 ETW000 34 0.068691

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

4 ETW000 [dev trc ,00000] Try to connect with default password 54 0.068765

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

4 ETW000 34 0.068799

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

4 ETW000 36 0.068835

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f97820 0x110fafc98 0x110faf548

4 ETW000 35 0.068870

4 ETW000 [dev trc ,00000] Assigning username to user session 0x110f9f600 23 0.068893

4 ETW000 [dev trc ,00000] Assigning password to user session 0x110f9f600 24 0.068917

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110fb2e38,srvhp=0x110fb3058,usrhp=0x110f9f600)

4 ETW000 35 0.068952

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

4 ETW000 1555 0.070507

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x110fb3058)

4 ETW000 31 0.070538

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x110fb2e38,srvhp=0x110fb3058)

4 ETW000 33 0.070571

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x110fb3058 133 0.070704

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

4 ETW000 36 0.070740

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 28000 19 0.070759

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

4 ETW000 99 0.070858

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#3 @ 431]

4 ETW000 31 0.070889

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

************************

Regards,

Ankita.

[Former Member]

Hi,

check Note 951167 - ORA-28000: the account is locked

regards,

kaushal

[Former Member]

alter user SAPSR3 account unlock;