Re: Multiple instance startup gives ORA-1102

Man... I forgot to change the reference in config<2>.ora to the new control files. Sorry for disturbing :-/

Brian

Neil C wrote:
>
> Brian,
>
> It sounds like one of your databases was already running when you ran
> dbstart, so it was trying to start it again. Make sure you run the dbshut
> before running dbstart.
>
> Because, dbstart and dbshut affect ALL sids in your oratab file (unless they
> have the Y/N flag set in oratab) you may want to create your own scripts to
> control individual instances.
>
> cheers
>
> NeilC
>
> Brian Rasmusson wrote in message <37EA2F3C.A61F4878_at_bellesystems.com>...
> >
> >I'm trying to set up a second Oracle 8.0.5 instance on a Solaris host. I
> >have done the following:
> >
> >1. Copy init* and config* from instance 1 to new.
> >2. Edited config<2>.ora and modified control files and db_name
> >3. Added new instance to /var/opt/oracle/oratab for dbstart to work
> >4. Set my ORACLE_SID to new sid
> >5. Issued "CREATE DATABASE" command from svrmgrl
> >
> >The above resulted in new control files, redo log files and system
> >tablespace file to be created. Everything seemed to work.
> >
> >However, when I try to start the second instance (or both for that
> >matter) using e.g. dbstart, I get the following error:
> >
> >|SVRMGR> ORACLE instance started.
> >|Total System Global Area 64011792 bytes
> >|Fixed Size 48656 bytes
> >|Variable Size 54050816 bytes
> >|Database Buffers 9830400 bytes
> >|Redo Buffers 81920 bytes
> >|ORA-01102: cannot mount database in EXCLUSIVE mode
> >|SVRMGR>
> >|Server Manager complete.
> >|
> >|Database "Site" warm started.
> >
> >
> >Where did i goof? Any hints will be greatly appreciated.
> >
> >Brian Rasmusson
> >Manager, Software Development
> >Belle Systems
> >E-mail: br_at_bellesystems.com
> >Tel.: +45 5944 2500
Received on Thu Sep 23 1999 - 09:15:54 CDT