Internal Error Unable To Initialize Nls During Driver Load Oracle
Contents |
during driver load. Solution: Make sure your
Internal Error Unable To Initialize Nls During Driver Load Obiee
TNS_ADMIN environment variable for your tnsnames.ora file is ms access internal error - unable to initialize nls during driver load exported in your bi.ora file, and that your ORACLE_HOME variable points to the unable to initialize nls during driver load oracle 11g ORACLE_HOME of the Oracle Client On my windows installation the file ends with “.bat” and can be found here: c:\Program 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 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 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: http://www.myoracleworld.net/BI-NLS-error01.html "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\ 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 http://www.orafaq.com/forum/t/43832/ 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 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? T
error unable to initialize NLS during driver http://www.amazing-reports.com/blog/2014/04/07/import-metadata-nls-driver-load-error load The solution Go to: C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin and edit bi_init.bat Add the following line as https://amazingreportsbi.wordpress.com/category/obiee11g/obi11-1-1-7-1/ 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 Administration tool. Then try to import againPosted unable to in 11.1.1.7.1, OBIEE11g, RepositoryTagged with Import metadata, error, nls 1 Comments Yudhisthira - March 31st, 2015 at 10:05 AM Hi, I did the same process. But no result same issue I am getting. Any other thing I need to check? @echo off unable to initialize 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 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 GU
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 Blog at WordPress.com.