SQL Developer

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connecting as sysdba returns ORA-01017: invalid username/password

842271Dec 3 2011 — edited Dec 5 2011

SQL Developer on my Win7 x64 Enterprise machine with Oracle 11gR2 Express was working fine until I tried to install the ODAC connectors so I could use Oracle as a data source for C# and VB in Visual Studio 2010.

The connection properties are:

Connection name "/ as sysdba"
Role "default"
Connection Type "basic"
OS Authentication checked
Hostname "localhost"
Port 1521
SID "orcl"

These are the same as when SQL Developer was working.

If I try to log on to SQL*Plus at the user-name prompt with "/ as sysdba", I get "insufficient privileges".

Where and what do I check to fix this?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2012

Added on Dec 3 2011

#sql-developer

4 comments

7,735 views