Oracle Database Connection Guide
Data Bridge Pro supports Oracle Database 12c and later, including Oracle Autonomous Database and Oracle Cloud Infrastructure.
Connection Settings
| Setting | Description | Example |
|---|---|---|
| Host | Hostname or IP | oracle.company.com |
| Port | Default: 1521 | 1521 |
| Service Name | Oracle service | ORCL |
Connection Methods
Service Name (Recommended)
Host=oracle.company.com;Port=1521;Service Name=ORCL;User Id=app_user;Password=****;Oracle Autonomous Database
- Download wallet from OCI Console
- Select "Wallet Authentication" in Data Bridge Pro
- Browse to wallet folder
- Select service level (HIGH, MEDIUM, LOW)
Required Permissions
GRANT CREATE SESSION TO app_user;
GRANT SELECT ANY TABLE TO app_user;
GRANT INSERT ANY TABLE TO app_user;
GRANT UPDATE ANY TABLE TO app_user;
GRANT DELETE ANY TABLE TO app_user;Troubleshooting
- ORA-12154: Check TNS configuration
- ORA-12541: Verify listener is running
- ORA-01017: Check credentials