DB startup failed: Terminating with error code 12

[Former Member]

Dear All,

I've been looking out for this problem but unfortunately haven't found a suitable solution to it yet.

Problem:

======

For starting my solution manager, enabling the listner is no issue. But after that when I try starting SAP using "startsap" i encounter the following error:

solman:soladm 3> startsap

Checking SOL Database

----

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

----

---

12:16:06 20.02.2008 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.94 700 - v2.00, Intel x86 with Linux, 2007/02*

/16

• 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 6050) is already running .....*

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

saposcol already running

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

Trying to start SOL database ...

Log file: /home/soladm/startdb.log

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

DB startup failed

Here's the "Log file: /home/soladm/startdb.log"

----

---

Wed Feb 20 12:16:06 PKT 2008

LOGFILE FOR STARTING ORACLE

Trying to start SOL database ...

----

---

Wed Feb 20 12:16:06 PKT 2008

checking required environment variables

ORACLE_HOME is >/oracle/SOL/102_32<

ORACLE_SID is >SOL<

----

---

Wed Feb 20 12:16:06 PKT 2008

check initora

----

---

Wed Feb 20 12:16:06 PKT 2008

check initora

----

---

Wed Feb 20 12:16:06 PKT 2008

checking V2 connect

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1035993088 bytes

Fixed Size 1264724 bytes

Variable Size 528483244 bytes

Database Buffers 503316480 bytes

Redo Buffers 2928640 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Pr

oductionto the database to check the database state:

With the Partitioning and Data Mining options

----

---

Wed Feb 20 12:16:34 PKT 2008

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/SOL/SYS/exe/run/startdb: Terminating with error code 12

Please help me in resolving the issue.

Thanks, and Best Regards,

Muzammil

[Former Member]

Hi/ Check the alert_SID.log in /oracle/SID/saptrace/background.

Whay there it is written?

Regards.

[former_member204746]

check contents of file trans.log

if you can't find it, run:

R3trans -d

then check again for that file.

[Former Member]

Thank you all for your feedback!

When i tried executing "R3trans -d" I encountered the following error:

This is R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SOL/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

Here's the logfile of "trans.log"

4 ETW000 R3trans version 6.14 (release 700 - 10.07.07 - 13:48:00).

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

ETW000

• ETW000 date&time : 14.12.2007 - 12:51:58*

• ETW000 control file: <no ctrlfile>*

• ETW000 R3trans was called as follows: R3trans -x*

• ETW000 trace at level 2 opened for a given file pointer*

• ETW000 dev trc ,00000 Fri Dec 14 12:51:58 2007*

10462 0.010462

• ETW000 dev trc ,00000 db_con_init called*

20 0.010482

• ETW000 dev trc ,00000 create_con (con_name=R/3)*

0.010526

• ETW000 dev trc ,00000 Loading DB library '/usr/sap/SOL/SYS/exe/run/dbs*

dbslib.so' ...4 ETW00041 0.010567

• ETW000 http://dlux.c ,00000 *** ERROR => DlLoadLib: dlopen()= /usr/sap/SOL/SYS/exe/run/dbsdbslib.so: cannot open shared object file: No such file or directo*

ry -> DLENOACCESS (0,Success)

• ETW0004990 0.015557*

• ETW000 http://dbcon.c ,00000 *** ERROR => Couldn't load library '/usr/sap/SOL/SYS/exe/run/dbsdbslib.so'*

• ETW000 0.0155832EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SOL/SYS/exe/run') or dbms_type ('ORA')"*

moreover on executing the "ldd dbsdbs.lib.so" I got the following output:

solman:soladm 26> ldd dbsdbslib.so

libdl.so.2 => /lib/libdl.so.2 (0x00d10000)

librt.so.1 => /lib/tls/librt.so.1 (0x00e60000)

libSQLDBC76.so => not found

libc.so.6 => /lib/tls/libc.so.6 (0x00220000)

libstdc+.so.5 => /usr/lib/libstdc+.so.5 (0x00c3e000)

libm.so.6 => /lib/tls/libm.so.6 (0x00aec000)

libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00e00000)

libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00111000)

/lib/ld-linux.so.2 (0x00208000)

Hope this would help in identifying the problem.

Regards,

[Former Member]

Hi,

DIR_LIBRARY = path of kernel.

check the value of LD_LIBRARY_PATH

download the patch for lib_dbsl for your relavant kernel from service.sap.com and extract it in kernel director.

regards,

kaushal

[former_member204746]

have you set these variables?

DIR_LIBRARY /usr/sap/SOL/SYS/exe/run

dbms_type ORA

[Former Member]

Hi,

Check the user with which you are performing the activity and also check the environment variables whether they are set properly or not.

This issue arises because of the Environment Variables if they are not set properly.

regards,

kaushal