Forum Stats

  • 3,826,772 Users
  • 2,260,706 Discussions
  • 7,897,072 Comments

Discussions

Unable to configure directory authentication for Users as SYSDBA

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 –

[[email protected] ~]$ sqlplus sdesmukh/[email protected] 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

[[email protected] ~]$ sqlplus sdesmukh/[email protected]

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 ?

Answers

This discussion has been closed.