Versions Compared

Old Version 1

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version Current

changes.mady.by.user Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

1.
iConnect to the source (dbv01) server as oracle.

No Format
su - oracle

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

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.

ii3. 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 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:3926:1310
Copyright (c) 1997, 20102013, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

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 = orclpdb1)))
OK (020 msec)

iii4. 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 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:4432:1453
Copyright (c) 1997, 20102013, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

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 = orclpdb1)))
OK (1030 msec)

...

5. Connect to the target (dbv02) 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_src

TNS Ping Utility for Linux: Version 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:4534:2143
Copyright (c) 1997, 20102013, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

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 = orclpdb1)))
OK (020 msec)
[oracle@target ~]$
...
7. 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 1112.21.0.21.0 - Production on 1101-JANAUG-2014 1301:4635:3729
Copyright (c) 1997, 20102013, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

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 = orclpdb1)))
OK (10 msec)
8. On the source server, check the database connection to the source database.
 No Format
sqlplus system/oracle@ttorcl_src

SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:37:57 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Last Successful login time: Fri Aug 01 2014 01:36:41 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PDB1@ORCL>  
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
9. On the source server, check the database connection to the target database.
 No Format
sqlplus system/oracle@ttorcl_trg

SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:38:59 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Last Successful login time: Fri Aug 01 2014 00:04:24 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PDB1@ORCL>
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
10. On the target server, check the database connection to the source database.
 No Format
sqlplus system/oracle@ttorcl_src

SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:40:19 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Last Successful login time: Fri Aug 01 2014 01:37:57 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 msec) - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PDB1@ORCL>
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
11. On the target server, check the database connection to the target database.
 No Format
sqlplus system/oracle@ttorcl_trg

SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 1 01:41:32 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Last Successful login time: Fri Aug 01 2014 01:39:00 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PDB1@ORCL>
 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
If any of the pre-requisites fail, then verify if all the previous steps have been done correctly before continuing.