Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

18cXE on CentOS 7: can't connect to XEPDB1

SmithJohn45Oct 1 2021 — edited Oct 1 2021

hi all,
installed 18c XE on CentOS 7, all things done and I can connect using:
sqlplus sys/ora1234 as sysdba
but even after created an entry in "tnsnames.ora" for XEPDB1 and issued below 2 ALTER PLUGGABLE commands as per documentation i can't using: sqlplus sys/ora1234@XEPDB1 as sysdba

SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
SQL> ALTER PLUGGABLE DATABASE ALL SAVE STATE;

only can connect using :

ALTER SESSION SET CONTAINER=xepdb1;

i have to install and use Oracle Apex with ORDS on this machine, so please help.
regards

Comments
Post Details
Added on Oct 1 2021
1 comment
271 views