Centos – Install oracle 11gR2 on Centos 5 : No init file found

centosdatabaseoracle

I'm trying to install oracle 11gR2 on Centos 5 and when I do a /etc/init.d/oracle start
I get in the log :
No init file found for Database instance "ORCL".
Error database instance "ORCL" not started.

I've followed this tutorial very well explained :
http://ivan.kartik.sk/oracle/install_ora11gR1_elinux.html

Do you have any idea about what's wrong ?

Thank you for your help !

Best Answer

To start a database, Oracle need a parameter file. It can be either an ASCII file (pfile) or a binary file that must not be modified by hand (spfile).

According to the error message, Oracle can't find this file and thus can't start your database. The file is suppose to be created with the database, not during the installation of the engine.

If you don't specify the file when you start the database, Oracle will look for the following files in $ORACLE_HOME/dbs:

  • spfileSID.ora
  • spfile.ora
  • initSID.ora
  • init.ora

You can find more informations about pfile and spfile here.

Related Topic