RE: core_dump_dest = /dev/null?

Kirti,

Iam posting the details that you want. I have no problem starting up the DB. I have problem how to test (ie, generating core dump file ), which I do not know.

inst:SQL>select name,value from v$parameter where name like '%dump%';

NAME                           VALUE 

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

shadow_core_dump               partial 

background_core_dump           partial 

background_dump_dest           /usr/local/oracle/log/inst 

user_dump_dest                 /usr/local/oracle/log/inst/usr 

max_dump_file_size             10240 

core_dump_dest                 /dev/null 

6 rows selected.

initinst.ora values:

user_dump_dest                = /usr/local/oracle/log/inst/usr
core_dump_dest                = /dev/null
background_dump_dest                            = /usr/local/oracle/log/inst
max_dump_file_size            = 10240

• Janardhana Babu

At 08:55 AM 5/26/00 -0800, Deshpande, Kirti wrote:
>Remember, when Oracle dumps core, it will create a file under the dump
>directory, And /dev/null is not a directory. So you will get ORA-443 (PMON
>not started) and ORA-9924 (directory not created properly) errors if dump
>directories settings are pointed to non-directory files. Just try it on you
>test db.
>So, /dev/null may be a good idea but you won't be able to startup the
>database !!!
>- Kirti
>
>
> > -----Original Message-----
> > From: Gilles PARC [SMTP:gparc_at_online.fr]
> > Sent: Thursday, May 25, 2000 6:56 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: core_dump_dest = /dev/null?
> >
> > At 05:38 25/05/2000 -0800, you wrote:
> > >
> > >> Here's an interesting thought - since Oracle very rarely wants the core
> > >> dump files, and since they can consume a lot of space unless you
> > >> routinely clean them up, is there any disadvantage to setting the
> > >> core_dump_dest parameter to /dev/null? Has anyone actually tried this?
> > >> Seems like it should work...
> > >
> >
> > Core_dump_dest is supposed to point to a directory so
> > /dev/null will probably not work.
> >
> > HTH
> >
> > Gilles Parc
> > Email : gparc_at_mail.dotcom.fr
> >
> > carpe diem !!
> > --
> >
>--
>Author: Deshpande, Kirti
> INET: Kirti.Deshpande_at_gtedc.gte.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Fri May 26 2000 - 13:04:37 CDT