仅连接内部直到释放 oracle sql 开发人员
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6471032/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
connect internal only until freed oracle sql developer
提问by praveenb
Hi im trying to connect to oracle server db using oracle Sql developer Im getting error as
嗨，我正在尝试使用 oracle Sql 开发人员连接到 oracle 服务器数据库我收到错误
connect internal only until freed
仅在内部连接直到被释放
Please let me know how to solve this error.
请让我知道如何解决此错误。
Thankyou
谢谢
采纳答案by Justin Cave
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.
你是这个数据库的DBA吗？如果没有，您将需要联系 DBA——此错误表明数据库基本上已关闭。最终用户无法修复此错误。
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?
如果您是 DBA，您使用的是什么版本的 Oracle？最常见的问题是，您将 Oracle 配置为将归档日志写入到的目录（或目录之一，具体取决于您的配置）已满，需要清除。你能在那个目录中释放一些空间吗？
回答by RC.
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.
检查 Oracle 服务器上的警报日志，以及存档日志目标中是否有可用磁盘空间。当无法归档重做日志时，归档程序错误可能会触发此错误。
You can login as the dba and do: show parameter archiveas Justin explained in his comment.
您可以以 dba 身份登录并执行以下操作： show parameter archive正如贾斯汀在他的评论中所解释的那样。
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.
您正在寻找诸如log_archive_dest_N. 您可能有许多这样的参数，我建议检查每个具有值的驱动器/位置。
My database for instance has log_archive_dest_1 = '/o296/dbSID/arch'
例如我的数据库有 log_archive_dest_1 = '/o296/dbSID/arch'
