LSH/DMW 2.4 - Loadset Job And Data Model Installation Failing With "ORA-12170: TNS:Connect timeout occurred" (Doc ID 2093372.1)

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.

Symptoms

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
------------------------------


STEPS
-----------------------
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

Changes

Issue ocured after moving LSH database servers from one server to another server with DB cloning fashion (MT not moved),

Cause

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