Getting Error as : failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux)

[aurekha]

Hi All,
Im newbie to Perl. My problem is that, when i run my script, It is showing the error like

"DBI connect('blah','blah',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc. at common.pl line 448"

Here Im giving dependancies :

Orcale Client-10.2.0
Perl - /usr/lib/perl5/5.8.8
Crypt::TripleDES -- 0.24
DBD::Oracle -- 1.27
DBI -- 1.616
ExtUtils::MakeMaker -- 6.56
Perl -- 5.8.8
Test::Simple -- 0.94

The paths in .bash_profile:

ORACLE_BASE=/usr/lib/oracle/xe/app/oracle
export ORACLE_BASE
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin
export PATH

Database is in another server with version :Oracle 9.8

When i run manually from terminal, my script is generating Output. But when i kept in Crontab, it is showing the above Error.

 
$password ='XXXXXXX'; 
     $connStr = 'DBI:Oracle:nmdb';
     $username='blah';
     $password='blah'
 
 
    $DBH = DBI->connect($connStr,$username,$password) or warn "FILED : $!\n";
    || croak("DB CONN FAILED");
 
 

I badly need ur support.
Please help me out..


Thank You

[numberwhun]

Anything run from crontab is actually run as root. You need to make sure that the paths you have specified for your configuration are also in root's .bash_profile as well, otherwise you will get these errors. That is probably a good starting point.

Regards,

Jeff