ORA-01034: Oracle Not Available error

Hi all,

          Im getting this ORA-01034 error in my alert lot from a long time even though the database is up and running and even the listener is working correctly. Following is the text from my alert log, which is continuously showing up

ORA-01034: ORACLE not available
Tue Mar 13 10:24:23 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc: ORA-01034: ORACLE not available
Tue Mar 13 10:26:58 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc: ORA-01034: ORACLE not available
Tue Mar 13 10:39:43 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc: ORA-01034: ORACLE not available
Tue Mar 13 11:03:13 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc: ORA-01034: ORACLE not available
Tue Mar 13 11:03:59 2007
Thread 1 advanced to log sequence 17000
  Current log# 2 seq# 17000 mem# 0: /u01/oradata/hosting/redo02.log Tue Mar 13 11:03:59 2007
ARC1: Evaluating archive log 1 thread 1 sequence 25777 ARC1: Beginning to archive log 1 thread 1 sequence 25777 Creating archive destination LOG_ARCHIVE_DEST_2:
'/u04/oradata/DB1/archive/1_25777.dbf'

Creating archive destination LOG_ARCHIVE_DEST_1:
'/u05/oradata/DB1/archive/1_25777.dbf'

Tue Mar 13 11:10:00 2007
ARC1: Completed archiving log 1 thread 1 sequence 25777 Tue Mar 13 11:13:19 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc: ORA-01034: ORACLE not available
Tue Mar 13 11:19:27 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc: ORA-01034: ORACLE not available
Tue Mar 13 11:28:34 2007
Errors in file /u01/app/oracle/admin/DB1/bdump/DB1_arc0_31166.trc:

I have been getting the above text (ORA-01034) in the alert log since a long time. I tried to look into this trace file "DB1_arc0_31166.trc" and issued the following to see if there are any ORA errors $ cat DB1_arc0_3166.trc | grep -v ORA-01034 | grep ORA

for which, i got the following errors

ORA-12541: TNS: no listener
ORA-16058: Standby database instance is not mounted

along with ORA-01034: Oracle Not Available error. We have a standby database in place, which is down from a long time. The error associated with ORA-01034 in the trace file tells about the standby database, so is this the situation because the standby is down?. The database DB1 is up and running and im able to connect & work on it with out any problem. Any suggestions for any other reasons this error could occur and how actually to diagnose it. Any help would be greatly appreciated.

Thanks,
Godwin.

--
http://www.freelists.org/webpage/oracle-l