Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
after installing ORDS 22.1 can't access apex

Windows 10 based VM, (1) Oracle DB 21c XE, (2) Apex 22.1, (3)Java 11, (4) Apache Tomcat 9 (5) Ords 22.2 (number mentioned are sequence of installations)
checked @thatJeffSmith-Oracle blog and tried to install ORDS 22.2
Apex in: c:\apex
Ords in: c:\ords and config folder: c:\ords\conf
Java in: c:\java
ords path sets in system variables c:\ords\bin
everything installed successfully, during installation of ords using "ords --config c:\ords\config install", there was no error, it means provided credentials was correct and it can create all objects in database (xepdb1)
then copied following contents:
copy c:\ords\ords.war C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps
copy c:\apex\images\* C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\i\
when in browser i entered localhost:8090/ it was fine (to check Tomcat is running) but when enter localhost:8090/ords/ it is showing below error:
is there anything i missed or something am doing wrong? if i did anything wrong, now how i can resolve? please help.
regards
please also check these prompts and my selections (some are selected defaults, just pressed enter key):
Enter a number to select the type of installation [1] Install or upgrade ORDS in the database only [2] Create or update a database pool and install/upgrade ORDS in the database [3] Create or update a database pool only Choose [2]: 1 Enter a number to select the database connection type to use [1] Basic (host name, port, service name) [2] TNS (TNS alias, TNS directory) [3] Custom database URL Choose [1]: Enter the database host name [localhost]: Enter the database listen port [1521]: Enter the database service name [orcl]: XEPDB1
Best Answer
-
You have entered wrong password and/or user when configuring pool. Or database user you have used (ORDS_PUBLIC_USER) is locked or password is expired.
Check that ORDS_PUBLIC_USER is not locked and make sure you have entered correct password to configuration.
You can change database user password and then set it for pool
ords --config c:\ords\config config secret db.password
Answers
-
Have you specify where configuration files located?
-
thanks @jariola
it is metioned in my post:
during installation of ords using "ords --config c:\ords\config install", there was...
regards
-
During install you have told where store config files. Tomcat don't know anything about that.
You need set JAVA_OPTS Dconfig.url as documentation says.
-
please help, how i can set it in Windows environment , also how to for creating config.url?
export JAVA_OPTS="-Dconfig.url=/scratch/my_ords_config"
regards
Is it correct as per my installations? set JAVA_OPTS="-Dconfig.url=c:\ords\config"
-
Sorry, I don't know how it's done in Windows.
Google how set environment variables in Windows for Tomcat.
-
thanks @jariola for your help.
regards
-
configure environment variable as JAVA_OPTS as name and -Dconfig.url=c:\ords\config as value, stop and start Apache Tomcat, in browser trying to access localhost:8090/ords/ but still the same error appears.
i checked the c:\ords\config folder is empty, is there any problem that for some reasons, it failed to create configuration file... if any?
as per Tim Hall guide lines i tried creating environment variable JAVA_TOOL_OPTIONS and run but got same error.
still looking for help.
regards
-
Have you try rerun command ords --config c:\ords\config install and see do you get configuration files to that directory?
When you run that command, it should also output what directory is used for configuration.
-
-
Now I noticed from output you did post, it seems you have select [1] Install or upgrade ORDS in the database only. Meaning you don't even like to have configuration files for pool.
Enter a number to select the type of installation [1] Install or upgrade ORDS in the database only [2] Create or update a database pool and install/upgrade ORDS in the database [3] Create or update a database pool only Choose [2]: 1
You need chose [2] Create or update a database pool and install/upgrade ORDS in the database order to get also configuration files