Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

alert log file ERROR in oracle 10g

Posted on 2009-04-03
1
Medium Priority
?
3,007 Views
Last Modified: 2013-12-18
Thread 1 advanced to log sequence 17298
  Current log# 5 seq# 17298 mem# 0: /oraData4/PRODINFI/Log/redo0501.log
  Current log# 5 seq# 17298 mem# 1: /oraData1/PRODINFI/Log/redo0502.log
Thu Apr  2 15:49:39 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_12451.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:50:32 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13333.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:51:36 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13347.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:52:25 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13353.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:53:59 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13365.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:55:18 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13373.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:57:29 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13379.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 15:58:35 2009
Errors in file /oracle/app/product/10.2.0/admin/PRODINFI/udump/prodinfi_ora_13401.trc:
ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Apr  2 20:49:50 2009
Thread 1 advanced to log sequence 17299
  Current log# 3 seq# 17299 mem# 0: /oraData4/PRODINFI/Log/redo0301.log
  Current log# 3 seq# 17299 mem# 1: /oraData1/PRODINFI/Log/redo0302.log

I am attaching the trace file 
 
 
Kindly advice me As my server is up and running I got these ERROR!! yesterday in my alert log file. Please advice how to proceed with that.
Sandeep Sxena
91-9370261361.

Open in new window

prodinfi-ora-12451.trc.txt
prodinfi-ora-13333.trc.txt
0
Comment
Question by:sachin_dba
1 Comment
 
LVL 35

Accepted Solution

by:
johnsone earned 1500 total points
ID: 24059333
According to MetaLink, the only published bug says it has to do with describing a cursor in 10.2.0.3.

It will occur after the database has been up for some time and flushing the shared pool may help clear the problem.

The bug is fixed in 10.2.0.4
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question