How can I install Oracle 11g on Ubuntu 16.04
Linode
Linode Staff
Hi,
I tried installing Oracle 11g on Ubuntu 16.04, and I encountered the following error during the configuration process. Does anyone have any input or advice on how to proceed?
sudo /etc/init.d/oracle-xe configure
Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Password can't be null. Enter password:
Confirm the password:
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y
Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details
----------------------------------------------------------------------------------------
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
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'
select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
2 Replies
It looks like you are trying to install Oracle 11g on Ubuntu using a RPM, which is dependent on converting the Red Hat based package to a Debian package using 'sudo alien -d'. Doing this conversion is not supported, and because of this, you can encounter a lot of issues. I was able to find more information on the installation of Oracle 11g on Ubuntu 16.04 in this blog post.
This may already be the guide you are using, since I see you issued a similar command 'sudo /etc/init.d/oracle-xe configure', but I wanted to include it in hopes that it will be useful to you. I also found this guide on installing Oracle 11g on CentOS7 which shows a more straightforward installation process using CentOS 7. Since CentOS7 is Red Hat based, you do not have to convert the RPM and may have a more natural process with the installation.
Since you are running 'oracle-xe configure' seems you got past the installation part. The ORA-1034 and ORA-27101 usually is due to kernel parameter setup. Check the parameters listed on https://wiki.debian.org/DataBase/Oracle#Preparations
Just a note: the last (and only) Oracle XE edition released as a Debian package (.deb) at the time of this update is Oracle 10g XE which you can get by adding the repository
deb http://oss.oracle.com/debian unstable main non-free
or directly from https://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/
The installation may require libaio which you can get from:
https://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb