ORA-01034: ORACLE not available error when configuring Oracle ApEx

10,964

http://blog.whitehorses.nl/2014/03/18/installing-java-oracle-11g-r2-express-edition-and-sql-developer-on-ubuntu-64-bit/

After reinstalling and following this instructions it finally works. Cheers!

Share:
10,964
Mateusz Mateja
Author by

Mateusz Mateja

Updated on June 05, 2022

Comments

  • Mateusz Mateja
    Mateusz Mateja almost 2 years

    I want to configure on Ubuntu system the Oracle Application Express and when I sudo /etc/init.d/oracle-xe configure it (I added oracle to localhost in etc/hosts) it is still not working. These are my log files:

    cloneDBCreation.log

     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"
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    alter system enable restricted session
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    alter database "XE" open resetlogs
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    alter database rename global_name to "XE"
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    alter system switch logfile
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    alter system checkpoint
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    alter database drop logfile group 3
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    select tablespace_name from dba_tablespaces where tablespace_name='USERS'
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    select sid, program, serial#, username from v$session
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    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 `
    
    CloneRmanRestore.log
    
        ORA-00845: MEMORY_TARGET not supported on this system
    select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    declare
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    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 `
    
    postScripts.log
    
        CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/u01/app/oracle/product/11.2.0/xe/lib/libqsmashr.so';
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    BEGIN dbms_datapump_utl.replace_default_dir; END;
    
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    commit
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    create or replace directory XMLDIR as '/u01/app/oracle/product/11.2.0/xe/rdbms/xml'
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    DROP DIRECTORY ORACLE_OCM_CONFIG_DIR
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    DROP DIRECTORY ADMIN_DIR
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    DROP DIRECTORY WORK_DIR
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    BEGIN dbms_swrf_internal.cleanup_database(cleanup_local => FALSE); END;
    
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    
    
    commit
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available 
    Process ID: 0 
    Session ID: 0 Serial number: 0 
    

    this is my localhost:

    127.0.0.1 localhost.localdomain localhost LatitudeE7240

    ::1 LatitudeE7240 localhost6.localdomain6 localhost6

    127.0.1.1 LatitudeE7240

    127.0.0.1 localhost LatitudeE7240