ORACLE在HP-UX下的系列问题处理(33)

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