Cross-platform data replication

11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1) RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1) Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration (Doc ID 413484.1) Advertisements

Step-by-step guide on installing and configuring OGG for Oracle replication(Part III – Monitoring and High Availability)

# create heartbeat job on source database exec dbms_scheduler.drop_job(job_name=>’OGG_HEARTBEAT_JOB’); create table nlnk.test(id number); BEGIN DBMS_SCHEDULER.create_job ( job_name => ‘ogg_heartbeat_job’, job_type => ‘PLSQL_BLOCK’, job_action => ‘BEGIN insert into nlnk.test(id) values(to_number(to_char(sysdate,”yyyymmddhh24miss”))); END;’, start_date => systimestamp, end_date => NULL, repeat_interval => ‘freq=minutely;bysecond=0;interval=1′, enabled => true); END; / exec dbms_scheduler.run_job(job_name=>’OGG_HEARTBEAT_JOB’); col max(id) for 99999999999999 select max(id) from NLNK.test; alter… Continue reading Step-by-step guide on installing and configuring OGG for Oracle replication(Part III – Monitoring and High Availability)

Step-by-step guide on installing and configuring OGG for Oracle replication(Part II – Configuring OGG)

#### Configuring Database (both source and destination) # If the database is configured to use a bequeath connection cd $ORACLE_HOME/network/admin vi sqlnet.ora # add the following bequeath_detach=true # We’re using Integrated Capture (LogMiner) and Integrated Replicat (LCR with Inbound Server) # cat ~/.ogg_profile # export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/ogghome_1 # export PATH=$ORACLE_HOME:$ORACLE_HOME/OPatch:$PATH # export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH # From OGG… Continue reading Step-by-step guide on installing and configuring OGG for Oracle replication(Part II – Configuring OGG)

Step-by-step guide on installing and configuring OGG for Oracle replication(Part I – Patching RDBMS and OGG)

It is well known that Oracle has replaced Streams with OGG(Oracle GoldenGate) as its primary data replication solution. You may easily find basic configuration steps for OGG from various sources, which would NOT be sufficient for production. This post aims to provide additional information for product-ready deployment. I have to divide these steps into several… Continue reading Step-by-step guide on installing and configuring OGG for Oracle replication(Part I – Patching RDBMS and OGG)

JDBC driver and JDK compatibility issue caused MERGE to fail

Recently, one developer came to me complaining about error ORA-17410. They are using JDBC thin to connect to Oracle databaes. The error was interesting because the application was executing a MERGE statement, which was used to compute quarterly commission fee. Those data would already have been computed on a daily basis and the task would… Continue reading JDBC driver and JDK compatibility issue caused MERGE to fail

ORA-01555 encountered with huge elapsed time discrepancies in alert and awr

We encountered the well-known ORA-1555 error recently : Fri Jun 23 21:07:02 2017 ORA-01555 caused by SQL statement below (SQL ID: a520vskru5tmy, Query Duration=3304 sec, SCN: 0x010a.b517cc1a): SELECT BOND_REPO_DEAL_F.BOND_REPO_DEAL_ID … Query Duration is 3304 seconds, wow! But when I checked the AWR report, it states the Elapsed time for the SQL is only 19.29 seconds.… Continue reading ORA-01555 encountered with huge elapsed time discrepancies in alert and awr