散尽浮华 2023

過去心不可得,現在心不可得,未來心不可得。
安寻安放,不卑不亢;重剑无锋,大巧不工!
  1. 首页
  2. oracle
  3. 正文

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

2021年10月24日 1500点热度 3人点赞 0条评论

数据库启动报错 ORA-32004

SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 24 23:14:44 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


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


shutdown immediate;
startup nomount;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.3462E+10 bytes
Fixed Size                  2265984 bytes
Variable Size            3087010944 bytes
Database Buffers         1.0335E+10 bytes
Redo Buffers               38014976 bytes
SQL>

查找原因:

# tail -300  /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log | grep WARNING:
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/main/orcl/trace
WARNING: The user_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the user_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 user logs and traces is /u01/app/oracle/diag/rdbms/main/orcl/trace

解决:

sqlplus / as sysdba

alter system reset background_dump_dest;
alter system reset diagnostic_dest;
alter system reset user_dump_dest;
shutdown immediate;
startup nomount;
标签: 暂无
最后更新:2021年10月24日

admin

这个人很懒,什么都没留下

点赞
< 上一篇
下一篇 >

文章评论

razz evil exclaim smile redface biggrin eek confused idea lol mad twisted rolleyes wink cool arrow neutral cry mrgreen drooling persevering
取消回复

COPYRIGHT © 2023 散尽浮华 2023. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang