ORA-00439的解决(笔记93天)
ORA-00439的解决(笔记93天)
jeanron100
发布于 2018-03-14 11:36:52
发布于 2018-03-14 11:36:52
今天用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.本文参与 腾讯云自媒体分享计划，分享自微信公众号。
原始发表：2014-06-04，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读