REP-501 Error When Connecting to Oracle Reports Using Externally Authorized User (Doc ID 162457.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Reports Developer - Version 6.0.8 to 12.2.1.0.0 [Release 6.0.8 to 12c]
Information in this document applies to any platform.

Symptoms

Running any report fails with the following error when connecting to Oracle Reports using Externally Authorized User (OPS$ user):

REP-501: Unable to connect to the specified database.


This is a feature of the Oracle database and TNS. Database is configured for remote authentication (OPS$) by setting the following INIT.ORA parameter:

 

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