ORA-32004

[root@ENMOEDU ~]# su - oracle
[oracle@ENMOEDU ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 18 10:13:16 2014

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

Connected to an idle instance.

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


引起问题的原因是过时或废弃参数中指定该实例类型SPFILE或PFILE在服务器端。

查看告警日志
[oracle@ENMOEDU trace]$ pwd
/u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/trace 
[oracle@ENMOEDU trace]$ tail -100f alert_ENMOEDU.log
Deprecated system parameters with specified values:
  sql_trace               
End of deprecated system parameter listing
Wed Jun 18 10:15:34 2014
PMON started with pid=2, OS id=5030
Wed Jun 18 10:15:34 2014
PSP0 started with pid=3, OS id=5032

发现过时参数 sql_trace 并重置

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

 

System altered.

 

SQL> startup force;

ORACLE instance started.

 

Total System Global Area  209715200 bytes

Fixed Size                  1218580 bytes

Variable Size              92276716 bytes

Database Buffers          113246208 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

参考文档  http://docs.oracle.com/cd/E11882_01/server.112/e17766/e29250.htm#ORA-32004

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29438041/viewspace-1185922/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29438041/viewspace-1185922/