connect internal only until freed oracle sql developer

Question

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

Answer 1

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?

Answer 2

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'