Re: ORA-01034: Oracle Not Available error
- From: "A. Coskan Gundogar" <gundogar@xxxxxxxxx>
- To: godwin.ror@xxxxxxxxx
- Date: Tue, 13 Mar 2007 17:22:49 +0200
Hi
Did you give value DEFER to the log_archive_dest_state_n parameter for the
phsical standby database
I think the database is still looking for the standby
On 3/13/07, Godwin vincent <godwin.ror@xxxxxxxxx> wrote:
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.
Other related posts:
