1. Overview

• Definition: Covers the network settings and validation rules required to connect Mobio to an Oracle database.
• Users: System Admin, DBA (Database Administrator).

2. Terminology & Configuration Parameters

• Service Name (SID) — A unique identifier on your Oracle server that Data Flow uses to route requests.
• Standard port — 1521.

3. Prerequisites

• Related article: Create Connector: Database
• Permissions: Run lsnrctl status (Listener) on your internal Oracle server to allow incoming requests.

4. Configuration Limits by Field

To keep Mobio compatible with your Oracle TNS Listener:

• Database/Service Name — Up to 128 characters. No special characters allowed. Enter the exact case — Oracle is case-sensitive, so don’t auto-capitalize the whole name.
• Hostname/IP — Up to 253 characters. Accepts IPv4 or an FQDN (domain name). No website prefixes (http/https). Never leave stray spaces before or after the address.
• Port — Any value from 1–65535. The standard Oracle port is 1521.
• Username — Up to 128 characters. No special characters, except the ones Oracle allows: #, $, or _.
• Password — Spaces are allowed. Security requirement: no control characters forbidden by the DB driver. Mobio masks the password as 15 asterisks (*****) once the connection succeeds.

5. Operational Rules

• Supported Oracle versions: Mobio Data Flow is fully compatible with Oracle 9i, 10g, 11g, and 12c.
• Periodic password rotation: Oracle’s default infrastructure policy requires a password change every 90 days. If a previously working Connector suddenly disconnects, ask your DBA to check this rule on the destination server.
• Mobio supports Incremental Snapshot sync with Oracle Connectors, so you can optimize extraction and pull only the latest updated records.

6. Frequently Asked Questions (FAQ)

• Q: How do I test connectivity internally before configuring it in Mobio?
  • A: Run: sqlplus <user>/<password>@<hostname>:1521/<service_name
• Q: Is Service Name a required or optional field?
  • A: Oracle’s Service Name/SID is required (along with the database name) — it’s not optional.

7. Next Steps

Back to Create Connector: Database