Re: Oracle7 & Oracle8 on the same server

You are quite right. I had forgotten that at the time I set it up, I needed to run both SQLNET and Net8. Otherwise no need. That's what's so much fun(?) about this business - so many ways to do the same or different things or different ways to do the same thing or... what was I talking about anyway?

fdp

Frode Hertzberg wrote:
>
> Hello
>
> It works fine with only one listner, I have 40 dbs running version 7.2.2,
> 7.3.4, 8.0.4 and 8.0.5 on the same Sun Unix with one listner and one oracle
> user.
>
> The only differense is ORACLE_HOME, ORACLE_SID, PATH and NLS???.
> My ORACLE_HOME for different version:
> ORACLE_BASE/product/7.2.2/
> ORACLE_BASE/product/7.3.4
> ORACLE_BASE/product/8.0.4
> ORACLE_BASE/product/8.0.5
>
> I place my create scripts, init<SID>.ora files and dump like this:
> ORACLE_BASE/admin/<SID>/?dump
> ORACLE_BASE/admin/<SID>/pfile/init<SID>.ora
> ORACLE_BASE/admin/<SID>/create/*.sql
>
> All data, redo and controll files like this:
> /u01/oradata/<SID>/system01.dbf
> /u04/oradata/<SID>/temp01.dbf
>
> And I have my tnsnames.ora, oratab, listner.ora and sqlnet.ora in
> /var/opt/oracle/
>
> I hope this can be some help.
> You can reace me at work: frode.hertzberg_at_no.ibm.com (PS I'm living in
> Norway GMT+1)
>
> Regards
> Frode Hertzberg
>
> "Fred Pierce" <fpierce_at_avialantic.com> wrote in message
> news:38AD4D04.903DF11F_at_avialantic.com...
> > you also need two listeners (at least I don't know of a way to do it with
> one).
> > If you can't figure that out I can email you my setup - I have 733 and 805
> > running on one machine and 734, 815 on another and they can all
> interconnect.
> > Not sure I completely understand how I did it though 8-)
> >
> > fdp
> >
> > ---------------------------------------------------------
> > Fred Pierce (DNRC) QSS Group Oracle/Sybase DBA
> > www.Avialantic.com fpierce_at_avialantic.com
> > MAAM WWII Weekend June 2-4 2000
> > http://www.maam.org/maamwwii.html
> > World Airshow News - http://www.wanews.com
> > ---------------------------------------------------------
> >
> > Sajidc wrote:
> >
> > > I hope someone can help me?
> > >
> > > What are the main issues to bear in mind when you are going to set-up a
> > > server which needs to have both versions of oracle 7 & 8 running at the
> same
> > > time? An application will be moving data from one database to the other?
> > >
> > > Thanks
> > > Saj
> >

--

   Fred Pierce (DNRC)- fpierce_at_avialantic.com Oracle/Sybase DBA     Mid-Atlantic Aviation on the Web - http://www.avialantic.com

• Mid Atlantic Air Museum *** World Airshow News **

  ---