Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details [solved]

This error occurred when I was installing oracle 11g R2 express.

Post installing rpm file, next action is to run ‘sudo /etc/init.d/oracle-xe configure’.

Following error message is displayed:

Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

When looking at log files, obscure messages were printed:

Create controlfile reuse set database “XE”
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

BEGIN dbms_backup_restore.zerodbid(0); END;

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

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
Create controlfile reuse set database “XE”

Solution to this is pretty simple:

  1. ensure hostname contains basic characters (no slash and co…), to find your hostname, run `hostname`
  2. edit file /etc/hosts and make sure your hostname, as returned by command `hostname`, is a matching entry for 127.0.0.1 (if not, add it after localhost, using a space as separator)

That’s it.

Install oracle, run `sudo /etc/init.d/oracle-xe configure` and you should see a successful message.

Starting Oracle Net Listener…Done
Configuring database…Done
Starting Oracle Database 11g Express Edition instance…Done
Installation completed successfully.

sources

3 Comments: Trackback URL | Comments RSS

  1. Victor Says:

    many thanks for simple and useful explenation
  2. Victor Says:

    Thanks for the Post. It worked for me with ease.
  3. Jason Says:

    Thanks for help... In centos 7 function: # nano /etc/hosts 127.0.0.1 localhost.localdomain localhost dhcppc2.domain dhcppc2 dhcppc2 = hostname.

Post a Comment

Your email is never published nor shared. You're allow to say what you want...