Joys of Linux
in [Oracle]
|
Prev: RMAN-06025
Next: Oracle Spatial/Locator issue
From: Mladen Gogala on 24 Oct 2009 01:22 Last night, I upgraded my CentOS from 5.3 --> 5.4. Of course, there is no upgrade for unixODBC, but there is a ton of other upgrades. Result: [mgogala(a)medo work]$ isql ora10 scott tiger +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select * from user_tables; isql: symbol lookup error: /usr/lib/oracle/10.2.0.3/client/lib// libsqora.so.10.1: undefined symbol: _VEC_memzero [mgogala(a)medo work]$ This used to work and now it doesn't. As 10g ODBC drivers are no longer supported, there is nobody to complain to. Of course, the 11g drivers are incompatible with the current release of the unixODBC driver manager: [mgogala(a)medo work]$ isql ora11 scott tiger isql: symbol lookup error: /usr/lib/oracle/11.2/client/lib/ libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW [mgogala(a)medo work]$ The trick would be to pull the latest source and run ../configure prefix=/usr but that would mess up the installed packages system and instantaneously render the whole thing unsupported. I am eagerly awaiting somebody to create the much needed RPM packages and put them into one of the available repositories. I am downloading the DVD with Oracle EL 5.4, in order to see whether it has the right version of the driver manager. Fortunately, RR is rather fast and that will be done quickly. -- http://mgogala.freehostia.com
From: Mladen Gogala on 24 Oct 2009 01:25 On Sat, 24 Oct 2009 05:22:29 +0000, Mladen Gogala wrote: > Last night, I upgraded my CentOS from 5.3 --> 5.4. Of course, there is > no upgrade for unixODBC, but there is a ton of other upgrades. Result: > > > [mgogala(a)medo work]$ isql ora10 scott tiger > +---------------------------------------+ | Connected! > | | | | sql-statement > | | help [tablename] | | quit > | | > | +---------------------------------------+ SQL> select * from > user_tables; > isql: symbol lookup error: /usr/lib/oracle/10.2.0.3/client/lib// > libsqora.so.10.1: undefined symbol: _VEC_memzero [mgogala(a)medo work]$ > > This used to work and now it doesn't. As 10g ODBC drivers are no longer > supported, there is nobody to complain to. Of course, the 11g drivers > are incompatible with the current release of the unixODBC driver > manager: > > [mgogala(a)medo work]$ isql ora11 scott tiger isql: symbol lookup error: > /usr/lib/oracle/11.2/client/lib/ libsqora.so.11.1: undefined symbol: > SQLGetPrivateProfileStringW [mgogala(a)medo work]$ > > > The trick would be to pull the latest source and run > > ./configure prefix=/usr > > but that would mess up the installed packages system and instantaneously > render the whole thing unsupported. I am eagerly awaiting somebody to > create the much needed RPM packages and put them into one of the > available repositories. I am downloading the DVD with Oracle EL 5.4, in > order to see whether it has the right version of the driver manager. > Fortunately, RR is rather fast and that will be done quickly. BTW, did anybody manage to successfully install the latest Tora on CentOS 5.x or RH EL 5.x? -- http://mgogala.freehostia.com
From: Mladen Gogala on 24 Oct 2009 02:23 On Sat, 24 Oct 2009 05:22:29 +0000, Mladen Gogala wrote: > I am downloading the DVD with Oracle EL 5.4, in order to see whether it > has the right version of the driver manager. Fortunately, RR is rather > fast and that will be done quickly. OEL doesn't have the right version, either. It's still unixODBC 2.2.11. The problem was reported to Red Hat in December 2008, still unresolved. I am starting to believe that the big boys are playing politics: https://bugzilla.redhat.com/show_bug.cgi?id=475615 The solution is described here: http://kuroyi.net/category/odbc/ Of course, it's unsupported to link the driver manager from the source. If any form of technical assistance is needed, you will be out of luck. My impression is that the state of ODBC on Linux is really sad on purpose because interoperability isn't in the best interest of the big software vendors. -- http://mgogala.freehostia.com
From: Robert Klemme on 24 Oct 2009 08:16 On 10/24/2009 08:23 AM, Mladen Gogala wrote: > On Sat, 24 Oct 2009 05:22:29 +0000, Mladen Gogala wrote: > >> I am downloading the DVD with Oracle EL 5.4, in order to see whether it >> has the right version of the driver manager. Fortunately, RR is rather >> fast and that will be done quickly. > > OEL doesn't have the right version, either. It's still unixODBC 2.2.11. > The problem was reported to Red Hat in December 2008, still unresolved. > I am starting to believe that the big boys are playing politics: > > https://bugzilla.redhat.com/show_bug.cgi?id=475615 > > The solution is described here: > http://kuroyi.net/category/odbc/ > > Of course, it's unsupported to link the driver manager from the source. > If any form of technical assistance is needed, you will be out of luck. > My impression is that the state of ODBC on Linux is really sad on purpose > because interoperability isn't in the best interest of the big software > vendors. Or maybe that interface is just too infrequently used. I guess many applications that need to run on Linux will either use JDBC or OCI. Do you think this is a wrong assumption? Kind regards robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/
From: Andreas Piesk on 24 Oct 2009 08:32
On 24 Okt., 07:25, Mladen Gogala <gogala.mla...(a)gmail.com> wrote: > > BTW, did anybody manage to successfully install the latest Tora on CentOS > 5.x or RH EL 5.x? yes, i did. i have tora-2.1.1svn running on RHEL5.4. -ap |