Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: running 9i and 10g on same AIX5L server

Re: running 9i and 10g on same AIX5L server

From: Ben <balvey_at_comcast.net>
Date: Wed, 06 Jun 2007 08:39:26 -0700
Message-ID: <1181144366.996476.43970@w5g2000hsg.googlegroups.com>


On Jun 5, 8:15 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 5, 12:52 pm, Ben <bal..._at_comcast.net> wrote:
>
>
>
>
>
> > On Jun 5, 2:47 pm, sybra..._at_hccnet.nl wrote:
>
> > > On Tue, 05 Jun 2007 09:15:18 -0700, Ben <bal..._at_comcast.net> wrote:
> > > >On Jun 5, 11:19 am, sybrandb <sybra..._at_gmail.com> wrote:
> > > >> On Jun 5, 5:12 pm, Ben <bal..._at_comcast.net> wrote:
>
> > > >> > So I've done a quick read of the upgrade and install manuals, I've
> > > >> > searched metalink, asktom, and here. I just can't find what I'm
> > > >> > looking for and I'm probably just not searching on the correct
> > > >> > phrases.
> > > >> > I know you have to create seperate homes and I know that a 10g install
> > > >> > can't read a 9i database and vice versa. My question is what exactly
> > > >> > is it that tells the instance what version of the software to use? I'm
> > > >> > assuming it is just the ORACLE_HOME environment variable that you have
> > > >> > set when you start the database. Am I missing something real obvious
> > > >> > here?
>
> > > >> cat /etc/oratab.
> > > >> What's in there?
>
> > > >> --
> > > >> Sybrand Bakker
> > > >> Senior Oracle DBA
>
> > > >it is supposed to be a listing of all the
> > > >sid:oracle_home:start_on_boot(Y|N)
> > > >we don't use dbstart or dbshut though, so it's kind of useless is it
> > > >not? If we indeed used dbstart, then yes, this would need to be set
> > > >accordingly. The only thing that I see dbstart doing with the home
> > > >portion of oratab though is setting the ORACLE_HOME.
>
> > > >Actually as I just checked our oratab, it isn't even up to date. The
> > > >homes that are listed in it don't even exist anymore.
>
> > > >So, is $ORACLE_HOME the only thing that tells an instance what
> > > >installation of oracle software to use?
>
> > > Next time, look better, and in the mean time answer the following quiz
> > > question:
> > > Which environment variable does oraenv adjust, which will determine
> > > which version of Oracle you get by typing 'sqlplus'?
>
> > > --
> > > Sybrand Bakker
> > > Senior Oracle DBA- Hide quoted text -
>
> > > - Show quoted text -
>
> > um PATH, not much of a quiz.
>
> > I didn't specifically state that I don't use oraenv either. oraenv
> > calls dbhome which in turn uses oratab, BUT I DON'T USE ORAENV. I get
> > the feeling that you are trying to tell me that oratab is what
> > controls the version of oracle software that is used for your
> > instance. I don't consider that to be accurate though, as I can see
> > with mine eyes that our oratab references non-existent homes. If you
> > use oraenv the indirectly it would use oratab to set the ORACLE_HOME
> > environment variable.
>
> > Back to my question, is $ORACLE_HOME what determines the version of
> > the software is executed to access a database
>
> Yes. And No. If you don't have what is in the path agreeing with
> what is in $ORACLE_HOME, you may wind up with some strangeness. If
> you are careful not to just append $ORACLE_HOME/bin's to your path,
> watch your ORACLE_SID and TWO_TASK (and library references in some
> cases), you can determine different versions entirely with environment
> variables. ORACLE_BASE and NLS_LANG might be something you consider
> handling, too.
>
> Also, watch what your listener does with who.http://download-west.oracle.com/docs/cd/B19306_01/network.102/b14213/...
> (you are probably better off not setting this).
>
> You might consider listening to Sybrand, straighten up your oratab and
> use oraenv. I don't, but there you go. I'm willing to suffer the
> consequences.
>
> jg
> --
> @home.com is bogus.http://dailytech.com/Pay+to+Play+Uncovering+Online+Payola/article7510...- Hide quoted text -
>
> - Show quoted text -

Thank you for being straightforward and polite. I appreciate the help. Received on Wed Jun 06 2007 - 10:39:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US