Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Check the following pre-requisites before starting Dbvisit Replicate. If these are not correct, then the replication will NOT function.

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

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

2. On the source server, check the TNS connection to the source database

[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)

3. On the source server, check the TNS connection to the target database

[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)

4. On the target server, check the TNS connection to the source database

[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)

5. On the target server, check the TNS connection to the target database

[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)

6. On the source server, check the database connection to the source database. Then select the hostname from v$instance. Type exit to exit out of SQL*Plus.

[oracle@source ~]$ sqlplus system/oracle@ttorcl_src
SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 11 16:09:09 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT host_name FROM v$instance;
HOST_NAME
----------------------------------------------------------------
source
SQL> exit

7. On the source server, check the database connection to the target database. Then select the hostname from v$instance. Type exit to exit out of SQL*Plus.

[oracle@source ~]$ sqlplus system/oracle@ttorcl_trg
SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 11 16:09:09 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT host_name FROM v$instance;
HOST_NAME
----------------------------------------------------------------
target
SQL> exit

8. On the target server, check the database connection to the source database. Then select the hostname from v$instance. Type exit to exit out of SQL*Plus.

[oracle@target ~]$ sqlplus system/oracle@ttorcl_src
SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 11 16:09:09 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT host_name FROM v$instance;
HOST_NAME
----------------------------------------------------------------
source
SQL> exit

9. On the target server, check the database connection to the target database. Then select the hostname from v$instance. Type exit to exit out of SQL*Plus.

[oracle@target ~]$ sqlplus system/oracle@ttorcl_trg
SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 11 16:09:09 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT host_name FROM v$instance;
HOST_NAME
----------------------------------------------------------------
target
SQL> exit

If any of the pre-requisites fail, then verify if all the previous steps have been done correctly before continuing. 

 

  • No labels