getting an error in startdb while restarting sap services

[Former Member]

hi Experts ,

while restarting my sap services it gets an error at startdb and log file is shown below

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

16:33:22 22.11.2010 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.95 700 - AIX v11.00 5L-64 bit 070920

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 356538) is already running .....

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

saposcol already running

Running /usr/sap/LBD/SYS/exe/run/startdb

Trying to start LBD database ...

Log file: /home/lbdadm/startdb.log

/usr/sap/LBD/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

my startdb.log file

-

---

Mon Nov 22 16:33:23 IST 2010

LOGFILE FOR STARTING ORACLE

Trying to start LBD database ...

-

---

Mon Nov 22 16:33:23 IST 2010

checking required environment variables

ORACLE_HOME is >/oracle/LBD/102_64<

ORACLE_SID is >LBD<

-

---

Mon Nov 22 16:33:23 IST 2010

check initora

-

---

Mon Nov 22 16:33:23 IST 2010

check initora

-

---

Mon Nov 22 16:33:23 IST 2010

checking V2 connect

"startdb.log" 77 lines, 2315 characters

-

---

Mon Nov 22 16:33:23 IST 2010

LOGFILE FOR STARTING ORACLE

Trying to start LBD database ...

-

---

Mon Nov 22 16:33:23 IST 2010

checking required environment variables

ORACLE_HOME is >/oracle/LBD/102_64<

ORACLE_SID is >LBD<

-

---

Mon Nov 22 16:33:23 IST 2010

check initora

-

---

Mon Nov 22 16:33:23 IST 2010

check initora

-

---

Mon Nov 22 16:33:23 IST 2010

checking V2 connect

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 22-NOV-2010 16:33:23

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/usr/sap/LBD/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = lodhabidev)

(PORT = 1527))) (CONNECT_DATA = (SID = LBD) (GLOBAL_NAME = LBD.WORLD)))

OK (30 msec)

tnsping: V2 connect to LBD

-

---

Mon Nov 22 16:33:23 IST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

R3trans: connect check finished with return code: 12

Database not available

-

---

Mon Nov 22 16:33:28 IST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Mon Nov 22 16:33:53 IST 2010

starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 22 16:33:53 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1526726656 bytes

Fixed Size 2021064 bytes

Variable Size 771754296 bytes

Database Buffers 738197504 bytes

Redo Buffers 14753792 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning and Data Mining options

-

---

Mon Nov 22 16:35:07 IST 2010

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/LBD/SYS/exe/run/startdb: Terminating with error code 12

~

~

~

~

~

~

starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 22 16:33:53 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1526726656 bytes

Fixed Size 2021064 bytes

Variable Size 771754296 bytes

Database Buffers 738197504 bytes

Redo Buffers 14753792 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning and Data Mining options

-

---

Mon Nov 22 16:35:07 IST 2010

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/LBD/SYS/exe/run/startdb: Terminating with error code 12

my trans.log file

ETW000 [dev trc ,00000] Rolling back transaction ... 38 0.261052

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x11100fb98,usrhp=0x110ffc360)

4 ETW000 208 0.261260

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 531 0.261791

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

4 ETW000 56 0.261847

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

tch

4 ETW000 51 0.261898

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110ff4580 0x11100c9f8 0x111

00c2a8

4 ETW000 52 0.261950

4 ETW000 [dev trc ,00000] Assigning username to user session 0x110ffc360 28 0.261978

4 ETW000 [dev trc ,00000] Assigning password to user session 0x110ffc360 36 0.262014

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x11100fb98,srvhp=0x11100fdb8,usrhp=0x110ffc360)

4 ETW000 63 0.262077

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

4 ETW000 3892 0.265969

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

4 ETW000 46 0.266015

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

4 ETW000 61 0.266076

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x11100fdb8 358 0.266434

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

4 ETW000 73 0.266507

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

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

4 ETW000 220 0.266767

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

4 ETW000 69 0.266836

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

here i checked my TNSListener is running

please check why it is not starting

Regards

[Former Member · Accepted solution]

>>***LOG BY0=>ORA-28000: the account is locked

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

logon to ora<SID> and try to start the database.

Logon to <SID>adm and perform R3trans -d

There will be a trans.log file created please check, if you can't resolve, paste the log.

[Former Member · Accepted solution]

hi sunil

please find below trans.log file

vi trans.log

"trans.log" 97 lines, 9755 characters

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 22.11.2010 - 18:07:14

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] Mon Nov 22 18:07:14 2010

100 0.000100

4 ETW000 [dev trc ,00000] db_con_init called

28 0.000128

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

54 0.000182

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/LBD/SYS/exe/run/dbo

