DB not start up Return code 012

[manoj_nayak2]

Hi ,

Listener started but DB not starting. Below is trans.log

4 ETW000 R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 13.01.2011 - 13:24:52

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] Thu Jan 13 13:24:52 2011 771 0.000771

4 ETW000 [dev trc ,00000] db_con_init called 78 0.000849

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/TST/SYS/exe/run/dboraslib.so' ... 46 0.000946

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/TST/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 308097 0.309043

4 ETW000 [dev trc ,00000] Library '/usr/sap/TST/SYS/exe/run/dboraslib.so' loaded 34 0.309077

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

4 ETW000 47 0.309124

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

4 ETW000 1608 0.310732

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

4 ETW000 35 0.310767

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

4 ETW000 51 0.310818

4 ETW000 [dev trc ,00000] New connection 0 created 32 0.310850

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 54 0.310904

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

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

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 54 0.311007

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0' 10620 0.321627

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 74 0.321701

4 ETW000 [dev trc ,00000] application info callback registered 25 0.321726

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 209372 0.531098

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 5323 0.536421

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 45 0.536466

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 49 0.536515

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

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

4 ETW000 37 0.536582

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

4 ETW000 41 0.536623

4 ETW000 [dev trc ,00000] 0 UTF8 0x10a7f350 0x10a86df0 0x10a976f8

4 ETW000 36 0.536659

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

4 ETW000 [dev trc ,00000] Allocating server context handle 119 0.559653

4 ETW000 [dev trc ,00000] Attaching to DB Server TST (con_hdl=0,svchp=0x10a97628,srvhp=0x10a9ab98)

4 ETW000 92 0.559745

4 ETW000 [dev trc ,00000] Thu Jan 13 13:24:53 2011 836423 1.396168

4 ETW000 [dev trc ,00000] Assigning server context 0x10a9ab98 to service context 0x10a97628 118 1.396286

4 ETW000 [dev trc ,00000] Allocating user session handle 4074 1.400360

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x10a97628, srvhp=0x10a9ab98, usrhp=0x10ada450)

4 ETW000 65 1.400425

4 ETW000 [dev trc ,00000] Thu Jan 13 13:24:54 2011 823487 2.223912

4 ETW000 [dev trc ,00000] Assigning user session 0x10ada450 to service context 0x10a97628 123 2.224035

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=52, stmth_p=0x10aa4748) 77 2.224112

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;

4 ETW000 41 2.224153

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l=600, con_hdl=0, stmth_p=0x10aa4748, vp=0x2b54837db3c0,ip=0x2b54835d8960,rlp=(nil),rcp=(nil))

4 ETW000 148 2.224301

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_STR, l=600, con_hdl=0, stmth_p=0x10aa4748, vp=0x2b54837db620,ip=0x2b54835d8962,rlp=(nil),rcp=(nil))

4 ETW000 83 2.224384

4 ETW000 [dev trc ,00000] CbApplInfoGet() failed (ignored 1). 35 2.224419

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=0x10aa57a0) 25 2.224444

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4 ETW000 35 2.224479

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l= 40, con_hdl=0, stmth_p=0x10aa57a0, vp=0x2b54835d8980,ip=(nil),rlp=(nil),rcp=(nil))

4 ETW000 62 2.224541

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x10aa57a0) 148343 2.372884

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 167 2.373051

4 ETW000 [dev trc ,00000] Connected to session 70. 82776 2.455827

4 ETW000 [dev trc ,00000] Now '/@TST' is connected: con_hdl=0, nls_hdl=0, session_id=70. 50 2.455877

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x10aa57a0) 44 2.455921

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 40 2.455961

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x10aa57a0) 566 2.456527

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0,:A1)

4 ETW000 46 2.456573

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l=256, con_hdl=0, stmth_p=0x10aa57a0, vp=0x2b5483831596,ip=(nil),rlp=(nil),rcp=(nil))

4 ETW000 81 2.456654

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_STR, l=256, con_hdl=0, stmth_p=0x10aa57a0, vp=0x7fff3e71fed0,ip=(nil),rlp=(nil),rcp=(nil))

4 ETW000 54 2.456708

4 ETW000 [dev trc ,00000] Got SAPSR3's password from OPS$-user 344228 2.800936

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 57 2.800993

4 ETW000 [dev trc ,00000] Rolling back transaction ... 951167 34 2.801027

