This discussion is archived
12 Replies Latest reply: Feb 5, 2013 8:00 AM by user8954613 RSS

LDAP USER OS AUTHENTICATION ERROR (sqlplus / as sysdba)

user8954613 Newbie
Currently Being Moderated
hi,

i have an ldao user which is dba and oinstall group member.

[myuser@myhost ~]$ id
uid=10031(myuser) gid=86(dummy) groups=86(dummy),500(oinstall),501(dba)

I can not login sqlplus without password:

[myuser@myhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 16 14:53:11 2013

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

ERROR:
ORA-01031: insufficient privileges


Enter user-name:



OS auth. is successful by the same grouped local user:

[myuser@myhost ~]$ id test1
uid=59831(test1) gid=86(dummy) groups=86(dummy),500(oinstall),501(dba)


I think this problem occurs because of ldap user. So, we realize that somehow, sqlplus checks /etc/passwd for os user.
Is there any sqlplus parameter for this problem or any other solutions??

Answers will be appreciated, thanks very much.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points