ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
来源:互联网 发布:亚像素边缘提取算法 编辑:程序博客网 时间:2024/06/05 21:58
原文地址:http://www.cnblogs.com/zrcoffee/archive/2012/11/21/2780468.html
Oracle 11g for Linux x86_64
因为11g的日志存储位置比较分散,不像10g都在$ORACLE_BASE/admin/$ORACLE_SID/目录下。于是,在参数文件中增加background_dump_dest和user_dump_dest两个参数。
SQL> startup pfile='/home/oracle/init.ora'ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecatedORA-32006: USER_DUMP_DEST initialization parameter has been deprecatedORACLE instance started.Total System Global Area 1.6602E+10 bytesFixed Size 2244872 bytesVariable Size 1.3019E+10 bytesDatabase Buffers 3556769792 bytesRedo Buffers 23953408 bytesDatabase mounted.Database opened.
出现错误提示说background_dump_dest和user_dump_dest两个参数已经弃用。没有在意,继续执行以下命令:
SQL> create spfile from pfile='/home/oracle/init.ora';File created.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 1.6602E+10 bytesFixed Size 2244872 bytesVariable Size 1.3019E+10 bytesDatabase Buffers 3556769792 bytesRedo Buffers 23953408 bytesDatabase mounted.Database opened.SQL> show parameters background_dump_destNAME TYPE VALUE------------------------------------ ----------- ------------------------------background_dump_dest string /u01/app/oracle/diag/rdbms/rec koning/reckoning/traceSQL> show parameters user_dump_destNAME TYPE VALUE------------------------------------ ----------- ------------------------------user_dump_dest string /u01/app/oracle/diag/rdbms/rec koning/reckoning/trace
出现错误提示信息"ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance"。查看background_dump_dest和user_dump_dest两个参数,发现没有变更成功。
删除参数文件中的background_dump_dest和user_dump_dest两个参数,并重启数据库。数据库正常运行。
阅读11g官方文档,发现background_dump_dest和user_dump_dest两个参数在11中废弃了,由新参数diagnostic_dest所取代。以下是参数说明:
USER_DUMP_DEST
USER_DUMP_DEST specifies the pathname for a directory where the server will write debugging trace files on behalf of a user process.NOTE This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1, which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.
BACKGROUND_DUMP_DEST
BACKGROUND_DUMP_DEST specifies the pathname (directory or disc) where debugging trace files for the background processes (LGWR, DBWn, and so on) are written during Oracle operations. An alert file in the directory specified by BACKGROUND_DUMP_DEST logs significant database events and messages. Anything that affects the database instance or global database is recorded here. The alert file is a normal text file. Its filename is operating system-dependent. For platforms that support multiple instances, it takes the form alert_sid.log, where sid is the system identifier. This file grows slowly, but without limit, so you might want to delete it periodically. You can delete the file even when the database is running.
NOTE
This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1, which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.
DIAGNOSTIC_DEST
As of Oracle Database 11g Release 1, the diagnostics for each database instance are located in a dedicated directory, which can be specified through the DIAGNOSTIC_DEST initialization parameter. The structure of the directory specified by DIAGNOSTIC_DEST is as follows: <diagnostic_dest>/diag/rdbms/<dbname>/<instname> This location is known as the Automatic Diagnostic Repository (ADR) Home.For example, if the database name is proddb and the instance name is proddb1, the ADR home directory would be diagnostic_dest>/diag/rdbms/proddb/proddb1. The following files are located under the ADR home directory: Trace files - located in subdirectory <adr-home>/trace Alert logs - located in subdirectory <adr-home>/alert. In addition, the alert.log file is now in XML format, which conforms to the Oracle ARB logging standard. Core files - located in the subdirectory <adr-home>/cdumd Incident files - the occurrence of each serious error (for example, ORA-600, ORA-1578,ORA-7445) causes an incident to be created. Each incident is assigned an ID and dumping for each incident (error stack, call stack, block dumps, and so on) is stored in its own file, separated from process trace files. Incident dump files are located in <adr-home>/incident/<incdir#>. You can find the incident dump file location inside the process trace file.
阅读全文
0 0
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004 obsolete or deprecated parameter(s) specified for RDBMS instance
- 手动建库时一个小错误:ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004 obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORA-32004:obsolete or deprecaated parameter(s) specified for RDBMS instance Oracle 12c Release 1
- ORA-32004: obsolete or deprecated parameter(s) specified for
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- ora-32004 obsolete and/or deprecated parameter(s) specified
- ORA-32004: obsolete and/or deprecated parameter(s) specified
- x86-32汇编语言基础汇总
- iOS学习笔记-108.多线程07——CGD栅栏函数、延时、一次性代码
- STM32串口配置的一种方法
- oracl普通表转换成分区表(使用id作为间隔分区)
- react-native报错[NSTaggedPointerString unsignedIntValue]: unrecognized selector sent to instance的解决办法
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- iOS学习笔记-109.多线程08——CGD快速迭代
- Centos7安装Nginx
- 一、CentOS6.5安装ElasticSearch5.5完整纪录与问题总结
- ORACLE 11G 性能诊断优化之ASH实战分析详解
- iOS学习笔记-110.多线程09——CGD队列组
- promise.js
- Android强指针和弱指针
- iOS学习笔记-111.多线程10——CGD队列组图片下载合成示例