HELP! URGENT!

[jn1971]

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

[JDoyle]

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

[gsprince]

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.

[chrisrlong]

Wow, somebody was trolling through the archives.

Considering this was originally posted in September, I'm hoping they've found a resolution by now :)

[chrisrlong]

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 :)

[jn1971]

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