Oracle Forms

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

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

Sorry, should also have suggested that you post this on the database forum as someone there may have a better view.

Karen

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.

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

I think, it is related to
BUG 5648872 - SCHEDULER: ORA-07445 [OPIDSA()+321] WHEN SETTING UP CHAIN

Kind regards,
Iloon

Hi,

Have a look at this thread

2664116

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