Analytics Software

Hello SmithJohn45.
Try the next commands:

systemctl start oracle-xe-21c
systemctl enable oracle-xe-21c

After running the commands, reboot and test the connection to SQLPLUS.
Regards.

thanks @rober584812 but it is already mentioned in guide and off course i executed those commands to start database audomatically.

thanks again, will check it and give you feedback

@rober584812 here is my feedback...
this helped me and now I can connect to my PDB.
thanks very much for help :)

hi rober584812
it was connected to my PDB but when I restart my CentOS 7 VM now it is not connecting to XEPDB1
i issued 2 ' Alter Pluggable Database ' commands ( as below ) but still failed to connect using sys/ora1234@xepdb1
in my .bash_profile i added following environment variables which can only enable me to run sqlplus, also i have to issue command manually as below to connect to XE (CDB) but this also not allowed me to connect to PDB.
. oraenv
alter commands as per oracle documents:

alter PLUGGABLE DATABASE ALL OPEN;
alter PLUGGABLE DATABASE ALL SAVE STATE;

environment variables:
export ORACLE_BASE=/opt/oracle/
export LD_LIBRARY_PATH=$ORACLE_BASE/product/21c/dbhomeXE/lib
export ORACLE_HOME=$ORACLE_BASE/product/21c/dbhomeXE
export PATH=$ORACLE_BASE/product/21c/dbhomeXE/bin:$PATH
export PATH=/usr/bin:$PATH
export ORACLE_SID=XE
this is same problem i am facing in 18c XE. please help to connect and start Apex 21 + ORDS 21 installation and development.
regards
Is it necessary to issue , oraenv command ? what about if i add it in .bash_profile but will this accept XE as parameter in that file?

Hello SmithJohn45 , check if the listener is running.

cd <oracle_home>/bin
lsnrctl status

After, if the listener status is OK, try the following command:
system/password@localhost.localdomain:1521/XEPDB1
The order . oraenv is necessary.
Regards.

yeah, i can connnect using ezconnect syntax. but as mentioned earlier, i am confused as i want to install Apex & ORDS, how I can configure to use it both " . oraenv " and ezconnect syntax without every time manually interact when logout and login, machine restart etc. and same for production environment?
regards

Hello @smithjohn45 , the important thing is that the listener is working, if the listener is in the OK state, you will be able to access the Oracle XE instance without problems; Regarding the installation of APEX with ORDS, using "oraenv" will be required during the installation process, you can configure ORDS in autorun or standalone mode.
Regards.