Lockmanager: 启动附加的Oracle实例
问题描述
我试图在一个正在运行的Lockmanager结点上配置另外一个Oracle实例,但Oracle出现错误:
ora-1148. Oerr utility returns 01148, 00000, "database must be mounted
EXCLUSIVE for this operation"
// *Cause: An attempt was made to mount the database PARALLEL without
the existence of a lock manager.
ACTION: Mount the database in EXCLUSIVE mode.
为什么会出现这个错误?
配置信息
操作系统 - HPUX
版本 - 10.20
硬件系统 - HP 9000
系列 - K460
解决方法
这个错误的原因,是试图用已有的实例号1运行另外一个实例。init.ora文件中的实例号、线程和回退段、或者相当物必须在集群内唯一,其中任何数字的任何重复都可能导致这个错误,或者产生类似的信息。为解决这个问题,可增大实例号、线程和/或回退段,使其不与集群上的任何其它实例冲突。
.........following with all English text ....
A5138881 [A5138881/TRAK/English]
Lockmanager: Initiating additional Oracle instances
Problem Description
I am attempting to configure another Oracle instance on a running
Lockmanager node and I=92m receiving an error from Oracle:
ora-1148. Oerr utility returns 01148, 00000, "database must be mounted
EXCLUSIVE for this operation"
// *Cause: An attempt was made to mount the database PARALLEL without the existence of a lock manager.
ACTION: Mount the database in EXCLUSIVE mode.
What causes this error?
Configuration Info
Operating System - HPUX
Version - 10.20
Hardware System - HP 9000
Series - K460
Solution
The cause of the error is an attempt to run another instance with the existing instance number 1 in this example. Instance numbers, threads,and rollback segments in init.ora file or its equivalent must be unique
cluster wide. Any replication of any of these numbers may cause this error or similar messages to be generated. To resolve increment the instance number, threads and/or rollback_segments so as not to conflict with any other instance on the cluster.
Cause
: An attempt was made to mount the database PARALLEL without the existence of a lock manager.
ACTION: Mount the database in EXCLUSIVE mode.
What causes this error?
Operating System - HPUX
Version - 10.20
Hardware System - HP 9000
Series - K460