mkdir /tomcat/ords

unzip /tomcat/ords*.zip -d /tomcat/ords

mkdir -p /tomcat/conf/ords/logs

export ORDS_HOME=/tomcat/ords

export ORDS_CONFIG=/tomcat/conf/ords

export ORDS_LOGS=${ORDS_CONFIG}/logs

export DB_HOSTNAME=mydbhost

export DB_PORT=1521

export DB_SERVICE=myservice

export SYSDBA_USER=SYS

export SYSDBA_PASSWORD=mysyspassword

export ORDS_PASSWORD=myordspassword

${ORDS_HOME}/bin/ords --config ${ORDS_CONFIG} install \

     --log-folder ${ORDS_LOGS} \

     --admin-user ${SYSDBA_USER} \

     --db-hostname ${DB_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

sqlplus / as sysdba

ALTER USER sys ACCOUNT LOCK;

Mutli-Tenant

ALTER USER sys ACCOUNT LOCK CONTAINER=ALL;