ORA-00257 : PL/SQL DEVELOPER

Hello

In theory, the folder where the redo logs are archived is available from Oracle; but since Oracle is not available for you, the easiest thing was to install a database to guide you. So I installed Oracle 10g Express Edition on Windows XP, and I then enabled archive log mode.
A little disappointment along the way: Oracle does not keep the log_archive_dest parameter up to date. Until Oracle 9.2, it was, but not anymore :-(
I threw a few alter system switch logfile; (that's my sync for me) and I went on the hunt for small recent files.
And I found in C:\oraclexe\app\oracle\flash_recovery_area\XE a folder called ARCHIVELOG. This folder contains a folder dated today (yyyy_mm_dd). And in this folder dated today, there are files O1_MF_1_n_xxxxxx_.ARC where n is a number (which for me starts at 4) and xxxxx is a sort of serial number certainly to verify that such archivelog is indeed intended for such instance.

So, if you also have an ARCHIVELOG folder that contains a folder for each day with .ARC files inside, I think you just need to delete them to be able to start your database without any issues. Just don't forget to disable this archivelog mode to avoid getting stuck again.

Hi

I don't have my manual on hand, but it smells like the volume is full.
Could it be that the volume where your archivelogs are stored is full? Since the archiver can no longer save its redologs, it blocks all activity and only allows internal connections (which, as we all know, does not trigger any activity).

Hi, thanks for your response, but I have no idea where ARCHIVELOG is located. Is it in the software's folder?

Hi
in %ORACLE_HOME%\admin\<instance>\pfile there should be a pfile.ini if I remember correctly.
It's a text file that contains a log_archive_dest parameter
this parameter tells you the folder in question.

I don't have a pfile on my computer.

It is likely a disk space issue.
http://openkb.fr/ORA-00257_erreur_d'archivage