熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle10g之ORA-32004問題

2013-11-13 12:46:16  來源: Oracle 

  今天在學習管理archivelog時遇到了ORA錯誤下面是解決方案

  
SQL> shutdown immediate;
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup
ORA: obsolete and/or deprecated parameter(s) specified
ORACLE instance started
Total System Global Area  bytes
Fixed Size                  bytes
Variable Size              bytes
Database Buffers           bytes
Redo Buffers                bytes
Database mounted
Database opened

  查看oracle給出的問題描述

   SQL> host oerr ora ;
obsolete and/or deprecated parameter(s) specified
// *Cause:  One or more obsolete and/or parameters 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

  去看看spfile

   *log_archive_format=%t_%s_%rdbf
*log_archive_max_processes=
*log_archive_start=FALSE
*log_archive_trace=

  然後在看看alert log文件裡面會出現以下信息

   Deprecated system parameters with specified values:
  log_archive_start
End of deprecated system parameter listing

  查了查資料說是oracle G已經不支持該參數了當打開歸檔模式(archive log mode) 則 ARCH 進程被隱性的自動設定g 中也就不會出現 i 以前那種數據庫已經在歸檔模式但是自動歸檔沒有被設定的情況了要解決該問題需要重置 log_archive_start 參數

  
SQL> alter system reset log_archive_start SCOPE=SPFILE SID=*;
System altered
SQL> shutdown immediate;
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup
ORACLE instance started
Total System Global Area  bytes
Fixed Size                  bytes
Variable Size              bytes
Database Buffers           bytes
Redo Buffers                bytes
Database mounted
Database opened

  重啟後再不報ORA錯誤了!

  查看g中都有那些參數是 deprecated 的

   SQL>select namedescription from v$parameter where isdeprecated = TRUE;

    上面提到的alert log文件位於%ORACLE_BASE%\admin\%ORACLE_SID%\bdump裡
From:http://tw.wingwit.com/Article/program/Oracle/201311/16555.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.