Oracle Database - Enterprise Edition - Applying Patch 21800477: QUARTERLY DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)
Note steps below are for patching DB Home only. Please review the relevant Patch README file for patching only Grid Infrastructure (GI) home or GI home and DB home together.
- Download Patch 21800477 (p21800477_112040_Linux-x86-64.zip) and copy onto server staging area say PATCH_TOP with appropriate permissions.
Apply latest OPatch Patch
- Check opatch version
$ORACLE_HOME/OPatch/opatch version
- You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch.
Apply latest OPatch Patch - on all nodes.
cd $ORACLE_HOME
mv OPatch OPatch_<ddmmyy>
unzip /sid/PATCH_TOP/p6880880_112000_Linux-x86-64.zip
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch version
OCM Configuration:
OPatch utility will prompt for your OCM (Oracle Configuration Manager) response file (ocm.rsp) when it is run. Provide ocm.rsp path if it exists or if not create
it by running following command:
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp
- Unzipped patch location must have read permission for ORA_INSTALL group of user who owns GI Home or group owner of Oracle central inventory.
- cd /sid/PATCH_TOP
$ unzip p21800477_112040_Linux-x86-64.zip
- cd /sid/PATCH_TOP/21800477
Validate Oracle Inventory on Grid Infrastructure Home and DB Home
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Save the output of opatch lsinventory to compare the output later in case there are post patching issues and rollback is needed.
OPatch Conflict Check
Determine whether any currently installed one-off patches conflict with the Database Patch For Exadata (OCT2015 - 11.2.0.4.20) 21800477 as follows:
For Grid Infrastructure Home, as home user (skip this step if applying patch on DB home only):
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /sid/PATCH_TOP/21800477/21761335
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /sid/PATCH_TOP/21800477/21352649
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /sid/PATCH_TOP/21800477/21352642
For Database home, as home user:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /sid/PATCH_TOP/21800477/21761335
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /sid/PATCH_TOP/21800477/21352649/custom/server/21352649
This report will indicate the patches that conflict with 21800477 and patches for which patch 21800477 is a superset.
Run OPatch SystemSpace Check
Check if enough free space is available on the ORACLE_HOME filesystem for the patches to be applied as given below:
For Grid Infrastructure Home, as home user (skip this step if applying patch on DB home only):
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /sid/PATCH_TOP/21800477/21761335
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /sid/PATCH_TOP/21800477/21352649
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /sid/PATCH_TOP/21800477/21352642
For Database home, as home user:
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /sid/PATCH_TOP/21800477/21761335
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /sid/PATCH_TOP/21800477/21352649/custom/server/21352649
- Stop DB services - on all nodes
$ORACLE_HOME/bin/srvctl stop home -o $ORACLE_HOME -s /tmp/$ORACLE_SID.txt -n <hostname>
Stop DB Console
$ORACLE_HOME/bin/emctl stop dbconsole
Apply following RDBMS patches
- 21761335: DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)
- 21352649: OCW Patch Set Update : 11.2.0.4.7
Pre patch step (all DB nodes)
$ /sid/PATCH_TOP/21800477/21352649/custom/server/21352649/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
Apply patch 21761335 (all DB nodes)
$ opatch napply -oh $ORACLE_HOME -local /sid/PATCH_TOP/21800477/21761335
Apply patch 21352649 (all DB nodes)
$ opatch napply -oh $ORACLE_HOME -local /sid/PATCH_TOP/21800477/21352649/custom/server/21352649
Patches [ 20420937 ] will be rolled back
Post patch step (all DB nodes)
/sid/PATCH_TOP/21800477/21352649/custom/server/21352649/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
- Start DB services
$ORACLE_HOME/bin/srvctl start home -o $ORACLE_HOME -s /tmp/$ORACLE_SID.txt -n <hostname> (all DB nodes)
Patch postinstallation (one node only)
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> connect / as sysdba
SQL> @catbundle.sql exa apply
SQL> @utlrp.sql
SQL> exit
Verify patch application
opatch lsinv -oh $ORACLE_HOME |egrep '21761335|21352649'
Start Mid-Tier services
Rollback patch
- cd $ORACLE_HOME
- Stop DB services - on all nodes
$ORACLE_HOME/bin/srvctl stop home -o $ORACLE_HOME -s /tmp/$ORACLE_SID.txt -n <hostname>
Stop DB Console
$ORACLE_HOME/bin/emctl stop dbconsole
- Rollback patch 21761335 - all nodes
- Rollback patch 21352649 - all nodes
- Start DB services - all nodes
Post patch rollback:
- cd $ORACLE_HOME
SQL> connect / as sysdba
SQL> @rdbms/admin/catbundle_EXA_<database SID>_ROLLBACK.sql
- Validate Oracle Inventory on Grid Infrastructure Home and DB Home
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Re-apply any patches that are missing in the Oracle Inventory after patch roll back.#
- Start Mid-Tier services
Related Posts:
Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
Showing posts with label Exadata. Show all posts
Showing posts with label Exadata. Show all posts
Saturday, 31 October 2015
Friday, 29 May 2015
Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
- Login to server as proper OS user.
- cd to stage area where the patch is copied.
Check for conflicts:
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Checks System Space
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
Applying the patches:
- Shutdown the services (Cold backup recommended before patching)
- Apply patch using the below steps
export ORACLE_HOME=/instance_name/oracle/product/112;
echo $ORACLE_HOME
Run prepatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
Apply patch
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17747140
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17992671/custom/server/17992671
Run postpatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
- Start services after applying the patches
- Execute catbundle.sql only on one node
sqlplus / as sysdba
@?/rdbms/admin/catbundle.sql exa apply
Verify if patches applied successfully.
=======================================
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17747140
Patch 17747140 : applied on date_timestamp
Patch description: "QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) :
(17747140)"
[orinstance_name@localhost ~]$
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17992671
Patch 17992671 : applied on date_timestamp
Patch description: "QUARTERLY CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
(17992671)"
[orinstance_name@localhost ~]$
Related Posts:
Oracle Database - Enterprise Edition - Applying Patch 21800477: QUARTERLY DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)
- Login to server as proper OS user.
- cd to stage area where the patch is copied.
Check for conflicts:
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Checks System Space
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
Applying the patches:
- Shutdown the services (Cold backup recommended before patching)
- Apply patch using the below steps
export ORACLE_HOME=/instance_name/oracle/product/112;
echo $ORACLE_HOME
Run prepatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
Apply patch
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17747140
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17992671/custom/server/17992671
Run postpatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
- Start services after applying the patches
- Execute catbundle.sql only on one node
sqlplus / as sysdba
@?/rdbms/admin/catbundle.sql exa apply
Verify if patches applied successfully.
=======================================
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17747140
Patch 17747140 : applied on date_timestamp
Patch description: "QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) :
(17747140)"
[orinstance_name@localhost ~]$
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17992671
Patch 17992671 : applied on date_timestamp
Patch description: "QUARTERLY CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
(17992671)"
[orinstance_name@localhost ~]$
Related Posts:
Oracle Database - Enterprise Edition - Applying Patch 21800477: QUARTERLY DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)
Thursday, 14 May 2015
[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
[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
Subscribe to:
Posts (Atom)