cancel
Showing results for 
Search instead for 
Did you mean: 

Using MTK with ORACLE RAC and EXADATA

xDB doesn't support RAC and EXADATA out of the box. 

 

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

 

When migrating from an Oracle database, SRC_DB_URL the below JDBC URL will 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 the service_name in tnsnames.ora file.

 You need to add this service_name in the above given connection string.

 

Version history
Revision #:
7 of 7
Last update:
Tuesday
Updated by:
 
Contributors