Oracle APEX ORDS升级导致404链接错误

fjaof16o  于 2023-02-15  发布在  Oracle
关注(0)|答案(1)|浏览(309)

Sys管理员刚从OHS升级到ORDS。我对ORDS不熟悉。我只是做一些Oracle APEX工作。我们有一些打开.pdf文件的链接，但我们收到404错误。我们启用了调试跟踪，但我没有任何进展。您知道是什么原因导致了这个问题吗？
运行：APEX版本：19.2.0.00.18
订单版本：20.4.3.r0501904
以下是调试跟踪：

[TE] url-mapping start: 2023-02-07T22:40:53.255943269Z duration: 0ms
 Could not find any dispatcher to handle request:
--Attributes--
oracle.dbtools.http.servlet.UriRequest = UriRequest [uri=https://www.test.com/vmdbagnt/plsql/Gate_Keeper.Get_Drawing_File/DART/CHRISORDS/J/2B945/17-JAN-2023/pg1/drawings/2B945_CHRISORDS_J.PDF, contextPath=/vmdbagnt/plsql]
oracle.dbtools.http.ecid = undX91G7JdD8dh5ZbntHtw
oracle.dbtools.common.di.Services = URL Mapped Scope
oracle.dbtools.plugin.api.di.InstanceLocator = URL Mapped Scope
--Attributes--
GET [/vmdbagnt/plsql]/Gate_Keeper.Get_Drawing_File/DART/CHRISORDS/J/2B945/17-JAN-2023/pg1/drawings/2B945_CHRISORDS_J.PDF HTTP/1.1
Host: www.test.com
host: www.test.com
connection: keep-alive
sec-ch-ua: "Not_A Brand";v="99", "Google Chrome";v="109", "Chromium";v="109"
sec-ch-ua-mobile: ?0
sec-ch-ua-platform: "Windows"
upgrade-insecure-requests: 1
user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36
accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
sec-fetch-site: same-origin
sec-fetch-mode: navigate
sec-fetch-user: ?1
sec-fetch-dest: document
referer: https://www.test.com/vmdbx/f?p=DART:QUERY:11551677945868::NO:::
accept-encoding: gzip, deflate, br
accept-language: en-US,en;q=0.9
cookie: _ga=GA1.2.2088229043.1633182967; _4c_=fVFNj5swFPwrK59jMMb4I7dqK7W9VHupekRgnMW7BCPbgaar%2FPc%2BJySRNlKRQH7DvPF7Mx9o6c2ItgUvy0IyWlWiUBv0bo4BbT%2BQntJ3Tp%2BDH9AW9TFOYZvny7JkYxOa7NXNedO6Q8x7%2B9oP8MaQf3%2BpX7ydG33M%2Brgf0AZp1xloL1QmMwF1%2FAsVLgmB8%2BRdd9CxjscpcRbTPoXuHX50Zrba1IvtYn9upuSO9ibdlWAiz%2FDkUwGnxY6dWz63reitTRX0LDbY2fhjHbwGcHSjAbQ1sYHqZzp6twSTpJ977%2FbmSTFAHbiDfp8VA5Te7Iz3Z9bVIBsCTia9BX03CqjBxrTkFVoR8HsF8QWcwHOUbhqcbobUASkB1%2BhoHeSF9o1NwLcv9a8fX6GmREpKFWFldsmSKi7QaYP%2BXMKlgvCKESHB%2BwhJSs5IeoDhbbemjGRHy1IUBvOWSMy0UbjlTYuZ7LTYacl3lKNVkxFVScVlxSiIzPaqQU3blkZwXDVFiZkQOyxJ2WDNWkMp75jgBN3mKiQnMBdX61yFvI41DaticScrUcKFil%2FJ7LbENK9s9rCyeFz5kmry8D99D1adTv8A; __utma=259910805.2088229043.1633182967.1651074519.1651074519.1; CFID=Zj3v2hrl7z9lq9mgcvittenrtbn7k0cm07xmisu1ajz3hpbnbe-284129; CFTOKEN=Zj3v2hrl7z9lq9mgcvittenrtbn7k0cm07xmisu1ajz3hpbnbe-59216697; LastMRH_Session=f101ed89; SBXSESSION=uz83F3fZLTbgcDGNHQtc4qT20jqtPU0/wMl+v1vN2yz7sWYmagMLVxox0KS99a3hVR4pUNbABLeTUxKGzjNTC78JZd39NoBuxMb+ED6fAKiNCfOVZJSGM2hn4CHb0X+VeSD40Pg+fqRvMiXnPcOhUA9FFixRQvHqjEbt1SOYLYy16vv0NMeUboTF0sfq5cKlwXkiPp9kTQhmgAPEzYidL9kzsXIncYf+Qc7ElNxA6VYzAiEACwIY2+yNXe6Qi6nMlUhJ6aDL44mVwrEZ/1yZ0n+TwVujlyKgJk4Mas7Hog/47cS7AyACm8aTtVP0PQskr1rCQm+1/8uutjM4JPeVQodFbX67y4z5i7iKOx1JjOAfQ0QtfF4ow8c7IYAUnp9F9KsXj9q8aCLQzEnxH3tXDK7HRbU4o9Hqxey4oxwf2weOPBX3bEkv8QreODTu3sjACxFZdtOKVNE9rhM85L8BJ+yuYuyTgbY3NX4gFITAdymjF6nVSsMi2u5VBMJd1+4OqXkhh9frb47HvWhXCylh+EM8iuY6PKRrvPmP1ujm3vt7GrOGu48AKjrWY061bVfONmQyIPU/UzfZHBwZcLvGifxe0DRbcE/4qP0FuiKke4qhZwEX46DdW6kEJVXI+tRcmbKxcOh3vhkNwFjpdpm5S0+HlmzQUQmDh0rbAV7g4Aq73IwmmrbfwMjKockLvJio8KF0NHErGPYBJbnOCPRywZDI4374GQDWCHqm7f4fMki+4P46VRWKkf8zXjXQDXnsIHHDKKwjdqfw7oZp5cgfxUwKbDV65sttaezyRQVpftDUknEBEJqxWLNTmUC260a1VuDmqx7TZKiDDWDNMqGKb7+U5Hobac/oQzgz33CHJ9C0pQqQ1kgypj7ottXr/SyVv+Mc6yBltBXcV1HLAabVzP0wwiOfpEM02iMAXScoasGaV9K5jTeje0JizQpVEWPPdUc5VmEknJRJU3otLA8ntos1Tnie71fbkIlXLEx47ZXmVCRkj7mQ/9SrSk+Q46N149hPSKVbdGMmT8Lod4OLySZK2ngyRfsRMXjoX7QpobJhEF1OUDhVxzkskrlq0Eti; F5_ST=1z1z1z1675807062z604800; iss-BigIP-sb=1543700746.42271.0000; SMSESSION=eQG4Qu3lBCY7iV2l0bZ9sQ248+0NFAckScam6d2rOfDYPBrzLo7V3AHXLDN8NBWdDO0K/bj7TMgF+poT+sYVLGcQkhD8lueg3P+wOdjMH3qj753cKKAljgENSnSCbVoY1QPjiGkvuJPWWfcFHnZw88qQVymiqGMalxdYpd1JGExp85pCQW/wL3/9bZJwRKpMWgzt4hEq7Eoe1edfcUdXbQx2bP9UtZx53YTQu7isMP2JUctCRXQDC/rU3WFiiXOqMaJMW2K/xC//9bWtf+WlmOStFg1f5vUwrZcTqT/1I5JUJzSc/MgR8JG3KYa64KcX2d7hfPxiHeKn7eFVN6oPCkK1bWFtb96z93llPF52mkPqly9XF/4/C2epvkjxetYCa/cVI/yQwXrY90yaLvqMWWjshMniLzql+oWwEJgN7kxo3p1/ERMapq/2IjWRwC9pmPhc531nOU6WzZyqo79z8snbwMElHkdzXT62y8O2KKJia5vBaE/M7MuGvUTZgDV5yOmsAqLfbO6WaCXaI803G+8CskiNG7hCkqkWfGj//yxMMYxlGjPwaAn58BzMV6hnkDUAmauip3L330Jn0yARGou10nmtQFgUjy7TADi309mI8dwFbom5f1YdP7Ps3+MbaavK4ZsNFU/Eu2pZvmF52jSHA7OaquRszOoNx4bgQhuCSBQys5XtI3pRimo7Jgl8jakWfYWtRUUr/ZZdmrwJRwZP75Onb7KtP1f02OINNHVUOehgscQikiXLtJYZvkEz/aZaZGB0+Kc5JxTfcThm1LyIXLwnmqf8U8zvISHJqTSYFZ9tfl03VzI4B5wZ302C9hb2YtyVEP0I20NXaFir8Ub3/7RV+7aPgvQiiHmF+4idx14icVcTWoIt2Omp/8a7MM7gI/ce/SNBkaN39bhpd3XP8ynC0GAHZx9/BL3Rjjum8Inh3u5NYuPfSAsmHAaF+tNvB0FjoVDx6yucrfMelwIAoYh07hfpK25aZHCd3wl8JYWnCS8BXC9mXcnL2zLqGVwZB0HqgBX8zvNimxNx7yZUh5Y3QmfwKNl7mnZkw2tcGmrK+y2r23hzJSLkIZho
x-forwarded-for: 129.50.109.4'

DispatcherNotFoundException [statusCode=404, logLevel=FINER, reasons=[]]
    at oracle.dbtools.http.entrypoint.Dispatcher.choose(Dispatcher.java:78)
    at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:89)
    at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:170)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:73)
    at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:90)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:68)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:68)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:75)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:101)
    at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:64)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.url.mapping.RequestMapperImpl.doFilter(RequestMapperImpl.java:158)
    at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:86)
    at oracle.dbtools.url.mapping.db.DatabaseTenantMapping.dispatchSelf(DatabaseTenantMapping.java:189)
    at oracle.dbtools.url.mapping.db.DatabaseTenantMappingBase.doFilter(DatabaseTenantMappingBase.java:50)
    at oracle.dbtools.url.mapping.defaultpool.LegacyDatabaseTenantMapping.doFilter(LegacyDatabaseTenantMapping.java:46)
    at oracle.dbtools.url.mapping.tenant.TenantMappingDispatcher.dispatch(TenantMappingDispatcher.java:52)
    at oracle.dbtools.url.mapping.tenant.TenantMappingFilter.doFilter(TenantMappingFilter.java:75)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.forwarding.ForwardingFailedFilter.doFilter(ForwardingFailedFilter.java:41)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.rt.authentication.apex.ApexSessionQueryRewriteFilter.doFilter(ApexSessionQueryRewriteFilter.java:58)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:90)
    at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.filters.AbsoluteLocationFilter.doFilter(AbsoluteLocationFilter.java:65)
    at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.auth.external.ExternalAccessValidationFilter.doFilter(ExternalAccessValidationFilter.java:59)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:87)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)
    at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
    at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
    at oracle.dbtools.http.filters.Filters.filter(Filters.java:67)
    at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:70)
    at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:125)
    at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
    at ApmCamsValve.invoke(ApmCamsValve.java:78)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.base/java.lang.Thread.run(Thread.java:833)
