Skip to Main Content

Oracle Database Discussions

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!

Can I adjust the parameter in XE's deb package?

haoniukunMar 7 2007
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2007
Added on Mar 7 2007
0 comments
296 views