Test Connection for Oracle Physical Data Servers is Failing with 'ORA-12505 TNS: listener does not currently know of SID given in connect descriptor' (Doc ID 2176386.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.0.2.1 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Healthcare Translational Research (TRC) 3.0.2.1 version,

When attempting to Test Connection for Oracle physical data servers,
the following error occurs.

ERROR
-----------------------


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Navigate to Topology > Physical Architecture tab, expand Oracle under
    Technologies. Select the physical data server created for APPS and double-click it.
2. Click Test Connection.

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