Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OS authentication only works for sys

2750374Aug 9 2016 — edited Aug 12 2016

Hello,

I recently installed an oracle database 12.1.0.2 and am trying to get os authentication setup. I am not using a container database or anything special. I have the remote_os_authent parameter set to true as well.

If i do "sqlplus /" i get back invalid username/password. My OS user is oracle and i have a database user called ops$oracle and ops$ is still the default prefix parameter. The odd thing is if i do "sqlpls / as sysdba" then it will connect me as sys user just fine.

Any ideas why im getting connected as sys and am unable to connect as ops$oracle ?

This post has been answered by Vlad Visan-Oracle on Aug 11 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2016

Added on Aug 9 2016

#general-database-discussions

5 comments

852 views