Configure Apache Tomcat to support ORDS web service - Intergraph Smart Materials - 10.3 - Installation & Upgrade - Hexagon

On the Apache Tomcat server, download Oracle Rest Dataservices to c:\tmp.

Extract ords.xx.x.x.xx.xxxx.zip to <tmp> folder.

For example:

ords-23.1.2.115.1944.zip or the latest version.

<tmp>: c:\tmp

Create a ords_config directory to store ORDS configuration data in <apache_home>\<ords_config>.

Create new system variable

_JAVA_OPTIONS = -Dconfig.url=<PATH_TO_ORDS_CONFIG_FOLDER>

For example:

Open a Command Prompt window as an administrator.

On Tomcat 9.x, perform the following steps to deploy Apache Tomcat:

• Navigate to <apache_home>\<ords.version> in Windows Explorer.

• Create copy of ords.war

• Rename copy of ords.war to apex.war.

• Copy the file apex.war from the <apache_home>\<ords.version> directory to the <apache_home>\webapps\ directory.

Change directory to <apache_home>\webapps\.

For example: C:\Apache\webapps

Execute the following command:

Run:

ords --config #PATH_TO_ORDS_CONFIG_FOLDER# install -i

for example:

ords --config C:\Apache-Tomcat-9\ords_config install -i

Enter the following information:

ORDS: Release 23.1 Production on Thu Sep 14 12:36:06 2023

Copyright (c) 2010, 2023, Oracle.

Configuration:

/C:/Apache-Tomcat/ords_config/

The configuration folder C:\Apache-Tomcat\ords_config does not contain any configuration files.

Oracle REST Data Services - Interactive Install

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]: 2

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]: 1

Enter the database host name [localhost]: AzDorD-PI-DB04

Enter the database listen port [1521]:

Enter the database service name [orcl]: pl104d.world

Provide database user name with administrator privileges.

Enter the administrator username: sys

Enter the database password for SYS AS SYSDBA: <PASSWORD>

Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//<FQDN>:1521/SMAT.WORLD

Retrieving information.

Enter the default tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [SYSAUX]:

Enter the temporary tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [M_TEMP]:

Enter a number to select additional feature(s) to enable:

[1] Database Actions (Enables all features)

[2] REST Enabled SQL and Database API

[3] REST Enabled SQL

[4] Database API

[5] None

Choose [1]: 1

Enter a number to configure and start ORDS in standalone mode

[1] Configure and start ORDS in standalone mode

[2] Skip

Choose [1]: 2

Start SQLPLUS and connect as SYS user.

Unlock all APEX and ORDS accounts and set the passwords as configured above (replace <..._password> accordingly):

alter user apex_rest_public_user identified by <apex_rest_user_password>;

alter user ords_public_user identified by <ords_public_user_password>;

alter user apex_public_user identified by <apex_public_user_password>;

alter user apex_listener identified by <apex_listener_password>;

alter user apex_rest_public_user account unlock;

alter user ords_public_user account unlock;

alter user apex_public_user account unlock;

alter user apex_listener account unlock;

Check the configuration files at <apache_home>\<ords_config>\apex.

These files should be in the databases\default subfolder:

• pool.xml

• wallet\cwallet.sso

This file should be in the global subfolder:

• settings.xml

Restart the TOMCAT service.

Open the following URL in a browser:

http://<servername>:9090/apex

If problems occur, see Troubleshooting.