DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: HELP! URGENT!

  1. #1
    Join Date
    Sep 2000
    Posts
    31

    Question

    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

  2. #2
    Join Date
    Oct 2000
    Posts
    80
    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

  3. #3
    Join Date
    Aug 2000
    Posts
    194
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Wow, somebody was trolling through the archives.

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

  5. #5
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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 :)

  6. #6
    Join Date
    Sep 2000
    Posts
    31
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width