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