Database startup failed error code 12

[former_member409456]

Dear Experts,

I am using SAP with oracle with AIX os.

i have taken a quality offline backup and restored it to another server named as XIPRD in the dircectory /oracle. After starting listner of database when i starts SAP it shows following error:

Trying to start JEQ database ...

Log file: /home/jeqadm/startdb.log

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

DB startup failed

Kindly help .

Reagrds,

Tarun

[Former Member]

HI Tarun,

Please check ENV variable .....LD_LIBRARY_PATH its pointed to $ORACLE_HOME/lib.

[Former Member]

Hi Tarun,

ORA-00205: error in identifying control file, check alert log for more info

Check alerlog for more information

Regards

Uday

[Former Member]

Can you perform an R3trans -d (as user sidadm) and post the output.

Kind regards,

Mark

[former_member409456]

R3Trans -d log is:

jkxiprd:jeqadm 1> R3trans -d

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

unicode enabled version

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

R3trans finished (0012).

[Former Member]

Please chekc the tnsnames.ora. Check tnsping to the SID.

Rgds,

JP.

[Former Member]

Have you renamed your database itself already? Or it is still running under the old SID?

Kind regards,

Mark

[former_member409456]

Hi mark,

i haven't renamed database.

When i checking oracle service it is showing:

orajeq 168136 1 0 Oct 15 - 0:08 /oracle/JEQ/102_64/bin/tnslsnr LISTENER -inherit

root 299074 106710 0 15:15:24 pts/0 0:00 grep oracle

[Former Member]

Have you adapted your controlfile(s) according to the new path names on the JEQ system?

[Former Member]

Can you execute the following statement from sqlplus: select open_mode from v$database

Kind regards,

Mark

[former_member409456]

Hi Sven Dinter ,

I have checked cntrl file but it is not showing any entry.

Kindly tell how to adopt control files.

regards,

Tarun

[Former Member]

I strongly recommend you to follow the system copy procedure guide.

follow: [original link is broken]

[former_member409456]

hiii sven,

when i checked control files in /oracle/JEQ/oracle/JEQ/sapdata1, file is showing blank.

[Former Member]

Tarun, have you done any system copy before on UNIX with oracle database?

[former_member409456]

Hii team,

i m doing this first time. i m using AIX with oracle.

[Former Member]

That's why I have suggested you to follow the system copyguide as mentioned earlier

follow: [original link is broken]

[former_member409456]

hii ,

I m trying this first time. and using aix with oracle.

[former_member409456]

hii,

kindly tell do we need to create trace file? because i m restoring quality offline backup to fresh system. or i have to work with control files only?

[Former Member]

execute below command on source system from SQL:

alter database backup controlfile to trace

This will generate a trace file under your /oracle/<SID>/saptrace/usertrace

there is a step by step procedure under http://www.saptechies.com/system-copy-guides/

[former_member524429]

Hi,

Please refer this useful document [Homogeneous-System-Copy-using-OnlineandOffline-ORACLE Backup/|http://www.basisconsultant.com/component/remository/Sytem-Copy-Guides/Homogeneous-System-Copy-using-OnlineandOffline-Backup/] to get more detailed steps. This document contains good description for each steps. Refer is and do the missing.

Regards,

Bhavik G. Shroff

[Former Member]

Hi Tarun,

Please post the error log for the file startdb.log.

Regards,

Hari Kishan

[former_member409456]

startdb.log is:

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

LOGFILE FOR STARTING ORACLE

Trying to start JEQ database ...

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

checking required environment variables

ORACLE_HOME is >/oracle/JEQ/102_64<

ORACLE_SID is >JEQ<

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

check initora

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

check initora

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

checking V2 connect

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 27-OCT-2010 10:04:28

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

Used parameter files:

/usr/sap/JEQ/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 = jkxiprd) (PORT = 1527))) (CONNECT_DATA = (SID = JEQ) (GLOBAL_NAME = JEQ.WORLD)))

OK (0 msec)

tnsping: V2 connect to JEQ

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Wed Oct 27 10:04:28 GMT+05:30 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Wed Oct 27 10:04:32 GMT+05:30 2010

starting database

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 27 10:04:32 2010

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4513071104 bytes

Fixed Size 2089960 bytes

Variable Size 2264927256 bytes

Database Buffers 2231369728 bytes

Redo Buffers 14684160 bytes

ORA-00205: error in identifying control file, check alert log for more info

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

With the Partitioning, Data Mining and Real Application Testing options

-

---

Wed Oct 27 10:04:36 GMT+05:30 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/JEQ/SYS/exe/run/startdb: Terminating with error code 12