ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Does TDM Web Portal Support Repository on ORACLE RAC?


Article ID: 4502


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Does TDM Web Portal support Repository on ORACLE RAC?


When using the database connect string provided from the DBA, TDM Portal does not connect.  This is due to not being able to have all servers fully described.


TDM Portal 3.6 and later;Repository on an Oracle RAC system - 3 database servers.


Performing a tnsping <<DB_SERVER_NAME>> will verify the port that is being used. For instance in this case, you were expecting port XXXX and the result from the actual tnsping was different then you know your initial information was not what our software was looking at.  Also, if you add the service name as well as below  

For instance: 

C:\>tnsping localhost/OracleServiceXE 

Provides an output similar to this: 

TNS Ping Utility for 32-bit Windows: Version - Production on 09-NOV-2016 13:49:43 

Copyright (c) 1997, 2010, Oracle. All rights reserved. 

Used parameter files: 

Used HOSTNAME adapter to resolve the alias 

OK (0 msec) 

Please note that it includes a method to contact it. This is especially important in a RAC environment. This is the method used to gather the information for the servers making up the RAC. This is then used in file. See below for further information. 

In the file, instead of this paragraph 

# Database 

Use something like this one 

# Database 

Please note that the description comes directly from the tnsping command result as mentioned above that added the service name to the tnsping command of the hostname.

Note: The example tnsping was NOT from a RAC system but from a standard single DB Server.  If it had been from a RAC system, the Description would have been similar to the RAC Description as above. 

Another note worthy Debugging tool is to edit C:\Program Files\CA\CA Test Data Manager Portal\conf\logback-tdm.xml and change this line 

<!-- <logger name="" level="DEBUG" />-->

to this

<logger name="" level="DEBUG" />

save and restart the service.  This will put debug information out for our Development to review.  When finished replicating the issue, stop the service, revert the line back, save, and restart the service.


Additional Information