Re: Why 'Failed to archive' & 'Failed to archive TEST' appear in the alert log file?

"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3f1d6f0e$1_1_at_news.estpak.ee>...
> Hi!
>
> It looks like you have to increase your enqueue_resources init.ora
> parameter.
>
> Tanel.
>
> "Jeffrey Yee" <jeffyee_at_hotmail.com> wrote in message
> news:ec4cec95.0307212238.6271debf_at_posting.google.com...
> > Hi,
> >
> > I'm running Oracle9i 9.0.1.4 on hp-ux b11.11. I recently change the
> > online redo log size from 10M to 200M, because of checkpoint not
> > complete message in the alert log file. Now, I'm puzzle with another
> > message from the same alert log file. I get 'Failed to archive' or
> > 'Failed to archive TEST' message. But when I check on my archive
> > location & v$log view (archived=yes for all, except the status=current
> > logfile), all my online redo logs has been archived. I even have 10G
> > available on my archive log mount point. And the 'TEST' is worrying
> > me, because I have no idea what it means. Is there a way to get
> > documentation on the messages that appear on the alert log file?
> >
> > A cut-out of my alert log file:
> >
> ****************************************************************************
> *
> > Sat Jul 19 13:58:56 2003
> > ARC0: Completed archiving log 4 thread 1 sequence 5681
> > Failed to archive
> > ORA-00053 Max number of enqueues exceeded
> > Failed to archive
> > Failed to archive
> > Mon Jul 21 13:43:42 2003
> > Thread 1 advanced to log sequence 5683
> > Current log# 1 seq# 5683 mem# 0: /ovo_data/oradata/redo01.log
> > ...
> > Mon Jul 21 22:21:10 2003
> > ARC0: Completed archiving log 1 thread 1 sequence 5683
> > Failed to archive TEST
> > Failed to archive TEST
> >
> ****************************************************************************
> *
> >
> > Please advice. Thank you in advance.
> >
> > Best Regards,
> > Jeffrey Yee

I have 975 for enqueue_resources.

I do the following:
select * from v$resource_limit where resource_name in ('sessions', 'enqueue_locks', 'enqueue_resources');

RESOURCE_NAME	CURRENT_	MAX_	INITIAL_       LIMIT_VALUE
                UTILIZATION UTILIZATION ALLOCATION
sessions	        27	41	       445	       445
enqueue_locks	        21	32	      5330	      5330
enqueue_resources	21	64	       975	 UNLIMITED

The formula provided in the Oracle9i Database Reference says that: 'For more than 10 sessions, it is the number of database files + ((SESSIONS - 10) * 2) + 55.' For my case, I have 19 dbf files. Therefore, it becomes 19 + ((41-10) * 2) + 55 = 19 +62 + 55 = 136.

I'm at a lost on the proper enqueue_resources value that I should set. Please do advice, as I still get Failed to archive TEST in the alert log file.

Thank you. Received on Fri Jul 25 2003 - 00:18:43 CDT