Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

One of my jUnit tests fails with the following exception:

java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed.

The Oracle error code refers to (for lack of better words/knowledge) ARCHIVELOG mode related issue. But, I made sure that the DB is running in NOARCHIVELOG mode. I checked V$DATABASE table and made sure that log_archive_start=false.

Can someone shed light on this?

share|improve this question
    
it can also refer to a lack of space in your redo-tablespace which something else than the archivelogs AFAIK... –  Yahia Aug 29 '11 at 14:51
1  
Is it possible to move this question to ServerFault? I don't want people to close this question as irrelevant, and lose sight of it. –  publicRavi Aug 29 '11 at 14:52
add comment

migrated from stackoverflow.com Aug 29 '11 at 15:58

This question came from our site for professional and enthusiast programmers.

1 Answer

This happens when the archiver cannot write or has no space in the destination specified by log_archive_dest. Check the results of "archive log list"

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.