Re: Can I start 2 instances in 1 ORACLE_HOME?

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Mon, 25 Mar 2002 20:06:38 GMT
Message-ID: <irLn8.5648$se.559131@bgtnsc04-news.ops.worldnet.att.net>

EOF on CC is not good kharma.

As MisterRogers said, it could be nearly anything; among the first is summing the SGA sizes of both databases and see whether that exceeds physical memory or even worse phymem+vmem; I've brought up (briefly) instances where my 'tuning' resulted in such enormous amoeba like things that "vi" had trouble coming up.

Because UNIX was being forced to swap and page. Bleah. (Thank goodness for development boxes..)

It does sound like a wierd and annoying IPC key problem, perhaps. Make sure you are (I know this sounds elementary, but....) setting your ORACLE_SID and ORACLE_HOME properly before attempting to start or stop an instance; I've seen that cause this, as well as worse.

RSH.
"Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message news:Pine.LNX.4.44.0203251115430.9779-100000_at_galt.rhadmin.org...
> On my development box, I place my production init.ora and modify the
> control file location.
>
> I would like to be able to "export ORACLE_SID=production", start my
> production instance in nomount mode, create the controlfile with a trace
> dump, then recover the instance.
>
> However, in svrmgrl, I get something like an "end of file on communication
> channel" on the startup nomount.
>
> I think there is some sort of IPC conflict.
>
> ----------------------------------------------------------------------

---

> / Charles J. Fisher |"The prettiest girls in the
world /
> / cfisher_at_rhadmin.org | live in Des Moines, Iowa."
/
> / http://rhadmin.org | -Jack Kerouac
/
> --------------------------------------------------------------------------
-
>
>
Received on Mon Mar 25 2002 - 14:06:38 CST