OVD 11.1.1.6.0: Error ORA-28274 When Global Users Try To Connect To The Database Using Java Thin Client (Doc ID 1990561.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Virtual Directory - Version 11.1.1.6.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 04-SEP-2016***

Symptoms

1. Receive error 28274 when establishing connection for OVD/EUS users using tools such as OEM 12.1.0.3 , sql developer 1.5.4 that uses jdbc thin client. Error reported is:


java.sql.SQLException: ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

2. Client application like OEM 12.1.0.3 and SQL Developer 1.5.4 works fine if JDBC 11.2.0.3 or higher is used, but it fails with ORA-28274 if an older version is used

3. OVD is working as expected as it returns the required attributes used by the EUS to provide authentication to the database users


4. OVD documentation list known integration limitations

The following is a list of Oracle Virtual Directory-Enterprise User Security integration known limitations:
+ JDBC Thin Driver—you must use the OCI driver

- 19.2.7 Integration Limitations
http://docs.oracle.com/cd/E28280_01/admin.1111/e10046/adv_integrate.htm#OVDAG4288
Oracle Fusion Middleware Administrator's Guide for Oracle Virtual Directory 11g Release 1 (11.1.1.7)

5. The solution for error  ORA-28274 is to upgrade the JDBC client drivers to 11.2.0.3 or higher.

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