Re: 2 instances on same machine

On 21 Jul 2005 04:26:05 -0700, "tsardaryan" <tsardaryan_at_gmail.com> wrote:

>I have a 2 working servers, but 1 of them now is broken (but I have all
>files from them). Now I want to start 2-nd instance on 1-st machine
>with data from 2-nd machine. I make changes in /var/opt/oracle/oratab
>file, in listeners and copy all datafiles and init files (dbs and
>init*.ora) from 2-nd server to 1-st.
>
>After that all I chenge my ORACLE_SID and try to startup 2-nd instance
>it starting correctly, but when it try to mount database it gives an
>error
>
>ORA-01102: cannot mount database in EXCLUSIVE mode
>
>Please help

Funny, I ran into this just today. In fact, one of the first things I did after checking tahit was to search this ng for ORA-01102, and found this thread. Now it's later in the evening, and I solved mine, so thought I'd toss it into the discussion.

In my case, I was picking up a bad init.ora file that had a reference in it to the other db running on the box. So, you might also want to verify which parm file (init<sid>.ora or spfile) you are really picking up at startup, and verify what's in it. Received on Fri Jul 22 2005 - 19:51:13 CDT