ORA-00257: archiver error. Connect internal only, until freed.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-00257: archiver error. Connect internal only, until freed.

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

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

    hi
    i am getting this error while i am connecting to sql plus what could be reason

    /dev/cciss/c0d0p5 5039840 946464 3837360 20% /
    /dev/cciss/c0d0p1 150128 13654 128723 10% /boot
    /dev/cciss/c0d0p3 44347968 25411780 16683416 61% /home1
    /dev/cciss/c0d0p2 44347968 14231408 27863788 34% /home2
    /dev/cciss/c0d0p9 38516328 6079504 30480264 17% /home3
    none 1029448 0 1029448 0% /dev/shm
    /dev/cciss/c0d0p6 4031856 814120 3012924 22% /usr
    /dev/cciss/c0d0p8 1509920 62328 1370892 5% /var

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Your archive file system is full. Backup and delete the archive files. Or may be automatic archival not enabled.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Re: ORA-00257: archiver error. Connect internal only, until freed.

    Originally posted by gajananpkini

    Re: ORA-00257: archiver error. Connect internal only, until freed.
    hi
    i am getting this error while i am connecting to sql plus what could be reason
    your database is freezed, not until you free some space to where your ARCHIVE_LOG_DEST is, it will remain to continue that way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width