- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Microsoft
- >
- Re: oracle db is down with memory allocation error...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2007 03:00 AM
тАО11-14-2007 03:00 AM
oracle db is down with memory allocation errors
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2007 03:04 AM
тАО11-14-2007 03:04 AM
Re: oracle db is down with memory allocation errors
Can you submit e:\oracle\admin\ovpi\bdump\alert_ovpi.log as zip file
Best Regards
Murat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2007 03:06 AM
тАО11-14-2007 03:06 AM
Re: oracle db is down with memory allocation errors
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2007 09:36 AM
тАО11-14-2007 09:36 AM
Re: oracle db is down with memory allocation errors
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=
If there is not enough memory, you'll get a message.
Best regards
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-15-2007 03:06 AM
тАО11-15-2007 03:06 AM
Re: oracle db is down with memory allocation errors
Thanks for ur response.
Murat,
Attached alertlog file.
Thanks,
Nirmal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2007 02:44 PM
тАО11-18-2007 02:44 PM
Re: oracle db is down with memory allocation errors
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.