Your Location is: Home > Oracle

Why is the command conn / as sysdba throwing an error in sqlplus?

From: Spain View: 4665 Hello 


Enter user-name: conn / as sysdba Enter password: ERROR: ORA-01017: invalid username/password; logon denied

This is the screen shot of the error

Best answer

The special string / as sysdba tells Oracle to use OS Authentication instead of a username/password. Your OS (looks like Windows) is not authorizing you to connect to Oracle as sysdba.

Make sure your Windows user is a member of the ORA_DBA local group on that computer.