ORACLE在HP-UX下的系列問題處理(33)
2024-08-29 13:40:03
供稿：網友
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
