28. September 2011

Oracle 11G XE Installation error: Database Configuration failed

While running the oracle configuration after installation:

/etc/init.d/oracle-xe configure

 the following error specified:

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

After looking inside the log file /u01/app/oracle/product/11.2.0/xe/config/log/CloneRmanRestore.log you can see an error which looks like:

 ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oralinux)(PORT=1521))'

The hostname "oralinux" cannot be found because it is not registered inside the dns-server. You can simply add an /etc/hosts file:

127.0.0.1 oralinux

After saving the file, rerun "/etc/init.d/oracle-xe configure" and everything should be fine.

15 Kommentare:

  1. I have no words for this great post such a awe-some information i got gathered. Thanks to Author.

    AntwortenLöschen
  2. solved my problem - great idea!

    AntwortenLöschen
  3. thanks a lot!
    save me from linux trouble :)

    AntwortenLöschen
  4. This site was... how do I say it? Relevant!! Finally
    I've found something which helped me. Thank you!
    my web site - tokyo milk bubble bath

    AntwortenLöschen
  5. Thank you, Arne. My problem solved with your tip. Great help!

    AntwortenLöschen
  6. Extremely helpful, thank you! Danke schön!

    AntwortenLöschen
  7. Thanks a lot, you save my day ...

    AntwortenLöschen
  8. I am getting the error :

    alter user sys identified by "oracle"
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0


    alter user system identified by "oracle"
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0


    alter system disable restricted session
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0


    What should i do?

    #env | grep ORACLE
    gives nothing

    AntwortenLöschen
  9. 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-00119: invalid specification for system parameter LOCAL_LISTENER
    ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=mobiusQA)(PORT=1521))'
    Create controlfile reuse set database "XE"
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0

    #env | grep ORACLE

    nothing

    AntwortenLöschen
  10. Hi, I wanted to install oracle 11g xe on ubuntu on my laptop. I wanted to learn sql statements. I had tried all tha was there on internet about installation for 2 complete days, but nothing worked. I got the same error - database configuration failed and the log files read the "memory target error". I gave up and tried to install another linux version that is based on ".rpm", but unfortunately here also i got the same error - database configuration failed but the log files read the different error - ORA-00130. I just followed your instructions and updated the hosts file. Then all went fine and now oracle is successfully installed on my computer. Thank You Very Much. However I liked ubuntu 12.4 lts very much because of its easy GUI. I wish if there is a solution for installing oracle 11g xe on it. well once again Thank You for saving my time.

    AntwortenLöschen
  11. Danke! It solved my problem

    AntwortenLöschen
  12. Thanks! Solved my problem.

    Oracle Express 11gR2 on Centos 6.5 64 bit.

    AntwortenLöschen
  13. Thanks! Solved my problem. You are my new God!!!

    AntwortenLöschen
  14. Boss, Thanx

    Regards,
    Harsha.

    AntwortenLöschen