Apex 404 Error
Contents |
Previous Next → Oracle APEX: Got a 404 Not Found? Posted on April 3, 2008 by Patrick Wolf Maybe you also already got the 404 Not Found error message The requested URL /pls/apex/wwv_flow.accept was the requested url /apex/wwv_flow.accept was not found on this server not found on this server. when you submit an Oracle APEX page, … There
The Requested Url /apex/wwv_flow.show Was Not Found On This Server
are a lot of reasons why this error can occur. But the above error message doesn't tell you a lot about oracle apex wwv_flow.accept error the root cause of the problem. The real error message can be found on your Apache Web server in the Apache\Apache\logs\error_log.xxxxx file. There you will find and entry like [Thu Apr 3 ...] mod_plsql: /pls/htmldb/wwv_flow.accept HTTP-404 oracle apex url not working wwv_flow.accept: SIGNATURE (parameter names) MISMATCH VARIABLES IN FORM NOT IN PROCEDURE: P_T02XXX NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: Without the above information, you have no chance to find out what's causing the 404 error. But the problem is, that most developers don't have access to the application server. You don't have to! Just put
Ords 404 Not Found
get the error message directly in your browser. For more details about PlsqlErrorStyle, have a look at the documentation. Note: Only use this setting on developments systems, because on production systems a hacker might get more information as he should! Credit for this tip goes to Dietmar Aust!
This entry was posted in Tips & Tricks and tagged 404 by Patrick Wolf. Bookmark the permalink. 9 thoughts on “Oracle APEX: Got a 404 Not Found?” Pingback: Fehler 404 - die Lösung | Der Oracle APEX Experten Blog daneska on December 15, 2009 at 12:14 said: Hi, Patrick! And what if I use apex with embedded pl/sql gateway. There is no Apache web server outside. In this case, where these log files with errors description could be placed? I have no idea though I need it indeed. samson on February 18, 2010 at 08:13 said: Hi Patrick, I have the same problem like daneska. My problem (look at http://www.htmldb.de/htmldb/read.php?4,2078) can not be identified. Where can I find some errormessages in this case? Kindly regards Samson Patrick Wolf on February 19, 2010 at 11:59 said: Hi Samson and Daneska, have a look at http://blog.oracleapex.at/fehler-404-die-losung/ which explains how you can do that for the Embedded PL/SQL gateway (EPG) as well. You just have to ethe class troubleshoot an APEX issue. He received a 404 error sporadically. How do you find the database error which caused the oracle rest data services 404 not found Apache to show the 404-error? Usually the error is found in the Apache error log. But you can also configure the mod_plsql to show more detailed information in the browser. This is very useful but should only used in development environments due to security reasons. Patrick wrote a nice blog posting about it. But using Oracle Express Edition (XE) you don't have http://www.inside-oracle-apex.com/oracle-apex-got-404-not-found-2/ an Apache / mod_plsql configuration. How do you find the errors here? Since Oracle XE uses the http listener of the XMLDB, it needs to be configured through the DBMS_EPG interface. The documentation can be found here.To see the error log similar to Apache, logon as SYSTEM via SQL*Plus and execute: SQL>execute dbms_epg.set_global_attribute('log-level', 3); The error log will go to the database trace http://daust.blogspot.com/2008/04/troubleshooting-404-not-found-error-on.html file app/oracle/admin/XE/bdump/xe_s00?_????.trc.Please ignore the bogus error message "Embedded PL/SQL Gateway: Unknown attribute 3" in the error log.The log levels are:0 - LOG_EMERG 1 - LOG_ALERT 2 - LOG_CRIT 3 - LOG_ERR 4 - LOG_WARNING 5 - LOG_NOTICE 6 - LOG_INFO 7 - LOG_DEBUG To turn off the error logging, execute the following as SYSTEM:SQL>execute dbms_epg.set_global_attribute('log-level', 0); In order to show the error messages in the browser, you would configure parameter error-style using the DBMS_EPG.Almost all parameters of the mod_plsql are configurable in the DBMS_EPG, too. They are just named differently (why?). You can find the mapping in the Oracle documentation.So, how can we enable the debug style messages in XE. It is easy, just connect as SYSTEM to the database and issue the following command:SQL>exec dbms_epg.set_dad_attribute('APEX', 'error-style', 'DebugStyle'); In order to revert to the standard message format, issue:SQL>exec dbms_epg.delete_dad_attribute('APEX', 'error-style'); Then your browser will show the following error message instead of the standard 404-error page:That's it.Now I have shown how to configure the DAD for XE, but how can you see the current configuration? My next post will cover these instructions.Regards,~Dietmar. Gepostet von Dietmar Aust
version 3.2.1.00.10, on a 10.2.0.3-database is working fine for some time. Then, while clicking the ‘application builder' home-page, we got the ‘page not found'-error in the browser. Logging of Apache shows: mod_plsql: /pls/apex_schd/f HTTP-404 ORA-03113: end-of-file on communication channel\n mod_plsql: Unable to reset state http://www.jobacle.nl/?p=604 for mode 0: Err 3114 url=>/pls/apex_schd/f Restarted the http-server and webcache: no result. Configured the same apex on another application server, pointing to the same database: no result. Allright, database alert-file shows: ORA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] There were no changes (really, there weren't…) in the not found past few days. Points out to be a bug in 10.2.0.3 (with any version of Apex): bugnr 5745817 : "Implementing regular flushes of the shared pool can prevent the problem from occurring. The problem is fixed in 11g via non-published bug:5648872 and the fix is included in 10.2.0.4." (note 418531.1) The patch is also available: 5648872 For the requested url the time being, ‘alter system flush shared_pool' is fine for me, until we upgrade to 10.2.0.4 (or 11gr2 of course… 🙂 ). By Job| 2009-10-26T13:04:48+00:00 October 26th, 2009|Categories: App. Server, Database|Tags: Database|1 Comment Share This Story, Choose Your Platform! FacebookTwitterLinkedinRedditTumblrGoogle+PinterestVkEmail About the Author: Job Related Posts Permalink Gallery Save money by understanding the Oracle licensing model - part I Permalink Gallery Connect Oracle Enterprise Manager 13 to Amazon’s Cloudwatch Permalink Gallery Implementing ORAchk in Oracle Enterprise Manager 13c One Comment Vinodh March 20, 2012 at 11:07 am Thanks for the suggestion. We were facing the same issue and your suggestion helped us to solve this issue. Thanks once again. Best Regards, Vinodh Leave A Comment Cancel reply Comment Blogroll Ahmed Baraka - DBA notes Alejandro Vargas AMIS technology blog Asktom Certification news - blogs.oracle.com Fuad Arshad Grid Control - Rob Zoetewij Harald v. Breederode Jacco Landlust - Jack of all trades Jonathan Lewis License information Orafaq - sources Orainternals Oratube.nl RAC - scripts / articles rman backup site