Re: Oracle7 & Oracle8 on the same server

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
>
Received on Sat Feb 19 2000 - 17:00:23 CST