仅连接内部,直到释放 oracle sql Developer
您好,我正在尝试使用 oracle Sql 开发人员连接到 oracle 服务器数据库 我收到错误为
仅连接内部直至释放
请让我知道如何解决此错误。
谢谢
Hi im trying to connect to oracle server db using oracle Sql developer
Im getting error as
connect internal only until freed
Please let me know how to solve this error.
Thankyou
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
你是这个数据库的DBA吗?如果没有,您需要联系 DBA——此错误表明数据库基本上已关闭。最终用户无法修复此错误。
如果您是 DBA,您使用的是哪个版本的 Oracle?最常见的问题是您配置 Oracle 将归档日志写入到的目录(或目录之一,具体取决于您的配置)已满,需要清除。您可以释放该目录中的一些空间吗?
Are you the DBA of this database? If not, you'll need to contact the DBA-- this error indicates that the database is, essentially, down. There is nothing that an end user could do to fix this error.
If you are the DBA, what version of Oracle are you using? The most common problem is that the directory (or one of the directories depending on your configuration) that you've configured Oracle to write your archived logs to is full and needs to be cleared out. Can you free up some space in that directory?
检查 Oracle 服务器上的警报日志以及存档日志目标中是否有可用磁盘空间。当归档程序无法归档重做日志时,可能会触发此错误。
您可以以 dba 身份登录并执行:
showparameterarchive
,正如 Justin 在评论中所解释的那样。您正在查找诸如
log_archive_dest_N
之类的条目。您可能会有许多这样的参数,我建议检查每个具有值的驱动器/位置。例如,我的数据库有
log_archive_dest_1 = '/o296/dbSID/arch'
Check your the alert log on the Oracle server and also that you have available disk space in the archive log destination. This error can be triggered by an archiver error when it is unable to archive redo logs.
You can login as the dba and do:
show parameter archive
as Justin explained in his comment.You're looking for entries such as
log_archive_dest_N
. You will likely have numerous of these parameters, and I would suggest checking each drive/location that has a value.My database for instance has
log_archive_dest_1 = '/o296/dbSID/arch'