-
Hi DBAs,
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?
Thanks,
JN1971
-
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 :)
-
Hi guys,
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.
Jn1971