Re: Problem with dual instances

Ok.

One of the common causes for 3113 other than those outlined below is an insufficient number of semaphores on Unix level. IIRC correctly it should be 2 times the number of processes + 5 * the number of instances.
Anyway Oracle will grab those semaphores at startup.

Hth,

Sybrand Bakker, Senior Oracle DBA

"Claudio A." <claudio.am_at_libero.it> wrote in message news:9ml3if$aej$1_at_lacerta.tiscalinet.it...
> Hi,
> I am using Oracle v. 8.1.7 on HP-UX v. 11i.
>
> I used the DBAssist to create the new instance and the new DB. I refered
to
> the first INIT<sid>.ORA file only for the right parameters (i.e.
> max_processes, block_size, etc.). .Then I defined the tablespace name and
> sizes, Rollback segment and redo files, etc properly.
> When I choose a new SID name in DBAssist, it refer to different path for
the
> control files and the other files.
> Now I have two different and indipendent Database (datafiles are in two
> different filesystem in my server!).
>
> If I start the first DB it work well. When I start the second one, I get
the
> error:
> ORA-03113 End-of-file on communication channel.
>
> Then if I shutdown the first instance and start the second one, it work
> well, but if now try to restart the first one I obtain again the
ORA-03113
> error.
>
> Thank very much for your interest.
>
>
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> tos25hrgdhpjcf_at_news.demon.nl...
> >
> > "Claudio A." <claudio.am_at_libero.it> wrote in message
> > news:9mkv4m$72o$1_at_pegasus.tiscalinet.it...
> > > Hi,
> > > I had an Oracle installation that worked properly.
> > > Then I shutted down that instance and I've created a new one without
> > having
> > > any problem.
> > > Now I need to startup both the instances but when I try to start the
> > second
> > > one I obtain the following error message:
> > > ORA-03113 End -Of-File On communication channel
> > >
> > > Could someone help me?
> > > Thanks
> > >
> > >
> > >
> >
> > On second thought:
> >
> > Questions:
> > What version. Please *ALWAYS, ALWAYS, ALWAYS* specify version and
> platform.
> > How did you create the second instance?
> > Did you copy the original edit init<sid>.ora
> > and edit the init.ora to reflect the change of controlfile names.
> >
> > If you only copied the init.ora...
> > be prepared for a shock:
> > you have your second instance linked to the first.
> >
> > Hth,
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > >
> >
> >
>
>
Received on Thu Aug 30 2001 - 05:46:21 CDT