I tried to startup my test instance and i got an error:
SQLDBA> startup pfile=$ORACLE_HOME/dbs/inittest.ora
ORACLE instance started.
ORA-00205: error in identifying control file '$ORACLE_HOME/dbs/c1test.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
Attempting to shutdown instance........ORACLE instance shut down.
I get my test control files are corrupted. Is it right? Please tell me what this error: ORA-09782: sfifi: another instance has the same database mounted means? How i fix it?
Is this the same database as involved in your earlier post about exceeded maxdatafiles?
If not, I'm guessing that the problem is related to the other DB
check whether the control file exists
check, if the $ORACLE_HOME/dbs/inittest.ora is not pointing to another already mounted instance.
Make sure, the instance name of ur new test db is different form the one already existing/started.
Try setting the environment variable ORACLE_SID=test and startup the DB.
Wow, somebody was trolling through the archives.
Considering this was originally posted in September, I'm hoping they've found a resolution by now :)
Wow! Where the he** was my head? I'm thinking it's been a long week. Please ignore my glib reply as it is obviously *me* who is out to lunch here.
signing out :)
Yes, it relates to the previous post about exceed maxdatafile number. I did do
setenv oracle_sid test before starting up the database.
my two instance have different names.
Anyway, i'll try those steps that you suggested on exceed maxdatafile number post. Thanks.
Click Here to Expand Forum to Full Width