Re: Multiple Oracle Homes in WinNT

Thanks Paul. It was more than I wanted to Know.

Sanjay

• Original Message ----- From: "Paul Drake" <paled_at_home.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 03, 2000 12:30 AM Subject: Re: Multiple Oracle Homes in WinNT

>
> > Sanjay Kumar wrote:
> >
> > Has any one dealt with Multiple Oracle Homes in WIndows NT?
> >
> > What is the impact of installing another oracle product with a new
> > Oracle Home in WIndows NT? What will happen to the existing Oracle
> > Home?
> >
> > TIA
>
> Sanjay,
>
> 2 things:
>
> - If you are going to support Oracle 7.3.x (backwards compatibility,
> still migrating old sites)
> install it first.
> - Oracle does not support minor releases in separate homes - so you're
> limited to one each of
> 7.3.x
> 8.0.x
> 8.1.x
>
> Only one will be the default home.
>
> I do have a machine at work with 4 homes, as I installed the 8.1.6
> documentation into its own home.
> I have multiple 7.3.x and 8.1.6 databases, but even though I have an
> 8.0.6 install, I have not created a database in it - but the binaries
> are there just in case. We jumped straight from 7.3.4 to 8.1.6.
>
> The 8.1.6 default listener is going to want to grab port 1521 by
> default, so leave that port open for it.
>
> Also, you may want to create batch files that start a command prompt
> with a specific ORACLE_SID set as an environment variable. For some
> reason, I still like using svrmgrl for some things, like recovery, or to
> use lsnrctl and netstat to check to see if I've crossed the streams on
> the configuration of the listeners. In this manner, you can set the
> title of your command prompt to have the proper SID - kind of like
> having the glogin script configured for sql*plus.
>
> Actually, I used SQL*Worksheet from OEM 1.3.6 today to recover a
> tablespace over a dial-up. I didn't think that I could use that product
> for it, but that's what I was logged in with, and just gave it a shot.
> Kind of a funky window that presented the choices of archived redo log
> to apply. It was definitely a Monday morning today.
>
> How much RAM is in your system? I was trying to run Quests schema
> manager on 256 MB of RAM with 3 smallish DBs up at once: a target, a
> baseline and a repository. Looks like the current version is still
> choking on clusters.
>
> more than you wanted to know ...
>
> Paul
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Drake
> INET: paled_at_home.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Oct 03 2000 - 12:12:57 CDT