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

For example:

ords-24.4.0.345.1601.zip or the latest version.

<

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:

If you are using a newer version of ORDS, please follow the guidelines from Oracle.

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 NOTE: 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]: 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. No changes

Choose [A]: A to start the installation.

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