raslib.o' ...

4 ETW000

70 0.000252

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/LBD/SYS/exe/run/db

oraslib.o), hdl 0

4 ETW000

14694 0.014946

@

"trans.log" 97 lines, 9755 characters

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 22.11.2010 - 18:07:14

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] Mon Nov 22 18:07:14 2010 100 0.000100

4 ETW000 [dev trc ,00000] db_con_init called 28 0.000128

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

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

4 ETW000 70 0.000252

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

4 ETW000 14694 0.014946

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

4 ETW000 45 0.014991

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

4 ETW000 49 0.015040

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

4 ETW000 1087 0.016127

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

4 ETW000 49 0.016176

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

4 ETW000 302 0.016478

4 ETW000 [dev trc ,00000] New connection 0 created 155 0.016633

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

0, con_max = 255, con_opt = 255, occ = NO

4 ETW000 57 0.016690

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

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

4 ETW000 45 0.016791

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

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 53 0.016844

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

nvironment

4 ETW000 531 0.017375

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 332 0.017707

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 8192 0.025929

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

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

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

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

4 ETW000 48 0.026020

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

tch

4 ETW000 50 0.026070

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110ff4580 0x11100c9f8 0x111

00c2a8

4 ETW000 62 0.026132

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

4 ETW000 [dev trc ,00000] Allocating server context handle 30 0.026200

4 ETW000 [dev trc ,00000] Attaching to DB Server LBD (con_hdl=0,svchp=0x11100fb98,srvhp=0x11100fdb8)

4 ETW000 87 0.026287

4 ETW000 [dev trc ,00000] Assigning server context 0x11100fdb8 to service context 0x11100fb98

4 ETW000 109025 0.135312

4 ETW000 [dev trc ,00000] Allocating user session handle 166 0.135478

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x11100fb98,srvhp=0x11100fdb8,usrhp=0x110ffc360)

4 ETW000 60 0.135538

4 ETW000 [dev trc ,00000] Assigning user session 0x110ffc360 to service context 0x11100fb98

4 ETW000 32455 0.167993

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

4 ETW000 192 0.168185

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

4 ETW000 111 0.168296

4 ETW000 [dev trc ,00000] Now '/@LBD' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1135 0.169431

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

4 ETW000 62 0.169493

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

4 ETW000 465 0.169958

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

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 39 0.170959

4 ETW000 [dev trc ,00000] Rolling back transaction ... 37 0.170996

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x11100fb98,usrhp=0x110ffc360)

4 ETW000 205 0.171201

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 549 0.171750

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

4 ETW000 57 0.171807

@

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

4 ETW000 57 0.171807

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

tch

4 ETW000 52 0.171859

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110ff4580 0x11100c9f8 0x111

00c2a8

4 ETW000 51 0.171910

4 ETW000 [dev trc ,00000] Assigning username to user session 0x110ffc360 29 0.171939

4 ETW000 [dev trc ,00000] Assigning password to user session 0x110ffc360 35 0.171974

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x11100fb98,srvhp=0x11100fdb8,usrhp=0x110ffc360)

4 ETW000 65 0.172039

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

4 ETW000 3869 0.175908

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

4 ETW000 47 0.175955

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

4 ETW000 47 0.176002

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x11100fdb8 357 0.176359

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

4 ETW000 72 0.176431

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

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

4 ETW000 218 0.176688

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

4 ETW000 67 0.176755

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

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 22.11.2010 - 18:07:14

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] Mon Nov 22 18:07:14 2010 100 0.000100

4 ETW000 [dev trc ,00000] db_con_init called 28 0.000128

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

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

4 ETW000 70 0.000252

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

4 ETW000 14694 0.014946

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

4 ETW000 45 0.014991

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

4 ETW000 49 0.015040

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

4 ETW000 1087 0.016127

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

4 ETW000 49 0.016176

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

4 ETW000 302 0.016478

4 ETW000 [dev trc ,00000] New connection 0 created 155 0.016633

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

0, con_max = 255, con_opt = 255, occ = NO

4 ETW000 57 0.016690

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

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

4 ETW000 45 0.016791

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

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 53 0.016844

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

nvironment

4 ETW000 531 0.017375

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 332 0.017707

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 8192 0.025929

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

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

[Former Member · Accepted solution]

>>***LOG BY0=>ORA-28000: the account is locked

see myprevious response and follow the note.

[markus_doehr2]

> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

10.2.0.1 was never supported and has serious bugs. Depending on how you loaded the data into the database you may have corrupted blocks already.

If that's a new installation I highly suggest reinstalling with a supported version (10.2.0.4 or 10.2.0.5 plus the necessary PSU).

Markus