Re: ORA-01034: Oracle Not Available error

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_at_gmail.com> 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.
>

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