1 2 3 Previous Next 82 Replies Latest reply on Oct 31, 2012 1:25 PM by Osama_Mustafa

    ORA-03113: end-of-file on communication channel

    Gajananh999
      Hello Everyone,

      I am using a amazon EC2 machine i have oracle 11g on EC2 linux machine.

      when i m trying to startup the oracle it giving the error.

      ORA-03113: end-of-file on communication channel
      Process ID: 15294
      Session ID: 125 Serial number: 5

      i did google for this but it said to look in to alert.log which shows the error but i m not able to get the alert.log on ec2 linux machine.

      Can anyone help me on this.
        • 1. Re: ORA-03113: end-of-file on communication channel
          Sunny kichloo
          alert.log should be present in $ORACLE_BASE/diag/rdbms/$ORACLE_SID/trace directory
          1 person found this helpful
          • 3. Re: ORA-03113: end-of-file on communication channel
            Gajananh999
            Here is the contain of log file

            <msg time='2012-10-31T12:49:28.200+05:30' org_id='oracle' comp_id='clients'
            type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
            host_addr='10.84.238.191'>
            <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
            </txt>
            </msg>
            <msg time='2012-10-31T13:21:04.820+05:30' org_id='oracle' comp_id='clients'
            type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
            host_addr='10.84.238.191'>
            <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
            </txt>
            </msg>
            <msg time='2012-10-31T13:22:17.324+05:30' org_id='oracle' comp_id='clients'
            type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
            host_addr='10.84.238.191'>
            <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
            </txt>
            </msg>
            • 4. Re: ORA-03113: end-of-file on communication channel
              Gajananh999
              Hello ,

              log.xml says /u01/app/oracle/product/11.2.0/db_1/log this folder does not exists but this folder present.
              • 5. Re: ORA-03113: end-of-file on communication channel
                Osama_Mustafa
                Check this if exists or not , if not create them to avoid this error

                /u01/app/oracle/product/11.2.0/db_1/log
                /u01/app/oracle/product/11.2.0/db_1/log/diag/clients
                • 6. Re: ORA-03113: end-of-file on communication channel
                  Gajananh999
                  Its there already and it permission also read/write.

                  look at this.

                  drwxr-xr-x 4 oracle oinstall 4096 Jul 4 10:49 log
                  • 8. Re: ORA-03113: end-of-file on communication channel
                    Gajananh999
                    Here is the contain of log folder

                    root@ip-10-84-238-191:[u01/app/oracle/product/11.2.0/db_1/log]
                    $ ll
                    total 8
                    drwxrwxr-x 3 oracle oinstall 4096 Jul 4 10:49 diag
                    drwxr-xr-t 3 oracle oinstall 4096 Jul 4 10:31 ip-10-84-238-191
                    • 9. Re: ORA-03113: end-of-file on communication channel
                      Osama_Mustafa
                      Post the alert log not Sqlnet.log Please
                      • 10. Re: ORA-03113: end-of-file on communication channel
                        Gajananh999
                        This is Alert log only see this .


                        root@ip-10-84-238-191:[home/oracle/oradiag_oracle/diag/clients/user_oracle/host_1672212190_76/alert]
                        $ tail -20 log.xml
                        </txt>
                        </msg>
                        <msg time='2012-10-31T13:22:17.324+05:30' org_id='oracle' comp_id='clients'
                        type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
                        host_addr='10.84.238.191'>
                        <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
                        </txt>
                        </msg>
                        <msg time='2012-10-31T14:03:19.188+05:30' org_id='oracle' comp_id='clients'
                        type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
                        host_addr='10.84.238.191'>
                        <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
                        </txt>
                        </msg>
                        <msg time='2012-10-31T14:08:38.214+05:30' org_id='oracle' comp_id='clients'
                        type='UNKNOWN' level='16' host_id='ip-10-84-238-191'
                        host_addr='10.84.238.191'>
                        <txt>Directory does not exist for read/write [u01/app/oracle/product/11.2.0/db_1/log] [u01/app/oracle/product/11.2.0/db_1/log/diag/clients]
                        </txt>
                        </msg>
                        • 11. Re: ORA-03113: end-of-file on communication channel
                          Osama_Mustafa
                          even inside this $ORACLE_BASE/diag/rdbms/$ORACLE_SID/trace


                          Error: ORA 3113
                          Text: end-of-file on communication channel
                          -------------------------------------------------------------------------------
                          Cause: An unexpected end-of-file was processed on the communication channel.
                          The problem could not be handled by the SQL*Net, two task, software.
                          This message could occur if the shadow two-task process associated with
                          a SQL*Net connect has terminated abnormally, or if there is a physical
                          failure of the interprocess communication vehicle, that is, the
                          network or server machine went down.

                          Action: If this message occurs during a connection attempt, check the setup
                          files for the appropriate SQL*net driver and confirm SQL*Net software
                          is correctly installed on the server. If the message occurs after a
                          connection is well established, and the error is not due to a physical
                          failure, check if a trace file was generated on the server at failure
                          time. Existence of a trace file may suggest an Oracle internal error
                          that requires the assistance of customer support.
                          • 12. Re: ORA-03113: end-of-file on communication channel
                            Gajananh999
                            Here is the contain

                            root@ip-10-84-238-191:[u01/app/diag/rdbms/sa/SA/trace]
                            $ tail -20 alert_SA.log
                            then consider changing RMAN ARCHIVELOG DELETION POLICY.
                            2. Back up files to tertiary device such as tape using RMAN
                            BACKUP RECOVERY AREA command.
                            3. Add disk space and increase db_recovery_file_dest_size parameter to
                            reflect the new space.
                            4. Delete unnecessary files using RMAN DELETE command. If an operating
                            system command was used to delete files, then use RMAN CROSSCHECK and
                            DELETE EXPIRED commands.
                            ************************************************************************
                            Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_ora_12222.trc:
                            ORA-19809: limit exceeded for recovery files
                            ORA-19804: cannot reclaim 30958592 bytes disk space from 53687091200 limit
                            ARCH: Error 19809 Creating archive log file to '/u01/flash_recovery_area/SA/archivelog/2012_10_31/o1_mf_1_2295_%u_.arc'
                            Errors in file /u01/app/diag/rdbms/sa/SA/trace/SA_ora_12222.trc:
                            ORA-16038: log 3 sequence# 2295 cannot be archived
                            ORA-19809: limit exceeded for recovery files
                            ORA-00312: online log 3 thread 1: '/u01/oradata/SA/redo03.log'
                            USER (ospid: 12222): terminating the instance due to error 16038
                            Wed Oct 31 14:10:24 2012
                            Instance terminated by USER, pid = 12222
                            • 13. Re: ORA-03113: end-of-file on communication channel
                              Osama_Mustafa
                              well now this the alert log and the error is clear
                              ORA-19809: limit exceeded for recovery files
                              ORA-19804: cannot reclaim 30958592 bytes disk space from 53687091200 limit
                              show parameter db_recovery_file_dest_size
                              alter system set db_recovery_file_dest_size=<you new size must be bigger than the old one>;
                              1 person found this helpful
                              • 14. Re: ORA-03113: end-of-file on communication channel
                                Osama_Mustafa
                                take also there's another solution for this error

                                1- i posted before
                                2-Using RMAN
                                crosscheck archivelog all ;
                                delete expired archivelog all ;
                                3-Delete unwanted Archive log in the location
                                1 2 3 Previous Next