Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 installed the Oracle 11g server on Ubuntu 12.10. But I can't start the server. When I start up the server, the following error occurs.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora'

How can I solve this issue? I think the connect failed because target host or object does not exist. How can a target host be specified?

Update as requested. Running:

$ ls -latr /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora


-rw-r--r-- 1 oracle dba 2637 Mar 13 17:07 /u01/app/oracle/product/11.2.0/xe/dbs/initxe.ora 
share|improve this question

migrated from Mar 13 '13 at 18:26

This question came from our site for Ubuntu users and developers.

What is the output of "ls -latr /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora" – Aaron Mar 13 '13 at 14:38
hi ,thanks for your comment .the out put is -rw-r--r-- 1 oracle dba 2637 Mar 13 17:07 /u01/app/oracle/product/11.2.0/xe/dbs/initxe.ora – Praneeth Pj Mar 13 '13 at 15:29
Ok, how about the output of "echo $ORACLE_SID" – Aaron Mar 13 '13 at 15:33
it is nothing display.start a empty line ! – Praneeth Pj Mar 13 '13 at 15:48
ls initXE.ora will not return initxe.ora. Unix is case sensitive. – miracle173 May 24 '14 at 22:29

I see two things wrong here. Oracle tries to open a parameter file in the $ORACLE_HOME/dbs directory with the format "spfile" + $ORACLE_SID + ".ora". If it cannot find it, it then tries to open "init" + $ORACLE_SID + ".ora". This is where the problem(s) are.

By virtue of the fact that Oracle is trying to open a parameter file named "initXE.ora", your SID must be (or was at one point) equal to "XE".

1) This is the easy part, so try this first. Since (in your comments) doing an echo $ORACLE_SID yields nothing, try setting it.


Then try starting Oracle again.

2) In your comments above, you show the file is named "initxe.ora". Is that really the name of the file? Or did your paste into a comment somehow lowercase the output of the ls command?

The reason I point this out, is that Ubuntu (Linux) has a case-sensitive filesystem. So initxe.ora and initXE.ora are actually two different files. So if your comment is correct and the file is lower-cased, you'll want to set your ORACLE_SID to "xe" instead:

export ORACLE_SID=xe

Try that, and see if it works.

share|improve this answer
thanks for your answer it is really helpful.but this error is below occurred.this is my first time installing oracle on the linux os.ORA-48108: invalid value given for the diagnostic_dest init.ora parameter ORA-48140: the specified ADR Base directory does not exist [/u01/app/oracle/product/11.2.0/xe/dbs/<ORACLE_BASE>] ORA-48187: specified directory does not exist Linux-x86_64 Error: 2: No such file or directory Additional information: 1 – Praneeth Pj Mar 14 '13 at 3:06
The case sensitivity issue is a good catch, thanks. – beldaz Mar 10 at 3:54

If this is a new installed Oracle and you do not have initXE.ora parameter file here /u01/app/oracle/product/11.2.0/xe/dbs/, that means you need to create XE DB first. To do that run /u01/app/oracle/product/11.2.0/xe/bin/ script first.

share|improve this answer

find "initXE.ora" in your oracle directory and used :
SQL> startup pfile=<directory_name>/initXE.ora

share|improve this answer
You might want to add some details about why this works, or what the problem is with the original poster's question. – Max Vernon Jan 1 '14 at 20:48

Just do ls -altr. If you find like this ...

-rw-r--r-- 1 oracle oinstall 2637 Mar 13 init.ora

... just change the owner: chown -R oracle:dba init.ora, then startup.

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.