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!

dbca failed with identifying spfile

John-MKAug 20 2014 — edited Aug 20 2014

Hello,

I removed entry from /etc/oratab but forgot to remove database from Oracle restart (dropped database before) but DBCA failed at the end with error that DB_UNIQUE_NAME with first 8 characters already exists.

I assume as I forgot to remove the CONFIG from Oracle restart thats why it identified the same DB_UNIQUE_NAME ..

but now:

AS SYSDBA> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA01/pos/spfilepos.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA01/pos/spfilepos.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:2 Failed to open file +DATA01/pos/spfilepos.ora

ORA-15173: entry 'spfilepos.ora' does not exist in directory 'pos'

How can I create create pile to start it and eventually STARTUP MOUNT RESTRICT and DROP DATABASE and create it again.

Thanks a lot.

Best Regards

This post has been answered by John-MK on Aug 20 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2014

Added on Aug 20 2014

#general-database-discussions

2 comments

515 views