Oracle报00439原因,ORA-00439的解决-CSDN博客

今天用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 disabledFri 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

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup

ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE 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.