after installing ORDS 22.1 can't access apex

SmithJohn45

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

https://www.thatjeffsmith.com/archive/2022/04/oracle-rest-data-services-version-22-1-read-the-readme/

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

jariola

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

jariola

Have you specify where configuration files located?

https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.2/ordig/deploying-and-monitoring-oracle-rest-data-services.html#GUID-BAF6F648-4748-4E1E-99CF-321252A063AE

SmithJohn45

thanks @jariola

it is metioned in my post:

during installation of ords using "ords --config c:\ords\config install", there was...

regards

jariola

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.

SmithJohn45

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"

jariola

Sorry, I don't know how it's done in Windows.

Google how set environment variables in Windows for Tomcat.

SmithJohn45

thanks @jariola for your help.

regards

SmithJohn45

@jariola

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.

https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat-22-onward

still looking for help.

regards

jariola

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.

SmithJohn45

@jariola

yes, there was an output which mentioned this config path, but its empty.

regards

jariola

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