ORDS Configuration Multiple database in single tomcat server.

 ORDS Configuration Multiple database in single tomcat server.

 

Create directories for ords configuration

 

Create configuration and logs directory

 

Cd /u01/test/ords

Mkdir -p  conf

Cd conf

Mkdir logs

 

Ords configuration database 1

 

Execute below script and mention that java home and ords path  correctly to configure ORDS.

 

export JAVA_HOME=/u01/app/tomcat_install/java/jdk-13.0.1 export PATH=/u01/app/tomcat_install/java/jdk-13.0.1/bin:$PATH export ORDS_HOME=/u01/test/ords export ORDS_CONFIG=/u01/test/ords/conf export ORDS_LOGS=${ORDS_CONFIG}/logs export DB_PORT=1523 export DB_SERVICE=test export SYSDBA_USER=SYS export SYSDBA_PASSWORD=oracle export ORDS_PASSWORD=**********     ${ORDS_HOME}/bin/ords --config ${ORDS_CONFIG} install \ --log-folder ${ORDS_LOGS} \ --admin-user ${SYSDBA_USER} \ --db-hostname ${HOSTNAME} \ --db-port ${DB_PORT} \ --db-servicename ${DB_SERVICE} \ --feature-db-api true \ --feature-rest-enabled-sql true \ --feature-sdw true \ --gateway-mode proxied \ --gateway-user APEX_PUBLIC_USER \ --proxy-user \ --password-stdin <<EOF ${SYSDBA_PASSWORD} ${ORDS_PASSWORD} EOF

 

Copy war file and apex images to tomcat webapps location

 

Create image directory in tomcat webapps location Cd /u01/test/tomcat/apache-tomcat-9.0.73/webapps/ Mkdir i   [oracle@tom ~]$ cd /u01/test/apex/images/ [oracle@tom images]$ cp -R * /u01/test/tomcat/apache-tomcat-9.0.73/webapps/i [oracle@tom images]$   [oracle@tom ords]$ cp ords.war /u01/test/tomcat/apache-tomcat-9.0.73/webapps/

 

create tomcat env and add java_opts variable.

 

export JAVA_HOME=/u01/app/tomcat_install/java/jdk-13.0.1 export CATALINA_HOME=/u01/test/tomcat/apache-tomcat-9.0.73 export CATALINA_BASE=$CATALINA_HOME export PATH=/u01/app/tomcat_install/java/jdk-13.0.1/bin:$PATH export ORDS_CONFIG=/u01/test/ords/conf export JAVA_OPTS="-Dconfig.url=${ORDS_CONFIG} -Xms1024M -Xmx1024M"

 

 

Start the tomcat services. Verify the url.

 

Adding another ords connection in new database.

 

 

Mentioned that new database service name listener port correctly

 

export JAVA_HOME=/u01/app/tomcat_install/java/jdk-13.0.1 export PATH=/u01/app/tomcat_install/java/jdk-13.0.1/bin:$PATH export ORDS_HOME=/u01/test/ords export ORDS_CONFIG=/u01/test/ords/conf export ORDS_LOGS=${ORDS_CONFIG}/logs export DB_PORT=1524 export DB_SERVICE=loans export SYSDBA_USER=SYS export SYSDBA_PASSWORD=oracle export ORDS_PASSWORD=******     ${ORDS_HOME}/bin/ords --config ${ORDS_CONFIG} install \ --log-folder ${ORDS_LOGS} \ --admin-user ${SYSDBA_USER} \ --db-hostname ${HOSTNAME} \ --db-pool sample\ --db-port ${DB_PORT} \ --db-servicename ${DB_SERVICE} \ --feature-db-api true \ --feature-rest-enabled-sql true \ --feature-sdw true \ --gateway-mode proxied \ --gateway-user APEX_PUBLIC_USER \ --proxy-user \ --password-stdin <<EOF ${SYSDBA_PASSWORD} ${ORDS_PASSWORD} EOF

 

To check that new connection pool status

 

[oracle@tom loans]$ cd .. [oracle@tom databases]$ tree . ├── default │   ├── pool.xml │   └── wallet │       └── cwallet.sso └── sample ├── pool.xml └── wallet └── cwallet.sso   4 directories, 4 files

 

Now have two paths available, representing the two connections. The URL will be different, depending on if you configured ORDS

 

REF Link ---- https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-configure-multiple-databases-22-onward

 

 

http://192.168.106.128:9090/ords/  --

 

 

http://192.168.106.128:9090/ords/sample--

 

 

http://192.168.106.128:9090/ords/apxprd 

 

  

Sample Screens