4 ETW000 [dev trc ,00000] Thu Jan 13 13:24:55 2011 34053 2.835080

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x10a97628,usrhp=0x10ada450) 43 2.835123

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 257656 3.092779

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

4 ETW000 66 3.092845

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

4 ETW000 47 3.092892

4 ETW000 [dev trc ,00000] 0 UTF8 0x10a7f350 0x10a86df0 0x10a976f8

4 ETW000 37 3.092929

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x10ada450 26 3.092955

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x10ada450 55 3.093010

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x10a97628, srvhp=0x10a9ab98, usrhp=0x10ada450)

4 ETW000 20261 3.113271

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 97717 3.210988

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 28000: 174 3.211162

4 ETW000 [dev trc ,00000] ORA-28000: the account is locked

4 ETW000 66 3.211228

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

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

4 ETW000 35 3.211290

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x10a9ab98 from con_hdl=0 253 3.211543

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 28000 28 3.211617

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=28000) 27 3.211644

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 28000 97 3.211741

4 ETW000 [dev trc ,00000] ORA-28000: the account is locked

4 ETW000 37 3.211778

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 28000 performing CON [dblink#8 @ 433] 75268 3.287046

4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-28000: the account is locked [dblink#8 @ 433] 126 3.287172

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

Regards

[audunlea_hansen · Accepted solution]

Try as follow:

sqlplus "/ as sysdba" (log on as user sys in the database)

alter user SAPSR3 account unlock;

retry again as <SID>adm: R3trans -d -v

Regards

Audun

[manoj_nayak2 · Accepted solution]

hi,

I executed alter user SAPSR3 account unlock;

retried again as <SID>adm: R3trans -d -v

4 ETW000 [dev trc ,00000] bind_type_and_length(): 1 input variables given 24 0.174955

4 ETW000 [dev trc ,00000] bind_type_and_length(): 21 output variables given 26 0.174981

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 536 0.175517

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 32 0.175549

4 ETW000 [dev trc ,00000] In 00: DBSL_DATA_CHAR (len=60, max=60, dec=0) 42 0.175591

4 ETW000 [dev trc ,00000] Out 00: DBSL_DATA_CHAR (len=60, max=60, dec=0) 32 0.175623

4 ETW000 [dev trc ,00000] Out 01: DBSL_DATA_INTEGER_2 (len=2, max=2, dec=0) 25 0.175648

4 ETW000 [dev trc ,00000] Out 02: DBSL_DATA_INTEGER_4 (len=4, max=4, dec=0) 24 0.175672

4 ETW000 [dev trc ,00000] Out 03: DBSL_DATA_RAW (len=32768, max=32768, dec=0) 25 0.175697

4 ETW000 [dev trc ,00000] bind_type_and_length(): 1 input variables given 23 0.175720

4 ETW000 [dev trc ,00000] bind_type_and_length(): 4 output variables given 25 0.175745

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 391 0.176136

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 31 0.176167

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=79, stmth_p=0x48efdc8) 136 0.176303

4 ETW000 [dev trc ,00000] INSERT INTO "PATCHHIST" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 )

4 ETW000 39 0.176342

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 395 0.176737

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 29 0.176766

4 ETW000 [dev trc ,00000] In 00: DBSL_DATA_CHAR (len=40, max=40, dec=0) 45 0.176811

4 ETW000 [dev trc ,00000] In 01: DBSL_DATA_CHAR (len=20, max=20, dec=0) 26 0.176837

4 ETW000 [dev trc ,00000] In 02: DBSL_DATA_CHAR (len=44, max=44, dec=0) 24 0.176861

4 ETW000 [dev trc ,00000] In 03: DBSL_DATA_CHAR (len=20, max=20, dec=0) 24 0.176885

4 ETW000 [dev trc ,00000] In 04: DBSL_DATA_CHAR (len=6, max=6, dec=0) 24 0.176909

4 ETW000 [dev trc ,00000] In 05: DBSL_DATA_CHAR (len=28, max=28, dec=0) 24 0.176933

4 ETW000 [dev trc ,00000] In 06: DBSL_DATA_NUMC (len=20, max=20, dec=0) 24 0.176957

4 ETW000 [dev trc ,00000] In 07: DBSL_DATA_NUMC (len=20, max=20, dec=0) 23 0.176980

4 ETW000 [dev trc ,00000] bind_type_and_length(): 8 input variables given 23 0.177003

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_AFC, l= 40, con_hdl=0, stmth_p=0x48efdc8, vp=0x48ba300,ip=0x48b7fa0,rlp=0x48b9150,rcp=(nil))

