R: Problem with dual instances

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:13:33 CDT