AD authentication on Oracle Database using OID
223508May 16 2005 — edited May 23 2005We want to achieve Single Sign-On with AD being the master LDAP repository.
Our Oracle Database environment is on Solaris so we cannot use Windows native authentication.
We have successfully installed and configured Oracle10g Release 2 Applications Server with the intent on using AD to synchronize with OID.
We linked an Oracle instance with the OID Server.
We can authenticate OID users in the database instance.
We configured import connector to replicate user information from AD to OID.
We configured OID to use external authentication to AD and can log into DAS using an AD account with AD credentials.
Problem:
We cannot log into the Oracle Database instance using AD authentication because the password field in OID is blank. However, since it is using external authentication to AD, it is supposed to be blank.
The error generated is below:
SQL*Plus: Release 10.1.0.4.0 - Production on Mon May 16 09:13:39 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-28274: No ORACLE password attribute corresponding to user nickname exists.
Any help or suggestions would be appreciated.
Thanks,
Anthony
siua@fhlbsf.com