Re: core dump problem!!!!

ddf_dba_at_my-deja.com writes:

> In article <01bf9d9f$b2a6cce0$1264a3ca_at_default>,
> "Ali Bukhari" <smab_at_cyber.net.pk> wrote:
> > Hi,
> > I have AIX 4.2.1 and Oracle 7.3.4
> > The problem is that i found many core_XXX directories in my oracle
 home
> > directory.
> > I checked the core dump destination defined in initora and wven in
> > v$parameter while my database is running. This destination is not
 same as
> > my Oracle home directory.
> >
> > Pls reply me if someone know the reason. and also tell me that how
 can i
> > find out the reason of these core dump files.
> >
> > regards,
> > Muhammad Ali Bukhari
> > ICI Pakistan.
> >
> >
>
> Muhammad,
>
> I cannot tell you the reason for finding core_XXX directories in
> $ORACLE_HOME, outside of an application writing them there, so I won't
> even try to answer that part of your post. You can find the reason for
> the core dump files with a debugger like dbx, adb or gdb. The debugger
> will load the core file and report on the reason for the core dump.
> Most likely you'll find the reason as a segmentation fault which is, I
> believe, a memory error. A likely candidate for this is an application
> error when accessing the database instance. Run the core files through
> a debugging program and see what comes out. Also, check your alert.log
> for errors that could dump core, like ORA-0600 errors. This should
> tell you the time when the errors occurred and possibly why the core
> file was created.

First, I must correct a misconception. The core dumps are due to the Oracle server crashing, something which never happen due to an application error.

So, running a debugger on the core dump would tell you next to nothing. If, forsome reason, you want to look at the stack trace, you can find in the log directory. Look for *<pid>*.trc. The exact name will vary depending on which Oracle process crashed.

The bottom line is that Oracle support should be contacted. There might be a fix available for the problem.

>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.