Re: location of text control file if not found in user_dump_dest?
Date: Sun, 21 Mar 2010 23:38:05 +0000
Can you also try to see where you actually writing ?
*This is from 11gR2*
SYS_at_ORACOS> oradebug setmypid
SYS_at_ORACOS> alter database backup controlfile to trace;
SYS_at_ORACOS> oradebug tracefile_name;
*This is from 10gR2* * * *
SYS_at_SOLARAC> oradebug setmypid
SYS_at_SOLARAC> alter database backup controlfile to trace;
SYS_at_SOLARAC> oradebug tracefile_name; /u01/app/oracle/admin/SOLARAC/udump/solarac1_ora_24493.trc
-- 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:Received on Sun Mar 21 2010 - 18:38:05 CDT
> 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