ORA-01034: ORACLE not available error when configuring Oracle ApEx
10,964
After reinstalling and following this instructions it finally works. Cheers!
Author by
Mateusz Mateja
Updated on June 05, 2022Comments
-
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