cancel
Showing results for 
Search instead for 
Did you mean: 

startdb: Terminating with error code 12

Former Member
0 Kudos

Hi,

We are running ECC6.0.Databse : Oracle & OS : Solaris. I have done a new installation & after system copy when we start the sap I got the following error :

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

Trying to start QLT database ...

Log file: /export/home/qltadm/startdb.log

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

DB startup failed

Following is the error in startdb.log

qltadm> more startdb.log

-


Sun Aug 22 15:37:23 IST 2010

LOGFILE FOR STARTING ORACLE

Trying to start QLT database ...

-


Sun Aug 22 15:37:23 IST 2010

checking required environment variables

ORACLE_HOME is >/oracle/QLT/102_64<

ORACLE_SID is >QLT<

-


Sun Aug 22 15:37:23 IST 2010

check initora

-


Sun Aug 22 15:37:23 IST 2010

check initora

-


Sun Aug 22 15:37:23 IST 2010

checking V2 connect

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 22-AUG-2010 15:37:23

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

Used parameter files:

/usr/sap/QLT/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 = lumax-qal) (PORT = 1

527))) (CONNECT_DATA = (SID = QLT) (GLOBAL_NAME = QLT.WORLD)))

OK (10 msec)

tnsping: V2 connect to QLT

-


Sun Aug 22 15:37:23 IST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Sun Aug 22 15:37:23 IST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Sun Aug 22 15:37:47 IST 2010

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Aug 22 15:37:48 2010

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4747952128 bytes

Fixed Size 2035280 bytes

Variable Size 2399146416 bytes

Database Buffers 2332033024 bytes

Redo Buffers 14737408 bytes

Database mounted.

Database opened.

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

With the Partitioning and Data Mining options

-


Sun Aug 22 15:38:03 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/QLT/SYS/exe/run/startdb: Terminating with error code 12

qltadm>

Pl help in resolving this issue.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Try to exceute R3Trans -d with the user <SID>ADM and then post us the trans.log.

Check whether the following env variables are set for the users.

1. DIR_LIBRARY

2. LD_LIBRARY_PATH

Regards,

Varadharajan M

Former Member
0 Kudos

Is your listener running? If not check your logs ...

Often you get this when DB isn't running and SAP needs to connect in order to start.

Also consider this - that if your environment is on cluster technology then startsap won't work - you will need something like this:

- As sidadm

startdb

startsap -t r3 -i ASCS00 -v c123biXXXacsxx

startsap -t r3 -i DVEBMGS00 -v c123dbXXXdbqxx

stefan_koehler
Active Contributor
0 Kudos

Hello Sanjeev,

using the search helps (maybe you will find the holy grail with the search too).

- http://www.sdn.sap.com/irj/scn/advancedsearch?query=terminatingwitherrorcode12

or

- Sapnote #403004

Regards

Stefan