Skip to Content
0
Jan 13, 2011 at 08:12 AM

DB not start up Return code 012

82 Views

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