7 Replies Latest reply on Jul 9, 2016 5:14 PM by Sudipto Desmukh

    Unable to configure directory authentication for Users as SYSDBA

    Sudipto Desmukh
    Sudipto Desmukh Jul 5, 2016 8:32 PM

      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 ?