OFS环境，删除Resource 时出现错误失败，应该如何继续

最新推荐文章于 2024-01-27 14:21:51 发布

weixin_30716725

最新推荐文章于 2024-01-27 14:21:51 发布

阅读量83

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/gaojian/p/7569008.html

本文介绍如何从Windows故障转移群集管理器中删除Oracle数据库监听器和数据库实例。首先需要停止并删除组监听器，然后选择一个节点作为数据库的所有者。接下来在其他节点上执行删除操作，并编辑listener.ora和tnsnames.ora文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

From the Windows failover cluster manager,
select the group listener, stop it, and delete it.
Do the same thing for the database.

Pick a node that will "own" the database.
Then, on the remaining nodes, execute the following command at a CMD prompt:

oradim -SID {sid} -DELETE

On all nodes execute the following command
sc delete {Windows service name for listener}

Edit the listener.ora and remove the declaration for the group listener.
Do this on all nodes.

Edit the tnsnames.ora on the nodes
that won't own the db and remove all entries that reference the database.

Edit the tnsnames.ora on the node that owns the database
and modify the address list for the database so that it contains the address of the local node.

That should clean things up.