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 as oracle.
...
2. The database orcl on both the source and target server should be started and available. To check if database orcl 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 ora_pmon_orcl
oracle 2974 2933 0 13:35 pts/1 00:00:00 grep pmon |
...
3. On the source server, check the TNS connection to the source database
| No Format |
|---|
[oracle@source ~]$ tnsping ttorcl_src
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 01-AUG-2014 01:26:10
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 = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1)))
OK (20 msec) |
4. On the source server, check the TNS connection to the target database
| No Format |
|---|
[oracle@source ~]$ 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) |
...
6. On the target server, check the TNS connection to the source database.
| No Format |
|---|
[oracle@target ~]$ tnsping ttorcl_src
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 01-AUG-2014 01:34:43
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 = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb1)))
OK (20 msec) |
7. On the target server, check the TNS connection to the target database.
| No Format |
|---|
[oracle@target ~]$ tnsping ttorcl_trg
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 01-AUG-2014 01:35:29
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 (10 msec) |
8. On the source server, check the database connection to the source database.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_src SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:37:57 2014 Copyright (c) 1982, 2013, 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 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL> |
...
9. On the source server, check the database connection to the target database.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_trg SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:38:59 2014 Copyright (c) 1982, 2013, 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 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL> |
...
10. On the target server, check the database connection to the source database.
| No Format |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_src SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:40:19 2014 Copyright (c) 1982, 2013, 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 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL> |
...
11. On the target server, check the database connection to the target database.
| No Format |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_trg SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:41:32 2014 Copyright (c) 1982, 2013, 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 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PDB1@ORCL> |
...