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 |
|---|
su - 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 |
If the ora_pmon_orcl process is running, that is a good indication that the Oracle database is running.
23. 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 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:3926:1310 Copyright (c) 1997, 20102013, 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 = orclpdb1))) OK (020 msec) |
34. 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 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:4432:1453 Copyright (c) 1997, 20102013, 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 = orclpdb1))) OK (1030 msec) |
5. Connect to the target (dbv02)
...
4server 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_src TNS Ping Utility for Linux: Version 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:4534:2143 Copyright (c) 1997, 20102013, 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 = orclpdb1))) OK (020 msec) |
57. 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 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:4635:3729 Copyright (c) 1997, 20102013, 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 = orclpdb1))) OK (010 msec) |
68. On the source server, check the database connection to the source database. Type exit to exit out of SQL*Plus.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_src SQL*Plus: Release 1112.21.0.21.0 Production on SatFri JanAug 111 1601:0937:0957 2014 Copyright (c) 1982, 20102013, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 01:36:41 -04:00 Connected to: Oracle Database 11g12c Enterprise Edition Release 1112.21.0.21.0 - 64bit Production With the Partitioning, OLAP, DataAdvanced MiningAnalytics and Real Application Testing options PDB1@ORCL> |
Then select the hostname from v$instance.
| No Format |
|---|
SQL> SELECT host_name FROM v$instance; HOST_NAME ---------------------------------------------------------------- source |
Type exit to exit
...
7out of SQL*Plus.
| No Format |
|---|
SQL> exit |
9. On the source server, check the database connection to the target database. Type exit to exit out of SQL*Plus.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_trg SQL*Plus: Release 1112.21.0.21.0 Production on SatFri JanAug 111 1601:0938:0959 2014 Copyright (c) 1982, 20102013, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 00:04:24 -04:00 Connected to: Oracle Database 11g12c Enterprise Edition Release 1112.21.0.21.0 - 64bit Production With the Partitioning, OLAP, DataAdvanced MiningAnalytics and Real Application Testing options PDB1@ORCL> |
Then select the hostname from v$instance.
| No Format |
|---|
SQL> SELECT host_name exit |
...
FROM v$instance;
HOST_NAME
----------------------------------------------------------------
target |
Type exit to exit out of SQL*Plus.
| No Format |
|---|
SQL> exit |
10. On the target server, check the database connection to the source database. Type exit to exit out of SQL*Plus.
| No Format |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_src SQL*Plus: Release 1112.21.0.21.0 Production on SatFri JanAug 111 1601:0940:0919 2014 Copyright (c) 1982, 20102013, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 01:37:57 -04:00 Connected to: Oracle Database 11g12c Enterprise Edition Release 1112.21.0.21.0 - 64bit Production With the Partitioning, OLAP, DataAdvanced MiningAnalytics and Real Application Testing options PDB1@ORCL> |
Then select the hostname from v$instance.
| No Format |
|---|
SQL> SELECT host_name FROM v$instance; HOST_NAME ---------------------------------------------------------------- source |
Type exit to exit out of SQL*Plus.
| No Format |
|---|
SQL> exit |
911. On the target server, check the database connection to the target database. Type exit to exit out of SQL*Plus.
| No Format |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_trg SQL*Plus: Release 1112.21.0.21.0 Production on SatFri JanAug 111 1601:0941:0932 2014 Copyright (c) 1982, 20102013, Oracle. All rights reserved. Last Successful login time: Fri Aug 01 2014 01:39:00 -04:00 Connected to: Oracle Database 11g12c Enterprise Edition Release 1112.21.0.21.0 - 64bit Production With the Partitioning, OLAP, DataAdvanced MiningAnalytics and Real Application Testing options PDB1@ORCL> |
Then select the hostname from v$instance.
| No Format |
|---|
SQL> SELECT host_name FROM v$instance; HOST_NAME ---------------------------------------------------------------- target |
Type exit to exit out of SQL*Plus.
| No Format |
|---|
SQL> exit |
If any of the pre-requisites fail, then verify if all the previous steps have been done correctly before continuing.