Oracle FAQ Your Portal to the Oracle Knowledge Grid

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: <>
Date: Tue, 05 Jun 2007 20:47:50 +0200
Message-ID: <>

On Tue, 05 Jun 2007 09:15:18 -0700, Ben <> wrote:

>On Jun 5, 11:19 am, sybrandb <> wrote:
>> On Jun 5, 5:12 pm, Ben <> 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
>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
Received on Tue Jun 05 2007 - 13:47:50 CDT

Original text of this message