on 08-22-2010 11:30 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.