关于ORA_32004错误的解决

最新推荐文章于 2024-09-04 09:35:30 发布

Gerry-格里

最新推荐文章于 2024-09-04 09:35:30 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle问题集文章标签： ORA_32004错误

本文链接：https://blog.youkuaiyun.com/Ajinnv/article/details/10137279

Oracle问题集专栏收录该内容

1 篇文章

订阅专栏

本文讨论了如何处理Oracle数据库中出现的错误提示，即已废弃的参数被启用。通过检查alert日志和使用SQL命令重置参数，成功解决了问题。重新启动数据库后，系统运行恢复正常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

数据为10g:

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified --报错，已废弃的参数被启用
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> show erro
No errors.
SQL> host oerr ora 32004 --查看错误定义
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause: One or more obsolete and/or parameters were specified in
// the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete. --提示去alert_ORCL.log中找相应的废弃参数
// or deprecated. Remove them from the SPFILE or the server
// side PFILE.

[oracle@class155 bdump]$ pwd
/oracle/admin/ORCL/bdump ---文件路径
[oracle@class155 bdump]$ vim alert_ORCL.log

Deprecated system parameters with specified values:
log_archive_start ---可以看到2个废弃的参数被设置了
sql_trace
End of deprecated system parameter listing
PMON started with pid=2, OS id=2998
PSP0 started with pid=3, OS id=3000
MMAN started with pid=4, OS id=3002
DBW0 started with pid=5, OS id=3004
LGWR started with pid=6, OS id=3006
CKPT started with pid=7, OS id=3008
/Deprecated ---在vim中查找关键字Deprecated (这样才能全部找到废弃的参数被启用的情况)

SQL> show parameter sql_trace;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean TRUE --默认为false

SQL> alter system reset sql_trace scope=spfile sid='*'; --重置参数

System altered.

SQL> show parameter log_archive_start

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean TRUE --默认为FALSE

SQL> alter system reset log_archive_start scope=spfile sid='*';

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started. --重启后正常

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.