在reference文档中说到 lock_name_space 主要是用于 standby db。
lock_name_space specifies the namespace that the distributed lock manager
(dlm) uses to generate lock names. consider setting this parameter if a standby or
clone database has the same database name on the same cluster as the primary
database.
if the standby database resides on the same file system as the primary database, set
lock_name_space in the standby initialization parameter file to a distinct value
such as the following:
lock_name_space = standby
但是可以巧用这个参数解决 同一个主机部署多个相同的db的问题。
在一个instance起来后,再启动另外一个instance,报错:
sql> startup
oracle instance started.
total system global area 1863815024 bytes
fixed size 733040 bytes
variable size 603979776 bytes
database buffers 1258291200 bytes
redo buffers 811008 bytes
ora-01102: cannot mount database in exclusive mode
这时去修改lock_name_space 为当前的instance_name。
当然,也要修改其他的instance 的初始化文件的 lock_name_space 的参数。
重启,问题得以解决:
sql> startup
oracle instance started.
total system global area 1863815024 bytes
fixed size 733040 bytes
variable size 603979776 bytes
database buffers 1258291200 bytes
redo buffers 811008 bytes
database mounted.
database opened.