4 ETW000 44 0.177047

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_AFC, l= 20, con_hdl=0, stmth_p=0x48efdc8, vp=0x48bcf38,ip=0x48b81d6,rlp=0x48b9386,rcp=(nil))

4 ETW000 54 0.177101

4 ETW000 [dev trc ,00000] - oci_bind ( 2: SQLT_AFC, l= 44, con_hdl=0, stmth_p=0x48efdc8, vp=0x48be554,ip=0x48b840c,rlp=0x48b95bc,rcp=(nil))

4 ETW000 46 0.177147

4 ETW000 [dev trc ,00000] - oci_bind ( 3: SQLT_AFC, l= 20, con_hdl=0, stmth_p=0x48efdc8, vp=0x48c15f8,ip=0x48b8642,rlp=0x48b97f2,rcp=(nil))

4 ETW000 46 0.177193

4 ETW000 [dev trc ,00000] - oci_bind ( 4: SQLT_AFC, l= 6, con_hdl=0, stmth_p=0x48efdc8, vp=0x48c2c14,ip=0x48b8878,rlp=0x48b9a28,rcp=(nil))

4 ETW000 45 0.177238

4 ETW000 [dev trc ,00000] - oci_bind ( 5: SQLT_AFC, l= 28, con_hdl=0, stmth_p=0x48efdc8, vp=0x48c32b6,ip=0x48b8aae,rlp=0x48b9c5e,rcp=(nil))

4 ETW000 46 0.177284

4 ETW000 [dev trc ,00000] - oci_bind ( 6: SQLT_AFC, l= 20, con_hdl=0, stmth_p=0x48efdc8, vp=0x48c51aa,ip=0x48b8ce4,rlp=0x48b9e94,rcp=(nil))

4 ETW000 46 0.177330

4 ETW000 [dev trc ,00000] - oci_bind ( 7: SQLT_AFC, l= 20, con_hdl=0, stmth_p=0x48efdc8, vp=0x48c67c6,ip=0x48b8f1a,rlp=0x48ba0ca,rcp=(nil))

4 ETW000 45 0.177375

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 1007 0.178382

4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000 72 0.178454

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=304, stmth_p=0x48ef768) 71 0.178525

4 ETW000 [dev trc ,00000] SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM PATCHHIST WHERE EXECUTABLE = 'R3

4 ETW000 62 0.178587

4 ETW000 [dev trc ,00000] trans' AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM PATCHHIST WHERE EXECUTABLE = 'R3trans' AND SAPRELEASE = '700' AND HOSTN

4 ETW000 40 0.178627

4 ETW000 [dev trc ,00000] AME = 'testbox' AND PLATFORM = 'Linux' AND DBVENDOR = 'ORA')

4 ETW000 34 0.178661

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 405 0.179066

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 29 0.179095

4 ETW000 [dev trc ,00000] bind_type_and_length(): 0 input variables given 47 0.179142

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=0,#output=8) 30 0.179172

4 ETW000 [dev trc ,00000] bind_type_and_length(): 8 output variables given 30 0.179202

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 482 0.179684

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 28 0.179712

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=0) 30 0.179742

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1433}

4 ETW000 36 0.179778

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=156, stmth_p=0x48f6800) 103 0.179881

4 ETW000 [dev trc ,00000] DELETE FROM "PATCHHIST" WHERE "EXECUTABLE" = :A0 AND "SAPRELEASE" = :A1 AND "HOSTNAME" = :A2 AND "PLATFORM" = :A3 AND "DBV

4 ETW000 38 0.179919

4 ETW000 [dev trc ,00000] ENDOR" = :A4 AND "TIMESTAMP" = :A5

4 ETW000 34 0.179953

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 359 0.180312

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 29 0.180341

4 ETW000 [dev trc ,00000] In 00: DBSL_DATA_CHAR (len=40, max=40, dec=0) 42 0.180383

4 ETW000 [dev trc ,00000] In 01: DBSL_DATA_CHAR (len=20, max=20, dec=0) 26 0.180409

4 ETW000 [dev trc ,00000] In 02: DBSL_DATA_CHAR (len=44, max=44, dec=0) 24 0.180433

4 ETW000 [dev trc ,00000] In 03: DBSL_DATA_CHAR (len=20, max=20, dec=0) 24 0.180457

