My Oracle Support Banner

Analyses In Oracle Analytics Server Fail With ORA-12154 Error When Using A Tnsnames.ora Alias In The RPD Connection Pool (Doc ID 2970727.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Analytics Server - Version 2022 (6.4) and later
Information in this document applies to any platform.

Symptoms

For an Oracle Database data source in Oracle Analytics Server (OAS), the Data Source Name in the repository connection pool is updated with the Oracle Database alias as set in the tnsnames.ora file. However, analyses fail and return the below error:

[nQSError:17001] Oracle Error code: 12154, message: ORA-12154: TNS: could not resolve the connection identifier specified at OCI call

This issue persists even after the alias is added to all "known" tnsnames.ora files as below:-

<DOMAIN_HOME>/config/fmwconfig/bienv/core/tnsnames.ora
<DOMAIN_HOME>/bidata/components/core/serviceinstances/ssi/oracledb/tnsnames.ora
<ORACLE_HOME>/bi/modules/oracle.bi.servicelcm/oracledb/tnsnames.ora
<ORACLE_HOME>/network/admin/tnsnames.ora

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.