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.
...
| 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> |
...
| 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> |
...
| 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> |
...
| 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> |
...