Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Changed spfileXE.ora and database wil not startup

gerhard2001Sep 11 2011 — edited Sep 11 2011
Hi!

I added into the .../dbs/spfileXE.ora the following lines:

############################
# Archive Log Destinations
############################
log_archive_dest_1='location=/usr/lib/oracle/xe/oradata/archive'
log_archive_start=TRUE

in order to set the database permanently to 'Archive Log Mode'

Now I can't mount or startup the database anymore!

SQL> startup mount
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'

So I created this 'initXE.oa' file as a copy of 'spfileXE.ora'

That gives me the following error:

SQL> startup mount
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 0 found in the input file

How can I fix this problem?

Is it possible on Oracle XE to change any parameters permanently in the initialization file, and where is this initialization file located on my linux OS

I'm using Ubuntu 10.10

Thanks for any help!!

Gerhard
This post has been answered by orafad on Sep 11 2011
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 9 2011
Added on Sep 11 2011
3 comments
2,360 views