4 ETW000 [dev trc ,00000] In 04: DBSL_DATA_CHAR (len=6, max=6, dec=0) 24 0.180481

4 ETW000 [dev trc ,00000] In 05: DBSL_DATA_CHAR (len=28, max=28, dec=0) 24 0.180505

4 ETW000 [dev trc ,00000] bind_type_and_length(): 6 input variables given 23 0.180528

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_AFC, l= 40, con_hdl=0, stmth_p=0x48f6800, vp=0x48ba118,ip=0x48b7fa0,rlp=0x48b905c,rcp=(nil))

4 ETW000 47 0.180575

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_AFC, l= 20, con_hdl=0, stmth_p=0x48f6800, vp=0x48bd8e0,ip=0x48b826a,rlp=0x48b9326,rcp=(nil))

4 ETW000 81 0.180656

4 ETW000 [dev trc ,00000] - oci_bind ( 2: SQLT_AFC, l= 44, con_hdl=0, stmth_p=0x48f6800, vp=0x48bf4c4,ip=0x48b8534,rlp=0x48b95f0,rcp=(nil))

4 ETW000 49 0.180705

4 ETW000 [dev trc ,00000] - oci_bind ( 3: SQLT_AFC, l= 20, con_hdl=0, stmth_p=0x48f6800, vp=0x48c3220,ip=0x48b87fe,rlp=0x48b98ba,rcp=(nil))

4 ETW000 46 0.180751

4 ETW000 [dev trc ,00000] - oci_bind ( 4: SQLT_AFC, l= 6, con_hdl=0, stmth_p=0x48f6800, vp=0x48c4e04,ip=0x48b8ac8,rlp=0x48b9b84,rcp=(nil))

4 ETW000 68 0.180819

4 ETW000 [dev trc ,00000] - oci_bind ( 5: SQLT_AFC, l= 28, con_hdl=0, stmth_p=0x48f6800, vp=0x48c5662,ip=0x48b8d92,rlp=0x48b9e4e,rcp=(nil))

4 ETW000 57 0.180876

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 321 0.181197

4 ETW000 PATCHHIST was already up to date.

4 ETW690 COMMIT "0" "0"

4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0) 34 0.181231

4 ETW000 trace to file pointer closed

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

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 13.01.2011 - 15:48:24

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 108 0.000108

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 28 0.000136

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x479a658,usrhp=0x47dd480) 143 0.000279

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

4 ETW000 326 0.000605

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 200 0.000805

4 ETW000 [dev trc ,00000] Disconnected from connection 0 15 0.000820

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1) 10 0.000830

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 9 0.000839

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 13.01.2011 - 15:48:24

[Former Member · Accepted solution]

Have you recently changed the SAPSR3 password? If so, have you changed it via brconnect?

Please execute brconnect -u / -c -f chpass and change the password. Check again with R3trans -d if you can connect.

Kind regards,

Mark

[nirmal_konchada · Accepted solution]

Hi,

If you DB is not able to start then how can u expect R3trans -d to work???

Nirmal.

[manoj_nayak2 · Accepted solution]

Hi.

i have not changed the password of SAPSR3.

I am doing heterogeneous system copy. Source Window 2003 & MSS2005. Target RHEL5.5 & Oracle 10.2.0.4.

In target system during installation Start instance phase it was stop. So restarted target system & after that i am trying to start listener & DB so that i can continue with old installation(but DB is not started).

Only i did unlock SAPSR3 user.

Regards

[Former Member · Accepted solution]

Can you login with sqlplus and enter "select open_mode from v$database" ?

Kind regards,

Mark

[manoj_nayak2 · Accepted solution]

Hello

SQL> select open_mode from v$database;

OPEN_MODE

-

---

READ WRITE

SQL>

Regards

[Former Member · Accepted solution]

So your database is started and open..

What do you get when you execute R3trans -d

Kind regards,

Mark

[manoj_nayak2 · Accepted solution]

<hostname>:tstadm 22> R3trans -d

This is R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

unicode enabled version

R3trans finished (0000).

As return code is 0000, can i start installation

Regards

[Former Member · Accepted solution]

Yes, looks fine to me!

[manoj_nayak2 · Accepted solution]

Thanks for help i started my installation.

Regards

[Former Member]

Looks like the SAP schema user is locked.

Check this note on how to unlock the account: Note 951167 - ORA-28000: the account is locked

Kind regards,

Mark