Thursday, January 31, 2008

Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name, value from v$parameter where name like '%dump_dest' or name like 'diag%';

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
background_dump_dest
c:\oracle\diag\rdbms\dbcse\dbcse\trace

user_dump_dest
c:\oracle\diag\rdbms\dbcse\dbcse\trace

core_dump_dest
c:\oracle\diag\rdbms\dbcse\dbcse\cdump


NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
diagnostic_dest
C:\ORACLE


SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 11.1.0
SQL>

No comments: