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!

Problem running Oracle XE on windows

user1220639Nov 26 2018 — edited Nov 28 2018

I'm not a DBA and I'm not used to Oracle, but I need to have a small oracle database to test a stored procedure before installing it on my client environment.

So I thought it could be easy to install an Oracle XE...

Here is my environment : Oracle XE 11.2.0 on Windows Server 2016 Standard 64bits

After installing I follow the documentation and run SQL command line :

SQL> connect

Enter user-name: system

Enter password:

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Process ID: 0

Session ID: 0 Serial number: 0

I tried to set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server (not sure it's the good directory)

But the result is the same...

I heard about ORACLE_SID but I don't know what to put in it...

Can you help ?

Added on Nov 26 2018

12 comments

2,313 views