Forum Stats

  • 3,728,418 Users
  • 2,245,612 Discussions
  • 7,853,515 Comments

Discussions

ORDS - 503 Service Unavailable (connection type TNS)

user5535076
user5535076 Member Posts: 5 Blue Ribbon

Hello!

Please, I need your help. I need connect to Oracle Apex using Tomcat and Ords.

When I access to url http://localhost:8080/ords/ of Ords Rest data services the error occurs

503 - Service Unavailable

ORDS was unable to establish a connection to the database. This can occur if the database is not available, the maximum number of sessions has been reached, or the pool has not been configured correctly. The connection pool named: | apex || has the following errors: I / O error: Unknown host specified (CONNECTION_ID=fiRwmzLwT8S7xAp9EqqudA==)


Thank you!!!


Architecture Details

SERVER 1: Database Oracle 11g with Oracle Apex 20.2

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE  11.2.0.4.0   Production

TNS for 64-bit Windows: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production


SQL> select * from apex_release;

VERSION_NO    API_COMPATIBILITY  PATCH_APPLIED

---------------- ------------------- --------------------------

20.2.0.00.20   2020.10.01     APPLIED


SERVER 2: ORDS Rest Data Services 20.4.3.r0501904 with Tomcat 9 

SQL> select ords.installed_version  from dual;

INSTALLED_VERSION

-----------------------------

20.4.3.r0501904


ORDS installation without errors

ORDS installation was done with TNS option

TOMCAT 9 - Ir running without errors


Stack Trace

ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[ORDS no ha podido establecer una conexión con la base de datos.  Esto puede ocurrir si la base de datos no está disponible, se ha alcanzado el número máximo de sesiones o el pool no se ha configurado correctamente. El pool de conexiones denominado: |apex|| presenta los siguientes errores: Error de E/S: Unknown host specified (CONNECTION_ID=fiRwmzLwT8S7xAp9EqqudA==) ]]

at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:48)

at oracle.dbtools.http.errors.ResponseRenderer.<init>(ResponseRenderer.java:75)

at oracle.dbtools.http.errors.ResponseRenderer.<init>(ResponseRenderer.java:61)

at oracle.dbtools.http.errors.ResponseRenderer$Builder.build(ResponseRenderer.java:229)

at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:108)

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:733)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: oracle.dbtools.url.mapping.TargetNotAvailableException: ORDS no ha podido establecer una conexión con la base de datos.  Esto puede ocurrir si la base de datos no está disponible, se ha alcanzado el número máximo de sesiones o el pool no se ha configurado correctamente. El pool de conexiones denominado: |apex|| presenta los siguientes errores: Error de E/S: Unknown host specified (CONNECTION_ID=fiRwmzLwT8S7xAp9EqqudA==) 

at oracle.dbtools.url.mapping.db.PoolInjector.inject(PoolInjector.java:64)

at oracle.dbtools.url.mapping.db.PoolInjector.inject(PoolInjector.java:49)

at oracle.dbtools.url.mapping.db.DatabaseURLMappingBase.injectPLSQLGatewayConnection(DatabaseURLMappingBase.java:919)

at oracle.dbtools.url.mapping.db.DatabaseURLMappingBase.addServices(DatabaseURLMappingBase.java:346)

at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:73)

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:39)

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)

... 35 more

Sign In or Register to comment.