Oracle Database Info¶
Retrieves high-level information about a connected Oracle database instance using the provided credentials. Returns a human-readable summary and a structured JSON payload with key details like version, instance name, and status.
Usage¶
Use this node when you need to verify and capture metadata about your Oracle database environment (e.g., during setup validation, audits, or health checks). Typically placed after a credentials/configuration step and before any query or schema exploration nodes.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | CREDENTIALS | Path or reference to stored Oracle database credentials that follow the Oracle credential template. | /configs/credentials/oracle.json |
| timeout | False | INT | Maximum time to wait for the database info request to complete. Increase if your database has high latency or slow responses. | 120000 |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | STRING | A readable summary of the Oracle database instance information. | Oracle Database Info: Version 19c, Instance ORCL, Status OPEN |
| json | STRING | Structured JSON string with detailed database info (e.g., version, instance name, status, platform). | {"version":"19.18.0.0.0","instance":"ORCL","status":"OPEN","platform":"Linux x86-64"} |
| html | STRING | HTML representation of the results (may be empty when using default output formatting). | |
| xlsx | BYTES | Binary content for an Excel export (empty when using default output formatting). | |
| BYTES | Binary content for a PDF export (empty when using default output formatting). |
Important Notes¶
- Credentials: Requires valid Oracle credentials that match the Oracle credential template.
- Timeouts: Long-running or slow connections may require increasing the timeout to avoid failures.
- Permissions: The connected user must have sufficient privileges to read database instance metadata.
- No extra parameters: This node does not require schema or table inputs; it reports instance-level details.
Troubleshooting¶
- Authentication failed: Ensure the credentials file/reference is correct and follows the Oracle template. Verify username/password and network access.
- Connection timeout: Increase the timeout value and confirm that the database host and port are reachable from the environment where this node runs.
- Insufficient privileges: Use a user with rights to query instance metadata or consult your DBA to grant the necessary permissions.
- Empty or partial results: Check database availability and user permissions; also verify that the instance is open and accessible.