Can I adjust the parameter in XE's deb package?
Dear all,
I've just installed 10g XE on my Debian 3.1 system.
But I found the following error in my log file.
shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# cat CloneRmanRestore.log | more
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# cat cloneDBCreation.log | more
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
shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# cat postDBCreation.log | morebegin
*
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
shuang:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log# cat postScripts.log | more
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
Would someone be kind enough to tell me how can I solve the problem?
Thanks in advance.