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.
| No Format |
|---|
su - oracle |
2. The database orcl XE on both the source and target server should be started and available. To check if the database orcl XE is running, check the pmon process (on both source and target)
| No Format |
|---|
$ 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.
3. On the source server, check the TNS connection to the source database
| No Format |
|---|
[oracle@source ~]$ tnsping ttorcl_srcSOURCE TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0124-AUGMAY-20142017 0123:2630:1030 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 |
|---|
[oracle@source ~]$ tnsping ttorcl_trgTARGET TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0124-AUGMAY-20142017 0123:3230:5358 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 (3060 msec) |
5. Connect to the target (dbv02) server server as oracle.
| No Format |
|---|
su - oracle |
6. On the target server, check the TNS connection to the source database.
| No Format |
|---|
[oracle@target ~]$ tnsping ttorcl_srcSOURCE TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0124-AUGMAY-20142017 0123:3431:4355 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 (20 msec) |
7. On the target server, check the TNS connection to the target database.
| No Format |
|---|
[oracle@target ~]$ tnsping ttorcl_trg tnsping TARGET TNS Ping Utility for Linux: Version 1211.12.0.12.0 - Production on 0124-AUGMAY-20142017 0123:3532:2900 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 (100 msec) |
8. On the source server, check the database connection to the source database.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_src manager@SOURCE SQL*Plus: Release 1211.12.0.12.0 Production on FriWed AugMay 124 0123:3735:5747 20142017 Copyright (c) 1982, 20132011, Oracle. All rights reserved. ERROR: ORA-28002: the password will expire within 7 days 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 |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_trgmanager@TARGET SQL*Plus: Release 1211.12.0.12.0 Production on FriWed AugMay 124 0123:3837:5935 20142017 Copyright (c) 1982, 20132011, Oracle. All rights reserved. ERROR: ORA-28002: the password will expire within 7 days 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 |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_srcmanager@SOURCE SQL*Plus: Release 1211.12.0.12.0 Production on FriWed AugMay 124 0123:4039:1951 20142017 Copyright (c) 1982, 20132011, Oracle. All rights reserved. ERROR: ORA-28002: the password will expire within 7 days 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 |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_trg manager@TARGET SQL*Plus: Release 1211.12.0.12.0 Production on FriWed AugMay 124 0123:4140:3239 20142017 Copyright (c) 1982, 20132011, Oracle. All rights reserved. ERROR: ORA-28002: the password will expire within 7 days 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.
...