- Written by Erwin
- Category: Oracle
- Published: 20 November 2013
- Hits: 2100
A short notice on installing Oracle 11g database.
I installed it on Oracle Linux 5 with an alias/SID bigger than 8 characters; in my case ora11g2se. This results in an error when starting the database:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initora11g2se.ora'
The error message should state: could not open parameter file 'spfileora11g2se.ora', because thát is the file missing.
When you look in your $ORACLE_HOME/dbs directory you'll find a spfileora11g2s.ora. Just copy it with the full database alias:
cp spfileora11g2s.ora spfileora11g2se.ora
and start the engines... uh ... database!