I have tried to install Oracle-xe-21c on Oracle Linux 8 and am unable to get a connection using SQLPLus
When i issue this command, I am able to login using SYSTEM and the password I entered when configuring the system. If I use SYSDBA I get an invalid username / password. Is that right, and what are the different default users for ?
sqlplus / as sysdba
ORACLE_SID=XE
ORACLE_BASE=/opt/oracle/product/21c/dbhomeXE
ORACLE_HOME=/opt/oracle/product/21c/dbhomeXE
$ lsnrctl status
LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 04-SEP-2024 15:32:10
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 21.0.0.0.0 - Production
Start Date 04-SEP-2024 14:45:06
Uptime 0 days 0 hr. 47 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /opt/oracle/homes/OraDBHome21cXE/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=localhost)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "2150a159efed7a60e065000000000001" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "xepdb1" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully