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 and Domain Authentication only works when connecting as sysdba

883119Aug 18 2011 — edited Aug 19 2011

Hello,

I'm using Oracle 10g R2 running on Windows System and I try to set it up to use the domain authentication.
I followed many guides (.e.g http://www.oracle-base.com/articles/misc/OsAuthentication.php) I done everything written there but it will not work ?!?!

But it doesn't work. I can only login to the local machine with my domain user and only as sysdba.

If I try just to connect on this server with sqlplus / login fails if I use sqlplus / as sysdba I can connect but only locally on the server.

If I try to connect from remote system I can't even connect as sysdba. What the hell is wrong here..

I mean all databases (MsSQL, MySQL, Postgres) work like a charm with domains but I can't get Oracle 10g to work.

The goal is that the user of the domain can access this database from any remote computer and must be authenticated by the domain only.

More technical details:

Windows XP 32bit with SP3
Oracle 10g R2
Active Directory authentication

Thanks in advance

Edited by: user13779637 on 18.08.2011 05:10

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2011

Added on Aug 18 2011

#authentication, #general-database-discussions

9 comments

442 views