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


Permlink Replies: 20 - Pages: 2 [ 1 2 | Next ] - Last Post: Jul 22, 2008 4:48 AM Last Post By: Jochen_2
mcgoran

Posts: 25
Registered: 01/03/99
Universal edition choke on en-GB browser, core dumped, ORA-07445, _npierr+4
Posted: Mar 2, 2006 1:20 PM
Click to report abuse...   Click to reply to this thread Reply
Environment:

XE version : Universal
OS : Any
Browser : Any
Browser language : en-gb

Symptoms:

While using Application Express, every so often, randomly, Firefox asks user to download "f" or "www_flow_accept" file, or when browsing with IE - it displays "IBMPC/WIN_NT-8.1.0" on empty page/frame.
After that, apex freezes for about 40 seconds.
On the server side, core gets dumped and ORA-07445 (_npierr+487) gets reported in alert log and trace files as shown in my other thread: "Beta 3 Bug: using database link freezes apex and xdb" http://forums.oracle.com/forums/thread.jspa?threadID=363310

Workaround:

Set browser to en-US language settings.
Note: If you have "User Agent Switcher" Firefox extension, default user agent string does not follow the language settings change. You should de-install or re-install the extension.



Now, this workaround looks fine for me during development, but I can't possible tell the users to change their browsers language settings. Even more I can't have server posing as sitting duck to be frozen every so often with anyone with "wrong" language settings.

Can this please be fixed or some other workaround found.

I haven't tried yet, but if western version has no problems with this then it might be better workaround. But not for long. Universal version is a must in my case.
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie
Posted: Mar 2, 2006 3:32 PM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
UPDATE:

I have just tried western version.
Unfortunately, the problem remains the same.
Definitively, apex doesn't work with en-gb browser.
It doesn't matter if you browse locally or remotely, I forgot to mention.
So, anyone with en-gb settings would crash my applications.
It doesn't matter database links or not, it happens anywhere, even when just surfing home page, before logon screen. Creating db link and testing it is just the most successful and consistent way I found to produce the error.

So the environment is now:

XE version : Universal & western
OS : Any
Browser : Any
Browser location : local & remote
Browser language : en-gb

Only user469099 and segafredozanetti complained so far for this!
Are we the only apex users in the UK ? :)
(Although they seem not to be from the UK.)

Anyone else seeing this?

mtownsen

Posts: 785
Registered: 01/10/01
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie
Posted: Mar 2, 2006 3:42 PM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
We are tracking this. I will add this new information to the bug report we have for this. We need to be able to reproduce the problem consistently to debug. This new information will help. Thanks for your perseverance
mtownsen

Posts: 785
Registered: 01/10/01
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie
Posted: Mar 2, 2006 3:52 PM   in response to: mtownsen in response to: mtownsen
Click to report abuse...   Click to reply to this thread Reply
mcgoran - can you confirm that you can reproduce this in any browser, and not just Firefox ?
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie, Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _
Posted: Mar 2, 2006 4:13 PM   in response to: mtownsen in response to: mtownsen
Click to report abuse...   Click to reply to this thread Reply
Yes.
Only, Firefox shows download dialog box
while IE displays "IBMPC/WIN_NT-8.1.0"
but the core dump / log / trace files / 45sec lock / are the same.
Both browsers works perfectly straight even without reseting when language settings changes to en-us.

I even produced the same errors in wmvare 4.5.2 with plain XP SP1 with lforumID=251
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie, Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _
Posted: Mar 2, 2006 4:20 PM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
to continue... (something wrong with Post message button)

I even produced the same errors in wmvare 4.5.2 with plain XP SP1 with lforumID=251
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie, Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _
Posted: Mar 2, 2006 4:21 PM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
(once again to try to post the end of message)
I even produced the same errors in wmvare 4.5.2 with plain XP SP1 with last sec patches dated August 2005 and installing XE on it. Of course Regional and language options are set to GB. You should be able to do the same.
hopser2000

Posts: 53
Registered: 01/09/06
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie, Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _
Posted: Mar 3, 2006 7:44 AM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
Hi,

searched the forum for a while and found your message.

Have the same bug - I am using the Universal Edition on (german) Windows XP SP2 with IE 6. A page in my app has a submit button which causes an action using a db-link. Before switching to XE production version I used the Beta2 and this error did not occur.

Your workaround works now for me - but as you stated it's not really a solution. Hope we'll get a fix soon.
sandyit

Posts: 2
Registered: 04/17/06
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npierr+4
Posted: Apr 18, 2006 12:20 AM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
Hi All,
Have been trying to figure this one out for 3 days. I have had identical crashes in the shared server processes as you have described - mainly when using database links to Oracle 9i or 8.1.7 databases.

Your workaround also works for me - don't know how you figured it out but thanks alot.

Roger
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445
Posted: Apr 21, 2006 4:55 PM   in response to: sandyit in response to: sandyit
Click to report abuse...   Click to reply to this thread Reply
Must say, despite finding this "workaround" the crashes still happen esspecially when using db links to 8.1.7. In all other circumstances the workaround work "almost" flawlessly.

I had few pc machines where I tested XE and on some of them te problem almost never occured. So finding workaround was just matter of what's different comparing to machines where problem occured more frequently.
ChrisL

Posts: 18
Registered: 01/04/06
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445
Posted: Apr 26, 2006 2:06 AM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
I'm having the same problem with nl brouwser settings.
On both firefox and IE.

Where using w2003 on a VMware box can WMware couse the problem?
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445
Posted: Apr 26, 2006 11:09 PM   in response to: ChrisL in response to: ChrisL
Click to report abuse...   Click to reply to this thread Reply
No, VMware is not a problem. This happens regardless machine being physical or virtual.
ChrisL

Posts: 18
Registered: 01/04/06
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445
Posted: May 16, 2006 1:56 AM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
The bug went awy when i used en-us lang in my browser.
user476923

Posts: 10
Registered: 01/02/06
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npierr+4
Posted: Aug 4, 2006 7:35 AM   in response to: mcgoran in response to: mcgoran
Click to report abuse...   Click to reply to this thread Reply
Hi,

Did you find a "real" workaround to this problem ?
I have exactly the same message (IBMPC/WIN_NT-8.1.0) and error (ORA-07445) in alert_xe.log and setting the browser language to en-us is not a suitable workaround for all the users of our application ...
Do you have any clue now since this is an old problem (already existed in beta 3 version) ?

Thanks a lot for your collaboration, best regards.

Message was edited by:
user476923
mcgoran

Posts: 25
Registered: 01/03/99
Re: Universal edition choke on en-GB browser, core dumped, ORA-07445, _npie
Posted: Aug 4, 2006 8:03 AM   in response to: user476923 in response to: user476923
Click to report abuse...   Click to reply to this thread Reply
I still use XE and apex for my private projects so this was fix for me.
Therefore I haven't pressed this further.
But, as I stated it as well, it is not really "the solution".
We still wait for official solution.
We uploaded trace/log files few months ago when requested.
I haven't checked apex on other editions and haven't checked version 2.2.
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums