Hi ,

I need to connect to two databases(Oracle 8.0.5 and 10g) . What
should be the $ORACLE_HOME for such a case ?

Thanks!

On 31 Aug 2006 22:23:06 -0700, abhi147@gmail.com wrote:

>Hi ,
>
> I need to connect to two databases(Oracle 8.0.5 and 10g) . What
>should be the $ORACLE_HOME for such a case ?
>
>Thanks!

AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
and vice versa.
Too many major releases in between.

--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
> On 31 Aug 2006 22:23:06 -0700, abhi147@gmail.com wrote:
>
> >Hi ,
> >
> > I need to connect to two databases(Oracle 8.0.5 and 10g) . What
> >should be the $ORACLE_HOME for such a case ?
> >
> >Thanks!
>
> AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
> and vice versa.
> Too many major releases in between.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi ,
Actually it's okay if it doesn't communicate . But can I have
some serial connections i.e., connect to 10g , get the data , close the
10g connection , then connect to 8 and execute some stored procedures .


In tha case , what should my Environment variables link $ORACLE_HOME
and $LD_LIBRARY_PATH should be ?

Thanks !

abhi147@gmail.com wrote:
> Sybrand Bakker wrote:
> > On 31 Aug 2006 22:23:06 -0700, abhi147@gmail.com wrote:
> >
> > >Hi ,
> > >
> > > I need to connect to two databases(Oracle 8.0.5 and 10g) . What
> > >should be the $ORACLE_HOME for such a case ?
> > >
> > >Thanks!
> >
> > AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
> > and vice versa.
> > Too many major releases in between.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> Hi ,
> Actually it's okay if it doesn't communicate . But can I have
> some serial connections i.e., connect to 10g , get the data , close the
> 10g connection , then connect to 8 and execute some stored procedures .
>
>
> In tha case , what should my Environment variables link $ORACLE_HOME
> and $LD_LIBRARY_PATH should be ?
>
> Thanks !

Easier would be two programs:
one compiled for 8i
one compiled for 10g

then pipline the data between them. (or shared memory, or text files,
whatever)
Anyway, no need to keep opening/closing ORACLE connections and no funky
build process.

HTH,
Ed

abhi147@gmail.com wrote:
> Sybrand Bakker wrote:
>> On 31 Aug 2006 22:23:06 -0700, abhi147@gmail.com wrote:
>>
>>> Hi ,
>>>
>>> I need to connect to two databases(Oracle 8.0.5 and 10g) . What
>>> should be the $ORACLE_HOME for such a case ?
>>>
>>> Thanks!
>> AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
>> and vice versa.
>> Too many major releases in between.
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
> Hi ,
> Actually it's okay if it doesn't communicate . But can I have
> some serial connections i.e., connect to 10g , get the data , close the
> 10g connection , then connect to 8 and execute some stored procedures .
>
>
> In tha case , what should my Environment variables link $ORACLE_HOME
> and $LD_LIBRARY_PATH should be ?
>
> Thanks !
>

The problem comes in when trying to compile your Pro*C app. You can
compile it with Oracle 8 libraries or with Oracle 10g libraries, but not
both. And it is the libraries that give you the network connectivity to
the database. You can test it out compiling the app under one version or
the other, but I would suspect that you will see errors when connecting
to the *other* database version.

Any reason why you cannot upgrade the Oracle 8 db to at least 9i?

HTH,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Brian Peasland schreef:
> abhi147@gmail.com wrote:
>> Sybrand Bakker wrote:
>>> On 31 Aug 2006 22:23:06 -0700, abhi147@gmail.com wrote:
>>>
>>>> Hi ,
>>>>
>>>> I need to connect to two databases(Oracle 8.0.5 and 10g) . What
>>>> should be the $ORACLE_HOME for such a case ?
>>>>
>>>> Thanks!
>>> AFAIK it's not going to work, because 8.0.5 won't communicate with 10g
>>> and vice versa.
>>> Too many major releases in between.
>>>
>>> --
>>> Sybrand Bakker, Senior Oracle DBA
>>
>> Hi ,
>> Actually it's okay if it doesn't communicate . But can I have
>> some serial connections i.e., connect to 10g , get the data , close the
>> 10g connection , then connect to 8 and execute some stored procedures .
>>
>>
>> In tha case , what should my Environment variables link $ORACLE_HOME
>> and $LD_LIBRARY_PATH should be ?
>>
>> Thanks !
>>
>
> The problem comes in when trying to compile your Pro*C app. You can
> compile it with Oracle 8 libraries or with Oracle 10g libraries, but not
> both. And it is the libraries that give you the network connectivity to
> the database. You can test it out compiling the app under one version or
> the other, but I would suspect that you will see errors when connecting
> to the *other* database version.
>
> Any reason why you cannot upgrade the Oracle 8 db to at least 9i?
>
> HTH,
> Brian
>
Would compiling against 9 be an option?
Should connect to 8, as well as 10

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...