| Table of Contents | ||
|---|---|---|
|
Example set up information
Below is the example of setup wizard session for PostgreSQL database.
...
- Hostname: oel712ctrg
- OS: Oracle Linux Server release 7.1
- Database: PostgreSQL 9.2
- User schema: ORA2PG
- Dbvrep schema: DBVREP
- Database name: postgres
- Database superuser: dbvrep_admin
- Replication HOME directory:
/home/oracle/ora2pg
| Warning |
|---|
We choosed postgres as database name for destination database. However, The postgres name is a database rather than a cluster (instance) name. |
Setup wizard
Transcript of the setup wizard:
...
Preparing the databases (running *-all.sh script)
| Info | ||
|---|---|---|
| ||
Requirements are:
Execute as root: yum install -y postgresql |
After running all scripts source and target database will be ready for replication.
...
| Code Block |
|---|
[oracle@oel712ctrg ora2pg]$ ls -ln total 8 -rwxr----- 1 54321 54321 0 Apr 19 14:01 APPLY.sql -rw-r----- 1 54321 54321 529 Apr 19 14:01 ora2pg-APPLY.ddc -rwxr----- 1 54321 54321 97 Apr 19 14:01 ora2pg-run-oel712ctrg.sh |
Instantiating / Replicating existing data from Oracle
Exporting CSV from Oracle and loading into non-Oracle Database
Starting up the replication
...