Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Connect Oracle Database as a source or destination in Zwiron, including LogMiner CDC.
| Field | Description |
|---|---|
| Host | Hostname or IP of the Oracle server |
| Port | Default: 1521 |
| Service name | Oracle service name (e.g. ORCLPDB1) |
| Username | Oracle user for Zwiron |
| Password | User’s password |
CREATE USER zwiron IDENTIFIED BY your_password;
GRANT CREATE SESSION TO zwiron;
GRANT SELECT ANY TABLE TO zwiron;
GRANT SELECT ANY DICTIONARY TO zwiron;
GRANT EXECUTE ON DBMS_LOGMNR TO zwiron;
GRANT EXECUTE ON DBMS_LOGMNR_D TO zwiron;
GRANT SELECT ON V_$LOG TO zwiron;
GRANT SELECT ON V_$LOG_HISTORY TO zwiron;
GRANT SELECT ON V_$LOGMNR_LOGS TO zwiron;
GRANT SELECT ON V_$LOGMNR_CONTENTS TO zwiron;
GRANT LOGMINING TO zwiron;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;