Label:PSU Upgrade (This experiment is to upgrade 10.2.0.3.12 to 10.2.0.3.15) First, unpack the installation packageCustom storage Path is/home/oracle/yjb/psu/10.2.0.3.15cd/home/oracle/yjb/psu/10.2.0.3.15Unzip P6880880_112000_04-sep-2015_linux-x86-64.zipUnzip p20760997_112030_15_linux-x86-64.zip-d 1120315 Second, check the PSU patch to see if there is a conflict/h
11.2.0.4.5 to your own virtual machine last week. 6 of the PSU did not expect me in a node to the previous Opatch backup directory to delete, the results will not be patched. Remember, $grid_home and $oracle_home . Patch_storage directory can never be deleted, otherwise it will not be patched. Today there is time, want to toss a bit, check the next, fortunately 2 nodes did not delete the directory, SCP came, nothing modified, direct opatch success, he
Tags: Oracle PSUFirst, the preparatory work1, database environmentOperating system version: Redhat 6.5 x64Database version: Oracle 11.2.0.4 x64Oracle database:11.2.0.42, Prepare contentOpatch:p6880880_112000_linux-x86-64.zipDB Psu:p21352635_112040_linux-x86-64.zip is used only for single instance.Opatch:Https://updates.oracle.com/download/6880880.htmlDescription: GI PSU includes DB psu,cpu.Second, update th
[Oracle] PSU upgrade processThe following is the content in the PSU's readme file: 3.2 Patch Installation InstructionsFollow these steps:If you are using a Data Guard Physical Standby database, you must install this patch on both the primary database and the physical standby database, as described by My Oracle Support Note 278641.1.Do one of the following, depending on whether this is a RAC environment:
If this is a RAC environment, choose one of the
Oracle 11gR2 RAC 11.2.0.4 fully automated 11.2.0.4.20170418 psu steps,
(The environment of patch p6880880_112000_Linux-x86-64.zip and p25476126_112040_Linux-x86-64.zip are put in/soft directory,
Grid and oracle users have read and write permissions on the/soft directory, and only the root user can perform the whole process.
Database Version
11.2.0.4
PSU
11.2.0.4.20170418
G
1, first download the required PSU package P6880880_112000_linux-x86-64.zipPatch Package: P19121551_112040_linux-x86-64-psu4.zip2, decompression p6880880_112000_linux-x86-64.zip to the $oracle_home directory, the original backupUnzip-n p6880880_112000_linux-x86-64.zip-d $ORACLE _home3. View version number[Email protected] opatch]$./opatch versionOpatch version:11.2.0.3.6Opatch succeeded.To see if you are hitting the
Summary of oracle psu upgrade, oraclepsu SummaryFirst, go to psu. first, let's take a look at readme.html. From this, we can know the detailed upgrade steps that have been rolled back. And avoids many pitfalls.Before executing the PSU, you must first confirm the version you are about to upgrade and the version of your own system database. Just like this time, we
Reference Document 278641.10. BackupSPFile of the Master and Standby libraryBacking up data from the main library1. Pause the log transfer to the standby library on the main libraryAlter system set Log_archive_dest_state_x=defer scope=both sid= ' * '2. Turn off the standby and the standby to monitor the PSU; do not need to execute catpatch/catbundle/catcpu these scripts; after patching, boot the repository to mount State and start the standby monitor(
Applying GI PSU using "Opatch Auto" fails with "the Opatch Component check failed" (document ID 1169036.1)
Applies to:oracle database-enterprise edition-version 11.2.0.3 and laterInformation in this document applies to any platform.Checked for relevance on 11-mar-2013***SymptomsApplying Grid Infrastructure PSU using "Opatch Auto" fails with "the Opatch Component check failed" For example:11.2.0
Oracle 11g update PSU detailed steps
Oracle releases the latest patches every quarter. For production O M personnel, regular system upgrade and patching are indispensable in daily work.
Compared with the previous versions, Oracle patching has become relatively simple, and the method for processing PSU has also changed. In the 11g environment, we can use the OPatch tool to fix minor bugs. For major version
Oracle 12.1.0.1 GI + DATABASE hitting PSU12.1.0.1 Patch Set Update 12.1.0.1.9 (Oct2015) machine: Two OLE6.5 machines, and the RAC preparation of 12.1.0.1 installed: Download The p6880880_121010_Linux-x86-64 (OPATCH Toolkit ), p21551666_121010_Linux-x86-64 (PSU for GI and DATABASE) implementation process: first upgrade the GI software OPATCH tool su-grid -- My p6880880_121010_Linux-x86-64 is placed under the/u01/app/opatch/directory cd/u01/app/opatch/u
Create the PSU 11.2.0.3.8 and then create the database.
SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. SQL> select created from v $ database; CREATED --------------------------------------- ---------------------------------------- ---------------------------------------- -2015-06-10 13:31:51 -------------> database creation time SQL> set pages 100 lines 120SQL> col action format a6SQL> col namespace format a10SQL>
Create the PSU 11.2.0.3.8, and then the database, 11.2.0.3.8psu.
SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. SQL> select created from v $ database; CREATED --------------------------------------- ---------------------------------------- ---------------------------------------- -2015-06-10 13:31:51 -------------> database creation time SQL> set pages 100 lines 120SQL> col action format a6SQL> col namespace forma
Recently circulated online through with bypass permissions to implement illegal update table data, there is a greater risk. For CPU bugs in the July 2014 PSU repair, recommended upgrade corresponding PSU, if the conditions are not allowed, you can temporarily avoid the risk through the _with_subquery parameterDatabase version InformationSql> select * from V$version;BANNER------------------------------------
Tags: root user site completed after port exec occupies the bug agent data"Introduction to the Environment"System environment: Solaris + Oracle 11R2 + OGG + Scripting timed task statistics collection"Background description"Based on group security checks, vulnerability scanning of database versions is required, vulnerabilities in RBDMS and JVM types exist in vulnerability scanning, and vulnerabilities need to be fixed by upgrading the small version of the PSU
Check the database for CPU and PSU patch information
Briefly describes how to check the current database for CPU and PSU patch installation.
Normally there are two methods, one is to log in to the database check dba_registry_hist view:
Moddb2:[/home/oracle] $sqlplus/as sysdba
Sql*plus:release 10.2.0.4.0-production on Thu Aug 18 13:04:43 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected t
Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows:
1. Stop log transfer service in primary;
2. Close the standby database, standby software on the patch (note: Do not need to be patched for the standby database), start standby for Mount state, do not
The following is the data Guard CPU/PSU patch installation method for a detailed analysis of the introduction, the need for friends can refer to the next
Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows:1
Tags: 11.2.0.4 PSU 18011627282436 = 27107360 (PSU) + 26925532 (OJVM)
0. In order to avoid installing patches running data dictionary scripts and system background jobs conflict, view Autotask, if there is enabled, first disable, after the patch and then enable.Su-oraclesqlplus "/as sysdba" set Lin pages 10000COL client_name format a40col consumer_group format A30col window_gr OUP FORMAT a30select clie
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.