Re: location of text control file if not found in user_dump_dest?

From: A. Coskan Gundogar <gundogar_at_gmail.com>
Date: Sun, 21 Mar 2010 23:38:05 +0000
Message-ID: <d1f742de1003211638v17acc847k3650adc108144afd_at_mail.gmail.com>

Can you also try to see where you actually writing ?

*This is from 11gR2*

SYS_at_ORACOS> oradebug setmypid
Statement processed.
SYS_at_ORACOS> alter database backup controlfile to trace;

Database altered.

SYS_at_ORACOS> oradebug tracefile_name;
/u01/app/oracle/*diag/rdbms/*oracos/ORACOS*/trace/*ORACOS_ora_1422.trc

*This is from 10gR2*
*
*
*

SYS_at_SOLARAC> oradebug setmypid
Statement processed.
SYS_at_SOLARAC> alter database backup controlfile to trace;

Database altered.

SYS_at_SOLARAC> oradebug tracefile_name; /u01/app/oracle/admin/SOLARAC/udump/solarac1_ora_24493.trc

Regards

-- 
Coskan GUNDOGAR

Oracle DBA

Email: gundogar_at_gmail.com
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan


*
On 19 March 2010 14:20, Roger Xu <wellmetus_at_gmail.com> wrote:



> Oracle user has permission to write and plenty of free space but I

> could not find it in either udump or bdump... still scrating my head

> ...

>

> On Fri, Mar 19, 2010 at 4:12 AM, Dunbar, Norman

> <norman.dunbar_at_environment-agency.gov.uk> wrote:

> > Morning,

> >

> >>>      SQL> show parameter user_dump_dest

> >>> /qadon/oradata/qadon/udump

> >

> > Does the oracle user on the server have permissions to write to the

> > above location? I have had occasions where oracle couldn't even write to

> > the bdump because the Unix guys hadn't set up the server permissions

> > correctly!

> >

> >

> > Cheers,

> > Norm.

> >

> >

> > Norman Dunbar

> > Contract Senior Oracle DBA

> > CIS Engineering Services

> > Internal : 7 28 2051

> > External : 0113 231 2051

> >

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>


--
http://www.freelists.org/webpage/oracle-l

Received on Sun Mar 21 2010 - 18:38:05 CDT