Oracle DB服务已打开,但Oracle SQL Developer软件中仍出现数据库未打开错误
本文介绍了Oracle DB服务已打开,但Oracle SQL Developer软件中仍出现数据库未打开错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!问题描述
我使用的是Oracle DB版本为19c和SQL Developer软件版本为21
我已尝试连接Oracle SQL Developer,但出现以下错误:
An error was encountered performing the requested operation:ORA-01109: database not open01109. 00000 – “database not open”*Cause: A command was attempted that requires the database to be open.*Action: Open the database and try the command againVendor code 1109
我认为Oracle服务已关闭,因此通过以下命令在SQL Plus软件中签入它
Enter user-name: systemEnter password:Last Successful login time: Fri Jan 14 2022 12:05:59 +05:30Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – ProductionVersion 19.3.0.0.0SQL> ALTER DATABASE OPEN;ALTER DATABASE OPEN*ERROR at line 1:ORA-01531: a database already open by the instanceSQL> select status from v$instance;STATUS————OPEN
Oracle DB服务已打开,但在Oracle SQL Developer software中仍出现‘数据库未打开’错误。
请参阅所附屏幕截图。
请建议问题是什么,我们如何解决它?非常感谢。
pdb
您正在处理推荐答案。您的根数据库已启动,但您没有启动PDB。
SQL> conn / as sysdbaConnected.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 713028296 bytesFixed Size 9138888 bytesVariable Size 545259520 bytesDatabase Buffers 150994944 bytesRedo Buffers 7634944 bytesDatabase mounted.Database opened.SQL> conn system/pwd@pdb01ERROR:ORA-01109: database not openWarning: You are no longer connected to ORACLE.SQL> conn / as sysdbaConnected.SQL> alter pluggable database all open;Pluggable database altered.SQL> conn system/pwd@pdb01Connected.
这篇关于Oracle DB服务已打开,但Oracle SQL Developer软件中仍出现数据库未打开错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持吉威生活!
[英文标题]Oracle DB service is already opened but still getting ‘database not open’ error in Oracle SQL Developer software
声明:本媒体部分图片、文章来源于网络,版权归原作者所有,如有侵权,请联系QQ:330946442删除。