2 Replies Latest reply: Mar 22, 2011 6:37 PM by Chen Dong RSS

ERROR => CONNECT failed with sql error '28000'

Ankita Kapoor
Currently Being Moderated

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.

Actions