InstantClient RPMs

Posted on January 3, 2011. Filed under: Linux, openSUSE | Tags: , , , , |

Well, a few years back I came across the Oracle InstantClient SPEC file prepared by Remi Collet, it was great to find it because the original RPMs made by Oracle don’t help to build other packages depending on them.

I created a set of packages for a project using the original file from Remi. Some days later I enhanced them to make the use of the package by end users really smooth (ORACLE_HOME environment variable, PATHs, etc). Also added other tweaks like a script to help building Perl-DBD-Oracle (not made by me) and was really happy with the results. Here’s where everything went downhill. There was a policy of only allowing software with source code on the openSUSE Build Service and the guys in charge just deleted the package from my repo project and I lost all the work done.

I had the recreation of the package on my ToDo list, but never had time to do it… A few days before, facing a new project involving Oracle, I went to Remi’s blog to look for the original SPEC file and luckily a month or so earlier he modified it to support the latest version of the client (to this date, 10.2.0.2).

I made some changes to it (them, as they were split in two) and I’m sharing the result here. As a final touch I’ll be addind tnsping to the packages, which is only included on the “thick” Oracle installation and maybe I’ll merge the “precomp*” sub-package to “devel”.

Files:

oracle-instantclient.spec
oracle-instantclient-11.2.0.2.0-37.1.nosrc.rpm

My changes to Remi’s SPEC files:


* Sun Jan 2 2011 Ciro Iriarte 11.2.0.2.0
- Added ORACLE_HOME definition
- Added tnsnames.ora example and required directory structure

* Sat Jan 1 2011 Ciro Iriarte 11.2.0.2.0
- merge i386/x86_64 SPECs again
- fixed RPM Groups
- added Jean-Christophe Duberga's config script to help building Perl-DBD-Oracle
(this wasn't documented on my first change in 2007, and was lost in OBS)
- skip RPATH and BYTECODE verifications in OBS builds
- renamed oracle-instantclient-basic to oracle-instantclient
- added unzip to BuildRequires
- general cleanup to make openSUSE 11.3 sanity checks happy
o ToDo: Verify rpmlint filters
- add precomp and precomp-devel sub-packages

Ref:

Request allowing OIC in Build Service

Advertisements
Read Full Post | Make a Comment ( 3 so far )

Faster Japanese rendering in Firefox

Posted on March 15, 2009. Filed under: Japanese, Linux, openSUSE | Tags: , , , , |

Years before I found that rendering japanese content in Firefox was REALLY slow, but just resigned to live with it and some time later forgot about the whole thing as I stopped accessing japanese content….

Today I found some interesting content again after reading some posts at kirainet.com, and suddenly was annoyed once more with this rendering slowness. After researching a little, I found this post which solves the issue. I’m not pretty sure about why this fonts help to render the pages faster than the stock fonts, should they be included in the distro?

Here’s the procedure to install them in openSUSE (tested with 11.0@x86_64):

Find a suitable repository using http://software.opensuse.org/search

Add the repository to your system (you don’t HAVE TO, but this way you can get updates later):

zypper addrepo http://download.opensuse.org/repositories/home:/swyear/openSUSE_11.0 “Japanese Fonts”

Install the packages:

zypper install ttf-wqy-zenhei wqy-bitmapfont

It will ask if it should trust and later import the key, just answer “YES” to both questions. You’ll have to restart Firefox to use this new fonts..

Pages to test rendering:

http://ja.wikipedia.org/wiki/%E6%97%A5%E6%9C%AC

http://news.google.com/news?ned=cn

http://news.google.com/news?ned=jp

http://kayanomori.net/memo/index.php?iFolder%20Simple%20Server

Read Full Post | Make a Comment ( 1 so far )

Modificando zonas horarias

Posted on March 29, 2006. Filed under: Linux | Tags: , , , |

Los archivos con informacion sobre las zonas horarias y el popular “daylight saving” se encuentran en /usr/share/zoneinfo. Los mismos pueden ser consultados con zdump -v “archivo”.

En nuestro caso es muy comun el que cambien las fechas donde se efectua el cambio de hora, para corregir esto hay que recompilar estos archivos luego de modificarlos, esto se realiza con el comando zic.

  • Los sources se bajan de ftp://elsie.nci.nih.gov/pub/

Procedimiento (ejemplo para Paraguay):

# Realizar copia de seguridad
cp -rp /usr/share/zoneinfo{,.$(date +%Y%m%d)}

# Obtener source:
mkdir -p /tmp/tzdata && cd /tmp/tzdata
wget ‘ftp://elsie.nci.nih.gov/pub/tzdata*.tar.gz’

# Realizar modificacion
tar xvzf tzdata*
vi southamerica

# Compilar
/usr/sbin/zic southamerica

# Definir zona horaria
cp /usr/share/zoneinfo/America/Asuncion /etc/localtime

Read Full Post | Make a Comment ( None so far )

Liked it here?
Why not try sites on the blogroll...