Configure Apache Tomcat to support ORDS web service - Intergraph Smart Materials - 10.6 - 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-24.4.0.345.1601.zip or the latest version.

<tmp>: c:\tmp

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

A Java_options parameter has to be added to the Java Options of Tomcat application.

• Start a Terminal as an Administrator and go to <apache_home>\bin directory.

• Execute: tomcat9w //ES/<apache_servicename>.

  Example: tomcat9w //ES/Tomcat9.

• Add the entry -Dconfig.url=<PATH_TO_ORDS_CONFIG_FOLDER> at the end of “Java Options”.

  Example: -Dconfig.url=C:\apache-tomcat\ords_config

Open a Command Prompt window as an administrator.

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

• Navigate to <tmp>\<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 <tmp>\<ords.version> directory to the <apache_home>\webapps\ directory.

Change directory to <tmp>\<ords.version>\bin.

For example:C:\tmp\ords-24.4.0.r3451601\bin.

Execute the following command:

Run:

ords --config <PATH_TO_ORDS_CONFIG_FOLDER> install -i

for example:

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

Enter the following information:

Please be aware that if you are using a newer Oracle REST Data Services, then this can´t reflect in the Installation Guide, follow the Oracle guidelines

If ORDS installer have access to a TNSNAMES.ORA you will this get choice otherwise you has to

add database connection

Enter a number to select the TNS net service name to use from C:\oracle\19c_Sta\db\network\admin\tnsnames.ora or specify the database connection

[1] CDB SERVICE_NAME=CDB

[2] ORACLR_CONNECTION_DATA SID=CLRExtProc

[3] SMAT.WORLD SERVICE_NAME=SMAT

[S] Specify the database connection

Choose [1]: 3

Choose your database or add a new connection

ENTER your DB connection

Provide database user name with administrator privileges.

Enter the administrator username: sys

Enter the database password for SYS AS SYSDBA:

Retrieving information.

ORDS is not installed in the database. ORDS installation is required.

Enter a number to update the value or select option A to Accept and Continue

[1] Connection Type: TNS

[2] TNS Connection: TNS_NAME=SMAT.WORLD TNS_FOLDER=C:\oracle\19c_Sta\db\network\admin

Administrator User: SYS AS SYSDBA

[3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <generate>

[4] ORDS runtime user and schema tablespaces: Default: SYSAUX Temporary M_TEMP

[5] Additional Feature: Database Actions

[6] Configure and start ORDS in Standalone Mode: Yes

[7] Protocol: HTTP

[8] HTTP Port: 8080

[9] APEX static resources location:

[A] Accept and Continue - Create configuration and Install ORDS in the database

[Q] Quit - Do not proceed. No changes

Choose [A]: 3

Enter your choice for the runtime user password (ORDS_PUBLIC_USER)

[S] Specify your own password

[G] Generate password

[C] Cancel - No Changes

Choose [G]: S

Enter the database password for ORDS_PUBLIC_USER: <Your password>

Confirm password: <Your password>

Choose [A]: 6 to change ORDS the Standalone Mode

Enter a number to update the value or select option A to Accept and Continue

[1] Connection Type: TNS

[2] TNS Connection: TNS_NAME=SMAT.WORLD TNS_FOLDER=C:\oracle\19c_Sta\db\network\admin

Administrator User: SYS AS SYSDBA

[3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <generate>

[4] ORDS runtime user and schema tablespaces: Default: SYSAUX Temporary M_TEMP

[5] Additional Feature: Database Actions

[6] Configure and start ORDS in Standalone Mode: No

[A] Accept and Continue - Create configuration and Install ORDS in the database

[Q] Quit - Do not proceed.

Choose [A]: A to start the installation.

Start SQLPLUS and connect as SYS user on your database.

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>.

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.