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!

xe edition installation failed on Debian 3.1

niukunMar 9 2007
Dear all,

I just downloaded the oracle-xe-universal's deb package from oracle's website.
Everything seems to be normal until I configured the database.
I can't find the manage webpage from my browser.
I used sqlplus and found that the database didn't startup.
I can really find oradata on my system.
And the dbf files seem to be normal.
The following are my config/log files.

Would anyone be kind enough to tell me how I can may the manage website work?
Thanks in advance.
shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log#
GROUP 1 SIZE 51200K,
*
ERROR at line 13:
ORA-02236: invalid file name


BEGIN dbms_backup_restore.zerodbid(0); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4168
ORA-06512: at line 1


ORA-01507: database not mounted


ORACLE instance shut down.
LRM-00104: '%sga_target%' is not a legal integer for 'sga_target'
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

shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# vi CloneRmanRestore.log
LRM-00104: '%sga_target%' is not a legal integer for 'sga_target'
ORA-01078: failure in processing system parameters

TO_CHAR(SYSTIMEST
-----------------
20070307 10:28:26

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
Restore done.

PL/SQL procedure successfully completed.


TO_CHAR(SYSTIMEST
-----------------
20070307 10:30:32

shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# vi postDBCreation.log
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
ORA-32003: error occured processing parameter 'sga_target'


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

shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# vi postScripts.log
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2007
Added on Mar 9 2007
0 comments
231 views