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)
...
6. 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_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> |
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.
...
7. 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_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> |
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.
...
8. 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_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> |
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.
...
9. 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_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> |
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.
...