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 and later
Information in this document applies to any platform.


On Oracle Healthcare Translational Research (TRC) version,

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


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.


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