Skip to Main Content

XE not able to connect via SQL*Plus

User_XILROFeb 16 2022

Yesterday I have installed "Oracle Database 21c Express Edition for Windows x64" for testing purposes.
What is working:
https://localhost:5500/em/ --> OK (SSL not used, warning ignored; user: sys)
https://localhost:5500/em/shell --> all "tables spaces" having status "green"
What is not working
SQL*Plus claims wrong user/password --> ORA-01017: invalid username/password; logon denied (user sysdba, because on user sys I get: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER)
http://localhost:1521 --> ERR_EMPTY_RESPONSE
https://localhost:1521 --> ERR_TIMED_OUT
Same result/problem for http://localhost:1521/XEPDB1 ...
How can I manage/login via SQL*Plus?
Database seems to be online and Oracle service(s) are running!
listener.log does not give information about failed login attempts... tnsnames.ora looks correct (auto-generated by setup...) ...
Big thanks in advance for helping me in making Oracle XE working!

This post has been answered by User_XILRO on Feb 22 2022
Jump to Answer
Post Details
Added on Feb 16 2022
1 comment