Oracle Check

Oracle Check

Oracle Check validates connectivity to an Oracle Database (21c and higher, including 23ai) using a service name (typically a PDB such as FREEPDB1).

Usage with Binary

./wait4it -type=oracle -h=127.0.0.1 -p=1521 -t=60 -u=app -P=secret -n=FREEPDB1

Usage with Docker

docker run ph4r5h4d/wait4it -type=oracle -h=127.0.0.1 -p=1521 -t=60 -u=app -P=secret -n=FREEPDB1

Environment Variables

VariableDescriptionDefault
W4IT_TYPEThe type of check (set to oracle for Oracle check).-
W4IT_TIMEOUTTimeout in seconds.30
W4IT_HOSTThe host to check.127.0.0.1
W4IT_PORTThe port to check on the Oracle host (default Oracle listener port).1521
W4IT_USERNAMEThe username for Oracle authentication.-
W4IT_PASSWORDThe password for Oracle authentication.-
W4IT_PASSWORD_FILEThe file with password for Oracle authentication.-
W4IT_DBNAMEThe service name (or PDB name, e.g. FREEPDB1 or XEPDB1) to connect to.-

Command-Line Arguments

ArgumentDescriptionDefault
-typeThe type of check (set to oracle).-
-tTimeout in seconds.30
-hThe host to check.127.0.0.1
-pThe port to check on the Oracle host.1521
-uThe username for Oracle authentication.-
-PThe password for Oracle authentication.-
-PfThe file with password for Oracle authentication.-
-nThe service name / PDB name to connect to (recommended for 21c+).-

Notes

  • Environment variables override command-line arguments.
  • For Oracle 21c and higher (including 23ai Free / XE), use the PDB service name in -n / W4IT_DBNAME (commonly FREEPDB1 with popular container images such as gvenzl/oracle-free or gvenzl/oracle-xe).
  • The check performs a TCP connection + authentication + PingContext. It does not run any DDL/DML.
  • For Oracle Autonomous Database or wallet-based TLS connections, additional configuration (not yet exposed via CLI flags) would be required.

Exit Codes

CodeMeaning
0Connection successful.
1Timed out.
2Validation error or incorrect input.