Hi,
I have installed Oracle Database 19c(WINDOWS.X64_193000_db_home), and Oracle APEX 20.2. After that I installed ORDS(ords-19.2.0.199.1647).
Now when I tried to open the http://localhost:8080/ords/
I am getting the below error.
503 Service Unavailable
The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked
Also the error in the Tomcat console is :
----------------------------------------------------------------------------------
15-Jan-2021 02:37:36.659 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
15-Jan-2021 02:37:36.858 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [538] milliseconds
15-Jan-2021 02:37:36.877 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
15-Jan-2021 02:37:36.878 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.41]
15-Jan-2021 02:37:36.893 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\ords.war]
15-Jan-2021 02:37:40.803 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
15-Jan-2021 02:37:43.656 WARNING [main] . The pool named: |apex|| is invalid and will be ignored: The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked
15-Jan-2021 02:37:44.728 WARNING [main] . The pool named: |apex|al| is invalid and will be ignored: The username or password for the connection pool named |apex|al|, are invalid, expired, or the account is locked
15-Jan-2021 02:37:45.133 INFO [main] . Configuration properties for: |apex|pu|
db.hostname=localhost
db.password=****
db.port=1521
db.servicename=orcl
db.username=ORDS_PUBLIC_USER
resource.templates.enabled=true
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
15-Jan-2021 02:37:45.137 WARNING [main] . * jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment *
15-Jan-2021 02:37:45.138 WARNING [main] . * jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment *
15-Jan-2021 02:37:46.869 WARNING [main] . The pool named: |apex|rt| is invalid and will be ignored: The username or password for the connection pool named |apex|rt|, are invalid, expired, or the account is locked
15-Jan-2021 02:37:47.157 INFO [main] . Oracle REST Data Services initialized
Oracle REST Data Services version : 19.2.0.r1991647
Oracle REST Data Services server info: Apache Tomcat/9.0.41
15-Jan-2021 02:37:47.172 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\ords.war] has finished in [10,280] ms
15-Jan-2021 02:37:47.173 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\docs]
15-Jan-2021 02:37:47.189 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\docs] has finished in [16] ms
15-Jan-2021 02:37:47.190 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\examples]
15-Jan-2021 02:37:47.432 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\examples] has finished in [242] ms
15-Jan-2021 02:37:47.432 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\host-manager]
15-Jan-2021 02:37:47.454 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\host-manager] has finished in [22] ms
15-Jan-2021 02:37:47.454 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\i]
15-Jan-2021 02:37:47.470 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\i] has finished in [16] ms
15-Jan-2021 02:37:47.471 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\manager]
15-Jan-2021 02:37:47.493 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\manager] has finished in [22] ms
15-Jan-2021 02:37:47.493 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\ROOT]
15-Jan-2021 02:37:47.509 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Tomcat\apache-tomcat-9.0.41-windows-x64\apache-tomcat-9.0.41\webapps\ROOT] has finished in [16] ms
15-Jan-2021 02:37:47.511 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
15-Jan-2021 02:37:47.517 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [10660] milliseconds
The user status in the database is as shown below:
-------------------------------------------------------------------------------------------------
ORDS_METADATA OPEN
ORDS_PUBLIC_USER OPEN
PDBADMIN OPEN
HR OPEN
APEX_REST_PUBLIC_USER OPEN
SYSTEM OPEN
APEX_PUBLIC_USER OPEN
SYS OPEN
ANONYMOUS OPEN
APEX_INSTANCE_ADMIN_USER OPEN
APEX_LISTENER OPEN
APEX_200200 OPEN