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!

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

8,091 views