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.
...
3. On the source server, check the TNS connection to the source database
| No Format |
|---|
tnsping ttorcl_srcSOURCE TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 2524-AUGMAY-20142017 1323:4730:5830 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (10 msec) |
4. On the source server, check the TNS connection to the target database
| No Format |
|---|
tnsping ttorcl_trgTARGET TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 2524-AUGMAY-20142017 1323:4830:3558 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = target)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (4060 msec) |
5. Connect to the target server as oracle.
...
6. On the target server, check the TNS connection to the source database.
| No Format |
|---|
tnsping ttorcl_srcSOURCE TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 2524-AUGMAY-20142017 1323:4731:5855 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (3020 msec) |
7. On the target server, check the TNS connection to the target database.
| No Format |
|---|
tnsping ttorcl_trgTARGET TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 2524-AUGMAY-20142017 1323:4832:3500 Copyright (c) 1997, 2011, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = target)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (100 msec) |
8. On the source server, check the database connection to the source database.
| No Format |
|---|
sqlplus system/manager@ttorcl_srcmanager@SOURCE SQL*Plus: Release 11.2.0.2.0 Production on MonWed AugMay 2524 1323:5135:0647 20142017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> |
Then select the hostname from v$instance.
...
9. On the source server, check the database connection to the target database.
| No Format |
|---|
sqlplus system/manager@ttorcl_trgmanager@TARGET SQL*Plus: Release 11.2.0.2.0 Production on MonWed AugMay 2524 1323:5237:1135 20142017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> |
Then select the hostname from v$instance.
...
10. On the target server, check the database connection to the source database.
| No Format |
|---|
sqlplus system/manager@ttorcl_srcmanager@SOURCE SQL*Plus: Release 11.2.0.2.0 Production on MonWed AugMay 2524 1323:5239:1151 20142017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> |
Then select the hostname from v$instance.
...
11. On the target server, check the database connection to the target database.
| No Format |
|---|
sqlplus system/manager@ttorcl_trgmanager@TARGET SQL*Plus: Release 11.2.0.2.0 Production on MonWed AugMay 2524 1323:5240:1139 20142017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> |
Then select the hostname from v$instance.
...