NickName:Ahsan Raza Ask DateTime:2018-08-24T14:34:54

Oracle XE ( 11.2.0 ) Database Configuration failed on Ubunto 14 and 16

I am facing Error while configuring Oracle XE after installation. I Follow this Tutorial

https://askubuntu.com/questions/566734/how-to-install-oracle-11gr2-on-ubuntu-14-04

When I run this statement for database Configuration.

/etc/init.d/oracle-xe configure

I face this Error after input ports and 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**

I guess it maybe memory Target size issue. I Tried this

nano /u01/app/oracle/product/11.2.0/xe/config/scripts/init.ora
comment # memory_target=100663296

but It won't work work for me.

Error Log.

PostDbCreation.log

    begin
*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 



File created.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
ORA-00845: MEMORY_TARGET not supported on this system
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 


BEGIN utl_recomp.recomp_serial(); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available 
Process ID: 0 
Session ID: 0 Serial number: 0 


select 'utl_recomp_end: ' || 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

Copyright Notice：Content Author:「Ahsan Raza」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/51998745/oracle-xe-11-2-0-database-configuration-failed-on-ubunto-14-and-16

Answers

Marcin Chaj 2018-08-30T20:53:13

The best would be to start from the beginning.\n\nStep 1 - Installation of SSH server\n\nsudo apt install openssh-server\n\n\nStep 2 - Execute the following commands (pre-requisite packages)\n\nsudo apt-get install alien libaio1 unixodbc vim\n\n\nStep 3 - Download the Oracle 11g express edition setup file from Oracle website http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html . Then go to folder where you have downloaded the setup file (rpm) and convert it to debian type (deb):\n\nsudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm\n\n\nStep 4 - Execute the pre-requisites, \nCreate a special chkconfig script:\n\nsudo vim /sbin/chkconfig\n\n\nand add following into the file:\n\n#!/bin/bash\nfile=/etc/init.d/oracle-xe\nif [[ ! `tail -n1 $file | grep INIT` ]]; then\necho >> $file\necho '### BEGIN INIT INFO' >> $file\necho '# Provides: OracleXE' >> $file\necho '# Required-Start: $remote_fs $syslog' >> $file\necho '# Required-Stop: $remote_fs $syslog' >> $file\necho '# Default-Start: 2 3 4 5' >> $file\necho '# Default-Stop: 0 1 6' >> $file\necho '# Short-Description: Oracle 11g Express Edition' >> $file\necho '### END INIT INFO' >> $file\nfi\nupdate-rc.d oracle-xe defaults 80 01\n\n\nSave the above file and provide appropriate permissions\n\nsudo chmod 755 /sbin/chkconfig\n\n\nExecute the following commands:\n\nfree -m\nsudo ln -s /usr/bin/awk /bin/awk\nmkdir /var/lock/subsys\ntouch /var/lock/subsys/listener\n\n\nExecute the below which prevents oracle installation errors. It is weird but helped in my case. Ignore errors that will appear.\n\nsudo -s\numount /dev/shm\nsudo rm -rf /dev/shm \nsudo mkdir /dev/shm\nmount --move /run/shm /dev/shm\nsudo mount -t tmpfs shmfs -o size=2048m /dev/shm\n\n\nStep 5 - Create the below file, \n\nsudo vim /etc/rc2.d/S01shm_load\n\n\nCopy content below into the opened file:\n\n#!/bin/sh case \"$1\" \nin start) mkdir /var/lock/subsys 2>/dev/null \ntouch /var/lock/subsys/listener \nrm /dev/shm 2>/dev/null \nmkdir /dev/shm 2>/dev/null \nmount -t tmpfs shmfs -o size=2048m /dev/shm ;;\n*) echo error \nexit 1 ;; \nesac \n\n\nExecute the following command \n\nsudo chmod 755 /etc/rc2.d/S01shm_load\n\n\nStep 6 - Restart the machine. \n\nStep 7 - Install Oracle 11gR2 XE. Go to the directory where you created the ubuntu package file and enter following commands (not as root user), \n\nsudo dpkg --install oracle-xe_11.2.0-2_amd64.deb\n\nsudo /etc/init.d/oracle-xe configure\n\n\nEnter the following configuration information: \n\nValid HTTP port for the Oracle Application Express (the default is 8080, use 7070) \n\nValid port for the Oracle database listener (the default is 1521) \n\nPassword for the SYS and SYSTEM administrative user accounts \n\nConfirm password for SYS and SYSTEM administrative user accounts \n\nWhether you want the database to start automatically when the computer starts, Y \n\nStep 8 - Before you start using Oracle 11gR2 XE you have to set-up few things more. \nChange to users home directory (type cd) \nOpen bashrc using the command \n\nvim .bashrc\n\n\nAdd following lines to .bashrc : \n\nexport ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe \nexport ORACLE_SID=XE \nexport NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` \nexport ORACLE_BASE=/u01/app/oracle \nexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH \nexport PATH=$ORACLE_HOME/bin:$PATH \n\n\nExecute .profile to load the changes: \n\n. ./.profile\n\n\nOpen root bash using \n\nsudo vim /root/.bashrc \n\n\nand copy the same contents at the end of that file \n\nStep 9 - Restart the appliance. Oracle should have been started now \n\nStep 10 - Execute the following command to enter SQL prompt \n\nsqlplus sys as sysdba\n",