Login as SYS user to Oracle 11g from .NET

Posted by Jens Bannmann on Stack Overflow See other posts from Stack Overflow or by Jens Bannmann
Published on 2010-04-09T12:36:56Z Indexed on 2010/04/14 14:43 UTC
Read the original article Hit count: 258

Filed under:
|
|
|
|

Using the Oracle Data Provider for .NET, my application connects to the database using the privileged SYS user. The connection string is as follows:

Data Source=MyTnsName;User ID=sys;Password=MySysPassword;DBA Privilege=SYSDBA

This works fine with Oracle 10, but Oracle 11 keeps complaining about an invalid username or password. I verified that the password is correct - other apps work fine with the same credentials.

Note that for regular users (without the DBA Privilege part), connecting to Oracle 11 works perfectly.

So, what's wrong?

Update:
This is not an issue with case sensitivity - when constructing the connection string, the password case is not altered by my code, and the password works fine with other, non-.NET-applications.

I suspect that this might be caused by the Oracle 10 client I'm using to connect to the 11 database. Oracle states that the client is upward-compatible, the only drawback being that you cannot use some new features of the database. However, SYSDBA connections clearly are not a new Oracle 11 feature, and - again - a non-.NET-app (Keeptool Hora) can connect using the same setup.

Any other ideas?

Update 2:
The problem persists when using an Oracle 11 client :-(

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about sysdba