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

Intergraph Smart Materials Installation (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.2
  1. On the Apache Tomcat server, download Oracle Rest Dataservices to c:\tmp.

  2. Extract ords.xx.x.x.xx.xxxx.zip to <apache_home> folder.

    For example:

    ords-19.4.6.142.1859.zip or the latest version.

    <apache_home>: c:\apache

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

  4. Open a Command Prompt window as an administrator.

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

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

    • Rename the file ords.war to apex.war.

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

  6. On Tomcat 10.x do the following, because Tomcat 10 requires a conversion of ORDS to get executed as J2EE Application within Tomcat.

    • Visit the tomcat webpage (https://tomcat.apache.org/download-migration.cgi) and download the Tomcat Migration Tool for Jakarta EE Software.

    • To covert apex.war into a tomcat 10 readable format, execute:

      java -jar jakartaee-migration-[##latest_version##].jar apex.war apex_tomcat10.war

    • Rename apex_tomcat10.war to apex.war and copy it into the <apache_home>\webapps folder.

  7. Change directory to <apache_home>\webapps\.

    For example: C:\Apache\webapps

  8. Execute the following command:

    Run: java -jar apex.war install advanced

  9. Enter the following information:

    • Location to store configuration: <apache_home>\ords_config

    • Database connection type to use: Type 1

    • Name of the database server [local host]: <your_database_server>

    • Database listen port [1521]

    • Database service name

    • Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]

    • Database password for ORDS_PUBLIC_USER

    • Database password for SYS AS SYSDBA

    • Confirm the password

    • Default tablespace for ORDS_METADATA [SYSAUX]: Select default [sysaux]

    • Temporary tablespace for ORDS_METADATA [TEMP]: Select default [temp]

    • Default tablespace for ORDS_PUBLIC_USER [USER]: Select default [users]

    • Temporary tablespace for ORDS_PUBLIC_USER [TEMP]: Select default [temp]

    • If using Oracle Application Express or ......: Type 1

    • PL/SQL Gateway database user name [APEX_PUBLIC_USER]: Select the APEX_PUBLIC_USER.

    • Database password for APEX_PUBLIC_USER

    • Confirm password

    • Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) ...: Type 1

    • Enter the database password for APEX_LISTENER

    • Confirm password

    • Database password for APEX_REST_PUBLIC_USER

    • Confirm password

    • Enter a number to select a feature to enable ... : Type 3

    • Enter 1 if you wish to start in standalone mode or 2 to exit: Type 2

  10. Start SQLPLUS and connect as SYS user.

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

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

    There should be defaults.xml.

    These files should be in the conf subfolder:

    • Apex.xml

    • apex_al.xml

    • apex_pu.xml

    • apex_rt.xml

  13. Restart the TOMCAT service.

  14. Open the following URL in a browser:

    http://<servername>:9090/apex

    Configure Apache Tomcat - APEX

    If problems occur, see Troubleshooting.