Hi list

Two of my 11 databases seem to be having some problem
with their settings. When i backup control file to
trace, the trace file is going to bdump instead of
udump. Here are the details.

home/oracle/admin/scripts> sqlplus [Email Address Removed] Release 9.2.0.1.0 - Production on Mon Mar 31
14:14:52 2003

Copyright (c) 1982, 2002, Oracle Corporation. All
rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.1.0 - Production

SQL> show user
USER is "SYSTEM"
SQL> show parameter dump

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
background_core_dump string
partial
background_dump_dest string
/u010/oracle/admin/REP/bdump
core_dump_dest string
/u010/oracle/admin/REP/cdump
max_dump_file_size string
UNLIMITED
shadow_core_dump string
partial
user_dump_dest string
/u010/oracle/admin/REP/udump
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release
9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.1.0 - Production
/home/oracle/admin/scripts>
/home/oracle/admin/scripts> grep -i 'dump'
$ORACLE_HOME/dbs/initREP.ora
background_dump_dest=/u010/oracle/admin/REP/bdump
core_dump_dest=/u010/oracle/admin/REP/cdump
user_dump_dest=/u010/oracle/admin/REP/udump
utl_file_dir=/u003/oradata/REP/utldump

I donot use spfile to start the database;

Any ideas.

TIA


=====
LayZee DBA

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Oracle LazyDBA home page