Download patch p21103263_111170_Linux-x86-64.zip from My Oracle Support website.
2. Transfer patch to staging area in destination
server
[oracle@obieesvr001 obiee_11117]$ cd /installers/oracle/obiee_11117
[oracle@obieesvr001 obiee_11117]$ cd /installers/oracle/obiee_11117
3. Unzip the patch
3 (A) Unzip the main patch zip file.
[oracle@obieesvr001 obiee_11117]$ cd 21103263/
3 (A) Unzip the main patch zip file.
[oracle@obieesvr001 obiee_11117]$ cd
/installers/oracle/obiee_11117
[oracle@obieesvr001 obiee_11117]$ unzip
p21103263_111170_Linux-x86-64.zip
3 (B) Unzip individual patches:
[oracle@obieesvr001 obiee_11117]$ cd 21103263/
[oracle@obieesvr001 21103263]$ ls
p16913445_111170_Generic.zip p19823874_111170_Generic.zip
p16997936_111170_Generic.zip p19825503_111170_Linux-x86-64.zip
p19822826_111170_Linux-x86-64.zip p20022695_111170_Generic.zip
p19822857_111170_Linux-x86-64.zip p21235729_111170_Generic.zip
p19822893_111170_Generic.zip README.htm
[oracle@obieesvr001 21103263]$
[oracle@obieesvr001 21103263]$ unzip
p16913445_111170_Generic.zip
[oracle@obieesvr001 21103263]$ unzip
p19823874_111170_Generic.zip
[oracle@obieesvr001 21103263]$ unzip p16997936_111170_Generic.zip
[oracle@obieesvr001 21103263]$ unzip
p19825503_111170_Linux-x86-64.zip
[oracle@obieesvr001 21103263]$ unzip
p19822826_111170_Linux-x86-64.zip
[oracle@obieesvr001 21103263]$ unzip
p20022695_111170_Generic.zip
[oracle@obieesvr001 21103263]$ unzip
p19822857_111170_Linux-x86-64.zip
[oracle@obieesvr001 21103263]$ unzip
p21235729_111170_Generic.zip
[oracle@obieesvr001 21103263]$ unzip
p19822893_111170_Generic.zip
4. Copy unzipped files to $ORACLE_HOME/21103263
Before copying the
unzipped files remove the individual zip files so that the size is smaller.
[oracle@obieesvr001 21103263]$ pwd
/installers/oracle/obiee_11117/21103263
[oracle@obieesvr001 21103263]$
[oracle@obieesvr001 21103263]$ rm -Rf p1*_111170*.zip
[oracle@obieesvr001 21103263]$ cd ..
[oracle@obieesvr001 obiee_11117]$ cp -R 21103263 $ORACLE_HOME/
5. Set environment variable
[oracle@obieesvr001 scripts]$ more OBIEE_env.sh
###Script Written By:Ashish Man Baisyet
###Date : 2015-APR-16
###Purpose: To set OBIEE shell environments.
MW_HOME=/u02/app/oracle/Middleware; export MW_HOME
DOMAIN_HOME=/$MW_HOME/user_projects/domains/bifoundation_domain; export DOMAIN_HOME
WL_HOME=$MW_HOME/wlserver_10.3; export WL_HOME
ORACLE_HOME=$MW_HOME/Oracle_BI1; export ORACLE_HOME
ORACLE_INSTANCE=$MW_HOME/instances/OBIEEInst1; export ORACLE_INSTANCE
export PATCH_TOP=/installers/oracle/obiee_11117
#
# You may also want to set your PATH environment to avoid having to use
# paths in the commands
#
PATH=$WL_HOME/server/bin:$DOMAIN_HOME/bin:$ORACLE_INSTANCE/bin:$ORACLE_HOME/OPatch:$PATH; export PATH
[oracle@obieesvr001 scripts]$
6. Perform prerequisite checks
Based on My Oracle Support document OBIEE
11g: Required and Recommended Bundle Patches and Patch Sets (Doc ID 1488475.1)
following are the patches bundled in Patch 21103263 version 11.1.1.7.150714.
- Patch 16913445 - Patch 11.1.1.7.150714 (1 of 9) Oracle Business Intelligence Installer (BIINST)
- Patch 19822893 - Patch 11.1.1.7.150714 (2 of 9) Oracle Business Intelligence Publisher (BIP)
- Patch 19825503 - Patch 11.1.1.7.150714 (3 of 9) Enterprise Performance Management Components Installed from BIInstaller 11.1.1.7.0 (BIFNDNEPM)
- Patch 19822857 - Patch 11.1.1.7.150714 (4 of 9) Oracle Business Intelligence Server (BISERVER)
- Patch 19822826 - Patch 11.1.1.7.150714 (5 of 9) Oracle Business Intelligence Presentation Services (BIPS)
- Patch 19823874 - Patch 11.1.1.7.150714 (6 of 9) Oracle Real-Time Decisions (RTD)
- Patch 16997936 - Patch 11.1.1.7.150714 (7 of 9) Oracle Business Intelligence ADF Components (BIADFCOMPS)
- Patch 20022695 - Patch 11.1.1.7.150714 (8 of 9) Oracle Business Intelligence Platform Client Installers and MapViewer
- Patch 21235729 - Patch 11.1.1.7.150714 (9 of 9) Oracle Business Intelligence Third Party
[oracle@obieesvr001
21103263]$ pwd
/u02/app/oracle/Middleware/Oracle_BI1/21103263
[oracle@obieesvr001
21103263]$
[oracle@obieesvr001
21103263]$ cd 16913445
[oracle@obieesvr001
16913445]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_16913445.log
[oracle@obieesvr001
16913445]$
[oracle@obieesvr001
16913445]$ cd ../19822893
[oracle@obieesvr001
19822893]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ > $HOME/scripts/log/opatch_apply_prereq_19822893.log
[oracle@obieesvr001
19822893]$
[oracle@obieesvr001
19822893]$ cd ../19825503
[oracle@obieesvr001
19825503]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_19825503.log
[oracle@obieesvr001
19825503]$
[oracle@obieesvr001
19825503]$ cd ../19822857
[oracle@obieesvr001
19822857]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_19822857.log
[oracle@obieesvr001
19822857]$
[oracle@obieesvr001
19822857]$ cd ../19822826
[oracle@obieesvr001
19822826]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_19822826.log
[oracle@obieesvr001
19822826]$
[oracle@obieesvr001
19822826]$ cd ../19823874
[oracle@obieesvr001
19823874]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_19823874.log
[oracle@obieesvr001
19822826]$
[oracle@obieesvr001
19823874]$ cd ../16997936
[oracle@obieesvr001
16997936]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_16997936.log
[oracle@obieesvr001
19823874]$
[oracle@obieesvr001
16997936]$ cd ../20022695
[oracle@obieesvr001
20022695]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_20022695.log
[oracle@obieesvr001
20022695]$
[oracle@obieesvr001
20022695]$ cd ../21235729
[oracle@obieesvr001 21235729]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./ >
$HOME/scripts/log/opatch_apply_prereq_21235729.log
7. Stop the services
Execute OBIEE_env.sh environment script to set the environment variables related to OBIEE.
[oracle@obieesvr001 scripts]$ pwd
/home/oracle/scripts
[oracle@obieesvr001 scripts]$
[oracle@obieesvr001 scripts]$ . ./OBIEE_env.sh
[oracle@obieesvr001 scripts]$
[oracle@obieesvr001 scripts]$ $DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1
[oracle@obieesvr001 scripts]$ $DOMAIN_HOME/bin/stopWebLogic.sh
[oracle@obieesvr001 scripts]$ $ORACLE_INSTANCE/bin/opmnctl status
Processes in Instance: OBIEEInst1
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
essbasestudio1 | EssbaseStudio | 966 | Alive
essbaseserver1 | Essbase | 965 | Alive
coreapplication_obiccs1 | OracleBIClusterCo~ | 963 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 961 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 964 | Alive
coreapplication_obips1 | OracleBIPresentat~ | 962 | Alive
coreapplication_obis1 | OracleBIServerCom~ | 960 | Alive
[oracle@obieesvr001 scripts]$
Execute OBIEE_env.sh environment script to set the environment variables related to OBIEE.
[oracle@obieesvr001 scripts]$ pwd
/home/oracle/scripts
[oracle@obieesvr001 scripts]$
[oracle@obieesvr001 scripts]$ . ./OBIEE_env.sh
[oracle@obieesvr001 scripts]$
[oracle@obieesvr001 scripts]$ $DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1
[oracle@obieesvr001 scripts]$ $DOMAIN_HOME/bin/stopWebLogic.sh
[oracle@obieesvr001 scripts]$ $ORACLE_INSTANCE/bin/opmnctl status
Processes in Instance: OBIEEInst1
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
essbasestudio1 | EssbaseStudio | 966 | Alive
essbaseserver1 | Essbase | 965 | Alive
coreapplication_obiccs1 | OracleBIClusterCo~ | 963 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 961 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 964 | Alive
coreapplication_obips1 | OracleBIPresentat~ | 962 | Alive
coreapplication_obis1 | OracleBIServerCom~ | 960 | Alive
[oracle@obieesvr001 scripts]$
[oracle@obieesvr001 scripts]$ $ORACLE_INSTANCE/bin/opmnctl stopall
8. Patch installation
i)
Install all patches with single command
[oracle@obieesvr001 obiee_11117]$ cd $ORACLE_HOME/21103263
[oracle@obieesvr001 21103263]$ ls
16913445 19822826 19822893
19825503 21235729
16997936 19822857 19823874
20022695 README.htm
[oracle@obieesvr001 21103263]$
[oracle@obieesvr001 21103263]$ opatch napply -skip_duplicate
> $HOME/scripts/log/opatch_napply_21103263.log
ii)
Install patches one at a time
[oracle@obieesvr001 obiee_11117]$ cd $ORACLE_HOME/21103263
[oracle@obieesvr001 21103263]$ ls
16913445 19822826 19822893
19825503 21235729
16997936 19822857 19823874
20022695 README.htm
[oracle@obieesvr001 21103263]$
[oracle@obieesvr001 21103263]$ cd $ORACLE_HOME/21103263/16913445
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_16913445.log
[oracle@obieesvr001 20022695]$ cd ../19822893
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_19822893.log
[oracle@obieesvr001 20022695]$ cd ../19825503
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_19825503.log
[oracle@obieesvr001 20022695]$ cd ../19822857
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_19822857.log
[oracle@obieesvr001 20022695]$ cd ../19822826
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_19822826.log
[oracle@obieesvr001 20022695]$ cd ../19823874
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_19823874.log
[oracle@obieesvr001 20022695]$ cd ../16997936
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_16997936.log
[oracle@obieesvr001 20022695]$ cd ../20022695
[oracle@obieesvr001 20022695]$ opatch apply > $HOME/scripts/log/opatch_apply_20022695.log
[oracle@obieesvr001 20022695]$ cd ../21235729
[oracle@obieesvr001 20022695]$ opatch apply >
$HOME/scripts/log/opatch_apply_21235729.log
9. Start OBIEE Services
[oracle@obieesvr001 scripts]$ $DOMAIN_HOME/bin/startWebLogic.sh
[oracle@obieesvr001 scripts]$ $DOMAIN_HOME/bin/startManagedWebLogic.sh
bi_server1
[oracle@obieesvr001 scripts]$ $ORACLE_INSTANCE/bin/opmnctl
startall
[oracle@obieesvr001 scripts]$ $ORACLE_INSTANCE/bin/opmnctl
status
Processes in Instance: OBIEEInst1
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
essbasestudio1 | EssbaseStudio |
966 | Alive
essbaseserver1 | Essbase | 965 | Alive
coreapplication_obiccs1 | OracleBIClusterCo~ | 963 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 961 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 964 | Alive
coreapplication_obips1 | OracleBIPresentat~ | 962 | Alive
coreapplication_obis1
| OracleBIServerCom~ | 960 |
Alive
[oracle@obieesvr001 scripts]$
10. OBIEE
Version after patching
Bundlepatches
11.1.1.7.150714 is identical to 11.1.1.7.150120, just has some additional
security fixes in it. Hence on application it shows still 11.1.1.7.150120
Hope this helps.
Hope this helps.
No comments:
Post a Comment