ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
来源:互联网 发布:招聘助手软件 编辑:程序博客网 时间:2024/05/21 07:11
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 637537872 bytes
Database Buffers 205520896 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SQL>
----出现ORA-32004错误,意思:已过期或不推荐使用参数,即使用的参数文件里有已过期或不推荐使用的参数。
解决步骤:
1:查看警报日志 alert_bianxueqing.log
发现提示:
db_name = "bxq"
db_unique_name = "bianxueqing"
open_cursors = 300
sql_trace = FALSE
diagnostic_dest = "/u01/app/oracle"
Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing
Thu Feb 21 17:19:32 2013
-----Deprecated system parameters with specified values:
---- sql_trace
2:删除 sql_trace 参数:
SQL> create pfile from spfile;
File created.
[oracle@liumujing dbs]$ vim initbianxueqing.ora
.................去掉 sql_trace = FALSE 后保存退出
3:使用init<SID>.ora文件启动实例 -----这里是 initbianxueqing.ora
[oracle@liumujing dbs]$ mv spfilebianxueqing.ora spfilebianxueqing.ora.bak
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 637537872 bytes
Database Buffers 205520896 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
------spfile 的value为空证明此时使用 initbianxueqing.ora 参数
4:用initbianxueqing.ora构造新的spfile<SID>.ora文件
SQL> create spfile from pfile;
File created.
SQL> startup force -------------重启没再出现ORA-32004错误
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 637537872 bytes
Database Buffers 205520896 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/11.2.0/db_1/db
s/spfilebianxueqing.ora
5:错误解决成功
- 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
- OGRE 资源管理
- 大话设计模式之简单工厂模式、抽象工厂模式及工厂方法模式的比较
- 大数据(Bigdata)未来发展趋势预测
- SQL Server 2008 阻止保存要求重新创建表的更改问题的设置方法
- Ubuntu修改host遇到unable to resolve host
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- 如何解决每当打开一个m文件时,matlab应用程序随之打开
- [WebKit]RefPtr和PassRefPtr基础
- 内存分配中的堆与栈
- JavaMelody开源系统性能监控
- oracle 的几个查询语句
- STM32 独立看门狗与窗口看门狗
- 作业调度中复杂关系图问题 不仅仅偏序关系
- Android带文字的ImageButton实现