cancel
Showing results for 
Search instead for 
Did you mean: 

Using MTK with ORACLE RAC and EXADATA

xDB doesn't supportRACandEXADATAout of the box. 

 

Generally using the defaultSRC_DB_URLwithin the toolkit.properties file doesn’t work with MTK when migrating data from Oracle RAC.

 

When migrating from an Oracle database,SRC_DB_URLthe belowJDBC URLwill not work with Oracle RAC.

 

SRC_DB_URL= jdbc:oracle:thin:@host_name:port:database_id

One should use a service based connection like below connection string in toolkit.properties file : 

 

SRC_DB_URL=jdbc:oracle:thin:@//host_name:port/{database_id|service_name}

You can find the service_name by connecting to Oracle database and use below parameter to search:

 

SQL> show parameter service
  NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
  service_names string XE

Or, you can also find theservice_name in thetnsnames.ora file.

You need to add thisservice_name in the above given connection string.

 

Version history
Revision #:
9 of 9
Last update:
‎07-10-2019 04:49 PM
Updated by: