[rt-users] OCIEnvNlsCreate error trying to initialize Oracle DB

[Joe Casadonte]

Having been scared off of using SQLite even for a small system, I've now 
bought some more memory and put Oracle on my home machine.  I can't get 
the damn schema set up, instead getting the following error:

# perl sbin/rt-setup-database --dba=reqtrack --dba-password=foobar 
--action init

DBI connect('reqtrack','reqtrack',...) failed: ERROR OCIEnvNlsCreate. 
Check ORACLE_HOME env var, NLS settings, permissions, etc. at 
sbin/rt-setup-database line 105

Failed to connect to dbi:Oracle:reqtrack as reqtrack: ERROR 
OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, 
etc. at sbin/rt-setup-database line 105.


I know that DBI is OK, because I run the following with no problem:

# perl -MDBI -le 'DBI->connect("DBI:Oracle:", "reqtrack", "foobar");'
#

Does anyone know what could be wrong?  I've checked all permissions, 
I've dropped and re-added the DB in case I screwed up the NLS stuff; 
everything seems to be set up OK.

Oracle: 10.2.0.3
RT: 3.6.6
OS: Fedora Core 5
Perl: 5.8.8

Thanks!

-- 
Regards,


joe
Joe Casadonte
joe.casadonte at oracle.com

==========                                                  ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation.               ==
==========                                                  ==========