Can any one remind me of the default location for udump,cdump and bdump on unix?
It did not work.
$ cd $ORACLE_HOME/admin/VTDB/udump
ksh: /u08/ora8/oracle/product/8.1.7/admin/VTDB/udump: not found.
NOTE: VTDB is the name of the SID/DATABASE
It's not specified in my initVTDB.ora file neither so the default should work
Log into your database and do show parameters. This will tell you what user_dump_dest, core_dump_dest and background_dump_dest are set to.
select name, value from v$parameter
where name like '%dump%'
this will show it to you...
or just use the unix find command.....
select name, value from v$parameter where name like '%dump%';
The background_dump_dest, background_core_dump is giving me the location of the alert file. That is not what I want.
$ORACLE_HOME/rdbms/log is where the alert file is located. Everything there starts with alert_SID.log or alert_SID_*****.log and tracle files that end with the extension trc. I want to locate the udump,cdump,ect.
bdump is specified by background dump dest.
cdump is specified by core dump dest.
udump is specified by user dump dest.
Whatever is showing is what Oracle is using for these
directories. No exceptions. If you don't believe me,
try 'alter database backup controlfile to trace' and see
where the file shows up.
If you want to change these, you can do it in the init.ora
file and then restart you database.
Click Here to Expand Forum to Full Width