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

On Tue, 05 Jun 2007 09:15:18 -0700, Ben <balvey_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