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

发表于:2007-06-22来源:作者:点击数: 标签:
Lockmanager: 启动附加的Oracle实例 问题描述 我试图在一个正在运行的Lockmanager结点上配置另外一个Oracle实例,但Oracle出现错误: ora-1148. Oerr utility returns 01148, 00000, "database must be mounted EXCLUSIVE for this operation" // *Cause: An

   
  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

原文转自:http://www.ltesting.net