topic oracle db is down with memory allocation errors in Operating System - Microsoft

oracle db is down with memory allocation errors

Nirmalkumar — Wed, 14 Nov 2007 11:00:51 GMT

Hi,

The oracle database is down with the below errors.

----------------------------------------------

Thu Nov 08 09:01:50 2007
ARC1: Evaluating archive log 2 thread 1 sequence 110268
ARC1: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ARC1: Beginning to archive log 2 thread 1 sequence 110268
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ADMIN\OVPI\ARCHIVE\ARC10268.001'
ARC1: Completed archiving log 2 thread 1 sequence 110268
There are 319 memory allocation errors for object-level stat
in the last 15 minutes
There are 118 memory allocation errors for object-level stat
in the last 15 minutes
Dump file e:\oracle\admin\ovpi\bdump\alert_ovpi.log

-------------------------------------------

The oracle services running fine but oracle databases are down.

version of oracle:9i

please help me out

1.why oracle database is down
2.why oracle services is not down once oracle database was down.
3.How to avoid it in future.

please response me

Thanks,
Nirmal.

Re: oracle db is down with memory allocation errors

Murat SULUHAN — Wed, 14 Nov 2007 11:04:05 GMT

Hi Nirmal

Can you submit e:\oracle\admin\ovpi\bdump\alert_ovpi.log as zip file

Best Regards
Murat

Re: oracle db is down with memory allocation errors

Hein van den Heuvel — Wed, 14 Nov 2007 11:06:30 GMT

Hmmmm looks like an HPUX forum is not the best place to ask.
The output suggest to me this is Oracle on an Windoze platform, and I woudl recommend you use an Oracle forum as a first step.

It doesn't look like the DB came down to me. It might just be 'unresponsive'... which is much the same to enduser.
Check with 'taskmanager'
(or 'ps -ef | grep -i oracle' if this is unix)

You may want to indicated exactly which oracle version, which platform, whether this ever worked, what changed?

Cheers,
Hein.

Re: oracle db is down with memory allocation errors

Volker Borowski — Wed, 14 Nov 2007 17:36:42 GMT

Hi,

increase shared_pool_size and set log_archive_format to a value that can deal with 6 digit log sequence numbers.

Increaseing shared_pool_size can be done while the system ist up, as long as there is enough unallocated memory defined for the sga (sga_max_size) and dynamic sga is configured.

simply try it

show parameter shared_pool_size

alter system set shared_pool_size= scope=memory

If there is not enough memory, you'll get a message.

Best regards
Volker

Re: oracle db is down with memory allocation errors

Nirmalkumar — Thu, 15 Nov 2007 11:06:33 GMT

Hi all,

Thanks for ur response.

Murat,

Attached alertlog file.

Thanks,
Nirmal

Re: oracle db is down with memory allocation errors

Hein van den Heuvel — Sun, 18 Nov 2007 22:44:23 GMT

I scan through that log, but it does not look like it is down. Those memory errors happened over days, and the system kept on ticking.

As Volker indicated, you may want to tuen the shared pool.

I would want to know why the redo log sometimes flips over in less than a minute.

Is that by design or by ignorance?
Maybe your redo's are too small (5mb?)
Check with a query like:

set pages 9999
set lines 132
column member format a44
column THREAD# format 99
column GROUP# format 999
column STATUS format a10

select l.group#, l.bytes/(1024*1024) "MB", l.status, f.member
from v$log l, v$logfile f
where l.group# = f.group#
order by l.group#;

hth,
Hein.