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

> This is a 9i database:
>
> SQL> show parameter user_dump_dest
>
>
>
> NAME TYPE VALUE
>
> ------------------------------------ -----------
> ------------------------------
>
> user_dump_dest string /qadon/oradata/qadon/udump
>
> SQL> alter database backup controlfile to trace;
>
>
>
> Database altered.
>
>
>
> SQL> !ls -l /qadon/oradata/qadon/udump
>
> total 0
>
>
>
> SQL>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Try looking in the bdump (for Shared server that's where it would be). Also make sure the udump has free space in the mount point. If the version is 9.2 or greater you can provide the file location as in: alter database backup controlfile to trace as '/path_of_a_directory/filename.sql';

-Madhu Sreeram

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