6 Replies Latest reply on Jun 8, 2016 8:51 AM by Ibrahim Malek

    ORA-00257: archiver error

    Ibrahim Malek

      Dear friends

      this is my DEV env it was working fine until today morning

      the apps servers is unable to start

       

       

      the DB sys is able to log in but the apps is n't

      please advice

       

      SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 8 11:16:58 2016

       

       

      Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

       

       

      Enter user-name: apps/acciprod1

      ERROR:

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

       

       

       

       

      Enter user-name:

        • 1. Re: ORA-00257: archiver error
          Kj - Kiran Jadhav

          ERROR:

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

          Your Database Archive Log destination is Full. Please move or cleanup old archive logs to free up the space.

           

          Regards,

          Kiran

          • 2. Re: ORA-00257: archiver error
            happy10319

            Hi,

            is archivelog enabled ?

            If yes is the archivelog directory FULL ?

            What is in your alertlog ?

            • 3. Re: ORA-00257: archiver error
              Ibrahim Malek

              SQL> archive log list;

              Database log mode              Archive Mode

              Automatic archival             Enabled

              Archive destination            ?/dbs/arch

              Oldest online log sequence     43

              Next log sequence to archive   43

              Current log sequence           44

              SQL> show parameter db_recovery_file_dest;

              • 4. Re: ORA-00257: archiver error
                happy10319

                Run this :

                sql>show parameter log_archive_dest

                 

                And look for folder displayed.

                • 5. Re: ORA-00257: archiver error
                  BrunoVroman

                  Hello Ibrahim

                   

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

                   

                  maybe you don't intend to have this DEV database in archivelog mode, but it is (this can be the "result" of a refresh of the database from a copy of PROD for example).

                  As most probably the archive destination is full (it is $ORACLE_HOME/dbs/arch) and as all the redologs need to be archived, the DB cannot accept user activity.

                  You can have a look at the alert logfile to see more info.

                  You have to remove some archives or to modify archive+dest so that the DB can archive the necessary redologs. As long as the redologs cannot be archived, no user activity is allowed in the database.

                   

                  If you don't want to be in archivelog mode, you cn just drop (with OS commands) the logfiles, then switch to NOARCHIVELOG mode asap (or same issue will reoccur). If you have to be in achivelog mode, you should not simply drop the archives but back them up, and RMAN can take care of the deletion after the backup (example or RMAN command to do this: backup archivelog all delete input)

                   

                  Best regards,

                   

                  Bruno Vroman.

                  P.S. Oracle 10g?  It is urgent to think at an upgrade...

                  1 person found this helpful
                  • 6. Re: ORA-00257: archiver error
                    Ibrahim Malek

                    Alles Goed bruno?

                     

                    you are right mate i did clean the archive & changed the dest then move it back to the location & the apps account is able to log in again

                     

                    thank you 

                     

                     

                    here was my commands  but first throw the Os i've cleaned the /archive

                     

                     

                     

                     

                    SQL>  alter system set log_archive_dest_1='location=/tmp' ;                     

                     

                     

                    System altered.

                     

                     

                    SQL> archive log list;

                    Database log mode              Archive Mode

                    Automatic archival             Enabled

                    Archive destination            /tmp

                    Oldest online log sequence     43

                    Next log sequence to archive   43

                    Current log sequence           44

                    SQL>

                    SQL>

                    SQL> alter system set log_archive_dest_1='location=/oracle/prod/d01/db/apps_st/archive';

                     

                     

                    System altered.

                     

                     

                    SQL> archive log list;

                    Database log mode              Archive Mode

                    Automatic archival             Enabled

                    Archive destination            /oracle/prod/d01/db/apps_st/archive

                    Oldest online log sequence     44

                    Next log sequence to archive   45

                    Current log sequence           45

                    SQL> alter system switch logfile;