Skip to Main Content
Forums

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!

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.

cant start my database

venkata_sudheerJul 17 2008 — edited Jul 18 2008
hi
i've recently installed the oracle 10g (10.2.0.1) in my pc (OS: RHEL AS4) just to try. I've created the starter database also.

Now database has created the spfile insted of pfile(init.ora). whenever i try to start the database it shows the error that the init.ora file is missing
if i use " STARTUP FORCE PFILE='/ADDR/PFILEORACLE_SID.ORA' "then it shows error LRM-00123:invalid character 0 found in input file
even though i havent done anything to this file it shows error

if i use startup force after creating the init.ora file by copying from the spfile
( $ cat >initORACLE_SID.ora <spfileoracle_sid.ora )
then it shows error that cannot mount database in exclusive mode (ORA-01102)


my db is not up yet
can anyone suggest any solution

thanks in advance

Comments

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

Post Details

Locked on Aug 15 2008
Added on Jul 17 2008
#general-database-discussions
12 comments
459 views