Oracle Error Requested Url
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Oracle: The requested URL was not found on this server. Oracle Database Tips by Burleson Consulting May 20, 2015 Question: I am getting this error in production: The requested URL /PROD/xxxxxxxxxxxxxxx was not https://docs.oracle.com/cd/A97337_01/ias102_otn/portal.102/a86707/chapter7.htm found on this server. Oracle-Application-Server-10g/10.1.2.2.0 Oracle-HTTP-Server Server at Port 443Not sure what to check, I checked the log files on OAS, couldn't find anything. Answer: It could be several issues causing "the requested URL was not found on this server" message: Add your database server IP address in your mail server (under "exceptions"). This http://www.dba-oracle.com/t_requested_url_not_found_server.htm will allow anonymous mail relay from the Oracle database server. You need to use https:\\ because port 443 is the standard secure port. Verify that your listener and HTTP server is running. You may have a permission problem. When directly accessing a package. (procedure) through the web interface you must grant execute on the package to public. Also, make sure to specify the full procedure name (schema.package.procedure). Debugging references: MOSC Note: 789659.1 - How To Generate A Stack Trace For Forms With Applications R12MOSC- Note: 743518.1 - Starting up AS10g services in an EBusiness Suite Release 12 environment Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. Burleson is the American Team Note: This Oracle docwas not found on this server I was trying out APEX function "Z", a so-called shorthand version of function HTMLDB_UTIL.COUNT_CLICK, an API tool http://oraclequirks.blogspot.com/2006/08/requested-url-was-not-found-on-this.html that enables an APEX developer to easily count clicks that users make to external sites (links that lead the user to different web sites), when i got the following https://books.google.com/books?id=DVolWOLddKwC&pg=PA143&lpg=PA143&dq=oracle+error+requested+url&source=bl&ots=HswRfc3yra&sig=yDzMUMPx1hWosSkdEeeL4OkVNIQ&hl=en&sa=X&ved=0ahUKEwis8cLFwuXPAhWBBSwKHfxABwgQ6AEIYjAJ message from the server:the requested URL /pls/htmldb/.z was not found on this serverAt first i was puzzled because i remember that i already got this function running previously, so oracle error how could it be that "Z" was no longer there?After checking all possible views, dropping and re-creating synonyms in all possible manners, invoking it with or without the schema prefix, function Z was still baffling me with its tedious "URL not found" message.To make it more frustrating, i tried out its "verbose" equivalent HTMLDB_UTIL.COUNT_CLICK and it worked oracle error requested like a charm!Then, suddenly and unexpectedly, there was a light at the end of the tunnel.A thought came through my mind and it was telling me: "check out the parameters!"Even if the very same parameters were working correctly with HTMLDB_UTIL.COUNT_CLICK, a quick review of Z's parameters showed that p_workgroup wasn't existing at all, being replaced by its "equivalent" p_company.Needless to say, as soon as i renamed the wrong parameter, Z started working too.Most likely the reason behind the parameter names inconsistency is what is normally called "backward compatibility problem".There was a time when probably only function Z was existing, a sort of jurassic htmldb.Then, in a subsequent release or era, a packaged version of the API was provided, but for some reason, the parameter was renamed (or evolved...).Then, HTMLDB was made available to the public and it was too late to change it.And now you know what a typical "backward compatibility quirk" looks like.Happy counting! Posted by Byte64 at 16:25 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Apex, Apex_uti
van GoogleInloggenVerborgen veldenBoekenbooks.google.nl - If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology....https://books.google.nl/books/about/Oracle_Internals.html?hl=nl&id=DVolWOLddKwC&utm_source=gb-gplus-shareOracle InternalsMijn bibliotheekHelpGeavanceerd zoeken naar boekeneBoek kopen - € 93,36Dit boek in gedrukte vorm bestellenCRC PressBol.comProxis.nlselexyz.nlVan StockumAlle verkopers»Oracle Internals: Tips, Tricks, and Techniques for DBAsDonald K. BurlesonCRC Press, 30 jul. 2001 - 896 pagina's 0 Recensieshttps://books.google.nl/books/about/Oracle_Internals.html?hl=nl&id=DVolWOLddKwCIf you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology. You need Oracle Internals: Tips, Tricks, and Techniques for DBAs.Oracle has evolved from a simple relational database into one of the most complex e-commerce platforms ever devised. It's not enough for you to understand just the Oracle database. You must also understand the components of the Web server technology, XML, Oracle Security, Oracle and Java, and a host of other issues in order to do your job properly. This book is a compendium of the best and most useful articles from Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators and other Oracle professionals. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information not found in any other book, information only available from peers and consultants. The chapters focus on the truly tough stuff - proven techniques learned in the trenches. You could get this information from other sources, but you'd have to hunt and peck for it. Can you