Re: ORA-03113 when trying to start more than one db

"Lionel Mandrake" <nobody_at_nospam.nowhere.nohow> wrote in message news:cS%I7.148054$My2.87261700_at_news1.mntp1.il.home.com...
> "Night Shade Books" <jasonw_at_nightshadebooks.com> wrote in message
> news:1CCDEED664A902A5.D648075C8FA7648F.41FB2E43FCFF6DDA_at_lp.airnews.net...
> > Howdy all,
> >
> > I'm on Solaris 2.8, running Oracle 8.1.7.
> >
> > I'm setting up a new box, and I wanted to migrate all of our various
> > development databases from the various boxes they were on to this one
box.
> >
> > So I moved the first one (EBQA817) over, and everything worked fine.
> Then
> > I moved the second one (EBDEV) over, but when I went into svrmgrl to
start
> > it up and build a new controlfile, I just kept getting ORA-03113. I
> checked
> > all the files, and looked at Metalink, but no love. Then I did a google
> > search of this group, which said try shutting down the other db first.
> >
> > So I shut down EBQA817, and then EBDEV came up just fine. I recreated
> the
> > controlfiles, and went about the business of getting it running. But of
> > course now I get an ORA-03113 trying to start up EBQA817.
> >
> > Any ideas what I need to do here? I'm not posting any init*.ora or
> > whatnot to this post, as I don't know what would be helpful in
diagnosing
> > this. Let me know if there's anything I could post to make this simpler
> to
> > figure out.
> >
> > Thanks,
> >
> > Jason
> >
> >
>
> This might be relevant...
>
> From MetaLink:
>
> RDBMS Version: 8.1.7.0.0
> Operating System and Version: Solaris 2.8
> Error Number (if applicable): ora 3113 on startup
>
> [ snip ]
>
> If the problem occurs the workaround is to
> increase semsys: seminfo_semmns in /etc/system & reboot the machine.
>
> HTH,
>
> -LM

Thanks! I did a little reading on all of the seminfo_* entries in /etc/system, and tweaked the values. Sure as hell, both db's came right up!

Much appreciated,

  Jason Received on Thu Nov 15 2001 - 22:16:52 CST