[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464] [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file
When using BI Admin Tools 11.1.1.7.150120 with Oracle Client 12c & invoking Metadata Importa Wizard to import data from Exadata database, you may see above error message in the OBIEERPD_NQSAdminTool.log file.
On the Metadata Import Wizard screen, steps to Import Metadata
1 - Select Data Source
2 - Select Metadata Types (Select all relevant schema objects tables, views, indexes, etc)
3 - Select Metadata Objects - Here Exadata database is visible in the wizard but no oracle schemas are displayed & therefore import cannot proceed. No error message displayed on BI Admin Tool but the error message above is displayed in NQSAdminTool.log file
If your OBIEE Admin Tool environment is an OBIEE 11g Client Tools only install, required Oracle database client library files may be missing as Client Tools is a minimal install only & may not contain all directories as in full install. There may also be a mismatch in java, Oracle Client & OBIEE installed in your environments. Check if it is 32-bit or 64-bit or mismatch.
You can resolve this issue by
1) Installing Oracle database client software (32-bit or 64-bit depending on version of OBIEE Admin Tool installed). Install only if not already installed.
Once Oracle Client is installed, configure TNSNAMES.ORA entry for your Oracle Database & edit bi_init.bat file under $BI_HOME\bifoundation\server\bin and add TNS_ADMIN variable pointing to location of TNSNAMES.ORA.
2) If you already have Oracle Database 12c Client installed on the Windows machine where OBIEE 11g BI Admin Tools is installed but facing this issue in the Metadata Import Wizard, you can simply copy oracore12.dll as oracore11.dll
OBIEE Admin Tool import will now show all available schemas in step 3 of the Metadata Import Wizard.
Related Posts:
Configuring evaluate function to work in OBIEE
OBI 11.1.1.8.1 - nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.
Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe
Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics
When using BI Admin Tools 11.1.1.7.150120 with Oracle Client 12c & invoking Metadata Importa Wizard to import data from Exadata database, you may see above error message in the OBIEERPD_NQSAdminTool.log file.
On the Metadata Import Wizard screen, steps to Import Metadata
1 - Select Data Source
2 - Select Metadata Types (Select all relevant schema objects tables, views, indexes, etc)
3 - Select Metadata Objects - Here Exadata database is visible in the wizard but no oracle schemas are displayed & therefore import cannot proceed. No error message displayed on BI Admin Tool but the error message above is displayed in NQSAdminTool.log file
If your OBIEE Admin Tool environment is an OBIEE 11g Client Tools only install, required Oracle database client library files may be missing as Client Tools is a minimal install only & may not contain all directories as in full install. There may also be a mismatch in java, Oracle Client & OBIEE installed in your environments. Check if it is 32-bit or 64-bit or mismatch.
You can resolve this issue by
1) Installing Oracle database client software (32-bit or 64-bit depending on version of OBIEE Admin Tool installed). Install only if not already installed.
Once Oracle Client is installed, configure TNSNAMES.ORA entry for your Oracle Database & edit bi_init.bat file under $BI_HOME\bifoundation\server\bin and add TNS_ADMIN variable pointing to location of TNSNAMES.ORA.
2) If you already have Oracle Database 12c Client installed on the Windows machine where OBIEE 11g BI Admin Tools is installed but facing this issue in the Metadata Import Wizard, you can simply copy oracore12.dll as oracore11.dll
OBIEE Admin Tool import will now show all available schemas in step 3 of the Metadata Import Wizard.
Related Posts:
Configuring evaluate function to work in OBIEE
OBI 11.1.1.8.1 - nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.
Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe
Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics
No comments:
Post a Comment