Hi,

I am wondering if we could install 32-bit client of 10g release2 and
64-bit client of the same (allowing delphi 32-bit apps and some .net
Windows services to connect to the oracle database server hosted on HP-
UX running 64-bit mode. has anyone done this before?

If so, can you please provide me some documentation of how to
configure the same.

Thanks in advance.
Deepak.

On 13 Apr 2007 10:00:52 -0700, deepak.kollipara@gmail.com wrote:

>Hi,
>
>I am wondering if we could install 32-bit client of 10g release2 and
>64-bit client of the same (allowing delphi 32-bit apps and some .net
>Windows services to connect to the oracle database server hosted on HP-
>UX running 64-bit mode. has anyone done this before?
>
>If so, can you please provide me some documentation of how to
>configure the same.
>
>Thanks in advance.
>Deepak.

Fact: 32-bit client can communicate with 64-bit server without
problem.
Fact: if you want to install 2 different clients you need to install
them in 2 different Oracle homes
Fact: your question is redundant, as this is all outlined in the
installation documentation on http://otn.oracle.com or
http://tahiti.oracle.com both reachable from http://www.oracle.com
Fact: you were even too lazy to type www.oracle.com in your browser
and hit the documentation button.


--
Sybrand Bakker
Senior Oracle DBA

On Apr 13, 11:12 am, sybra...@hccnet.nl wrote:
> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> >Hi,
>
> >I am wondering if we could install 32-bit client of 10g release2 and
> >64-bit client of the same (allowing delphi 32-bit apps and some .net
> >Windows services to connect to the oracle database server hosted on HP-
> >UX running 64-bit mode. has anyone done this before?
>
> >If so, can you please provide me some documentation of how to
> >configure the same.
>
> >Thanks in advance.
> >Deepak.
>
> Fact: 32-bit client can communicate with 64-bit server without
> problem.
> Fact: if you want to install 2 different clients you need to install
> them in 2 different Oracle homes
> Fact: your question is redundant, as this is all outlined in the
> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.comboth reachable fromhttp://www.oracle.com
> Fact: you were even too lazy to typewww.oracle.comin your browser
> and hit the documentation button.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Truth: I am not that lazy for not doing any search on oracle.com for
documentation.. The problem is about 32-bit client and 64-bit client
coexisting..not abt the server... I have gone through the
documentation already and I want an automatic way to do that as I
wouldnot have the access to production sites...and DBA's/ Support
folks wouldnt want to change the ORACLE_HOME using Oracle Selector.

Thanks a lot for your answer the fact maker: Sybrand

On Apr 13, 2:12 pm, sybra...@hccnet.nl wrote:
> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> >Hi,
>
> >I am wondering if we could install 32-bit client of 10g release2 and
> >64-bit client of the same (allowing delphi 32-bit apps and some .net
> >Windows services to connect to the oracle database server hosted on HP-
> >UX running 64-bit mode. has anyone done this before?
>
> >If so, can you please provide me some documentation of how to
> >configure the same.
>
> >Thanks in advance.
> >Deepak.
>
> Fact: 32-bit client can communicate with 64-bit server without
> problem.
> Fact: if you want to install 2 different clients you need to install
> them in 2 different Oracle homes
> Fact: your question is redundant, as this is all outlined in the
> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.comboth reachable fromhttp://www.oracle.com
> Fact: you were even too lazy to typewww.oracle.comin your browser
> and hit the documentation button.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

The oracle documentation does not cover how to run two clients on
windows with the default windows configuration. It isn't as simple as
setting up two clients on any other environment. The oracle home
selector in windows simply switches the PATH entry order. This is a
major problem for clients that use these settings. You have links
pasted, but the links don't point to the specific documentation and
they are generic. What docs outline multi-homing on windows with 32
and 64 bit clients and configuring applications to use a particular
client?

On Apr 13, 2:27 pm, deepak.kollip...@gmail.com wrote:
> On Apr 13, 11:12 am, sybra...@hccnet.nl wrote:
>
>
>
> > On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> > >Hi,
>
> > >I am wondering if we could install 32-bit client of 10g release2 and
> > >64-bit client of the same (allowing delphi 32-bit apps and some .net
> > >Windows services to connect to the oracle database server hosted on HP-
> > >UX running 64-bit mode. has anyone done this before?
>
> > >If so, can you please provide me some documentation of how to
> > >configure the same.
>
> > >Thanks in advance.
> > >Deepak.
>
> > Fact: 32-bit client can communicate with 64-bit server without
> > problem.
> > Fact: if you want to install 2 different clients you need to install
> > them in 2 different Oracle homes
> > Fact: your question is redundant, as this is all outlined in the
> > installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.combothreachable fromhttp://www.oracle.com
> > Fact: you were even too lazy to typewww.oracle.cominyour browser
> > and hit the documentation button.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Truth: I am not that lazy for not doing any search on oracle.com for
> documentation.. The problem is about 32-bit client and 64-bit client
> coexisting..not abt the server... I have gone through the
> documentation already and I want an automatic way to do that as I
> wouldnot have the access to production sites...and DBA's/ Support
> folks wouldnt want to change the ORACLE_HOME using Oracle Selector.
>
> Thanks a lot for your answer the fact maker: Sybrand

Your best options is to install and run the applications as different
local or domain users if you are talking about Windows. Set each
user's local variable settings configurable to the appropriate path
for the desired home. I've opened up tickets about these issues and
lack of appropriate Windows documentation. Oracle does not respond
well or even handle multi-home issues well on Windows. In fact, they
get quite agitated when you point this out.

If anyone has a link to documentation specific to running concurrent
multi-homes on Windows without having to switch the home via the
installer as is in the documentation, please post the exact link or
document title and page number.

On 13 Apr 2007 11:47:08 -0700, "EscVector" <Junk@webthere.com> wrote:

>On Apr 13, 2:12 pm, sybra...@hccnet.nl wrote:
>> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>>
>> >Hi,
>>
>> >I am wondering if we could install 32-bit client of 10g release2 and
>> >64-bit client of the same (allowing delphi 32-bit apps and some .net
>> >Windows services to connect to the oracle database server hosted on HP-
>> >UX running 64-bit mode. has anyone done this before?
>>
>> >If so, can you please provide me some documentation of how to
>> >configure the same.
>>
>> >Thanks in advance.
>> >Deepak.
>>
>> Fact: 32-bit client can communicate with 64-bit server without
>> problem.
>> Fact: if you want to install 2 different clients you need to install
>> them in 2 different Oracle homes
>> Fact: your question is redundant, as this is all outlined in the
>> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.comboth reachable fromhttp://www.oracle.com
>> Fact: you were even too lazy to typewww.oracle.comin your browser
>> and hit the documentation button.
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>
>The oracle documentation does not cover how to run two clients on
>windows with the default windows configuration. It isn't as simple as
>setting up two clients on any other environment. The oracle home
>selector in windows simply switches the PATH entry order. This is a
>major problem for clients that use these settings. You have links
>pasted, but the links don't point to the specific documentation and
>they are generic. What docs outline multi-homing on windows with 32
>and 64 bit clients and configuring applications to use a particular
>client?

Look this is not rocket science, isn't it?
For your shortcuts, the shortcut starts in the proper bin directory.
Oracle_Home will be automagically determined by reading the file
oracle.key, which is present in every Oracle_Home.
This is documented, but I am aware no one reads the documentation, or
wants to spend more than 1 minute.
For DOS sessions, being in this situation myself, I've developed one
cmd file per sid, called init<SID>.cmd. This sets all env vars
appropiately.
Other than that, most of the problems are courtesy of Mickeysoft (for
not providing a proper shell), so you could always switch to a real
O/S.

--
Sybrand Bakker
Senior Oracle DBA

On Apr 13, 3:24 pm, deepak.kollip...@gmail.com wrote:
> On Apr 13, 12:07 pm, sybra...@hccnet.nl wrote:
>
>
>
> > On 13 Apr 2007 11:47:08 -0700, "EscVector" <J...@webthere.com> wrote:
>
> > >On Apr 13, 2:12 pm, sybra...@hccnet.nl wrote:
> > >> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> > >> >Hi,
>
> > >> >I am wondering if we could install 32-bit client of 10g release2 and
> > >> >64-bit client of the same (allowing delphi 32-bit apps and some .net
> > >> >Windows services to connect to the oracle database server hosted on HP-
> > >> >UX running 64-bit mode. has anyone done this before?
>
> > >> >If so, can you please provide me some documentation of how to
> > >> >configure the same.
>
> > >> >Thanks in advance.
> > >> >Deepak.
>
> > >> Fact: 32-bit client can communicate with 64-bit server without
> > >> problem.
> > >> Fact: if you want to install 2 different clients you need to install
> > >> them in 2 different Oracle homes
> > >> Fact: your question is redundant, as this is all outlined in the
> > >> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.combothreachablefromhttp://www.oracle.com
> > >> Fact: you were even too lazy to typewww.oracle.cominyourbrowser
> > >> and hit the documentation button.
>
> > >> --
> > >> Sybrand Bakker
> > >> Senior Oracle DBA
>
> > >The oracle documentation does not cover how to run two clients on
> > >windows with the default windows configuration. It isn't as simple as
> > >setting up two clients on any other environment. The oracle home
> > >selector in windows simply switches the PATH entry order. This is a
> > >major problem for clients that use these settings. You have links
> > >pasted, but the links don't point to the specific documentation and
> > >they are generic. What docs outline multi-homing on windows with 32
> > >and 64 bit clients and configuring applications to use a particular
> > >client?
>
> > Look this is not rocket science, isn't it?
> > For your shortcuts, the shortcut starts in the proper bin directory.
> > Oracle_Home will be automagically determined by reading the file
> > oracle.key, which is present in every Oracle_Home.
> > This is documented, but I am aware no one reads the documentation, or
> > wants to spend more than 1 minute.
> > For DOS sessions, being in this situation myself, I've developed one
> > cmd file per sid, called init<SID>.cmd. This sets all env vars
> > appropiately.
> > Other than that, most of the problems are courtesy of Mickeysoft (for
> > not providing a proper shell), so you could always switch to a real
> > O/S.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -
>
> > - Show quoted text -
>
> At last I figured out by myself...Hurrah! this works...Its not rocket
> science as told by Sybrand..but there are somethings which might have
> been overlooked upon while reading the documentation...People spend
> more than 10 hours to figure out a simple problem which might take
> just a minute to fix..but the knowlegdge of how to fix it is what
> matters at last...and I agree that there might be people looking our
> for help without doing anything....Having said that there is no harm
> in helping out someone who is in need, even if he is just out there
> for help without trying for himself doesnt hurt anything :-) Just my
> thoughts...

So how did you fix it?

On Apr 13, 3:07 pm, sybra...@hccnet.nl wrote:
> On 13 Apr 2007 11:47:08 -0700, "EscVector" <J...@webthere.com> wrote:
>
>
>
> >On Apr 13, 2:12 pm, sybra...@hccnet.nl wrote:
> >> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> >> >Hi,
>
> >> >I am wondering if we could install 32-bit client of 10g release2 and
> >> >64-bit client of the same (allowing delphi 32-bit apps and some .net
> >> >Windows services to connect to the oracle database server hosted on HP-
> >> >UX running 64-bit mode. has anyone done this before?
>
> >> >If so, can you please provide me some documentation of how to
> >> >configure the same.
>
> >> >Thanks in advance.
> >> >Deepak.
>
> >> Fact: 32-bit client can communicate with 64-bit server without
> >> problem.
> >> Fact: if you want to install 2 different clients you need to install
> >> them in 2 different Oracle homes
> >> Fact: your question is redundant, as this is all outlined in the
> >> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.combothreachable fromhttp://www.oracle.com
> >> Fact: you were even too lazy to typewww.oracle.cominyour browser
> >> and hit the documentation button.
>
> >> --
> >> Sybrand Bakker
> >> Senior Oracle DBA
>
> >The oracle documentation does not cover how to run two clients on
> >windows with the default windows configuration. It isn't as simple as
> >setting up two clients on any other environment. The oracle home
> >selector in windows simply switches the PATH entry order. This is a
> >major problem for clients that use these settings. You have links
> >pasted, but the links don't point to the specific documentation and
> >they are generic. What docs outline multi-homing on windows with 32
> >and 64 bit clients and configuring applications to use a particular
> >client?
>
> Look this is not rocket science, isn't it?
> For your shortcuts, the shortcut starts in the proper bin directory.
> Oracle_Home will be automagically determined by reading the file
> oracle.key, which is present in every Oracle_Home.
> This is documented, but I am aware no one reads the documentation, or
> wants to spend more than 1 minute.
> For DOS sessions, being in this situation myself, I've developed one
> cmd file per sid, called init<SID>.cmd. This sets all env vars
> appropiately.
> Other than that, most of the problems are courtesy of Mickeysoft (for
> not providing a proper shell), so you could always switch to a real
> O/S.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

No not rocket science at all. I use powershell, wscript and cygwin
for my windows scripting needs, but I thought the comment was about
the documentation. I consider the .bat file and fudging the paths and
shortcuts a workaround. I haven't had an issue with the init files.
The problem as I see it on Windows is multi-homing especially with 9i
and 10g versions is tedious and not well documented by Oracle. Is it
in the Oracle documentation? I don't think so, but I could be
wrong. :-)

On Apr 13, 2:24 pm, deepak.kollip...@gmail.com wrote:
> On Apr 13, 12:07 pm, sybra...@hccnet.nl wrote:
>
>
>
> > On 13 Apr 2007 11:47:08 -0700, "EscVector" <J...@webthere.com> wrote:
>
> > >On Apr 13, 2:12 pm, sybra...@hccnet.nl wrote:
> > >> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> > >> >Hi,
>
> > >> >I am wondering if we could install 32-bit client of 10g release2 and
> > >> >64-bit client of the same (allowing delphi 32-bit apps and some .net
> > >> >Windows services to connect to the oracle database server hosted on HP-
> > >> >UX running 64-bit mode. has anyone done this before?
>
> > >> >If so, can you please provide me some documentation of how to
> > >> >configure the same.
>
> > >> >Thanks in advance.
> > >> >Deepak.
>
> > >> Fact: 32-bit client can communicate with 64-bit server without
> > >> problem.
> > >> Fact: if you want to install 2 different clients you need to install
> > >> them in 2 different Oracle homes
> > >> Fact: your question is redundant, as this is all outlined in the
> > >> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.combothreachablefromhttp://www.oracle.com
> > >> Fact: you were even too lazy to typewww.oracle.cominyourbrowser
> > >> and hit the documentation button.
>
> > >> --
> > >> Sybrand Bakker
> > >> Senior Oracle DBA
>
> > >The oracle documentation does not cover how to run two clients on
> > >windows with the default windows configuration. It isn't as simple as
> > >setting up two clients on any other environment. The oracle home
> > >selector in windows simply switches the PATH entry order. This is a
> > >major problem for clients that use these settings. You have links
> > >pasted, but the links don't point to the specific documentation and
> > >they are generic. What docs outline multi-homing on windows with 32
> > >and 64 bit clients and configuring applications to use a particular
> > >client?
>
> > Look this is not rocket science, isn't it?
> > For your shortcuts, the shortcut starts in the proper bin directory.
> > Oracle_Home will be automagically determined by reading the file
> > oracle.key, which is present in every Oracle_Home.
> > This is documented, but I am aware no one reads the documentation, or
> > wants to spend more than 1 minute.
> > For DOS sessions, being in this situation myself, I've developed one
> > cmd file per sid, called init<SID>.cmd. This sets all env vars
> > appropiately.
> > Other than that, most of the problems are courtesy of Mickeysoft (for
> > not providing a proper shell), so you could always switch to a real
> > O/S.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -
>
> > - Show quoted text -
>
> At last I figured out by myself...Hurrah! this works...Its not rocket
> science as told by Sybrand..but there are somethings which might have
> been overlooked upon while reading the documentation...People spend
> more than 10 hours to figure out a simple problem which might take
> just a minute to fix..but the knowlegdge of how to fix it is what
> matters at last...and I agree that there might be people looking our
> for help without doing anything....Having said that there is no harm
> in helping out someone who is in need, even if he is just out there
> for help without trying for himself doesnt hurt anything :-) Just my
> thoughts...

I'm still curious ... why do you need two clients in the first place?
It is well established that 32-bit clients will talk to 64-bit db's,
and vice versa. And unless you get very far afield, even the relative
versions of the client and db are not a factor .. I've had 8.1 clients
talking to 10.2 databases.

On Apr 19, 8:50 am, EdStevens <quetico_...@yahoo.com> wrote:
> On Apr 13, 2:24 pm, deepak.kollip...@gmail.com wrote:
>
>
>
> > On Apr 13, 12:07 pm, sybra...@hccnet.nl wrote:
>
> > > On 13 Apr 2007 11:47:08 -0700, "EscVector" <J...@webthere.com> wrote:
>
> > > >On Apr 13, 2:12 pm, sybra...@hccnet.nl wrote:
> > > >> On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote:
>
> > > >> >Hi,
>
> > > >> >I am wondering if we could install 32-bit client of 10g release2 and
> > > >> >64-bit client of the same (allowing delphi 32-bit apps and some .net
> > > >> >Windows services to connect to the oracle database server hosted on HP-
> > > >> >UX running 64-bit mode. has anyone done this before?
>
> > > >> >If so, can you please provide me some documentation of how to
> > > >> >configure the same.
>
> > > >> >Thanks in advance.
> > > >> >Deepak.
>
> > > >> Fact: 32-bit client can communicate with 64-bit server without
> > > >> problem.
> > > >> Fact: if you want to install 2 different clients you need to install
> > > >> them in 2 different Oracle homes
> > > >> Fact: your question is redundant, as this is all outlined in the
> > > >> installation documentation onhttp://otn.oracle.comorhttp://tahiti.oracle.combothreachablefromhttp:...
> > > >> Fact: you were even too lazy to typewww.oracle.cominyourbrowser
> > > >> and hit the documentation button.
>
> > > >> --
> > > >> Sybrand Bakker
> > > >> Senior Oracle DBA
>
> > > >The oracle documentation does not cover how to run two clients on
> > > >windows with the default windows configuration. It isn't as simple as
> > > >setting up two clients on any other environment. The oracle home
> > > >selector in windows simply switches the PATH entry order. This is a
> > > >major problem for clients that use these settings. You have links
> > > >pasted, but the links don't point to the specific documentation and
> > > >they are generic. What docs outline multi-homing on windows with 32
> > > >and 64 bit clients and configuring applications to use a particular
> > > >client?
>
> > > Look this is not rocket science, isn't it?
> > > For your shortcuts, the shortcut starts in the proper bin directory.
> > > Oracle_Home will be automagically determined by reading the file
> > > oracle.key, which is present in every Oracle_Home.
> > > This is documented, but I am aware no one reads the documentation, or
> > > wants to spend more than 1 minute.
> > > For DOS sessions, being in this situation myself, I've developed one
> > > cmd file per sid, called init<SID>.cmd. This sets all env vars
> > > appropiately.
> > > Other than that, most of the problems are courtesy of Mickeysoft (for
> > > not providing a proper shell), so you could always switch to a real
> > > O/S.
>
> > > --
> > > Sybrand Bakker
> > > Senior Oracle DBA- Hide quoted text -
>
> > > - Show quoted text -
>
> > At last I figured out by myself...Hurrah! this works...Its not rocket
> > science as told by Sybrand..but there are somethings which might have
> > been overlooked upon while reading the documentation...People spend
> > more than 10 hours to figure out a simple problem which might take
> > just a minute to fix..but the knowlegdge of how to fix it is what
> > matters at last...and I agree that there might be people looking our
> > for help without doing anything....Having said that there is no harm
> > in helping out someone who is in need, even if he is just out there
> > for help without trying for himself doesnt hurt anything :-) Just my
> > thoughts...
>
> I'm still curious ... why do you need two clients in the first place?
> It is well established that 32-bit clients will talk to 64-bit db's,
> and vice versa. And unless you get very far afield, even the relative
> versions of the client and db are not a factor .. I've had 8.1 clients
> talking to 10.2 databases.

I'm not sure about the original post, but we have issues with 3rd
party software, such as Business Objects that don't like the 64bit
client. It is easy on any OS other than windows. My beef is the
multi-homing issues on Windows when connecting via 3rd party software
that requires a specific client or non-default home. Windows is
workable, but it requires additional non-documented knowledge. I have
yet to see good Oracle docs on this.