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