Re: multiple listeners

The way we work it is the listener name would be listener_sid. We have one listener per database. I do not see what the issue with that is. This way, if you are doing work on one database, you can bring down the listener without affecting other databases. You can, in your listener.ora file, give other databases per listener in the sid_list. Do what you want.

John

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0204050029.7fce248c_at_posting.google.com...
> 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 Sat Apr 06 2002 - 23:33:34 CEST