...
This configuration will take about 15 minutes.
...
Pre-requisites checks
Check the following pre-requisites before starting Dbvisit Replicate:
a. The database orcl on both the source and target server should be started and available.
...
To check if the database is running run the following command (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.
b. 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 11.2.0.2.0 - Production on 11-JAN-2014 13:39:13
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec) |
c. 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 11.2.0.2.0 - Production on 11-JAN-2014 13:44:14
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = target-int)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec) |
d. 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 11.2.0.2.0 - Production on 11-JAN-2014 13:45:21
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec)
[oracle@target ~]$ |
e. 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 11.2.0.2.0 - Production on 11-JAN-2014 13:46:37
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = target-int)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec) |
If any of the pre-requisites fail, then verify if all the previous steps have been done correctly before continuing.
Starting the dbvrep setup wizard
The following is a step-by-step guide of configuring a replication using the setup wizard.
1. Connect to the source (dbv01) server as oracle
...