GREAT!!!
I've increased the value for the SEMMNS parameter in the kernel and now
everything works well
Thank you once again for your help!
Bye.
;-)
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
tos7rhsq6e5929_at_news.demon.nl...
> 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 - 07:49:03 CDT
