OBIEE Patch 18277370 conflicts with Patch 17611288 installed during OBIA 11.1.1.8.1 installation
When attempting to apply OBIEE required patch 18277370, conflict is detected with Patch 17611288 which is for Fusion / OTBI applications.
Do not apply 18277370 in this case as it will rollback patch 17611288 and you may encounter an issue with EM not working post patching.
Instead obtain controlled Patch 20805649 from Product Support. EM should work without issue after applying Patch 20805649.
Related Posts:
FMW 11.1.1.7.0 - Applying Patch 20805649: REL9 BP16 CUMULATIVE JDEVADF_11.1.1.7.9ADF-FAREL9-BP_GENERIC_150401.1409.6807
Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g
FMW 11.1.1.7.0 - Applying Patch 20805649: REL9 BP16 CUMULATIVE JDEVADF_11.1.1.7.9ADF-FAREL9-BP_GENERIC_150401.1409.6807
- Review the patch README file to ensure all the pre-requisites for this patch are met including opatch version, environment variables are set, access to valid inventory, etc
- Set ORACLE_HOME to $MW_HOME/oracle_common
- For Standalone JDeveloper install type, shutdown JDeveloper and make sure that the Embedded/Integrated WLS Server is also stopped.
- No action needed for WebCenter/SOA/Classic, etc.install type:
- For Standalone WLS install type, make sure that the WLS server is stopped.
Applying patch 20805649
- $ unzip -d PATCH_TOP p20805649_111170_Generic.zip
- $ cd PATCH_TOP/20805649
- Run OPatch to apply the patch.
For OUI Home, run $ opatch apply
For Standalone JDeveloper Home.
Use the following command
$ opatch apply -jdk [Path to jdk] -jre [Path to jre]
Post Patch instructions
a) For Standalone JDeveloper install type:
- Start JDeveloper and ensure Embedded/Integrated WLS Server is also started.
- If patch does not deploy to Integrated WLS Server then shutdown JDeveloper and integrated WLS, clean up tmp directory $JDEV_USER_DIR]\DefaultDomain\servers\DefaultServer\tmp\* .
- Once this has been done, restart JDeveloper and the integrated WLS.
b) For WebCenter/SOA/Classic/etc. install type:
- Restart all WLS Managed Servers and WLS Admin Server.
c) For Standalone WLS install type:
- Start all WLS Managed Servers and WLS Admin Server
Rollback patch
- $ cd PATCH_TOP/20805649
- $ opatch rollback -id 20805649 -jdk [Path to jdk/jre]
a) For Standalone JDeveloper install type:
Clean up tmp directory under $JDEV_USER_DIR]\DefaultDomain\servers\DefaultServer\tmp\* .
b) For WebCenter/SOA/Classic/etc. install type:
Clean up tmp directory for Admin & Managed Servers under $MW_HOME]/user_projects/domains/[DOMAIN_NAME]/servers/[SERVER NAME]/tmp/*
c) For Standalone WLS install type:
Restart all WLS Managed Servers and WLS Admin Server
- Start JDeveloper and make sure that the Embedded WLS Server is also started.
Related Posts:
FMW 11.1.1.8.0 - Applying Patch 20022599: WEBCENTER CONTENT BUNDLE PATCH 11.1.1.8.9
WebCenter Content 11.1.1.8.9 Stuck Threads Issue - Applying Patch 20319643: STUCK THREADS DUE TO UNSAFE RIDC CODE - HASHMAP
FMW 11.1.1.7.0 MDS Patch 17693339 removed after applying ADF Patch for WebCenter Portal - Patch 21880254: MERGE REQUEST ON TOP OF 11.1.1.7.0 FOR BUGS 20224749 21789440
FMW 11.1.1.7.0 - Applying Patch 18182516: UTF-8 CHARACTERS E3 E80 E81 NOT RECOGNIZED PROPERLY BY B2B
OBIEE Patch 18277370 conflicts with Patch 17611288 installed during OBIA 11.1.1.8.1 installation
[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
OBIEE 11.1.1.7.140715 Bundle Patch Released
Oracle Business Intelligence Enterprise Edition - OBIEE 11.1.1.7.140715 Suite Bundle Patch on July 15, 2014.
• OBIEE 11.1.1.7.140715 suite bundle patch 18818588 is a single patch that contains all eight component patches.
o Oracle Business Intelligence Installer (BIINST)
o Oracle Real Time Decisions (RTD)
o Oracle Business Intelligence Publisher (BIP)
o Oracle Business Intelligence ADF Components (BIADFCOMPS)
o Enterprise Performance Management Components Installed from BI Installer (BIFNDNEPM)
o Oracle Business Intelligence: (BIFNDN)
o Oracle Business Intelligence: (BISERVER):
o Oracle Business Intelligence Platform Client Installers and MapViewer
• The OBIEE 11.1.1.7.140715 suite bundle patch includes more than 52 BISERVER, BIFNDN and BIP bugs fixes since the last suite bundle patch released in May 2014.
