1 2 Previous Next 15 Replies Latest reply on Nov 11, 2010 3:02 AM by 811427

    ORA-07445 [opidsa()+313]

    23119
      Periodically in 1-3 weeks we start getting ORA-07445 in alert.log when clicking on certain links in APEX. Last time it was when developers was trying just login into workspace. Now it happens when developers trying to edit report columns on pages that have reports.

      alert.log:

      Thu Jan 11 09:24:50 2007
      Errors in file /oracle/db/10.2.0/admin/cars/udump/cars_ora_27657.trc:
      ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
      Thu Jan 11 09:24:57 2007
      Errors in file /oracle/db/10.2.0/admin/cars/udump/cars_ora_27669.trc:
      ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
      Thu Jan 11 09:25:05 2007
      Errors in file /oracle/db/10.2.0/admin/cars/udump/cars_ora_27677.trc:
      ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []

      For each ORA-07445 there is a corresponding trace in udump

      We're on 10.2.0.3, linux x86, APEX 2.2.1.00.04

      I would like to know if someone else is hurted by this issue?
        • 1. Re: ORA-07445 [opidsa()+313]
          John Edward Scott
          Hi Edward,

          Take a look at Metalink note 5752147, it may be relevant.
          • 2. Re: ORA-07445 [opidsa()+313]
            23119
            Thanks Jes.
            I think this is exact the same bug we've encountered.
            • 3. Re: ORA-07445 [opidsa()+313]
              Oracleator
              Hi,

              I have a similar problem ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_opidsa+360] [PC:0x2080540] [ADDR:0x0] [UNABLE_TO_READ]

              This is causing HTTP 404 - File Not Found to the APEX end user.

              Related bug is 5745817 (among others), SR open since 04-JAN-2007 whith priority 1. We are on 28-FEB-2007 and no solution has been posted.

              We're on 10.2.0.3.0, Windows 2003 Server, Application Express 2.2.1.00.04

              Does anyone know how to fix this?

              Francisco
              • 4. Re: ORA-07445 [opidsa()+313]
                23119
                Hi,

                the only recommendation was to restart database periodically. We are waiting development on fixing bug 5745817

                You can try to rollback to 10.2.0.2 patchset level if it's appropriate for you. I believe this should fix this issue.
                • 5. Re: ORA-07445 [opidsa()+313]
                  493761
                  Hi,

                  I have encountered the same error "ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_opidsa+360] [PC:0x209ABCC] [ADDR:0x0] [UNABLE_TO_READ] []" from my production DB 10gR2 10.2.0.3 with interim patch CPUApr2007. I applied the latest patch two days before as per Oracle support advise. Now waiting for response from Oracle Support for this specific error.

                  Thanks,
                  Musthafa
                  • 6. Re: ORA-07445 [opidsa()+313]
                    23119
                    Musthafa,

                    I applied 5648872 patch only and no CPU patches because we are not ready for production yet. This patch solved the problem for us.
                    As a workaround try to flush shared pool when you encounter this issue again. It may help you to avoid restarting database. If so you can flush shared_pool on a reqular basis via dbms_job or cron untill Oracle support solves the problem
                    • 7. Re: ORA-07445 [opidsa()+313]
                      493761
                      Hi

                      Oracle Support also now confirmed that it is related to bug 5648872. As I am on windows, I have to wait till next patch of 10.2.0.3.

                      Thanks,
                      Musthafa
                      • 8. Re: ORA-07445 [opidsa()+313]
                        Earl Lewis
                        Have some of you seen this in your applications, or only when you're running the application builder? Up until tonite I only saw it in the application builder. Tonite I saw it in one of my applications, which is pretty bothersome. I don't want users calling telling me that they click a link and they get a 'page not found' error because of this.

                        Anyone have any idea when a patch might be coming for 10.2.0.3.0?

                        Earl
                        • 9. Re: ORA-07445 [opidsa()+313]
                          23119
                          Earl,

                          have you applied oneoff patch 5648872 ?
                          • 10. Re: ORA-07445 [opidsa()+313]
                            Earl Lewis
                            That patch gives too many warnings about the bug description exactly matching our situation (and that not being the case) for us to feel comfortable applying it. It refers to the scheduler, when setting up a chain test.

                            I just read a metalink article that says this bug is fixed in 11g. Guess we're gonna have to wait until 11g stabilizes (after the first round of patches) before we're gonna get this one fixed.

                            Earl
                            • 11. Re: ORA-07445 [opidsa()+313]
                              567263
                              Have you been able to apply a patch to your Windows environment for 5648872? I am seeing similar symptoms and do not see that this patch applies to Windows, only other platforms.
                              • 12. Re: ORA-07445 [opidsa()+313]
                                gfreddi
                                We have this issue in all of our servers, if we flush the shared_pool everything works again, but i don't like the idea of flushing frequently to solve this just temporary. Would like to know from APEX Team if could be the way we create our application (another server with others applications don't ocurr this situation), this ocurrs just in the servers we have a specific application....

                                TY
                                • 13. Re: ORA-07445 [opidsa()+313]
                                  658055
                                  Hi,

                                  I am also getting this issue with my 12.0.4 apps, 10.2.0.3 db instance pls look into error and guide me the situation,
                                  WARNING: inbound connection timed out (ORA-3136)
                                  WARNING: inbound connection timed out (ORA-3136)
                                  WARNING: inbound connection timed out (ORA-3136)
                                  ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
                                  WARNING: inbound connection timed out (ORA-3136)
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []
                                  ORA-07445: exception encountered: core dump [opidsa()+313] [SIGSEGV] [Address not mapped to object] [0x0] [] []

                                  Thanks,
                                  ven
                                  • 14. Re: ORA-07445 [opidsa()+313]
                                    Sunilqln-Oracle
                                    Hi,


                                    Can I apply oneoff patch 5648872 after applying cpujuly2008 in 10.2.0.3(apex 2.2.1-Linux box)?


                                    Thanks in advance,
                                    Sunil
                                    1 2 Previous Next