on 05-22-2008 1:04 PM
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.
Hi,
check Note 951167 - ORA-28000: the account is locked
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.