[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/