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
