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: joel garry <joel-garry_at_home.com>
Date: Tue, 05 Jun 2007 17:15:23 -0700
Message-ID: <1181088923.345188.36590@o11g2000prd.googlegroups.com>


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/listener.htm#sthref807 (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.htm
Received on Tue Jun 05 2007 - 19:15:23 CDT

Original text of this message

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