Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01034: ORACLE not available

2790985Nov 2 2015 — edited Nov 4 2015

Hi,

I received following alert for DB.

ORA-01034: ORACLE not available

My findings

I thought of using  V$RMAN_BACKUP_JOB_DETAILS to check if RMAN backup ran during alert time but the view doesn't exist.

Could you please tell me how to find the cause of the DB down?

SQL> select SESSION_KEY, INPUT_TYPE, STATUS,

to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,

to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,

elapsed_seconds/3600 hrs

from V$RMAN_BACKUP_JOB_DETAILS

order by session_key;  2    3    4    5    6

from V$RMAN_BACKUP_JOB_DETAILS

     *

ERROR at line 5:

ORA-00942: table or view does not exist

Oracle -- 8.1.7.3.0

OS     -- OSF1

This is non prod env.

Regards,

Bala

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2015
Added on Nov 2 2015
20 comments
4,208 views