Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Install Oracle XE on Debian

440152Mar 6 2006 — edited Mar 6 2006
Hello, I am trying to install Oracle XE in my Debian.
I have lowered deb from Oracle and also used apt sources that appears in a message in the forum. From the two forms I obtain some errors in the installation and to me it is not working the data base well.
I detail the errors to them.

This error appears when install (dpkg -i oracle....deb), with both version

Setting up oracle-xe-universal (10.2.0.1-1.0) ...
Executing Post-install steps...

/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 65: test: !=: unary operator expected
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 71: test: !=: unary operator expected
/var/lib/dpkg/info/oracle-xe-universal.postinst: line 1: bc: command not found
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.

Then when i run /etc/init.d/oracle-xe configure the process don't show any error, but log messages contain this :
----------------------------------------------------------------------------------------

CloneRmanRestore.log:

LRM-00116: syntax error at 'audit_file_dest' following '='
ORA-01078: failure in processing system parameters
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


declare
*
ERROR at line 1:
ORA-01034: ORACLE not available


select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available

---------------------------------------------------------------------------------------------------------

cloneDBCreation.log

Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN dbms_backup_restore.zerodbid(0); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available


ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
LRM-00116: syntax error at 'audit_file_dest' following '='
ORA-01078: failure in processing system parameters
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system enable restricted session
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database rename global_name to "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system switch logfile
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system checkpoint
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database drop logfile group 3
*
ERROR at line 1:
ORA-01034: ORACLE not available


ALTER TABLESPACE TEMP ADD TEMPFILE '/usr/lib/oracle/xe/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-01034: ORACLE not available


select tablespace_name from dba_tablespaces where tablespace_name='USERS'
*
ERROR at line 1:
ORA-01034: ORACLE not available


select sid, program, serial#, username from v$session
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user sys identified by "oracle"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user system identified by "oracle"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system disable restricted session
*
ERROR at line 1:
ORA-01034: ORACLE not available

--------------------------------------------------------------------------------
<b>postDBCreation.log</b>

begin
*
ERROR at line 1:
ORA-01034: ORACLE not available


create spfile='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/spfileXE.ora' FROM pfile='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/init.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at 'audit_file_dest' following '='


ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN utl_recomp.recomp_serial(); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available


select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available

----------------------------------------------------------------------------------------------------

<b>postScripts.log</b>

CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libqsmashr.so';
*
ERROR at line 1:
ORA-01034: ORACLE not available


create or replace directory DATA_PUMP_DIR as '/usr/lib/oracle/xe/app/oracle/admin/XE/dpdump/'
*
ERROR at line 1:
ORA-01034: ORACLE not available


commit
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN dbms_swrf_internal.cleanup_database(cleanup_local => FALSE); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available


commit
*
ERROR at line 1:
ORA-01034: ORACLE not available

-------------------------------------------------------------------------------------


Can somebody help me?

Message was edited by:
anionline
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2006
Added on Mar 6 2006
2 comments
1,054 views