ORACLE学习问题记录（不断更新）
1.11gr2手工建库，启动时出现ORA-32004错误[*]SQL> startup
[*]ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
[*]ORACLE instance started.
[*]Total System Global Area514736128 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!
页:
[1]