Post

2 followers Follow
0
Avatar

Error: error is ERROR OCIEnvNlsCreate.

Question

I got the following message?:

Error: error is ERROR OCIEnvNlsCreate.

Answer

The usual cause of this error is environmental variables. Try the following:

unset ORA_NLS10
unset ORA_TZFILE
unset TNS_ADMIN
export TNS_ADMIN= <correct TNS>
Chris Lawless Answered

Please sign in to leave a comment.

1 comment

-1
Avatar

Testing with the below commands will provide insight into the configuration of the running instance of Dbvisit Replicate 2.6.03.4023:

$ ./start-console.sh ENGINE TEST_CONNECTION_ORACLE SYSTEM/<password>@<OracleSid>
Initializing......done
DDC loaded from database (323 variables).
Dbvisit Replicate version 2.6.03.4123
Copyright (C) Dbvisit Software Limited. All rights reserved.
DDC file /home/oracle/SOURCEDB/SOURCEDB-MINE.ddc loaded.
Connection OK (now try to execute alter session). Environment settings:
_FORCE_LD_PATH_ALL="NO"
_FORCE_LD_PATH_SYSDBA="NO"
TNS_ADMIN="/u01/app/oracle/product/11.2.0/db_1/network/admin"
ORACLE_HOME="/u01/app/oracle/product/11.2.0/db_1"
ORACLE_SID="SOURCEDB"
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
ORA_NLS=<not defined>
ORA_NLS32=<not defined>
ORA_NLS33=<not defined>
ORA_NLS10=<not defined>
LD_LIBRARY_PATH="/tmp/par-oracle/cache-97c3db380bb0154930a8377410b54b6b1f37f45f:/u01/app/oracle/product/11.2.0/db_1/lib"
PATH="/tmp/par-oracle/cache-97c3db380bb0154930a8377410b54b6b1f37f45f:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/orac
le/bin:/usr/dbvisit/replicate/dbvrep:/u01/app/oracle/product/11.2.0/db_1/bin"
TWO_TASK=<not defined>
ORA_TZFILE=<not defined>
ORACLE_BASE="/u01/app/oracle"
ORACLE_PATH=<not defined>
ORACLE_TRACE=<not defined>
ORAENV_ASK=<not defined>
SQLPATH=<not defined>
OK-0: Completed successfully.
$ ./start-console.sh ENGINE TEST_CONNECTION_ORACLE_AS_SYSDBA sys/<password>@<OracleSid>
Initializing......done
DDC loaded from database (323 variables).
Dbvisit Replicate version 2.6.03.4123
Copyright (C) Dbvisit Software Limited. All rights reserved.
DDC file /home/oracle/SOURCEDB/SOURCEDB-MINE.ddc loaded.
Connection OK (now try to execute alter session). Environment settings:
_FORCE_LD_PATH_ALL="NO"
_FORCE_LD_PATH_SYSDBA="NO"
TNS_ADMIN="/u01/app/oracle/product/11.2.0/db_1/network/admin"
ORACLE_HOME="/u01/app/oracle/product/11.2.0/db_1"
ORACLE_SID="SOURCEDB"
NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
ORA_NLS=<not defined>
ORA_NLS32=<not defined>
ORA_NLS33=<not defined>
ORA_NLS10=<not defined>
LD_LIBRARY_PATH="/tmp/par-oracle/cache-97c3db380bb0154930a8377410b54b6b1f37f45f:/u01/app/oracle/product/11.2.0/db_1/lib"
PATH="/tmp/par-oracle/cache-97c3db380bb0154930a8377410b54b6b1f37f45f:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/orac
le/bin:/usr/dbvisit/replicate/dbvrep:/u01/app/oracle/product/11.2.0/db_1/bin"
TWO_TASK=<not defined>
ORA_TZFILE=<not defined>
ORACLE_BASE="/u01/app/oracle"
ORACLE_PATH=<not defined>
ORACLE_TRACE=<not defined>
ORAENV_ASK=<not defined>
SQLPATH=<not defined>
OK-0: Completed successfully.
Donna Zehl -1 votes
Comment actions Permalink