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 server as oracle.
...
2. The database XE on both the source and target server should be started and available. To check if the database XE is running, check the pmon process (on both source and target)
...
| No Format |
|---|
tnsping ttorcl_src TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0125-AUG-2014 0113:2647:1058 Copyright (c) 1997, 20132011, 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 = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1XE))) OK (2010 msec) |
4. On the source server, check the TNS connection to the target database
| No Format |
|---|
tnsping ttorcl_trg TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0125-AUG-2014 0113:3248:5335 Copyright (c) 1997, 20132011, 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 = pdb1XE))) OK (3040 msec) |
5. Connect to the target server as oracle.
...
| No Format |
|---|
tnsping ttorcl_src TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0125-AUG-2014 0113:3447:4358 Copyright (c) 1997, 20132011, 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 = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1XE))) OK (2030 msec) |
7. On the target server, check the TNS connection to the target database.
| No Format |
|---|
tnsping ttorcl_trg TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0125-AUG-2014 0113:48:35:29 Copyright (c) 1997, 20132011, 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 = pdb1XE))) OK (10 msec) |
8. On the source server, check the database connection to the source database.
| No Format |
|---|
sqlplus system/oracle@ttorclmanager@ttorcl_src SQL*Plus: Release 1211.12.0.12.0 Production on FriMon Aug 125 0113:3751:5706 2014 Copyright (c) 1982, 20132011, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 01:36:41 -04:00 Connected to: Oracle Database 12c11g EnterpriseExpress Edition Release 1211.12.0.12.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL> SQL> |
Then select the hostname from v$instance.
...
9. On the source server, check the database connection to the target database.
| No Format |
|---|
sqlplus system/oracle@ttorclmanager@ttorcl_trg SQL*Plus: Release 1211.12.0.12.0 Production on FriMon Aug 125 0113:3852:5911 2014 Copyright (c) 1982, 20132011, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 00:04:24 -04:00 Connected to: Oracle Database 12c11g EnterpriseExpress Edition Release 1211.12.0.12.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL>SQL> |
Then select the hostname from v$instance.
...
10. On the target server, check the database connection to the source database.
| No Format |
|---|
sqlplus system/oracle@ttorclmanager@ttorcl_src SQL*Plus: Release 1211.12.0.12.0 Production on FriMon Aug 125 0113:4052:1911 2014 Copyright (c) 1982, 20132011, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 01:37:57 -04:00 Connected to: Oracle Database 12c11g EnterpriseExpress Edition Release 1211.12.0.12.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL>SQL> |
Then select the hostname from v$instance.
...
11. On the target server, check the database connection to the target database.
| No Format |
|---|
sqlplus system/oracle@ttorclmanager@ttorcl_trg SQL*Plus: Release 1211.12.0.12.0 Production on FriMon Aug 125 0113:4152:3211 2014 Copyright (c) 1982, 20132011, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 01:39:00 -04:00 Connected to: Oracle Database 12c11g EnterpriseExpress Edition Release 1211.12.0.12.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL>SQL> |
Then select the hostname from v$instance.
...