Connect to Oracle Database to query and analyze your enterprise data. Supports tables with Oracle Spatial (SDO_GEOMETRY) columns for geographic analysis.
Connect to Oracle
- Click Add data in the Layers panel
- Go to the Connections tab
- Select Oracle
- Fill in the connection parameters
- Click Create Connection
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| Connection Name | Yes | A friendly name to identify this connection |
| Host | Yes | Hostname or IP address (e.g., localhost, oracle.example.com) |
| Port | Yes | Port number (default: 1521) |
| Database (SID) | Yes | Oracle System Identifier (e.g., ORCL) |
| Service Name | No | Oracle Service Name (used instead of SID if provided) |
| Username | Yes | Database username |
| Password | Yes | Database password |
| Schema | No | Default schema within the database |
SID vs Service Name
Use Database (SID) for older Oracle installations or single-instance databases. Use Service Name for Oracle RAC, pluggable databases (PDBs), or when your DBA provides a service name. If both are provided, Service Name takes precedence.
SSL/TLS Configuration
Enable SSL/TLS for encrypted connections to your database. When enabled, you can optionally upload:
- Client Certificate: PEM or CRT format
- Private Key: PEM or KEY format
- CA Certificate: For server verification
Working with Data
After connecting, browse available schemas and tables. Select the data you want to import and click Add to Project. Tables with Oracle Spatial columns (SDO_GEOMETRY) import as vector layers.
Firewall Configuration
If your database is behind a firewall, whitelist these Atlas IP addresses:
16.16.129.130
51.20.23.178
13.50.71.210
51.21.188.73
Troubleshooting
| Issue | Solution |
|---|---|
| Connection Refused | Verify host and port. Check Oracle listener is running (lsnrctl status). |
| ORA-12514 | Invalid SID or Service Name. Verify with your DBA. |
| Authentication Failed | Confirm credentials. Check user account is not locked. |
| Schema Not Found | Oracle schema names are case-sensitive (typically uppercase). |
| ORA-01017 | Invalid username/password. Oracle passwords are case-sensitive. |