Re: multiple listeners

tberthon_at_adapsys.ca (Tobie Berthon) wrote in message news:<e9946f43.0204041843.2a3530c1_at_posting.google.com>...
> "news" <x_at_y.com> wrote in message news:<%O3r8.143660$u77.32080649_at_news02.optonline.net>...
> > You can have 3 databases running as 8.1.7 and the other 5 running as 8.0.5
> > no problem, assuming each has it's own set of binaries. What I mean by that
> > is there is a different $ORACLE_HOME for each one (or at least one set for
> > the 8.0.5 databases and 1 set for the 8.1.7 databases). You need a listener
> > for each database. If you have 8 databases on that machine, you need 8
> > different listeners each with it's own unique port. To upgrade will be
> > simple. First take a backup of every database on that box (if possible a
> > cold one.). If you can not back up all of them, backup the ones you plan to
> > upgrade (definitely do a cold backup for those). Run the oracle migration
> > utility. It will ask you witch databases you want to upgrade. It will be
> > self explanatory from then out. You will also need to change your profiles
> > or enviornment scripts to point to the correct $ORACLE_HOME. If you need
> > any more assistance, repost.
> >
> > John
> Hi John,
> 8 separate listeners? how would you go about choosing the
> ports? What about naming for the listeners? Couldn't you have just two
> listeners? One for the 8.0.5 and onr for the 8.1.7?

Two listeners is sufficient, one for 8.0.5 and one for 8.1.7 One listener per database is just utter nonsense. A listener is a *broker* only.

Regards

Sybrand Bakker
Senior Oracle DBA

> > "Tobie Berthon" <tberthon_at_adapsys.ca> wrote in message
> > news:e9946f43.0204041314.58888c02_at_posting.google.com...
> > > Hi,
> > > This is my first time, so go easy on me. We have a box running
> > > AIX 4.3.3
> > > and Oracle 8.0.5. We have installed the software for 8.1.7 and want to
> > > upgrade
> > > 3 instances on the box , while leaving the other 5 untouched. How do
> > > we set things up so that we can run databases in each set of software.
> > > I believe that we need a listener for each set of software. Can they
> > > use the same port? Any help would be appreciated.
Received on Fri Apr 05 2002 - 10:29:52 CEST