My Oracle Support Banner

OBIEE 11g: How to Configure the TNS/OCI Alias for Deployment on Unix or Linux to Avoid the Error: "ORA-01017: invalid username/password; logon denied" (Doc ID 1538169.1)

Last updated on SEPTEMBER 13, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11g]
Generic UNIX
Generic Linux

Purpose

This document intends to describe a method to configure the TNS/OCI alias from RPD development to deployment on a Unix or Linux server where OBIEE 11g is installed to avoid common ORA-01017 'invalid username/password; logon denied' errors from mis-configuration when connecting to an Oracle database.

Scope

Typically, ORA-01017 errors can be misleading or difficult to troubleshoot because of the potential points of mis-configuration and the error message could be misleading. This document is intended for OBIEE Administrators and basic understanding of connections is assumed. This only covers connections to the Oracle database via OCI / TNS, no other databases or connectivity is covered (i.e. - odbc, jdbc) as OCI is the preferred connectivity to an Oracle database

Details

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
Purpose
Scope
Details
 A Typical Error Message:
 ORA-01017 can occurs for several reasons:
 The deployment scenario which most often exhibits this issue, is as follows:
 What have you configured:
 How do we fix the problem?

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