[rt-users] Oracle data problem

[Joop van de Wege]

Matt Miller wrote:
> Using RT 3.8.5, Perl 5.10.1, mod_perl 2.0.4, and Apache 2.2.13.  I
> have the following Oracle client packages installed on my CentOS 5.3
> x86_64 box:
> oracle-instantclient11.1-basic-11.1.0.7.0-1
> oracle-instantclient11.1-sqlplus-11.1.0.7.0-1
> oracle-instantclient11.1-devel-11.1.0.7.0-1
> 
> My Oracle server is running on a separate server from the RT
> application.  I have confirmed connectivity using SQL*Plus.

> 
> I strongly doubt this is a compilation problem because the "rtdb_user"
> is created and I can see the RT login screen in my web browser.  I
> have tried populating the database this with both root and the RT
> user's login, both of which are able to connect to the database using
> SQL*Plus and have their environment variables set to the following:
> NLS_NCHAR=AL32UTF8
> NLS_LANG=AMERICAN_AMERICA.AL32UTF8
> 
> 
> Thoughts?
Yes, a bug in DBD::Oracle-1.23. Check your version and if it is  1.23 
downgrade to 1.22 and you'll be fine. I found this bug and searching the 
archives of both devel and user should find a post of mine about it.

Regards,

Joop