当前位置： 首页 > news >正文

ORA-32004: obsolete and/or deprecated parameter(s) specified

news 来源：原创 2024/5/20 22:59:45

今天在自己虚拟机的一套环境上手动shutdown、up一个11g的数据库的时候报了这个错误。

<!--more-->

[oracle@gtlions ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 1月 21 12:59:05 2011

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

idle> conn /as sysdba
已连接。
sys(at)TEST> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

sys(at)TEST> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
sys(at)TEST> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE 例程已经启动。

Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 390072032 bytes
Database Buffers 125829120 bytes
Redo Buffers 5869568 bytes
数据库装载完毕。
数据库已经打开。
sys(at)TEST>
奇怪的是数据库可以正常打开，并且能够正常使用。于是去看了下alert文件，如下：
Fri Jan 21 13:00:38 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/db/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /opt/oracle/db/db_1/dbs/spfileTEST.ora
System parameters with non-default values:
processes = 100
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 500M
control_files = "/opt/oracle/db/oradata/TEST/control01.ctl"
control_files = "/opt/oracle/db/oradata/TEST/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=TESTXDB)"
audit_file_dest = "/opt/oracle/db/admin/TEST/adump"
audit_trail = "DB"
db_name = "TEST"
open_cursors = 300
sql_trace = FALSE
diagnostic_dest = "/opt/oracle/db"
Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing
Fri Jan 21 13:00:41 2011
PMON started with pid=2, OS id=6763
Fri Jan 21 13:00:41 2011
VKTM started with pid=3, OS id=6765 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Fri Jan 21 13:00:41 2011
GEN0 started with pid=4, OS id=6773
Fri Jan 21 13:00:41 2011
DIAG started with pid=5, OS id=6784
Fri Jan 21 13:00:41 2011
DBRM started with pid=6, OS id=6786
Fri Jan 21 13:00:41 2011
PSP0 started with pid=7, OS id=6788
Fri Jan 21 13:00:42 2011
DIA0 started with pid=8, OS id=6790
Fri Jan 21 13:00:42 2011
MMAN started with pid=9, OS id=6792
Fri Jan 21 13:00:42 2011
DBW0 started with pid=10, OS id=6794
Fri Jan 21 13:00:42 2011
LGWR started with pid=11, OS id=6796
Fri Jan 21 13:00:42 2011
CKPT started with pid=12, OS id=6798
Fri Jan 21 13:00:42 2011
SMON started with pid=13, OS id=6800
Fri Jan 21 13:00:42 2011
RECO started with pid=14, OS id=6802
Fri Jan 21 13:00:42 2011
MMON started with pid=15, OS id=6804
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jan 21 13:00:42 2011
MMNL started with pid=16, OS id=6806
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle/db
Fri Jan 21 13:00:42 2011
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 2039110523
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Fri Jan 21 13:00:49 2011
ALTER DATABASE OPEN
Thread 1 opened at log sequence 75
Current log# 3 seq# 75 mem# 0: /opt/oracle/db/oradata/TEST/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Fri Jan 21 13:00:50 2011
QMNC started with pid=20, OS id=6844
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Fri Jan 21 13:00:52 2011
CJQ0 started with pid=24, OS id=6858
注意这段：
Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing
看下这个参数的值是多少呢？
sys(at)TEST> show parameter sql_trace;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean FALSE
再去看下这个参数是否废弃了。
sys(at)TEST> column name format a10;
sys(at)TEST> column value format a10;
sys(at)TEST> column isdefault format a10;
sys(at)TEST> column descriptio format a10;
sys(at)TEST>SELECT NAME,Value,isdefault,Description FROM v$parameter WHERE isdeprecated = 'TRUE' And Name='sql_trace';
NAME VALUE ISDEFAULT DESCRIPTION
---------- ---------- ---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sql_trace FALSE FALSE enable SQL trace
果然是废弃的参数，可能是我之前给加到spfile去了，现在去掉看看。
sys(at)TEST> alter system reset sql_trace;

系统已更改。

sys(at)TEST> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
sys(at)TEST> startup
ORACLE 例程已经启动。

Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 390072032 bytes
Database Buffers 125829120 bytes
Redo Buffers 5869568 bytes
数据库装载完毕。
数据库已经打开。
sys(at)TEST>
吼吼，世界清静了。
小结
错误信息
32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance"
// *Cause: Obsolete or deprecated parameters for this instance type
// were specified in the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete
// or deprecated. Remove them from the SPFILE or the server
// side PFILE.
在升级到新版本的时候，注意观察和留意升级说明，需要关注默认参数的变化。
关键词： v$parameter
-The End-

相关文章：

  • 个人总结
  • 年终考评以后
  • NOSql之redis的学习
  • scapy-其中迭代器的实现细节
  • 初学前端犯下的错误（用于反省）
  • scapy-yield的含义和使用
  • Oracle-建表course
  • risc和cisc在嵌入式设备中的博弈
  • Adobe Unity大战3D网游市场
  • 面向对象和类
  • Autodesk收购引擎开发商Wild Pocket将推网页3D游戏引擎
  • 游戏将是21世纪最强大的媒体？
  • 搜索引擎
  • iOS 4.3社交媒体流功能或针对Facebook
  • MyBatis传入参数为集合 list 数组 map写法
  • 「前端」从UglifyJSPlugin强制开启css压缩探究webpack插件运行机制
  • 【附node操作实例】redis简明入门系列—字符串类型
  • 【每日笔记】【Go学习笔记】2019-01-10 codis proxy处理流程
  • 【跃迁之路】【699天】程序员高效学习方法论探索系列（实验阶段456-2019.1.19）...
  • ECS应用管理最佳实践
  • golang中接口赋值与方法集
  • iOS帅气加载动画、通知视图、红包助手、引导页、导航栏、朋友圈、小游戏等效果源码...
  • Kibana配置logstash，报表一体化
  • miaov-React 最佳入门
  • mockjs让前端开发独立于后端
  • mysql_config not found
  • npx命令介绍
  • PAT A1120
  • python 学习笔记 - Queue Pipes，进程间通讯
  • Python打包系统简单入门
  • RedisSerializer之JdkSerializationRedisSerializer分析
  • sublime配置文件
  • Tornado学习笔记（1）
  • V4L2视频输入框架概述
  • 分布式事物理论与实践
  • 回顾 Swift 多平台移植进度 #2
  • 浅析微信支付：申请退款、退款回调接口、查询退款
  • 什么软件可以提取视频中的音频制作成手机铃声
  • 吐槽Javascript系列二：数组中的splice和slice方法
  • 一天一个设计模式之JS实现——适配器模式
  • ​Linux Ubuntu环境下使用docker构建spark运行环境（超级详细）
  • ​ssh-keyscan命令--Linux命令应用大词典729个命令解读
  • ​软考-高级-系统架构设计师教程（清华第2版）【第12章 信息系统架构设计理论与实践（P420~465）-思维导图】​
  • ​学习一下，什么是预包装食品？​
  • # MySQL server 层和存储引擎层是怎么交互数据的？
  • #pragam once 和 #ifndef 预编译头
  • #我与Java虚拟机的故事#连载05：Java虚拟机的修炼之道
  • $(function(){})与(function($){....})(jQuery)的区别
  • ${factoryList }后面有空格不影响
  • （+4）2.2UML建模图
  • （4）(4.6) Triducer
  • (LeetCode) T14. Longest Common Prefix
  • (pojstep1.1.2)2654(直叙式模拟)
  • （十一）图像的罗伯特梯度锐化
  • （一）80c52学习之旅-起始篇