Prev: flawed logic in connection pooling
Next: UPDATE: TkTable 2.9 and MouseWheel bindings ...
From: osalcescu on 24 Jun 2008 12:31
Hi,

I tried to run oratcl 4.3 over "oracle client instantclient" (v.
10.1.10) and it didn't connect to the database but it finally did once
I installed oracle client runtime option. The runtime libraries are
somewhere arround 200MB vs 80MB's of the instant client so I would
really like to make it work with the bare instant client if it is
possible and there's info on the tcl wiki that it should connect using
just the instant client. Some one even suggested that it should be
enough to *unzip* the instant client to make oratcl work (I wonder how
that could be done since there's no obvious zip/archives for any
client type instalation on the dvd I got).

Also there's no network folder to hold a tnsnames.ora configuration on
the disk if I choose the instant client type of installation and the
oratcl dsnless way of connecting the code to oracle doesn't work
either.

I'm developing on an windows xp professional box.

I searched Tom Pointdexter's web site (maintainer of the oratcl
package) and didn't find any help on this matter. Also the wikit tcl
doesn't have much on this issue too and clt search didn't bring any
light on the matter either. So I'm assuming that it's something
obvious but I can't find what it is.

Could some one guide/help me explaining what specific settings are
necessary to make oratcl work with instant client?
Thank you a lot.


From: venkitaswaran on 24 Jun 2008 16:59
On Jun 24, 11:31 am, osalce...(a)gmail.com wrote:
> Hi,
>
> I tried to run oratcl 4.3 over "oracle client instantclient" (v.
> 10.1.10) and it didn't connect to the database but it finally did once
> I installed oracle client runtime option. The runtime libraries are
> somewhere arround 200MB vs 80MB's of the instant client so I would
> really like to make it work with the bare instant client if it is
> possible and there's info on the tcl wiki that it should connect using
> just the instant client. Some one even suggested that it should be
> enough to *unzip* the instant client to make oratcl work (I wonder how
> that could be done since there's no obvious zip/archives for any
> client type instalation on the dvd I got).
>

I'm not expert on this, but, here're some suggestions:

According to the Wiki notes on Oratcl at http://wiki.tcl.tk/204 - it
indicated that the folder to which the Oracle instant client was
installed
must be in your PATH.

> Also there's no network folder to hold a tnsnames.ora configuration on
> the disk if I choose the instant client type of installation and the
> oratcl dsnless way of connecting the code to oracle doesn't work
> either.

One suggestion is to set the TNS_ADMIN variable to point to the
directory
that contains the tnsnames.ora file. Granted, this won't achieve
dsnless
connections, though.

I don't have a WinXP box to test on, since my efforts were mainly
directed
at installing and using the instant client on AIX.

Hope that helps
--
Ramesh.
From: thelfter on 25 Jun 2008 00:07
On Jun 24, 12:31 pm, osalce...(a)gmail.com wrote:
> Hi,
>
> I tried to run oratcl 4.3 over "oracle client instantclient" (v.
> 10.1.10) and it didn't connect to the database but it finally did once
> I installed oracle client runtime option. The runtime libraries are
> somewhere arround 200MB vs 80MB's of the instant client so I would
> really like to make it work with the bare instant client if it is
> possible and there's info on the tcl wiki that it should connect using
> just the instant client. Some one even suggested that it should be
> enough to *unzip* the instant client to make oratcl work (I wonder how
> that could be done since there's no obvious zip/archives for any
> client type instalation on the dvd I got).
>
> Also there's no network folder to hold a tnsnames.ora configuration on
> the disk if I choose the instant client type of installation and the
> oratcl dsnless way of connecting the code to oracle doesn't work
> either.
>
> I'm developing on an windows xp professional box.
>
> I searched Tom Pointdexter's web site (maintainer of the oratcl
> package) and didn't find any help on this matter. Also the wikit tcl
> doesn't have much on this issue too and clt search didn't bring any
> light on the matter either. So I'm assuming that it's something
> obvious but I can't find what it is.
>
> Could some one guide/help me explaining what specific settings are
> necessary to make oratcl work with instant client?
> Thank you a lot.


I will send you the instructions on how to do this tomorrow.

-Todd
From: Larry W. Virden on 25 Jun 2008 07:07
On Jun 24, 12:31 pm, osalce...(a)gmail.com wrote:

>
> I searched Tom Pointdexter's web site (maintainer of the oratcl
> package) and didn't find any help on this matter.

The main help I can provide is that Tom is the original author of
oratcl, but maintainenance of the package has transitioned to the team
at http://oratcl.sf.net/ , which is tmh, along with Jeff Hobbs and Tom
P providing valuable mentorship, feedback, etc.

Use the oratcl.sf.net web site for the primary source of info, place
to file bug reports, etc.
From: venkitaswaran on 25 Jun 2008 11:54
On Jun 24, 11:07 pm, "thelf...(a)gmail.com" <thelf...(a)gmail.com> wrote:
> On Jun 24, 12:31 pm, osalce...(a)gmail.com wrote:
> > Could some one guide/help me explaining what specific settings are
> > necessary to make oratcl work with instant client?
> > Thank you a lot.
>
> I will send you the instructions on how to do this tomorrow.

It would be greatly appreciated if you could publish those
instructions in a common location (the tcl wiki) for instance.

Thank you
- Ramesh

 |  Next  |  Last
Pages: 1 2
Prev: flawed logic in connection pooling
Next: UPDATE: TkTable 2.9 and MouseWheel bindings ...