I recently install an Oracle XE database on Ubuntu by following these steps:
I downloaded the latest rpm file for Oracle XE and ran the following commands to install the database:
sudo apt-get install alien
alien oracle-xe-11.2.0-1.0.x86_64.rpm
dpkg -i oracle-xe_11.2.0-2_amd64.deb
Then I made sure that I have permissions on / u01 / as well as on the dba group.
Now when I try to start the database, I am having problems:
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 13 15:33:51 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> start
SP2-1506: START, @ or @@ command has no arguments
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'
I see that I do not have a file initXE.ora, and I only have init.ora, as shown here:
$ ls /u01/app/oracle/product/11.2.0/xe/dbs/
init.ora
Update:
I copied the file init.ora, renamed it to a file initXE.oraand updated the parameters in it so that they point to valid directories, now when I start my database, I get an error message:
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2233344 bytes
Variable Size 616565760 bytes
Database Buffers 444596224 bytes
Redo Buffers 5541888 bytes
ORA-00205: error in identifying control file, check alert log for more info