Oracle Odbc Error Unable To Initialize Nls During Driver Load
Contents |
during driver load. Solution: Make sure your
Unable To Initialize Nls During Driver Load Odbc
TNS_ADMIN environment variable for your tnsnames.ora file is internal error unable to initialize nls exported in your bi.ora file, and that your ORACLE_HOME variable points to the
Internal Error Unable To Initialize Nls During Driver Load Obiee
ORACLE_HOME of the Oracle Client On my windows installation the file ends with “.bat” and can be found here: c:\Program ms access internal error - unable to initialize nls during driver load Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orahome\bifoundation\server\bin\bi_init.bat Add the following to the above file – this is where the tnsnames.ora file is for my Oracle Client which I used for the ODBC configuration: TNS_ADMIN=c:\Oracle\product\11.2.0\dbhome_1\network\admin and update ORACLE_HOME to point to the unable to initialize nls during driver load oracle ORACLE_HOME of the 11G client. HTML Comment Boxis loading comments... www.myoracleworld.net Oracle Database TIPS ◦ Creating an ASM alias for control files ◦ RMAN ◦ Creating a Recovery Catalog ◦ Installing 11GR2 on redhat 5U5 64-Bit ◦ Next 4 Oracle APPS 12.* TIPS ◦ Installing EBS 12.1.1 on Redhat ES 6.0 x86_64 ◦ Getting the EBS Login URL from within SQL*Plus ◦ PA_PWP_SUMM_PKG Invalid after 12.1.1 upgrade to 12.1.3 ◦ Concurrent Manager Status Middleware TIPS ◦ Next 1 Linux TIPS ◦ cman_tool: aisexec daemon didn't start ◦ Setup a yum or up2date repository to use a locally mounted DVD ◦ Installing SAMBA and adding new SMB Shares/Users/Passwords Contact Me About Myself Site Map Weather Forecast|Weather Maps
oracleClient92 Release 9.2.0.3.0 [message #115093] Thu, 07 April 2005 07:53 tom3025 Messages: 1Registered: April 2005 Junior Member Hello! We have an Excel-File with queries to our Oracle
Unable To Initialize Nls During Driver Load Oracle 11g
DB. To get the data we use "ThisWorkbook.RefreshAll". Problem: With 'oracleClient92 Release 9.2.0.3.0 - Production' all worked as it should. But with 'oracleClient92 Release 9.2.0.5.0 - Production' we get an error. Excel shows the Msg: "Oracle ODBC Driver Internal error - unable to initialize NLS during driver load." So if checked the NLS-Settings: Client:SQL*Plus: Release 9.2.0.5.0 - Production \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ http://www.myoracleworld.net/BI-NLS-error01.html NLS_LANG --> AMERICAN_AMERICA.WE8ISO8859P1 \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0 NLS_LANG --> AMERICAN_AMERICA.WE8ISO8859P1 \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 NLS_LANG --> AMERICAN_AMERICA.WE8ISO8859P1 Server:Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production With the Partitioning option JServer Release 9.2.0.5.0 - Production NAME TYPE VALUE ------------------------------------ ----------- -------- nls_calendar string nls_comp string nls_currency string nls_date_format string nls_date_language string nls_dual_currency string nls_iso_currency string nls_language string AMERICAN nls_length_semantics string BYTE nls_nchar_conv_excp string FALSE nls_numeric_characters string nls_sort http://www.orafaq.com/forum/t/43832/ string nls_territory string AMERICA nls_time_format string nls_time_tz_format string nls_timestamp_format string nls_timestamp_tz_format string I can't see anything that is wrong here!? Now I tested with 'Release 9.2.0.3.0 - Production': (To get the Client to 9.2.0.3.0, I’ve just copied the 'bin' Folder from the oracleClient92 Folder of another PC (no new installation).) I've changed the NLS_LANG Reg-Keys to GERMAN_GERMANY.WE8ISO8859P1. All worked fine. Then I’ve changed the Keys to JAPANESE_JAPAN.JA16EUCTILDE. With this setting in can't connect to the database. So this means, my ODBC-Problem with Release 9.2.0.5.0 is after the connection to the Database, right? Does anyone know this error? Can your help me? Thanks a lot! Tom Maier Report message to a moderator Re: Error with ODBC and oracleClient92 Release 9.2.0.3.0 [message #124966 is a reply to message #115093] Wed, 22 June 2005 10:01 McCoy1 Messages: 2Registered: June 2005 Junior Member Did you ever resolve this issue? Report message to a moderator Re: Error with ODBC and oracleClient92 Release 9.2.0.3.0 [message #125002 is a reply to message #115093] Wed, 22 June
error unable to initialize NLS during driver load The solution Go to: C:\Program Files\Oracle Business http://www.amazing-reports.com/blog/2014/04/07/import-metadata-nls-driver-load-error Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin and edit bi_init.bat Add the following line as shown: set TNS_ADMIN=C:\app\client\REPLACE for your user\product\12.1.0\client_1\network\admin Save the file and Restart the OBI https://amazingreportsbi.wordpress.com/category/obiee11g/obi11-1-1-7-1/ Administration tool. Then try to import againPosted in 11.1.1.7.1, OBIEE11g, RepositoryTagged with Import metadata, error, nls 1 Comments Yudhisthira - March 31st, 2015 at 10:05 unable to AM Hi, I did the same process. But no result same issue I am getting. Any other thing I need to check? @echo off rem overwrite JAVA_HOME set JAVA_HOME=%~d0%~p0..........jre if exist "%JAVA_HOME%binjava.exe" goto:doneJAVAHOME rem abort echo ******************* echo ****** ERROR ****** echo ******************* set /p prompt=[Invalid JAVA_HOME: %JAVA_HOME%] Enter return unable to initialize to abort exit 100 :doneJAVAHOME set ORACLE_HOME=C:Program FilesOracle Business Intelligence Enterprise Edition Plus Client Toolsoraclebiorahome set ORACLE_INSTANCE=C:Program FilesOracle Business Intelligence Enterprise Edition Plus Client Toolsoraclebiorainst set ORACLE_BI_APPLICATION=coreapplication rem call %ORACLE_INSTANCE%bifoundationOracleBIApplication%ORACLE_BI_APPLICATION%setupuser.cmd set TNS_ADMIN=C:appzanacoproduct11.2.0client_1networkadmin if NOT "%1" == "" set COMPONENT_NAME=%1 set PATH=%ORACLE_HOME%bifoundationserverbin;%ORACLE_HOME%bifoundationwebbin;%ORACLE_HOME%bin;%JAVA_HOME%bin;%windir%;%windir%system32;%PATH% if "%2" == "" goto:end %2 :end Reply Leave a Comment Submit ◀ Older Post Newer Post ▶ Main Search FollowCategories11.1.1.7.1 (6) Catalog (1) Cloud (1) Dashboards (3) Enterprise Manager (1) OBI11g Migration (2) OBIEE11g (4) ODBC (1) Oracle Database (1) Oracle12c (2) Refresh GUIDs (2) Repository (2) Security (1) TNSnames.ora (1) VNC (1) Tags11.1.1.7.1 Dashboard GUIDs Import metadata My Folders OBIEE11g Permissions error administration tool analytics cloud enterprise manager error linux nls odbc oltp oracle12c tnsnames transactional vnc server Recent PostsOracle In-Memory Hightlights OBIEE11g could not connect to Oracle Database Refresh GUIDs after migrating Repository and Catalog OBIEE11g Repository Port Import Metadata: NLS driver load error HomeConsultingTrainingsOracle PaaSCertificationsBlogPhotosContact
on results tab to see the output of certain criteria: Oracle Error code: 12154, message: ORA-12154: TNS:could not […] Read Article → Business Intelligence, OBI11.1.1.7.1, OBIEE11g OBIEE11g Repository Port March 31, 2014by Jordi Morris Leave a comment It is possible to have multiple Instances of OBIEE running in weblogic Domain. Hence, each instance demands having its own ports for accessing the repository and catalog in online mode. […] Read Article → Administration tool, Business Intelligence, OBI11.1.1.7.1, OBIEE11g Import Metadata: NLS driver load error March 28, 2014by Jordi Morris Leave a comment The problem In OBI 11.1.1.7.1 it came up with the following error when trying to import metadata. internal error unable to initialize NLS during driver load The solution: Go to: […] Read Article → Administration tool, Business Intelligence, OBI11.1.1.7.1, OBIEE11g Post navigation Upcoming Events No upcoming events Trainings OBI 11g Advanced 9-12 September Oracle UK OBI 11g Bootcamp 16-20 September Oracle UK OBI 11g Applications 1-4 October Oracle UK OBI 11g Bootcamp 14-18 October Oracle Germany OBI 11g Bootcamp 18-22 November Oracle Germany Recent Posts OBIEE11g could not connect to Oracle Database Refresh GUIDs after migrating Repository and Catalog OBIEE11g Repository Port Import Metadata: NLS driver load error OBI 11.1.1.7.1 Import Metada from Oracle12c Recent CommentsArchives April 2014 March 2014 November 2013 Categories Administration tool Business Intelligence Cloud Linux OBI11.1.1.7.1 OBIEE11g Uncategorized VNC Search Trainings OBI11g Metadata Administrator Training Follow me on LinkedIN lang: en_US Search Blogroll OBI11g Metadata Administrator Training Meta Register Log in Follow Amazing Reports on WordPress.com Create a free website or blog at WordPress.com.