1.11gr2手工建库,启动时出现ORA-32004错误
- SQL> startup
- ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
- ORACLE instance started.
- Total System Global Area 514736128 bytes
- Fixed Size 1337576 bytes
- Variable Size 159385368 bytes
- Database Buffers 348127232 bytes
- Redo Buffers 5885952 bytes
- Database mounted.
- Database opened.
查看官方文档错误记录
- ORA-32004: obsolete or deprecated parameter(s) specified for string 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.
红色为解决办法,查看alert log
- Mon Apr 18 11:58:54 2011
- WARNING: The user_dump_dest init.ora parameter has been deprecated.
- WARNING: Please remove the user_dump_dest parameter from the init.ora file.
- WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data
- WARNING: The new location for the user logs and traces is /opt/app/oracle/diag/rdbms/testdb/testdb/trace
找到解决办法
- SQL> create file='inittestdb.ora' from spfile;
- SQL> ho vim inittestdb.ora
- *.background_dump_dest='$ORACLE_BASE/admin/testdb/bdump'
- *.user_dump_dest='$ORACLE_BASE/admin/testdb/udump'
删除 pfile中这两行,然后
- SQL> create spfile from pfile;
- SQL> shutdown immediate
- SQL> startup
ok!