[rt-users] Oracle data problem

[Matt Miller]

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.

When I run the "make initialize-database" step the RT user is created
by the script, but the moment I get to the coredata step I get the
following output:

Now inserting RT core system objects
[Fri Oct  2 20:55:52 2009] [warning]: DBD::Oracle::st execute failed:
ORA-04043: object Users does not exist (DBD ERROR: Can't match some
parameters to LOB fields in the table, check type and name) [for
Statement "INSERT INTO Users (Comments, RealName, Creator, Password,
LastUpdatedBy, Created, id, Name, LastUpdated) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?)" with ParamValues: :p1='Do not delete or modify this user.
It is integral to RT's internal database structures', :p2='The RT
System itself', :p3='1', :p4='*NO-PASSWORD*', :p5='1', :p6='2009-10-02
20:55:52', :p7='8', :p8='RT_System', :p9='2009-10-02 20:55:52'] at
/opt/rt-3.8.5/perl-5.10.1/lib/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm
line 509, <STDIN> line 1.
(/opt/rt-3.8.5/perl-5.10.1/lib/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:509)
[Fri Oct  2 20:55:52 2009] [warning]: RT::Handle=HASH(0x14928068)
couldn't execute the query 'INSERT INTO Users (Comments, RealName,
Creator, Password, LastUpdatedBy, Created, id, Name, LastUpdated)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/opt/rt-3.8.5/perl-5.10.1/lib/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm
line 522
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x14928068)',
'INSERT INTO Users (Comments, RealName, Creator, Password, Las...',
'HASH(0x14b6a958)', 'The RT System itself', 1, '*NO-PASSWORD*', 1,
'2009-10-02 20:55:52', 8, ...) called at
/opt/rt-3.8.5/perl-5.10.1/lib/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm
line 357
        DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x14928068)',
'Users', 'Comments', 'HASH(0x14b6a958)', 'RealName', 'The RT System
itself', 'Creator', 1, 'Password', ...) called at
/opt/rt-3.8.5/perl-5.10.1/lib/site_perl/5.10.1/DBIx/SearchBuilder/Handle/Oracle.pm
line 105
        DBIx::SearchBuilder::Handle::Oracle::Insert('RT::Handle=HASH(0x14928068)',
'Users', 'Comments', 'HASH(0x14b6a958)', 'RealName', 'The RT System
itself', 'Creator', 1, 'Password', ...) called at
/opt/rt-3.8.5/perl-5.10.1/lib/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1293
        DBIx::SearchBuilder::Record::Create('RT::User=HASH(0x14a9ae90)',
'Comments', 'Do not delete or modify this user. It is integral to
RT\'s in...', 'RealName', 'The RT System itself', 'Creator', 1,
'Password', '*NO-PASSWORD*', ...) called at
/opt/rt-3.8.5/rt-3.8.5/sbin/../lib/RT/Record.pm line 289
        RT::Record::Create('RT::User=HASH(0x14a9ae90)', 'id', 8,
'Comments', 'Do not delete or modify this user. It is integral to
RT\'s in...', 'Password', '*NO-PASSWORD*', 'LastUpdatedBy', 1, ...)
called at /opt/rt-3.8.5/rt-3.8.5/sbin/../lib/RT/User_Overlay.pm line
388
        RT::User::_BootstrapCreate('RT::User=HASH(0x14a9ae90)',
'Name', 'RT_System', 'RealName', 'The RT System itself', 'Comments',
'Do not delete or modify this user. It is integral to RT\'s in...',
'Creator', 1, ...) called at
/opt/rt-3.8.5/rt-3.8.5/sbin/../lib/RT/Handle.pm line 593
        RT::Handle::InsertInitialData('RT::Handle=HASH(0x14928068)')
called at ./rt-setup-database line 230
        main::action_coredata('action', 'coredata') called at
./rt-setup-database line 166
(/opt/rt-3.8.5/perl-5.10.1/lib/5.10.1/Carp.pm:47)
Couldn't finish 'coredata' step.



I have manually verified the USERS table does in fact exist:

$ sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Oct 2 16:56:08 2009

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL> connect rtdb_user/xxx at orasvr/db1
Connected.
SQL> describe users
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(11)
 NAME                                      NOT NULL VARCHAR2(200)
 PASSWORD                                           VARCHAR2(40)
 COMMENTS                                           CLOB
 SIGNATURE                                          CLOB
 EMAILADDRESS                                       VARCHAR2(120)........



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?