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!

Can connect using SQL Developer but not using SQLPlus with XE 18c

LeFromageJun 5 2020 — edited Jun 17 2020

Hello,

I recently installed OracleXE184.

I can connect to the database using SQL Developer. However, I cannot using SQLPlus. When attempting to connect using SQLPlus, I'm given the following error message:

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Process ID: 0

Session ID: 0 Serial number: 0

What should I do? Why does it work with Developer but not SQLPlus?

Thank you :-)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2023

Added on Jun 5 2020

11 comments

3,683 views