11G 解决启动时报ORA-32004: obsolete or deprecated parameter(s) specified 错误

设为首页加入收藏

三通it学院：www.santongit.com

聚焦: 网络技术-思科华为 H3C Juniper 编程开发-软件 Web 移动项目 H3C 华为虚拟化 Juniper

生活: 数据库 Oracle MySQL 服务器 Linux Windows MySQL Linux 微软 IBM Oracle Windows

休闲: 云计算大数据 Hadooop OpenStack Spark 虚拟化 Vmware Citrix F5负载均衡 Docker Vmware Hadooop OpenStack Citrix F5负载均衡 Docker

分类: 软考等考美图美工网络营销 Office

三通IT学院 › 门户 ›技术频道› 数据库 › 查看内容

2014-11-26 13:23

11G 解决启动时报ORA-32004: obsolete or deprecated parameter(s) specified 错误

时光与梦2014-11-26 13:23886814

原作者: Liuxuebo

今天公司测试库启动时报 ORA-32004 错误下面看错误信息
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 26 10:51:56 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
........
Database opened.
此时查看告警日志 alter.log
WARNING: The background_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the background_dump_dest parameter from the init.ora file.
WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data
WARNING: The new location for the background logs and traces is /u01/app/oracle/diag/rdbms/orcl/orcl/trace

根据告警日志可知是参数 background_dump_dest 参数设置了具体的参数
下面查看11G 官方文档关于 background_dump_dest 参数的讲解。在讲解 backgroud_dump_dest 参数时最后有一个注意选项
Note:
This parameter is ignored by the new diagnosability infrastructure introduced in Oracle Database 11g Release 1 (11.1),
which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.
也就是说在11G中此参数已不再使用，用参数DIAGNOSTIC_DEST  代替了，但是设置后也不影响数据库使用
下面打开文本参数文件注释掉 background_dump_dest 参数
[oracle@Master dbs]$ ls
hc_orcl.dat  init.ora  initorcl.ora  lkORCL  orapworcl  spfileorcl.ora
[oracle@Master dbs]$ vi initorcl.ora
注释掉后
此时要把二进制参数文件删除掉或者更换一个名字，让oracle启动时读新的文本参数文件或者指定启动的参数文件
[oracle@Master dbs]$ mv spfileorcl.ora spfileorcl.ora.bak
[oracle@Master dbs]$ ll
total 24
-rw-rw---- 1 oracle oinstall 1544 Nov 26 11:25 hc_orcl.dat
-rw-r--r-- 1 oracle oinstall 1153 Nov 26 11:22 initorcl.ora
-rw-r----- 1 oracle oinstall 2048 Jul  6 23:05 orapworcl
-rw-r----- 1 oracle oinstall 3584 Nov 26 11:23 spfileorcl.ora.bak
下面使用指定参数文件办法启动
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 26 11:22:46 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size    2230952 bytes
Variable Size 1258292568 bytes
Database Buffers  1224736768 bytes
Redo Buffers    20078592 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
此时重建二进制参数文件后整个数据库都恢复正常