RAC/ASM Clusterware Installation :: Where To Take GI Patch Set Update For Windows
Sep 14, 2012
Where to take and how to find the latest versions of patches GI Patch Set Update for Windows?
For a DB there is article "*ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [ID 880782.1]*". I am signed on notification messages by mail. When article *880782.1* changes, to me the notification message comes. From *880782.1* it is possible to pass in article "*Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms [ID 161549.1]*". Here there are links to the latest versions of patches.
The latest versions for GI Patch Set Update it is possible to look in article "*Oracle Recommended Patches - Oracle Database [ID 756671.1]*" but here is not present Windows platform.
1). Where to take and how to find the latest versions of patches GI Patch Set Update for Windows?
2). Whether It is possible GI Patch Set Update for Windows to find by means of searching on tab MOS "*Patches & Updates*"?
We have 2 servers running Oracle 11gR2 Window server 2008 64 bit RAC. Today I add new shared disk visible from both servers. All our data placed on ASM partitions, but we need Windows volume for exchanging some data between servers & users;Actions:then i have prepare disk on shared storage from 1st node, run diskmfmt.msc & rescan disks when windows recognizes new hdd, initialize it.create an Extended partition & Logical drive & Assign drive letter. from another nodes, make sure no drive letter is assigned.
Sometimes Windows automatically assign drive letter. If drive letter is assigned, right click & Change drive letter & Remove. from 1st node, format this logical drive using ocfsFormat.exe after execute below scripts i have face some issues
E:app11.2.0gridcfs>ocfsformat /m P: /c 1024 /v DATA /f /d /aReg Get Cluster Name(): Reg Query ValueEx for CFS_CLUSTER_NAME failed with error 203
This indicates that the Cluster Name has not been configured on this node for OCFSThe volume formatted in this condition will be seen by all nodes running OCFS.
I am setting up a RAC cluster in Oracle 11.2.0.3 on two Windows 2008R2 nodes.I have completed all the pre-installation tasks would like to verify this by running:cluvfy comp sys -p database -n allusing the standalone download of cluvfy - I haven't installed any Oracle software as yet. This completes successfully on the remote node but fails on the local node (whichever one I run it from).
There is a lot of output but these seem to be the key problems: [1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [WindowsSystem.deleteService:876] _WS_ deleteService2: node PRDAT217 Service OracleRemExecService result: 0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:91] NativeResult: The String obtained is0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:99] The status string is: 0[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:112]
I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.
We're trying to utilize Oracle RAC 11.2. We want to have two servers in our grid. These two server are installed on a VM using Hyper-V software.
common storage for asm is also developed on a VM using FreeNAS software.Now, when we try to install Grid Infrastructure the disk that is recognized as a extra drive in both servers are disabled and we can't select it as ASM storage. The OS we're using is Windows Server 2008 R2.I have to say the IP requirements are considered and the servers have two IPs.
I want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
I encountered problems when installing Oracle 11g. The problem comes from Enterprise Manager. After searching online, I find there is an official solution path patch 8350262 for this. But I cannot find how to download or get that patch.
Am planning to install oracle RAC 11g on linux server. Have doubt on installation of clusterware or grid infrastructure first .?I think grid infrastructure covers clusterware and ASM both and then oracle 11g software to be installed. But how to download grid insfrastructure software. Will it come with oracle 11g software..? or need to download it seperately.? Because when i try to download oracle RAC 11g which gives link to download the 11g software not grid.
I am using Oracle 11g (11.2.0.1.0) and I want to apply January patch on 11.2.0.1.0. I have applied 3 patches. I have single Instance with ASM and Grid.
1. Applied Opatch on grid. unzip p6880880_112000_LINUX.zip -d /opt/grid/11.2.0/grid
2. Validated the Oracle Inventory. /opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/grid/11.2.0/grid
3. Shut down the databases. 4. Run the prepatch script ./9655006/custom/server/9655006/custom/scripts/prepatch.sh 5. Shutdown the ASM. 6. Ran the below command to stop CSS etc. /opt/grid/11.2.0/grid/crs/install/roothas.pl -unlock
8. Applied Opatch on Oracle home 9. Applied Oracle patch /opt/oracle/product/11.2.0/db/OPatch/opatch napply -oh /opt/oracle/product/11.2.0/db -id 10248516
8. Run the postpatch script ./9655006/custom/server/9655006/custom/scripts/postpatch.sh
9. Run the following script to enable CSS etc. /opt/grid/11.2.0/grid/crs/install/roothas.pl -patch /opt/grid/11.2.0/grid/bin/crsctl check has /opt/grid/11.2.0/grid/bin/crsctl check css
10. If CSS is not online ran the below command. /opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1" /opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1" /opt/grid/11.2.0/grid/bin/crsctl stop has /opt/grid/11.2.0/grid/bin/crsctl start has
11. Up the ASM and Databases. Ran the postinstall in GRID and Oracle. @catbundle.sql psu apply
12. Ran the below command on grid and Oracle. /opt/grid/11.2.0/grid/OPatch/opatch lsinventory /opt/oracle/product/11.2.0/db/OPatch/opatch lsinventory
1. Let me know steps which are followed are right because I didnot see the version change after connecting to database? (for example 11.2.0.1.0 after applying I can see 11.2.0.1.4 but not changed the version). How should I know the patch is applied properly?
I read on the oracle site that Windows 8 support will come with Oracle version 11.2.0.4 and higher. Without a maintenance contract I see only 11.2.0.3. What version of Oracle is now the latest, is patch 11.2.0.4 out?
I have installed grid and oracle 11g on linux environment. I want to installation January patch related to grid and oracle 11g. This is the first time i m going to install the oracle 11g.
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
identify the latest Critical Patch Update for 10g RAC. My DB server is 10g RAC 2 node cluster running on IBM Aix Pseries servers. The version is 10.2.0.3.
I am trying to apply patch 16619892 on 11.2.0.3.0 to upgrade it to 11.2.0.3.7.
I hope this is a straight forword stuff i beleive, but i am getting the following errors and log details.
$ cd /noracle/patch/16619892/ xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved.
I need to apply this Critical Patch in my databases but I have a doubt about if the component that I find out in the documentation is the component where the fix has to be applied or doesn't matter and I have to apply this fix on all my installations.
CVE# Component
CVE-2012-1740 - Oracle Application Express Listener CVE-2011-3192 - Apache CVE-2012-1737 - Enterprise Manager for Oracle Database CVE-2012-1745 - The vulnerability affects Microsoft Windows platforms only. CVE-2012-1746 - The vulnerability affects Microsoft Windows platforms only. CVE-2012-1747 - The vulnerability affects Microsoft Windows platforms only. CVE-2012-3134 - The vulnerability affects Microsoft Windows platforms only. CVE-2011-4885 - PHP
I have been working in the installation of oracle 11g r2 in my fedora 17 (32 bits) system for a few days and still have not gotten.Now I found that I need the OPtatch for enable the db console and even being a member of My Oracle Support I can not request the patch for a technical question.
1) Note to the Approver: I am that one because I am an end user (freelance)
I have HP server with Windows 2008 Server R2 64bit. I installed latest 64-bit version of Oracle Database 10.2.0.4 and everything works fine and later installed the patch 10.2.0.5 (64 bits) as the Oracle maintains that with the R2 version of the system it is necessary to correct work.
Now, after uploading the patch database starts and closes after about 15 minutes - an additional log file is changed to the binary version which do not see anything.
how to solve problem? The move to Oracle 11 drops.
This is the link to my alert log file (it's strange after 10.2.0.5 patch installation):
Just to confirm with you if we can apply the October 2011 Critical Patch Update (CPU) to address vulnerabilities covered from CPU 2007 up to CPU 2011?
The PC Server (staging) where patching will be applied is running under Windows Vista have not been patched since it's database creation. This is maintained by our Contractors.
We are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.
Following files are active :
E:oracleproduct10.2.0inoraclient10.dll E:oracleproduct10.2.0inorapls10.dll E:oracleproduct10.2.0inoracommon10.dll E:oracleproduct10.2.0inorageneric10.dll E:oracleproduct10.2.0inoraplp10.dll [code]........ -------------------------------------------------------------------------------- The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ] in the Oracle Home -------------------------------------------------------------------------------- Its not an rac. We stopped all the services running on this server.
I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command
but then it says oplan is not recognized. I have set the Oracle_home and path variable
my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan
Note that my database version is 11.2.0.3 with ASM
Is it possible to upgrade GI 11.2.0.1 Enterprise Edition version to 11.2.0.3 STANDARD EDITION?
We have 2 Node RAC with 10.2 DB SE. Last time I think by mistake or not knowing the licensing information GI was upgraded to EE 11.2.0.1 by somebody or may be whatever version of GI is used, it has nothing to do with the license?
I have heard that I can upgrade Grid Infrastructure, but to Standard Edition. Does GI also comes with SE and also just want to know that can I perform this upgrade?
I want to upgrade (out of place) Grid Infrastructure to latest version of 11.2.0.3 and then PSU on top of that.
GI HOME and DB HOME are separated. Database I want to upgrade later on, not with this clusterware upgrade. I have download p10404530_112030_Linux-x86-64_3of7.zip from MOS for upgrading GI.
grid@db1p [rec]: /home/grid > crsctl query crs softwareversion Oracle Clusterware version on node [db1p] is [11.2.0.1.0] grid@db1p [rec]: /home/grid > crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.1.0]grid@db1px [ec]: /home/grid > sqlplus / as sysasm
[code]....
1) Is this the correct p10404530_112030_Linux-x86-64_3of7.zip to upgrade GI from 11.2.0.1 to 11.2.03?
2) Do I need a COMPLETE DOWNTIME to upgrade GI on 2 node RAC where DB is STANDARD EDITION but Clusterware is 11.2 as you have seen above..
3) Will this ASM version will also be upgraded along with GI upgrade installer or it must be upgrades separately after GI Upgrade?
When I use 'ONSCTL PING' to test the ons status, it says: configure localport and remoteport directives and attempt to start ONS server again.ons is not running.The content of D:app11.2.0gridopmnconfons.config is:
localport=6100 # line added by Agent allowgroup=true usesharedinstall=true remoteport=6200 # line added by Agent nodes=rac1:6200,rac2:6200 # line added by Agent
The content of D:app11.2.0gridopmnconfons.config.rac2 is: localport=6100 # line added by Agent allowgroup=true usesharedinstall=true remoteport=6200 # line added by Agent nodes=rac1:6200,rac2:6200 # line added by Agent
The configuration file is almost the same in rac1.But the output of 'srvctl status nodeapps' is :
ons is enabled ons is running on node1:rac1 ons is running on node2:rac2
I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).