ORA-16557: database is already in use ORACLE 报错 故障修复 远程处理

文档解释

ORA-16557: database is already in use

Cause: An attempt was made to create a duplicate database in the broker configuration, or to add a duplicate instance (sid) for an existing database in the broker configuration.

Action: Check the database to be added to ensure there are no duplicates.

ORA-16557：数据库已经在使用中

官方解释

This error is raised by the RDBMS if the database is mounted and in use when attempting to open that database.

常见案例

一般处理方法及步骤

如果已经启动数据库，需要正确关闭它，以免发生ORA-16557错误（普遍存在）：

1.停止其他用户的创新，暂时停止工作以关闭数据库。

2.使用shutdown immediate来关闭数据库。

3.使用startup mount命令启动数据库进入挂载模式。

4.可以使用alter database open来打开数据库。