ORA-00439的解決

今天用gc配置了stream後，重啟資料庫後發現有以下的問題

 

SQL> startup
ORA-00439: feature not enabled: Real Application Clusters

 

我這個庫PROD不是rac環境，單例項的。

 

開始以為是stream的什麼引數有問題。

然後從引數檔案裡面全部刪掉，重啟資料庫還是一樣的問題。

檢視alert日誌

 

ALTER SYSTEM SET job_queue_processes=10 SCOPE=BOTH;
Fri Oct 26 14:39:18 2012
ALTER SYSTEM SET job_queue_processes=20 SCOPE=BOTH;
Fri Oct 26 14:45:09 2012
Shutting down instance: further logons disabled
Fri Oct 26 14:45:11 2012
kkjcre1p: unable to spawn jobq slave process, error 1089
Fri Oct 26 14:45:14 2012
Stopping background process CJQ0
Fri Oct 26 14:45:14 2012
Stopping background process QMNC
Fri Oct 26 14:45:15 2012
Stopping background process MMNL
Fri Oct 26 14:45:15 2012
Streams CAPTURE C001 with pid=14, OS id=2162 stopped
Fri Oct 26 14:45:16 2012
Stopping background process MMON
Fri Oct 26 14:45:17 2012
Shutting down instance (immediate)
License high water mark = 12

Archiving is disabled
Fri Oct 26 14:45:57 2012
ARCH shutting down
ARC1: Archival stopped
Fri Oct 26 14:46:02 2012
ARCH shutting down
ARC0: Archival stopped
Fri Oct 26 14:46:03 2012
Thread 1 closed at log sequence 7
Successful close of redo thread 1
Fri Oct 26 14:46:03 2012
Completed: ALTER DATABASE CLOSE NORMAL
Fri Oct 26 14:46:03 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active

百思不得其解，還好是個是實驗庫，如果是正式庫就麻煩了。

最後查各處資料。metalink裡面提到。是一個引數(cluster_database)需要設為false. 這個引數在引數檔案裡不存在，可能被設為了false.改好後重啟

[oracle@oel1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 26 15:06:37 2012

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

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size              88082024 bytes
Database Buffers          188743680 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL> show parameter cluster

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     FALSE
cluster_database_instances           integer     1
cluster_interconnects                string
SQL> create pfile from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@oel1 dbs]$ vi initPROD.ora
[oracle@oel1 dbs]$

 

當然這個問題的原因還需要復現才行，暫時沒從日誌裡面看出什麼端倪來，有進展隨時更新。

 

對於 ORA-32004: obsolete and/or deprecated parameter(s) specified
需要從alert日誌中找出過期的引數

 

Deprecated system parameters with specified values:
  parallel_server

修改後重啟，沒有問題。

ORACLE instance shut down.
SQL> create spfile from pfile;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size             100664936 bytes
Database Buffers          176160768 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.