Problem running Oracle XE on windows

user1220639

Hi

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 ?

Billy Verreynne

In Windows, services are used to auto start the database and listener - and (if I recall correctly from 8i, the current version when I last used Windows), the oradim command was used to create and delete such services. I assume XE does not behave differently in this regard.

Refer to Creating an Oracle service on Windows - Oracle FAQ for details.

cormaco

Is "Start Database" working for you?

Exploring the Oracle Database XE User Interface

user1220639

Hi

I don't know what "Start database" is supposed to show but when I run it it just show me a prompt with C:\oraclexe\app\oracle\product\11.2.0\server\bin>

Is it ok ?

Windows services OracleServiceXE and OracleXETNSListener are running

clcarter

Services might be running, but the ORA-01034: ORACLE not available ... means the instance is not running. Try starting it:

sqlplus /nolog

conn /as sysdba ;

startup ;

If installer didn't finish all its chores the database didn't get created, startup will probably gripe about the controlfile, or datafiles. Can't recall the exact location but there should be an ...\oradata\XE folder and it may be empty- should be five or six *dbf files and a controlfile in that folder. One possible cause for the database not getting created is not running the installer as a local admin user, check via a cmd.exe box:

net localgroup administrators

...administrators

...<domain>/<user>...

If %USERDOMAIN%/%USERNAME% (?) aren't on the list isn't on the list, login to the host with an admin user and deinstall, and on the installer .exe do the right click/runas administrator.

>>not sure it's the good directory

Looks pretty close- file explore and look in \oraclexe. Or type system.dbf into the explore search box explore should come up with datafiles folder. If they're present.

cormaco

I don't know what "Start database" is supposed to show but when I run it it just show me a prompt with C:\oraclexe\app\oracle\product\11.2.0\server\bin>Is it ok ?Windows services OracleServiceXE and OracleXETNSListener are running

It should start a batch skript that starts the database services.

Start Database: Starts Oracle Database XE if it is currently stopped. By default, the database is started for you after installation and every time your computer is restarted. However, to reduce the overall performance load on the system, you can manually stop the database, and then manually restart it later.(If the database is not currently stopped, an informational message is displayed that the database is already started.)

user1220639

Hi,

You're right : oradata/XE is empty !

It's not a problem of user right because I use the user "Adminstrator" to install Oracle.

I tried to uninstall and reinstall but the problem is the same : install seems to finish without error but oradata is still empty...

And then :

SQL> conn /as sysdba;

ERROR:

ORA-12638: Credential retrieval failed

cormaco

It's not a problem of user right because I use the user "Adminstrator" to install Oracle.

That may not be enough. Right-click on setup.exe and select "Run as Administrator".

Jason A.

if you right click on the file and hit properties.  If there is a button that says "unblock" in the bottom right corner click that first and then hit ok.  Next you should right click the installer and run as administrator.

user1220639

Hi

There's no "unblock" button

I tried reinstalling with "run as administrator" -> same result....

user1220639

Hi

There's no "unblock" button

I tried reinstalling with "run as administrator" -> same result....