Content Comparison

Check the following pre-requisites before starting Dbvisit Replicate. If these are not correct, then the replication will NOT function.

1. Connect to the source (dbv01) server  server as oracle.

su - oracle

2. The database orcl XE on both the source and target server should be started and available. To check if database orcl XE is running, check the pmon process (on both source and target)

ps -ef | grep pmon
oracle    2467     1  0 13:31 ?        00:00:00 oraxe_pmon_orclXE
oracle    2974  2933  0 13:35 pts/1    00:00:00 grep pmon

If the oraxe_pmon_orcl XE process is running, that is a good indication that the Oracle database is running.

...

tnsping ttorcl_trg

TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 01-AUG-2014 01:32:53
Copyright (c) 1997, 2013, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = target-int)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1)))
OK (30 msec)

5. Connect to the target (dbv02) server  server as oracle.

su - oracle

...