Skip to Main Content

Security Software

Announcement

Testing banner

Unable to configure directory authentication for Users as SYSDBA

Sudipto DesmukhJul 5 2016 — edited Jul 9 2016

We had a task where we were required to assign SYSDBA privileges to a certain user using Directory Authentication using EUS

Here’s the document & blog we followed -

How To Configure Directory Authentication for Database Administrative Users (SYSDBA and SYSOPER) (Doc ID 457083.1)

http://blog.yannickjaquier.com/oracle/enterprise-user-security-eus-password-authentication.html

But we get the following error –

[oracle@xovm1116 ~]$ sqlplus sdesmukh/Welcome1@eusOnWindows as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 5 15:25:40 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

However, since EUS is configured, the user is able to login fine as a non-SYSDBA user as shown below

[oracle@xovm1116 ~]$ sqlplus sdesmukh/Welcome1@eusOnWindows

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 5 15:23:25 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Any ideas on what I could try or might be missing ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details