-
1. Re: Unable to configure directory authentication for Users as SYSDBA
handat Jul 6, 2016 12:13 AM (in response to Sudipto Desmukh)Step 4 might require you to restart the database in order for the setting to take effect.
-
2. Re: Unable to configure directory authentication for Users as SYSDBA
Sudipto Desmukh Jul 6, 2016 7:22 PM (in response to handat)handat Thanks for your reply. I already tried that.
I noticed a weird thing, if I create the user locally in the DB as in the attached image, I'm able to login just fine albeit with AD password.
But it doesn't make sense to me that for EUS Password Authentication to work for SYSDBA roles, I would need to create local DB users.
-
3. Re: Unable to configure directory authentication for Users as SYSDBA
handat Jul 6, 2016 10:54 PM (in response to Sudipto Desmukh)1 person found this helpfulI think it would make sense since they are special users with additional privileges. They also normally get added to orapw file while normal users don't.
-
4. Re: Unable to configure directory authentication for Users as SYSDBA
Sudipto Desmukh Jul 7, 2016 4:56 AM (in response to handat)Hmmm... handat, even I thought so. But it doesn't make sense since the whole idea of EUS is to centralize Db users in the LDAP.
Moreover this step is not mentioned in Oracle Knowledge Articles or the only blog I found on it. It's more of a hack I feel.
-
5. Re: Unable to configure directory authentication for Users as SYSDBA
Sudipto Desmukh Jul 7, 2016 11:28 PM (in response to Sudipto Desmukh)Does any one have any other ideas on this ?
-
6. Re: Unable to configure directory authentication for Users as SYSDBA
Vivek Anand-Oracle Jul 9, 2016 6:03 AM (in response to Sudipto Desmukh)Hello Sudipto,
Could you please try to connect using an UPPERCASE for the username as follows and see if it returns the same error.
sqlplus SDESMUKH/Welcome1@eusOnWindows as sysdba
Regards
Vivek
-
7. Re: Unable to configure directory authentication for Users as SYSDBA
Sudipto Desmukh Jul 9, 2016 5:14 PM (in response to Vivek Anand-Oracle)Tried already didn't work
Thanks,
Sudipto