Re: multiple listeners

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
"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 Thu Apr 04 2002 - 23:44:27 CEST