System Not starting after Offline Backup

[Former Member]

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

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:

ORA-12547: TNS:lost contact

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

[ashish_mishra2]

after above checks if problem persists. Try with below two options:

Option:1

from orasid user

cd $ORACLE_HOME

pwd

-> confirm that the path is pointing to 11g database only.

Now from root:

chown <oracle owner>:dba $ORACLE_HOME/bin/sqlplus

chmod 6751 $ORACLE_HOME/bin/sqlplus

chmod 6751 $ORACLE_HOME/bin/oracle

also check if orasid is part of dba group

=> Try starting dataabase now and see if it works. If it does not proceed with option-2

Option:2

1: Stop the database (if running) and listener. make sure no processes running from orasid.

2: from orasid user

cd $ORACLE_HOME/bin

relink all

3: start database and listener.

Hope this will help.

Cheers !!!

Ashish

[Former Member]

Hi Sandeep,

Please check the Environment Variables for Oracle 10. After the Oracle upgrade your ENV variables or Listener might have changed the path to 11G. Check it Accordingly.

2). Check the Listener Service whether its pointing to 10 or 11G path.

Can you also paste the log of tnsping <Listener name> from the prompt?

Thanks,

Sravanthi

[Former Member]

Hi Sravanthi,

chsappid:orapid 3> tnsping listener_pid

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 22-DEC-2011 10:30:10

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

Used parameter files:

/oracle/PID/112_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = chsappid)(PORT = 1501))

OK (10 msec)Singh

Regards,

Sandeep

[ashish_mishra2]

Hi,

Problem seems to be interesting. I would suggest below actions:

1: check network configuration files in /oracle/SID/11202/net*/admin as well as /sapmnt/SID/profile/oracle folderu2026. And see if they all are pointing to 11202 oracle home. And parameters are same in both the locations.

2: Cross check environment variables of orasid and sidadm user. Oracle home and client locations should point to same 11202.

In case client is still 10202 then oracle client should be same 10x for sidadm and orasid.

3: Check tnsping from both sidadm and orasid. and see if output is same.

4: I am not sure if dbstart is tried with sidadm -> sqlplus u2018/as sysdbau2019

Most of the time we try with orasid only.. check if you get any different error.

5: If problem remainsu2026.send us .. db startup error logsu2026

Make sure that no processes are running of orasid (except listener) and semaphores are clear.

We will try our best to resolve this problem.

Cheers !!!

Ashish

[ashish_mishra2]

Hi Sandeep,

Posted logs are of Thu Nov 24 03:15:38 2011.. one month old.

Could you please paste some new error logs if this problem is still there ?

Cheers !!!

Ashish

[Former Member]

Hi Ashish,

We are still facing the issue, with the latest dates.

Listener is also reachable.

Regards,

Sandeep

[former_member189725]

Please check if the /proc filesystem is mounted .

Also check if the listener is listening to the port mentioned in the listener.ora file

netstat -an |grep <portnumber>

Edited by: Ratnajit Dey on Dec 22, 2011 6:33 PM