Run Cluster Verification Utility to ensure that everything is fine for upgrade process
D:\Sources\11.2.0.4\grid>runcluvfy.bat stage -pre crsinst -upgrade -n OR-11,OR-11 -rolling -src_crshome D:\app\11.2.0\grid -dest_crshome D:\app\11.2.0.4\grid -dest_version 11.2.0.4.0 -verbose >> d:\temp\fixup\fixup.txt
=================================================
Output d:\temp\fixup\fixup.txt
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "or-11"
Destination Node Reachable?
------------------------------------ ------------------------
or-12 yes
or-11 yes
Result: Node reachability check passed from node "or-11"
Checking user equivalence...
Check: User equivalence for user "farhat"
Node Name Status
------------------------------------ ------------------------
or-12 passed
or-11 passed
Result: User equivalence check passed for user "farhat"
Checking node connectivity...
Interface information for node "or-12"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
public 192.168.1.12 192.168.1.0 On-link UNKNOWN 00:1A:A0:34:91:0A 1500
public 192.168.1.14 192.168.1.0 On-link UNKNOWN 00:1A:A0:34:91:0A 1500
public 192.168.1.65 192.168.1.0 On-link UNKNOWN 00:1A:A0:34:91:0A 1500
private 10.11.11.2 10.11.11.0 On-link UNKNOWN 00:1A:A0:34:91:0C 1500
VMware Network Adapter VMnet1 192.168.253.1 192.168.253.0 On-link UNKNOWN 00:50:56:C0:00:01 1500
VMware Network Adapter VMnet8 192.168.59.1 192.168.59.0 On-link UNKNOWN 00:50:56:C0:00:08 1500
Interface information for node "or-11"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
public 192.168.1.11 192.168.1.0 On-link UNKNOWN 00:1D:09:0C:B4:CD 1500
public 192.168.1.13 192.168.1.0 On-link UNKNOWN 00:1D:09:0C:B4:CD 1500
public 192.168.1.64 192.168.1.0 On-link UNKNOWN 00:1D:09:0C:B4:CD 1500
public 192.168.1.66 192.168.1.0 On-link UNKNOWN 00:1D:09:0C:B4:CD 1500
private 10.11.11.1 10.11.11.0 On-link UNKNOWN 00:1D:09:0C:B4:CF 1500
VirtualBox Host-Only Network 169.254.30.184 169.254.0.0 On-link UNKNOWN 08:00:27:00:D0:E0 1500
Check: Node connectivity for interface "public"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
or-12[192.168.1.12] or-12[192.168.1.14] yes
or-12[192.168.1.12] or-12[192.168.1.65] yes
or-12[192.168.1.12] or-11[192.168.1.11] yes
or-12[192.168.1.12] or-11[192.168.1.13] yes
or-12[192.168.1.12] or-11[192.168.1.64] yes
or-12[192.168.1.12] or-11[192.168.1.66] yes
or-12[192.168.1.14] or-12[192.168.1.65] yes
or-12[192.168.1.14] or-11[192.168.1.11] yes
or-12[192.168.1.14] or-11[192.168.1.13] yes
or-12[192.168.1.14] or-11[192.168.1.64] yes
or-12[192.168.1.14] or-11[192.168.1.66] yes
or-12[192.168.1.65] or-11[192.168.1.11] yes
or-12[192.168.1.65] or-11[192.168.1.13] yes
or-12[192.168.1.65] or-11[192.168.1.64] yes
or-12[192.168.1.65] or-11[192.168.1.66] yes
or-11[192.168.1.11] or-11[192.168.1.13] yes
or-11[192.168.1.11] or-11[192.168.1.64] yes
or-11[192.168.1.11] or-11[192.168.1.66] yes
or-11[192.168.1.13] or-11[192.168.1.64] yes
or-11[192.168.1.13] or-11[192.168.1.66] yes
or-11[192.168.1.64] or-11[192.168.1.66] yes
Result: Node connectivity passed for interface "public"
Check: TCP connectivity of subnet "192.168.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
or-11:192.168.1.11 or-12:192.168.1.12 passed
or-11:192.168.1.11 or-12:192.168.1.14 passed
or-11:192.168.1.11 or-12:192.168.1.65 passed
or-11:192.168.1.11 or-11:192.168.1.13 passed
or-11:192.168.1.11 or-11:192.168.1.64 passed
or-11:192.168.1.11 or-11:192.168.1.66 passed
Result: TCP connectivity check passed for subnet "192.168.1.0"
Check: Node connectivity for interface "private"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
or-12[10.11.11.2] or-11[10.11.11.1] yes
Result: Node connectivity passed for interface "private"
Check: TCP connectivity of subnet "10.11.11.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
or-11:10.11.11.1 or-12:10.11.11.2 passed
Result: TCP connectivity check passed for subnet "10.11.11.0"
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.1.0".
Subnet mask consistency check passed for subnet "10.11.11.0".
Subnet mask consistency check passed.
Result: Node connectivity check passed
Checking multicast communication...
Checking subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0"...
PRVG-11134 : Interface "192.168.1.14" on node "or-12" is not able to communicate with interface "192.168.1.11" on node "or-11"
PRVG-11134 : Interface "192.168.1.14" on node "or-12" is not able to communicate with interface "192.168.1.13" on node "or-11"
PRVG-11134 : Interface "192.168.1.14" on node "or-12" is not able to communicate with interface "192.168.1.64" on node "or-11"
PRVG-11134 : Interface "192.168.1.14" on node "or-12" is not able to communicate with interface "192.168.1.66" on node "or-11"
PRVG-11134 : Interface "192.168.1.65" on node "or-12" is not able to communicate with interface "192.168.1.11" on node "or-11"
PRVG-11134 : Interface "192.168.1.65" on node "or-12" is not able to communicate with interface "192.168.1.13" on node "or-11"
PRVG-11134 : Interface "192.168.1.65" on node "or-12" is not able to communicate with interface "192.168.1.64" on node "or-11"
PRVG-11134 : Interface "192.168.1.65" on node "or-12" is not able to communicate with interface "192.168.1.66" on node "or-11"
PRVG-11134 : Interface "192.168.1.11" on node "or-11" is not able to communicate with interface "192.168.1.12" on node "or-12"
PRVG-11134 : Interface "192.168.1.11" on node "or-11" is not able to communicate with interface "192.168.1.14" on node "or-12"
PRVG-11134 : Interface "192.168.1.11" on node "or-11" is not able to communicate with interface "192.168.1.65" on node "or-12"
PRVG-11134 : Interface "192.168.1.13" on node "or-11" is not able to communicate with interface "192.168.1.12" on node "or-12"
PRVG-11134 : Interface "192.168.1.13" on node "or-11" is not able to communicate with interface "192.168.1.14" on node "or-12"
PRVG-11134 : Interface "192.168.1.13" on node "or-11" is not able to communicate with interface "192.168.1.65" on node "or-12"
PRVG-11134 : Interface "192.168.1.64" on node "or-11" is not able to communicate with interface "192.168.1.12" on node "or-12"
PRVG-11134 : Interface "192.168.1.64" on node "or-11" is not able to communicate with interface "192.168.1.14" on node "or-12"
PRVG-11134 : Interface "192.168.1.64" on node "or-11" is not able to communicate with interface "192.168.1.65" on node "or-12"
PRVG-11134 : Interface "192.168.1.66" on node "or-11" is not able to communicate with interface "192.168.1.12" on node "or-12"
PRVG-11134 : Interface "192.168.1.66" on node "or-11" is not able to communicate with interface "192.168.1.14" on node "or-12"
PRVG-11134 : Interface "192.168.1.66" on node "or-11" is not able to communicate with interface "192.168.1.65" on node "or-12"
Checking subnet "192.168.1.0" for multicast communication with multicast group "224.0.0.251"...
Check of subnet "192.168.1.0" for multicast communication with multicast group "224.0.0.251" passed.
Checking subnet "10.11.11.0" for multicast communication with multicast group "230.0.1.0"...
PRVG-11134 : Interface "10.11.11.1" on node "or-11" is not able to communicate with interface "10.11.11.2" on node "or-12"
Checking subnet "10.11.11.0" for multicast communication with multicast group "224.0.0.251"...
Check of subnet "10.11.11.0" for multicast communication with multicast group "224.0.0.251" passed.
Check of multicast communication passed.
Checking the status of Windows firewall
Node Name Enabled? Comment
------------ ------------------------ ------------------------
or-12 no passed
or-11 no passed
Result: Windows firewall verification check passed
Checking OCR integrity...
OCR integrity check passed
Check: Total memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
or-12 15.9951GB (1.6772032E7KB) 922MB (944128.0KB) passed
or-11 15.9951GB (1.6772032E7KB) 922MB (944128.0KB) passed
Result: Total memory check passed
Check: Available memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
or-12 10.8619GB (1.1389492E7KB) 50MB (51200.0KB) passed
or-11 9.8306GB (1.030812E7KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
or-12 31.9883GB (3.3542208E7KB) 15.9951GB (1.6772032E7KB) passed
or-11 31.9883GB (3.3542208E7KB) 15.9951GB (1.6772032E7KB) passed
Result: Swap space check passed
Check: Free disk space for "or-12:D:\app\11.2.0.4\grid"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
D:\app\11.2.0.4\grid or-12 D 257.0327GB 4.5GB passed
Result: Free disk space check passed for "or-12:D:\app\11.2.0.4\grid"
Check: Free disk space for "or-11:D:\app\11.2.0.4\grid"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
D:\app\11.2.0.4\grid or-11 D 132.5272GB 4.5GB passed
Result: Free disk space check passed for "or-11:D:\app\11.2.0.4\grid"
Check: Free disk space for "or-12:C:\Windows\temp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
C:\Windows\temp or-12 C 18.3252GB 1GB passed
Result: Free disk space check passed for "or-12:C:\Windows\temp"
Check: Free disk space for "or-11:C:\Windows\temp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
C:\Windows\temp or-11 C 18.8738GB 1GB passed
Result: Free disk space check passed for "or-11:C:\Windows\temp"
There are no oracle patches required for home "D:\app\11.2.0\grid".
There are no oracle patches required for home "D:\app\11.2.0.4\grid".
Check: System architecture
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
or-12 64-bit 64-bit passed
or-11 64-bit 64-bit passed
Result: System architecture check passed
Checking length of value of environment variable "PATH"
Check: Length of value of environment variable "PATH"
Node Name Set? Maximum Length Actual Length Comment
---------------- ------------ ------------ ------------ ----------------
or-12 yes 5119 552 passed
or-11 yes 5119 31 passed
Result: Check for length of value of environment variable "PATH" passed.
Checking for Media Sensing status of TCP/IP
Node Name Enabled? Comment
------------ ------------------------ ------------------------
or-12 no passed
or-11 no passed
Result: Media Sensing status of TCP/IP check passed
Starting Clock synchronization checks using Network Time Protocol(NTP)...
Checking daemon liveness...
Check: Liveness for "W32Time"
Node Name Running?
------------------------------------ ------------------------
or-12 yes
or-11 yes
Result: Liveness check passed for "W32Time"
Check for NTP daemon or service alive passed on all nodes
Result: Clock synchronization check using Network Time Protocol(NTP) passed
Checking if current user is a domain user...
Check: If user "farhat" is a domain user
Result: User "farhat" is a part of the domain "testdomain"
Check: Time zone consistency
Result: Time zone consistency check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.
Checking Oracle Cluster Voting Disk configuration...
ASM Running check passed. ASM is running on all specified nodes
Oracle Cluster Voting Disk configuration check passed
Clusterware version consistency passed
Checking for status of Automount feature
Node Name Enabled? Comment
------------ ------------------------ ------------------------
or-12 yes passed
or-11 yes passed
Result: Check for status of Automount feature passed
Pre-check for cluster services setup was successful.
=================================================
Stop enterprise manager dbconsole
D:\>set oracle_unqname=fintest
D:\>emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://OR-11.localdomain.com:1158/em/console/aboutApplication
The OracleDBConsolefintest service is stopping.........
The OracleDBConsolefintest service was stopped successfully.
------------------------------------------------------------
While installing Patchset setup will stop cluster services and associate with new home bineries and restart. You must stop windows Windows Management Instrumentation Service and check in process explorer, if any process for this service is running kill it and stop above service.
This service acquires a lock on following files under folder C:\WINDOWS\system32\drivers
oracleacfs.sys
oracleadvm.sys
oracleoks.sys
------------------------------------------------------------
Unset ORACLE environments from Windows Path
My Computer > Properties > Advanced > Environment Veriables > System Veriable > Path
Delete Oracle Homes from Path Veriable
Start Setup and install Oracle Grid Infrastructure in a new Grid Home
old home
D:\app\grid\11.2.0
New Grid Home
D:\app\grid\11.2.0.4
If you already have followed above instructions, hopefully this process should complete successfully.
After successfull upgrade
Deinstall Old Home
Deinstall old home by running deinstall script
d:\app\11.2.0\grid\deinstall\deinstall
Note: (Run it from root of D drive otherwise directories will not be properly deleted if you are into these directories)
Deinstall script will delete old home,registry entries and services from both nodes
-----------------------------------------------------------
Upgrade Database.
Install Oracle Database under a new home (Different from old one)
Just Software Installation.
Old Home
D:\app\Oracle\product\11.2.0.3\dbhome_1
Install Database in new home
D:\app\Oracle\product\11.2.0.4\dbhome_1
-------------------------------------------------------------------------------------------
Run database upgrade assistant from Newly installed home
D:\app\Oracle\product\11.2.0.4\dbhome_1
No comments:
Post a Comment