Forum Stats

  • 3,783,394 Users
  • 2,254,768 Discussions
  • 7,880,377 Comments

Discussions

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

SmithJohn45
SmithJohn45 Member Posts: 467 Blue Ribbon

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/[email protected] 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

Answers