GRC - DataSource Test Connection Failed (Doc ID 1984150.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 and later
Information in this document applies to any platform.


On : 8.6.5 version, Application Access Contr. Gov.

DataSource Test Connection Failed in GRC, When configured the Application datasource.


In grc.log,

2015-02-20 21:32:16,924 DEBUG [http-bio-8080-exec-10] DataSourceDaoSpr:1725 in testDSConnection connect to jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(
2015-02-20 21:32:16,924 DEBUG [http-bio-8080-exec-10] DBConfigUtil:601 in getNewConnection(String, String, String)
2015-02-20 21:32:19,423 ERROR [http-bio-8080-exec-10] DataSourceDaoSpr:1759 Error in testDSConnection: java.sql.SQLException: ORA-12545: Connect failed because target host or object does not exist

The issue can be reproduced at will with the following steps:
1. Navigate to Setup and Administration > Manage Application Datasources.
2. Create a datasource.
3. Save and Test Connection.

The issue has the following business impact:
Due to this issue, users cannot create datasource and run ETL for the datasource.


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