This content has been marked as final. Show 2 replies
aside from the fact you shouldn't use root but your oracle user (or some even less privileged user) to start sqlplus, you need to set up your environment properly to make a login work the way you want to use it. Did you set "ORACLE_SID" in your environment? Are there other database instances next to your XE on that machine?
Does your password contain any special characters that might not be supported by Oracle?