oracle

1条答案

按热度按时间
a8jjtwal

a8jjtwal1#

我的第一个答案是.... a.你为什么不去问系统管理员，而不是论坛上的陌生人呢？他们很可能是按照文档（https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.4/orddg/migrating-mod_plsql-ords.html）
然后...阅读日志。即使你不知道订单，它也会给你很多信息。
在日志中可以看到，引用URL为“https://www.test.com/vmdbx/f?p=DART:QUERY:11551677945868::NO:::“，这是您的顶点URL，路径为“vmdbx”。但请求指向的URL类似于“https://www.test.com/vmdbagnt/plsql/Gate_Keeper.Get_Drawing_File/DART/CHRISORDS/J/2B945/17-JAN-2023/pg1/drawings/2B945_CHRISORDS_J.PDF“。在该URL中，路径为“vmdbagnt/plsql”。我猜测此路径是在OHC中配置的，但尚不存在/在ORDS中命名不同
pl/sql网关需要在ORDS中配置，就像在OHC中配置一样。这意味着您将告诉ords：“如果我为您提供此路径，则以该用户身份连接到数据库并执行过程”。如果迁移正确完成，则此操作已经完成，但可能需要您进行一些更改，因为pl/sql网关的路径不再是“vmdbagnt/plsql”。但是...只有系统管理员才有此信息。

赞(0）分享  回复(0）举报  2023-02-15
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com