For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi, How to add (register) more GPIO pins which are not included in the preconfigured list?
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.
@smithjohn45 read and try the next: https://connor-mcdonald.com/2021/09/23/21cxe-post-install-tip/ Regards.
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.
system/password@localhost.localdomain:1521/XEPDB1
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.