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

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：错误解决成功