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 server as oracle.
1
| 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.
23. On the source server, check the TNS connection to the source database
| No Format |
|---|
[oracle@source ~]$ tnsping ttorcl_srctnsping SOURCE TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 1124-JANMAY-20142017 1323:3930:1330 Copyright (c) 1997, 20102011, 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 = (SERVER = DEDICATED) (SERVICE_NAME = orclXE))) OK (010 msec) |
34. On the source server, check the TNS connection to the target database
| No Format |
|---|
[oracle@source ~]$ tnsping ttorcl_trgtnsping TARGET TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 1124-JANMAY-20142017 1323:4430:1458 Copyright (c) 1997, 20102011, 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 = (SERVER = DEDICATED) (SERVICE_NAME = orclXE))) OK (1060 msec) |
...
5. Connect to the target 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_srctnsping SOURCE TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 1124-JANMAY-20142017 1323:4531:2155 Copyright (c) 1997, 20102011, 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 = (SERVER = DEDICATED) (SERVICE_NAME = orclXE))) OK (020 msec) |
57. 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 11.2.0.2.0 - Production on 1124-JANMAY-20142017 1323:4632:3700 Copyright (c) 1997, 20102011, 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 = (SERVER = DEDICATED) (SERVICE_NAME = orclXE))) OK (0 msec) |
68. On the source server, check the database connection to the source database. Then select the hostname from v$instance.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_srcmanager@SOURCE SQL*Plus: Release 11.2.0.2.0 Production on SatWed JanMay 1124 1623:0935:0947 20142017 Copyright (c) 1982, 20102011, Oracle. All rights reserved. Connected to: Oracle Database 11g EnterpriseExpress Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> |
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 |
79. On the source server, check the database connection to the target database. Then select the hostname from v$instance.
| No Format |
|---|
[oracle@source ~]$ sqlplus system/oracle@ttorcl_trgmanager@TARGET SQL*Plus: Release 11.2.0.2.0 Production on SatWed JanMay 1124 1623:0937:0935 20142017 Copyright (c) 1982, 20102011, Oracle. All rights reserved. Connected to: Oracle Database 11g EnterpriseExpress Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> |
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 |
810. On the target server, check the database connection to the source database. Then select the hostname from v$instance.
| No Format |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_srcmanager@SOURCE SQL*Plus: Release 11.2.0.2.0 Production on SatWed JanMay 1124 1623:0939:0951 20142017 Copyright (c) 1982, 20102011, Oracle. All rights reserved. Connected to: Oracle Database 11g EnterpriseExpress Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> |
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. Then select the hostname from v$instance.
| No Format |
|---|
[oracle@target ~]$ sqlplus system/oracle@ttorcl_trgmanager@TARGET SQL*Plus: Release 11.2.0.2.0 Production on SatWed JanMay 1124 1623:0940:0939 20142017 Copyright (c) 1982, 20102011, Oracle. All rights reserved. Connected to: Oracle Database 11g EnterpriseExpress Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> |
Then select the hostname from v$instance.
| No Format |
|---|
SQL> SELECT host_name FROM v$instance; HOST_NAME ---------------------------------------------------------------- target |
...