0

I'm currently using oracle xe c18. I can login using sqlplus / AS SYSDBA as oracle user. However, the command does not work for other users. It always shows an error ORA-01017: invalid username/password; logon denied. I already give SUID and GUID to all installation files. What's the problem?

Improve this question
1
  • How did you create those "other users"? With Oracle, database users are not necessarily the same as OS users.
    – mustaccio
    Nov 19, 2020 at 18:04

1 Answer 1

Reset to default
2

The syntax you gave is using 'os authentication' to connect. That is, the OS user issuing the command is a member of the os group "DBA". (Or, on Windblows, "ORA_DBA"). I hope you did not change ownership or permission of any of the files.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.