Oracle Database Appliance ODA Marcels Blog. On 2. 3 july 2. 01. ODA bundle patch 2. As with each new bundle patch, in this version the patch process is getting more robust and the long awaited support for rolling upgrade of the Grid Infrastructure and RAC databases is implemented. Unfortunately the installation of the infrastructure part still requires downtime of the complete cluster stack and rebooting of both nodes although you can skip the reboot part of the infra patch and reboot the nodes at a more convenient time. At the beginning I was very surprised how well this new bundle patch installed on one of our test ODAs. It installed without any problems and in a couple of hours I brought this ODA from 2. Grid and 2. 2. 0. Unfortunately after this successfull installation and upgrade of 7 test databases, on the second ODA I patched after that, the first node crashed during patching of the 2. JDBMS_FILESYSTEM_2.png' alt='How To Install Utl_File Package In Oracle' title='How To Install Utl_File Package In Oracle' />After cleanup and restarting I was able to fix this ODA, but while patching the third ODA, the second node crashed during the installation of the 2. Unfortunately cleanup and restarting the patch didnt help. On this ODA I now have 1 node with an old BIOS version and even worse, the first node having an applied core configuration key, but on the second node OAK doesnt know anymore about this applied core configuration key on the first node. How To Install Utl_File Package In Oracle' title='How To Install Utl_File Package In Oracle' />Solution for the coreconfigkey problem run the oakcli apply coreconfigkey lt key file again on the second node. After the reboot it will only reboot the second node OAK knows about the key again. My guess is that the problem lies in the combination of the usage of core configuration keys and the BIOS upgrade that is done during the installation of the infra componentphase of the 2. At the moment I have an SR opened with Oracle Support and I cant patch my other ODAs until the problem is solved. Although I have problems with the installation of bundle patch 2. I will describe the patching process here, to get some idea of how long things take and what questions you can expect. Patch installation component infra. The first component that needs to be patched is the infra component that for bundle patch 2. BIOS, ILOM, SAS disks and of course a new version of OAK. You want to run a query or two against an Oracle database. You want to get the data back into a userfriendly and consumable format, such as a comma separated values. Weak and default passwords is still problem No. Oracle databases. Even if Oracle default accounts like SYS, SYSTEM. This document explains the full set of steps that need to be taken in order to perform a complete and working installation. ASSUMPTIONS PREREQUISITES. How To Install Utl_File Package In Oracle' title='How To Install Utl_File Package In Oracle' />Oraclevalidated RPM, simplify install of Oracle Oracle. Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video. Register this procedure as a concurrent program so that this program can be run from Oracle Applications which will email a concurrent programs output. As mentioned, the installation of the infra component requires downtime of the complete cluster the complete Grid Infrastructure will be shutdown. Mandatory requirements before installing the 2. Copy the zipfile containing the 2. Linux x. 86 6. 4. Forge Minecraft 1.4 7 on this page. BOTH nodes of the ODAUnpack this patch using the oakcli unpack package command on BOTH nodes of the ODAYou need the passwords just sudo isnt enough for OS user root. After that start the installation of the infra component using the command run as user root oakcli update patch 2. It will take around 4. ODA nodes are rebooted and the complete CRS stack and databases are up and running again time may differ a little depending on the number of databases. Also make sure to do the checks mentioned in the 2. BOTH NODES run as user root dmidecode t 1 grep Serial Number. A5 CONTROLLERFor the dmidecode command, the serial number of your ODA should be returned on both nodes. For the fwupdate command the output should contain a value in the BIOS version column for controllers c. If any of these checks fail, reboot the node and check again. Patch installation component GIAs of ODA bundle patch 2. PSU the Grid Infrastructure requires is done in a rolling fashion. So unlike the infra component all RAC databases will be available during the patch process. The process will first patch the Grid Infra environment on ODA node 1 SC0 and when it is finished and all instances are started again, it will start patching the Grid Infrastructure on ODA node 2 SC1. Requirements before installing the 2. GI component You need the passwords just sudo isnt enough for OS users root and grid. After that start the installation of the gi component using the command run as user root oakcli update patch 2. It will take around 3. Grid Infrastructure patch to complete and as mentioned doesnt require downtime for RAC databases. Patch installation creating 1. Because I didnt have my ODAs running on ODA version 2. RAC databases, I had to install mandatory parts of this bundle patch first to be able to install the 2. I decided to only install the infra and GI component of the 2. ODA 2. 1. 0. 3. 1 to 1. ODA 2. 3. 0. 0. 0. Using the database upgrade functionality of ODA 2. ODA 2. 2 that databases with a databases name containing capitals couldnt get upgraded. Requirements for creating an Oracle home 1. You need the passwords just sudo isnt enough for OS users root and oracle. You need the password for user SYS on the ASM instances. To create a new 1. Oracle database home use the following command run as user root create dbhome version 1. It takes around 6 minutes to create this new Oracle home. Download Wifi Hotspot For Bb 8520. Patch installation upgrading databases. After creating the new 1. Oracle home for databases I upgraded all databases running Oracle 1. Oracle 1. 1. 2. 0. Requirements for upgrading databases using the oakcli upgrade database command You need the passwords just sudo isnt enough for OS users root and oracle. A list of all available dbhomes. Use the command oakcli show dbhomes. A list of all available databases. Use the command oakcli show databases. To upgrade 1 database use the following command run as user root oakcli upgrade database db lt dbname to lt destination home name. Ora. Db. 11. 20. 3home. To upgrade all databases running from one Oracle home serial process run as user root oakcli upgrade database from lt source home name to lt destination home name. Ora. Db. 11. 20. 3home. The databases gets upgraded by oakcli using the DBUA in the background. The logfiles of the upgrade process can be found under the directory structure u.