7 Replies Latest reply on Sep 2, 2008 8:21 AM by pjturley

    page not found, ORA-07445: exception encountered: core dump

    617197
      any one can help me to check this log? I get "page not found" occasionally.thanks .

      Dump file f:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
      Tue Jan 08 18:14:24 2008
      ORACLE V10.2.0.1.0 - Production vsnsta=0
      vsnsql=14 vsnxtr=3
      Windows XP Version V5.1 Service Pack 1
      CPU : 2 - type 586
      Process Affinity : 0x00000000
      Memory (Avail/Total): Ph:2991M/3583M, Ph+PgF:4952M/5471M, VA:1945M/2047M
      Tue Jan 08 18:14:24 2008
      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      Picked latch-free SCN scheme 2
      Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
      Autotune of undo retention is turned on.
      IMODE=BR
      ILAT =10
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      ksdpec: called for event 13740 prior to event group initialization
      Starting up ORACLE RDBMS Version: 10.2.0.1.0.
      System parameters with non-default values:
      sessions = 49
      __shared_pool_size = 222298112
      __large_pool_size = 16777216
      __java_pool_size = 4194304
      __streams_pool_size = 0
      spfile = F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
      sga_target = 805306368
      control_files = F:\ORACLEXE\ORADATA\XE\CONTROL.DBF
      __db_cache_size = 557842432
      compatible = 10.2.0.1.0
      db_recovery_file_dest = F:\oraclexe\app\oracle\flash_recovery_area
      db_recovery_file_dest_size= 10737418240
      undo_management = AUTO
      undo_tablespace = UNDO
      remote_login_passwordfile= EXCLUSIVE
      dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
      shared_servers = 5
      job_queue_processes = 4
      audit_file_dest = F:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
      background_dump_dest = F:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
      user_dump_dest = F:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
      core_dump_dest = F:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
      db_name = XE
      open_cursors = 300
      os_authent_prefix =
      pga_aggregate_target = 268435456
      PMON started with pid=2, OS id=1132
      PSP0 started with pid=3, OS id=3612
      MMAN started with pid=4, OS id=2392
      DBW0 started with pid=5, OS id=3624
      LGWR started with pid=6, OS id=1356
      CKPT started with pid=7, OS id=1164
      SMON started with pid=8, OS id=3832
      RECO started with pid=9, OS id=2904
      CJQ0 started with pid=10, OS id=2844
      MMON started with pid=11, OS id=2176
      Tue Jan 08 18:14:24 2008
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
      MMNL started with pid=12, OS id=1292
      Tue Jan 08 18:14:24 2008
      starting up 5 shared server(s) ...
      Oracle Data Guard is not available in this edition of Oracle.
      Tue Jan 08 18:14:24 2008
      alter database mount exclusive
      Tue Jan 08 18:14:28 2008
      Setting recovery target incarnation to 2
      Tue Jan 08 18:14:28 2008
      Successful mount of redo thread 1, with mount id 2524594368
      Tue Jan 08 18:14:28 2008
      Database mounted in Exclusive Mode
      Completed: alter database mount exclusive
      Tue Jan 08 18:14:28 2008
      alter database open
      Tue Jan 08 18:14:28 2008
      Beginning crash recovery of 1 threads
      Tue Jan 08 18:14:28 2008
      Started redo scan
      Tue Jan 08 18:14:28 2008
      Completed redo scan
      1305 redo blocks read, 132 data blocks need recovery
      Tue Jan 08 18:14:28 2008
      Started redo application at
      Thread 1: logseq 62, block 3
      Tue Jan 08 18:14:29 2008
      Recovery of Online Redo Log: Thread 1 Group 1 Seq 62 Reading mem 0
      Mem# 0 errs 0: F:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3NX4T37T_.LOG
      Tue Jan 08 18:14:29 2008
      Completed redo application
      Tue Jan 08 18:14:29 2008
      Completed crash recovery at
      Thread 1: logseq 62, block 1308, scn 126409946604
      132 data blocks read, 132 data blocks written, 1305 redo blocks read
      Tue Jan 08 18:14:30 2008
      Thread 1 advanced to log sequence 63
      Thread 1 opened at log sequence 63
      Current log# 2 seq# 63 mem# 0: F:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_3NX4T4J3_.LOG
      Successful open of redo thread 1
      Tue Jan 08 18:14:30 2008
      SMON: enabling cache recovery
      Tue Jan 08 18:14:30 2008
      Successfully onlined Undo Tablespace 1.
      Tue Jan 08 18:14:30 2008
      SMON: enabling tx recovery
      Tue Jan 08 18:14:30 2008
      Database Characterset is AL32UTF8
      replication_dependency_tracking turned off (no async multimaster replication found)
      Starting background process QMNC
      QMNC started with pid=20, OS id=524
      Tue Jan 08 18:14:32 2008
      Completed: alter database open
      Tue Jan 08 18:14:33 2008
      db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
      user-specified limit on the amount of space that will be used by this
      database for recovery-related files, and does not reflect the amount of
      space available in the underlying filesystem or ASM diskgroup.
      Tue Jan 08 18:14:53 2008
      Memory Notification: Library Cache Object loaded into SGA
      Heap size 2208K exceeds notification threshold (2048K)
      KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

      Tue Jan 08 18:56:55 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_3780.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 18:56:55 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_3780.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 18:56:56 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_3780.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 18:57:00 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s001_3252.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 18:57:00 2008
      found dead shared server 'S000', pid = (14, 1)
      Tue Jan 08 18:57:00 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s001_3252.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 18:57:01 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s001_3252.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 18:58:00 2008
      found dead shared server 'S001', pid = (15, 1)
      Tue Jan 08 19:03:56 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1816.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 19:03:57 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1816.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 19:03:57 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1816.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 19:03:58 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s001_3056.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 19:04:03 2008
      found dead shared server 'S000', pid = (14, 2)
      Tue Jan 08 19:04:03 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s002_312.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 19:05:03 2008
      found dead shared server 'S001', pid = (15, 2)
      found dead shared server 'S002', pid = (16, 1)
      Tue Jan 08 19:05:30 2008
      Errors in file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s002_2864.trc:
      ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []

      Tue Jan 08 19:06:03 2008
      found dead shared server 'S002', pid = (16, 2)
        • 1. Re: page not found, ORA-07445: exception encountered: core dump
          617197
          Anyone can help on it?


          The content in trc :

          Dump file f:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_4016.trc
          Thu Jan 10 11:22:05 2008
          ORACLE V10.2.0.1.0 - Production vsnsta=0
          vsnsql=14 vsnxtr=3
          Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
          Windows XP Version V5.1 Service Pack 1
          CPU : 2 - type 586
          Process Affinity : 0x00000000
          Memory (Avail/Total): Ph:2860M/3583M, Ph+PgF:4122M/5471M, VA:1095M/2047M
          Instance name: xe

          Redo thread mounted by this instance: 1

          Oracle process number: 14

          Windows thread id: 4016, image: ORACLE.EXE (S000)


          *** ACTION NAME:(PAGE 4150) 2008-01-10 11:22:05.390
          *** MODULE NAME:(APEX:APPLICATION 4000) 2008-01-10 11:22:05.390
          *** SERVICE NAME:(SYS$USERS) 2008-01-10 11:22:05.390
          *** CLIENT ID:(DENNIS:4389204267300536) 2008-01-10 11:22:05.390
          *** SESSION ID:(27.149) 2008-01-10 11:22:05.390
          *** 2008-01-10 11:22:05.390
          ksedmp: internal or fatal error
          ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []
          Current SQL statement for this session:
          COMMIT
          ----- PL/SQL Call Stack -----
          object line object
          handle number name
          3BFE8478 6676 package body FLOWS_030000.WWV_FLOW
          3BFE8478 9782 package body FLOWS_030000.WWV_FLOW
          3BFF9504 255 procedure FLOWS_030000.F
          3BFFC6EC 30 anonymous block
          ----- Call Stack Trace -----
          calling call entry argument values in hex
          location type point (? means dubious value)
          -------------------- -------- -------------------- ----------------------------
          _npierr+487                   00000000             B70F61FA 660D72C2 F7AFA83
          1DE5487 20E88300 8D0004C2
          8589F841 FFFFFED8 F183B66
          3B686 E9098B00 3A1 10845F6
          29EE850F A2E90000 8B0002A5
          8AFE909 6A0000 82474FF 707E8
          ~~~~~~~~~~~~~~~~
          4C200 33104D8B C1D18BC0
          ABF302E9 E183CA8B E9AAF303
          3FA 2468B66 FC83B66 E5982
          C33B6600 9451850F 5B80002



          *** 2008-01-10 11:22:06.406
          ksedmp: internal or fatal error
          ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_npierr+487] [PC:0x5F22C3] [ADDR:0x4] [UNABLE_TO_READ] []
          Current SQL statement for this session:
          COMMIT
          ----- PL/SQL Call Stack -----
          object line object
          handle number name
          3BFE8478 6676 package body FLOWS_030000.WWV_FLOW
          3BFE8478 9782 package body FLOWS_030000.WWV_FLOW
          3BFF9504 255 procedure FLOWS_030000.F
          3BFFC6EC 30 anonymous block
          ksedmp: Obtaining call stack failed twice. not retrying
          • 2. Re: page not found, ORA-07445: exception encountered: core dump
            614439
            simulyf

            Usually ORA 7445 messages get reported to Oracle Support on enterprise versions, not sure what happens with XE.

            Has the database been aborted recently? an improper shutdown? Perhaps through a server/PC crash or something?

            I would be tempted to stop and restart the database cleanly, re-run your application and see if you get the same errors appearing. Usually in the trc file the statement executed at the time of the problem is written, if you can't see anything like that then it looks like it may be an internal issue. See if the controlled stop/re-start helps first.

            Karen
            • 3. Re: page not found, ORA-07445: exception encountered: core dump
              614439
              Sorry, should also have suggested that you post this on the database forum as someone there may have a better view.

              Karen
              • 4. Re: page not found, ORA-07445: exception encountered: core dump
                617197
                thanks a lot for your reply, karen.
                the database is OK, all of my procs/functions/queries were running without any problem.
                I have re-install the Oracle/Apex & os, still got the same error.

                In the application I got this error, I create a query with a dblink to access to a Orale 8i remote server and this server has a bad performance sometimes (response time of a query over 1 mins while commonly it is under 100ms). The root cause should be in it but I still get no any solution till now.
                • 5. Re: page not found, ORA-07445: exception encountered: core dump
                  Nicolas Jaworsky
                  Hi.

                  Does someone know somthing about this error?

                  I got the same one with Oracle Database Express and APEX 3.1.2.

                  Is there any patch for this ?

                  Thanks in advance.

                  Nicolas Jaworsky
                  Tolede

                  Edited by: Nicolas Jaworsky on Sep 2, 2008 10:08 AM
                  • 6. Re: page not found, ORA-07445: exception encountered: core dump
                    Iloon Wolff-Oracle
                    I think, it is related to
                    BUG 5648872 - SCHEDULER: ORA-07445 [OPIDSA()+321] WHEN SETTING UP CHAIN

                    Kind regards,
                    Iloon
                    • 7. Re: page not found, ORA-07445: exception encountered: core dump
                      pjturley
                      Hi,

                      Have a look at this thread

                      Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npierr+4

                      I change my browser to en-us and the problem went away. Maybe worth a go to see if it fixes your issues.

                      Regards

                      Paul