Fatal error during TDM repository installation- DBMS cannot be contacted

Document ID : KB000007505
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We downloaded TDM and are trying to install the repository. We are running the Oracle database install kit command from these instructions: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/install-the-repository#InstalltheRepository-UsetheDatabaseInstallerUtilitytoInstalltheRepository 


When running this from the command line, we are receiving the following error message: Fatal error: Dbms cannot be contacted. We went to C:\Users\AppData\Roaming\Local\Temp to find the ca-tdm-db-installer.log. The log file revealed the error message- ORA-12154: TNS:could not resolve the connect identifier specified. SP2-0751: Unable to connect to Oracle. 

Environment:
CA Test Data Manager (TDM)- Datamaker
Cause:

This error message means that the Oracle database cannot be reached either because the user does not have permission or because it is not running. Although you may be installing the repository on your local machine or a machine you are an admin of, the existing Oracle database may be in another location where your user does not have admin access.

Resolution:

We suggest installing the Oracle database to a location where you will be the administrator of it and be able to connect without issue. 

Documentation to install and connect to the repository: 
- Install Repository: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/install-the-repository 
- Connect to Repository: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/connect-to-the-repository

Additional Information:

If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html.