Connection Parameters
| Parameter | Description | Required | Example |
|---|---|---|---|
| Host | Database server address | Yes | oracle.example.com |
| Port | Database port | Yes | 1521 (default) |
| SID/Service Name | Database identifier | Yes | ORCL or orcl.example.com |
| Username | Database user | Yes | READONLY_USER |
| Password | User password | Yes | ******** |
Required Permissions
Create a user with minimum privileges required for metadata extraction:
oracle_permissions.sql
-- Minimum required permissions GRANT CONNECT TO readonly_user; GRANT SELECT ANY DICTIONARY TO readonly_user; -- Or more restrictive (granular) permissions: GRANT SELECT ON ALL_TABLES TO readonly_user; GRANT SELECT ON ALL_TAB_COLUMNS TO readonly_user; GRANT SELECT ON ALL_CONSTRAINTS TO readonly_user; GRANT SELECT ON ALL_CONS_COLUMNS TO readonly_user; GRANT SELECT ON ALL_INDEXES TO readonly_user;
Special Features
Complex Schema Support
Handles Oracle's sophisticated schema structures and multi-tenant environments.
Synonym Support
Automatically resolves synonyms to their actual tables for accurate lineage.
Package Documentation
Extracts metadata from PL/SQL packages to document stored logic.
Partition Detection
Identifies partitioned tables and their underlying strategies.
Common Issues
ORA-12541: TNS:no listener
Ensure the Oracle listener is running on the server. Check your `listener.ora` configuration.
ORA-12154: TNS:could not resolve identifier
Verify the SID or Service Name is correct. Check `tnsnames.ora` or use the full connection string format.
ORA-01017: invalid username/password
Verify credentials are correct. Oracle is case-sensitive; ensure capitalization matches exactly.
ORA-28000: account is locked
Unlock the account using:
ALTER USER readonly_user ACCOUNT UNLOCK;