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来打开数据库。