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

[Former Member]

Hi Experts,

We have made a system copy from Production to Quality and it has been done successfully. Now we are able to open the database manually. But when we are trying to start SAP it is not connecting the database base and it is giving error which is given below :

/home/qasadm/startdb.log

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4764729344 bytes

Fixed Size 2035312 bytes

Variable Size 2432700816 bytes

Database Buffers 2315255808 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

-

---

Mon Apr 12 10:45:40 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/QAS/SYS/exe/run/startdb: Terminating with error code 12

^C

root@bsltest # tail -f /home/qasadm/startdb.log

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Mon Apr 12 10:55:53 IST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Mon Apr 12 10:56:22 IST 2010

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 12 10:56:22 2010

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4764729344 bytes

Fixed Size 2035312 bytes

Variable Size 2432700816 bytes

Database Buffers 2315255808 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

-

---

Mon Apr 12 10:56:42 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/QAS/SYS/exe/run/startdb: Terminating with error code 12

Kindly see the logs and request you to kindly help us how it will resolve this issue.

Regards,

Jitendra

[Former Member]

nice support

[Former Member]

We have made a system copy from Production to Quality 

After client copy sap schema had been changed thats why its not connecting.

fyi: Client copy and system copy both are different

schema had been changed thats why its not connecting

This is one of the post installation step after doing a system copy(reffer the ssytem copy guide)

Problem has resolved

Great, suggest you to close this thread

Regards,

Nick Loy

[Former Member]

closed

[Former Member]

Hi All,

Problem has resolved. After client copy sap schema had been changed thats why its not connecting.

Regards,

Jitendra

[Former Member]

Hello,

Whenever you get an error like this (R3trans exit code 12), run the R3trans connection test manually:

su - qasadm
R3trans -d -w $HOME/dbconn.log
cat $HOME/dbconn.log

The R3trans output will contain detailed error information. Please post this on the forum.

Regards,

Mark

[Former Member]

Hi,

It is a problem of OPS$ user...

Please refer the below thread and the link in the same reply...

[|]

You can also provide the "trans.log" (from the location where you run R3trans -d command)

Regards.

Rajesh Narkhede

[Former Member]

First start your DB manually...If it get started then start SAP.

Regards,

Nick Loy

[Former Member]

Hi,

Has the database been started sucessfully after the system copy, before using the startsap script ?

Mark