10 Replies Latest reply: Jul 15, 2012 5:44 AM by Osama_Mustafa RSS

    ORA-445

    864103
      hi all ,
      now i receive this error

           
      Alert Details
      Metric          Generic Incident
      Time/Line Number          Sat Jul 14 04:03:23 2012/190775
      Severity          
      [Critical]           Critical
      Timestamp          Jul 14, 2012 4:00:36 AM
      Administrator          <SYSTEM>
      Message          Incident (ORA-445) detected in /report/oracle/diag/rdbms/report/REPORT/alert/log.xml at time/line number: Sat Jul 14 04:03:23 2012/190775.


      is this critical ??? how can i solve it ???


      many thanks
        • 1. Re: ORA-445
          Karan
          Try increasing memory and check your swap size too

          Edited by: Karan on Jul 15, 2012 12:55 PM
          • 2. Re: ORA-445
            Osama_Mustafa
            Could you please post your database version
            Select * from v$version ;
            Also OS version ?

            can you post alert log (last lines at least )

            Edited by: Osama-mustafa on Jul 15, 2012 10:31 AM
            • 3. Re: ORA-445
              864103
              sorry for that , please see the below




              SQL> select * from v$version;

              BANNER
              --------------------------------------------------------------------------------
              Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
              PL/SQL Release 11.2.0.1.0 - Production
              CORE 11.2.0.1.0 Production
              TNS for Linux: Version 11.2.0.1.0 - Production
              NLSRTL Version 11.2.0.1.0 - Production

              SQL>


              on linux version 6


              many thanks .
              • 4. Re: ORA-445
                Osama_Mustafa
                Please Post alert logs ? (last 20 lines)
                • 5. Re: ORA-445
                  Osama_Mustafa
                  First i have to tell that
                  Oracle Database 11.2.0.1.0 is not certified on Linux x86 Oracle Linux 6
                  Oracle Database 11.2.0.1.0 is not certified on Linux x64 Oracle Linux 6


                  Only 11.2.0.3 is certified with linux 6 try to install it and check if this error appear again

                  Note : Please mark this thread as answered if you get what you want .
                  Osama ...
                  • 6. Re: ORA-445
                    864103
                    thanks Osama ,there is nothink in alert log file but in xml file i found this

                    </txt>
                    </msg>
                    <msg time='2012-07-15T07:43:07.668+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt> Current log# 1 seq# 47506 mem# 1: /report/oradata/u02/redo01a.log
                    </txt>
                    </msg>
                    <msg time='2012-07-15T07:43:08.162+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8088'>
                    <txt>Archived Log entry 20327 added for thread 1 sequence 47505 ID 0xdf44a788 dest 1:
                    </txt>
                    </msg>
                    <msg time='2012-07-15T08:36:09.768+03:00' org_id='oracle' comp_id='rdbms'
                    msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION'
                    group='admin_ddl' level='16' host_id='IT-RBT'
                    host_addr='10.1.151.15' module='sqlplus@IT-RBT (TNS V1-V3)' pid='14593'>
                    <txt>alter tablespace IN_BASETAB add datafile &apos;/report/oradata/u01/BASETAB08.DBF&apos; size 1g autoextend on next 100m maxsize 10g
                    </txt>
                    </msg>
                    <msg time='2012-07-15T08:36:09.813+03:00' org_id='oracle' comp_id='rdbms'
                    msg_id='opiexe:3056:2780954927' client_id='' type='NOTIFICATION'
                    group='admin_ddl' level='16' host_id='IT-RBT'
                    host_addr='10.1.151.15' module='sqlplus@IT-RBT (TNS V1-V3)' pid='14593'>
                    <txt>ORA-1119 signalled during: alter tablespace IN_BASETAB add datafile &apos;/report/oradata/u01/BASETAB08.DBF&apos; size 1g autoextend on next 100m maxsize 10g...
                    </txt>
                    </msg>
                    <msg time='2012-07-15T08:36:30.851+03:00' org_id='oracle' comp_id='rdbms'
                    msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION'
                    group='admin_ddl' level='16' host_id='IT-RBT'
                    host_addr='10.1.151.15' module='sqlplus@IT-RBT (TNS V1-V3)' pid='14593'>
                    <txt>alter tablespace IN_BASETAB add datafile &apos;/report/oradata/u01/BASETAB08.DBF&apos; size 1g autoextend on next 100m maxsize 10g
                    </txt>
                    </msg>
                    <msg time='2012-07-15T08:36:42.010+03:00' org_id='oracle' comp_id='rdbms'
                    msg_id='opiexe:3065:2802784106' client_id='' type='NOTIFICATION'
                    group='admin_ddl' level='16' host_id='IT-RBT'
                    host_addr='10.1.151.15' module='sqlplus@IT-RBT (TNS V1-V3)' pid='14593'>
                    <txt>Completed: alter tablespace IN_BASETAB add datafile &apos;/report/oradata/u01/BASETAB08.DBF&apos; size 1g autoextend on next 100m maxsize 10g
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:04.219+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt>Thread 1 cannot allocate new log, sequence 47507
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:04.267+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt>Private strand flush not complete
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:04.267+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt> Current log# 1 seq# 47506 mem# 0: /report/oradata/u01/redo01.log
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:04.267+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt> Current log# 1 seq# 47506 mem# 1: /report/oradata/u02/redo01a.log
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:07.424+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt>Thread 1 advanced to log sequence 47507 (LGWR switch)
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:07.424+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt> Current log# 2 seq# 47507 mem# 0: /report/oradata/u03/redo02.log
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:07.424+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8022'>
                    <txt> Current log# 2 seq# 47507 mem# 1: /report/oradata/u04/redo02b.log
                    </txt>
                    </msg>
                    <msg time='2012-07-15T09:40:09.335+03:00' org_id='oracle' comp_id='rdbms'
                    client_id='' type='UNKNOWN' level='16'
                    host_id='IT-RBT' host_addr='10.1.151.15' module=''
                    pid='8090'>
                    <txt>Archived Log entry 20328 added for thread 1 sequence 47506 ID 0xdf44a788 dest 1:
                    </txt>
                    </msg>
                    IT-RBT:oracle:/report/oracle/diag/rdbms/report/REPORT/alert$



                    also why you say 11g not certified in linux 6 ,i would try to install 10g but not supported ,so i install 11g
                    • 7. Re: ORA-445
                      Osama_Mustafa
                      regarding to MOS Or Support.oracle.com under certification tab you can check that 11.2.0.1 and 11.2.0.2 is not certified with linux 6 ,
                      Because Linux 6 released after 11.2.0.1/11.2.0.2 , but Oracle Corporation Release database version 11.2.0.3 which is certified with linux 6
                      and you can download it from MOS

                      Osama ...
                      • 8. Re: ORA-445
                        Osama_Mustafa
                        Handle:      861100
                        Email:      tntman_88@yahoo.com
                        Status Level:      Newbie
                        Registered:      May 24, 2011
                        Total Posts:      357
                        Total Questions:      116 ( *43 unresolved* )
                        Name      Ahmed
                        Location      IRAQ

                        Osama ...
                        • 9. Re: ORA-445
                          864103
                          thanks .
                          • 10. Re: ORA-445
                            Osama_Mustafa
                            You are welcome :)