Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm having problems installing Oracle XE 10g on a Windows Server 2008 64 bit machine.
After the installation the connection to the database administration page fails.

If I run sqlplus / as sysdba I get the error ORA-12560: TNS:protocol adapter error.

Looking at the services, I can see that OracleServiceXE is not started (even if the startup type is automatic).

I restart the service and re-run

c:\>sqlplus / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Is it possible to recreate that file somehow? I already tried uninstalling and reinstalling, and got exactly the same behavior.

share|improve this question
up vote 3 down vote accepted

I assume you have a pfile somewhere? Either in the directory where it's looking for the spfile in your question, or perhaps in the admin\pfile directory. Anyway, try:

sqlplus / as sysdba
create spfile from pfile='<location of pfile>'

That should do it.


You can always go back and forth with your spfile and pfile in this manner. It's good to have a text file backup of your spfile, since you can't directly edit the spfile (you can only change it when the database is mounted):

create pfile='<pfile location>' from spfile;

The spfile gives you the ability to change dynamic parameters while the database is open without restarting the database and to make them permanent across database restarts:

alter system set open_cursors=new limit scope=both

This makes the change in the running database as well as the spfile to make it effective across DB restarts.

With the old pfile paradigm, you had to edit the pfile manually to make the change effective across restarts. Additionally, you can modify parameters that require a database restart in the spfile while the database is up, to become effective on the next restart:

alter system set sga_max_size=new_sga_max scope=spfile

You can't modify the running instance with this parameter, but you can make it effective on the next restart.

share|improve this answer

I had the same problem after installing Oracle 11R2 XE in Windows 8.1 as a domain user who was an administrator of the local machine. After I reinstalled Oracle as a local adminstrator (can't remember where I read this hint) the problem was solved.

share|improve this answer

On my workstation, I had to right click on the installer > execute as administrator to resolve the problem.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.