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

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? Received on Tue Jun 05 2007 - 11:15:18 CDT