Versions Compared

Old Version 2

changes.mady.by.user Seymore Asses (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Miroslav Sivon (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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
titleNOTE

Requirements are:

  • Postgres client (psql and Postgres libreries) 
  • Oracle tnsnames.ora

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

...