Problems with Perl script that connects to Oracle database

0

I'm trying to run a script that connects to an Oracle database, and I get the following error:

DBI connect('...,...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env 
var  or PATH (Windows) and or NLS settings, permissions

I'm using DBD :: Oracle

Use in MacOs Sierra

What is it that may be failing? I read several posts about this and apparently there are several causes but nothing I read helped me to solve it.

Is it possible that ORACLE_HOME is wrong? And in that case what value should it have?

    
asked by user54067 27.07.2017 в 11:52
source

1 answer

1

ORACLE_HOME should equal the path where Oracle is installed. That is, the place within the file system where the Oracle libraries and binaries are.

In the case of Windows, instead of $ ORACLE_HOME it would be% PATH%

    
answered by 28.07.2017 в 10:44