文档解释 ORA-12350: database link being dropped is still mounted Cause: An attempt was made to drop a ROM: database lin
ORA-12350: database link being dropped is still mounted
Cause: An attempt was made to drop a ROM: database link that was still mounted and/or opened.
Action: Close and dismount the database and then re-issue the drop statement.
ORA-12350错误是当应用程序尝试删除一个数据库链接时,另一个未关联的数据库会出现的错误。
错误12350: 尝试删除已挂载的数据库链接
ORA-12350会通常发生在当数据库链接已被挂载未被关闭的情况下。如果想要释放资源,你必须先关闭连接。
1.使用激活功能检查数据库链接活动状态:
select * from v$session where program like ‘%db_link%’;
2. 对于激活的数据库链接,执行断开连接命令
alter system disconnect session ‘,’ immediate;
3. 验证链接是否已断开连接:
select * from v$session where program like ‘%db_link%’;
4. 如果确实断开连接了,可以继续执行删除数据库链接的命令:
drop database link ;
--结束END--
本文标题: ORA-12350: database link being dropped is still mounted ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/542208.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0