up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
50% accept rate
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
feedback

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

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

1 Answer

up vote 0 down vote

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"

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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