Connect internal only until freed oracle sql developer?

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?

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?

Im very newbie to oracle. Im using 11g, I donot know where archived logs are located to freeup space. :( please let me know.

Thanks – Praveenb Jun 24 at 17:03 @Praveenb - OK, so you are the DBA? From a command-line, open SQL*Plus and connect to the database as SYSDBA. To do that, type "sqlplus sys/>@> as sysdba" at the command line.

Type the command "show parameter archive" and post the results by editing your question. – Justin Cave Jun 24 at 17:07 i've to run this commands at local system or at server?. Db is in linux server.Im sorry if I ask a silly questions.

– Praveenb Jun 24 at 17:23 @Praveenb - If the server allows remote connections to the database as SYSDBA, you could do it from either the client or the server. If not, you'd have to do it from the server. – Justin Cave Jun 24 at 17:25.

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.

Im very newbie to oracle. Im using 11g, I donot know where alert logs are located to freeup space. :( please let me know.

Thanks – Praveenb Jun 24 at 17:04.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.