System Not starting after Offline Backup

100 Views

Hi All,

Recently we performed a oracle upgrade from 10 to 11, After the upgrade we found that system is not coming up after the offline backup and we are starting the database manually for this. As the database is not starting with startsap command, we starting database manually and starting sap.

we checked the listener settings it seems to be fine.

=====================================================================================

Error Log::

Thu Nov 24 03:15:35 NFT 2011

check if Oracle processes are running

database not available

There are no Oracle processes running -

Database is probably already stopped.

check_db_running: check finished with return code: 10

Database not available

-

Thu Nov 24 03:15:35 NFT 2011

Shutdown database

First trying to shutdown the database - May be, the database is in the nomount or mount state

-

Thu Nov 24 03:15:38 NFT 2011

starting database

SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 24 03:15:38 2011

ERROR:

ORA-12547: TNS:lost contact

-

Thu Nov 24 03:15:40 NFT 2011

Connect to the database to verify, that the database is now open

-

check if Oracle processes are running

database not available

There are no Oracle processes running -

Database is probably already stopped.

ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/PID/SYS/exe/run/startj2eedb: Terminating with error code 12

=============================================================================

Can you please advise on the issue.

Thanks,

Sandeep Singh