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

0
votes

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

This is the screen shot of the error

1
oraclesqlplus
Welcome to Stack Overflow. Please always provide source code, error messages and other textual information as inline plain text rather than external pictures. Text is searchable, reusable and normally easier to read. - Álvaro González
You've been prompted for a user name ("Enter user-name: "). You've entered a connect command ("conn / as sysdba"). That may, perhaps, explain the problem you're having. - Bob Jarvis - Reinstate Monica

1 Answers

1
votes

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.