LSH/DMW 2.4 - Loadset Job And Data Model Installation Failing With "ORA-12170: TNS:Connect timeout occurred"
Last updated on AUGUST 28, 2017
Applies to:Oracle Life Sciences Data Hub - Version 2.4.3 and later
Information in this document applies to any platform.
On : 2.4.3 version, Installation and Upgrade
When attempting to submit a Loadset (part of LSH Smoke Test), after moving LSH database servers from one server to another server with DB cloning fashion (MT not moved),
the following error occurs.
Also, when installing a Data Model in DMW, the same "ORA-12170: TNS:Connect timeout occurred" is thrown.
LSH Loadset job log ERROR
The issue can be reproduced at will with the following steps:
A. For LSH Loadset:
1. Create text Loadset
2. Submit Loadset
3. Check the job log
B. For DMW data model:
1. Login to DMW (User should have privs)
2. Search for a Study in Home (eg. Smoke_DMWTEXT_GN)
3. Click on Study Configuration
4. Search for a Clinical Data Model (eg. TextDM)
5. Install the Data Model using Upgrade/Full install
Issue ocured after moving LSH database servers from one server to another server with DB cloning fashion (MT not moved),
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms