Oracle Database Info
Retrieves high-level instance information from an Oracle database using the configured credentials. It calls the Oracle service to return details such as version, instance status, and other metadata. Results are returned in a human-readable text summary and structured JSON, with additional export formats supported by the platform.
Usage
Use this node to quickly verify the Oracle instance details during environment setup, health checks, or pre-flight steps before running queries. Typically placed early in a workflow to confirm connectivity and to capture database metadata for logging or auditing.
| Field | Required | Type | Description | Example |
|---|
| credentials_path | True | STRING | Path to the stored Oracle credentials file that follows the 'oracle' credential template (includes host, port, service/SID, username, and password or secret reference). | /workspace/credentials/oracle.json |
| timeout | False | INT | Maximum time in seconds to wait for the Oracle service to respond before failing the request. | 30 |
Outputs
| Field | Type | Description | Example |
|---|
| text | STRING | Human-readable summary of the Oracle database information. | Oracle Database Info: Instance 'ORCL' is OPEN, version 19.18.0.0.0. |
| json | JSON | Structured JSON containing the database info returned by the Oracle service. | {"instance_name": "ORCL", "status": "OPEN", "version": "19.18.0.0.0"} |
| html | HTML | HTML-formatted table or content for display or reporting (when available). | | instance_name | ORCL |
|---|
| status | OPEN |
|---|
|
| xlsx | XLSX | Excel workbook export of the data (when export is enabled). | |
| pdf | PDF | PDF export of the data (when export is enabled). | |
Important Notes
- Credentials must use the 'oracle' credential template and have sufficient privileges to view instance information.
- Network access to the Oracle host must be allowed; ensure firewall rules and security groups permit connectivity.
- Timeout controls the service call duration only; very slow database responses may still require an increased timeout.
- This node relies on the Salt CData service for execution. Ensure the service is deployed and reachable from your environment.
- Returns a text summary and JSON by default. Additional formats (HTML/XLSX/PDF) may be present depending on platform configuration.
Troubleshooting
- Connection failed: Verify host, port, and service/SID in the credentials file and confirm the Salt CData service is reachable.
- Authentication error: Ensure the username/password or secret reference in the credentials is valid and has required privileges.
- Timeouts: Increase the timeout input value if the Oracle environment is slow or under heavy load.
- Empty or partial data: Confirm the connected user has permissions to access instance metadata views.
- TLS/SSL issues: If using secure connections, verify certificates and connection parameters in the credentials.
