Rollback interim patch in Oracle 12c R1 (12.1.0.2.0) - 21519686 patch
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5046 1 0 00:17 ? 00:00:00 asm_pmon_+ASM1
oracle 7259 1 0 00:18 ? 00:00:00 ora_pmon_corcldb1
oracle 7261 1 0 00:18 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 7275 1 0 00:18 ? 00:00:00 ora_pmon_orcl1
[oracle@rac1-12c ~]$ srvctl stop instance -d orcl -i orcl1 -f
[oracle@rac1-12c ~]$ srvctl stop instance -d corcldb -i corcldb1 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d orcl -i orcl2 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d corcldb -i corcldb2 -f
OR
[oracle@rac2-12c ~]$ srvctl stop database -d orcl
[oracle@rac2-12c ~]$ srvctl stop database -d corcldb
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
21519686;
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-38AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-28-38AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 21519686 : applied on Fri Sep 15 02:07:26 IST 2017
Unique Patch ID: 20178159
Created on 9 May 2016, 09:28:22 hrs PST8PDT
Bugs fixed:
21519686
Rac system comprising of multiple nodes
Local node = rac1-12c
Remote node = rac2-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch rollback -id 21519686
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-51AM_1.log
Patches will be rolled back in the following order:
21519686
The following patch(es) will be rolled back: 21519686
This node is part of an Oracle Real Application Cluster.
Remote nodes: 'rac2-12c'
Local node: 'rac1-12c'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Rolling back patch 21519686...
RollbackSession rolling back interim patch '21519686' from OH '/u01/app/oracle/product/12.1.0.2/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '21519686' from inventory
Patching in rolling mode.
The node 'rac2-12c' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'rac2-12c'.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'rac2-12c'
Rollback-related files are:
FR = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt"
DR = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt"
FP = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt"
MP = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt"
RC = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remote_cmds.txt"
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt" with actual path.
Removing files on remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt" with actual path.
Removing directories on remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt" with actual path.
Running command on remote node 'rac2-12c':
cd /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1 || echo REMOTE_MAKE_FAILED::>&2
The node 'rac2-12c' has been patched. You can restart Oracle instances on it.
Finished patching in rolling mode.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-51AM_1.log
OPatch succeeded.
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-30-20AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-30-20AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac1-12c
Remote node = rac2-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5046 1 0 00:17 ? 00:00:00 asm_pmon_+ASM1
oracle 7261 1 0 00:18 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 19112 16276 0 00:30 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ ssh rac2-12c
Last login: Sun Sep 17 00:25:37 2017 from 192.168.2.1
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 4969 1 0 00:17 ? 00:00:00 asm_pmon_+ASM2
oracle 19012 18954 0 00:30 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
[oracle@rac2-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-31-19AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-31-19AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac2-12c
Remote node = rac1-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 4969 1 0 00:17 ? 00:00:00 asm_pmon_+ASM2
oracle 20365 18954 0 00:32 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ srvctl start database -d orcl
[oracle@rac2-12c ~]$ srvctl start database -d corcldb
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 4969 1 0 00:17 ? 00:00:00 asm_pmon_+ASM2
oracle 20479 1 0 00:32 ? 00:00:00 ora_pmon_orcl2
oracle 20794 1 0 00:32 ? 00:00:00 ora_pmon_corcldb2
oracle 21357 18954 0 00:33 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5046 1 0 00:17 ? 00:00:00 asm_pmon_+ASM1
oracle 7261 1 0 00:18 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 20259 1 0 00:32 ? 00:00:00 ora_pmon_orcl1
oracle 20706 1 0 00:32 ? 00:00:00 ora_pmon_corcldb1
oracle 21183 16276 0 00:33 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$
Saturday, September 16, 2017
Rollback interim patch in Oracle 12c R1 (12.1.0.2.0) - 21519686 patch
Published Oracle Technology Articles (Oracle Technology Network (OTN), OraWorld Magazine and All things ORACLE from Redgate
Published 100+ Oracle Technology Articles Globally - Oracle Technology Network (OTN), OraWorld Magazine and All things ORACLE from Redgate Co-Author – OraWorld Magazine (4 Articles) Article-1: OraWorld Magazine has published - Topic on CBO Artificial Intelligence (Part-2) http://www.oraworld.org/fileadmin/documents/13-2019_ORAWORLD.pdf Article-2: OraWorld Magazine has published - Topic on CBO Artificial Intelligence (Part-1) http://www.oraworld.org/fileadmin/documents/12-ORAWORLD-k.pdf Article-3: OraWorld Magazine has published - Topic on "Oracle Analytical Functions:Tips and Tricks" http://www.oraworld.org/fileadmin/documents/11-2018_ORAWORLD.pdf Article-4: Oracle Exadata Database Machine: Decade of Innovation http://www.oraworld.org/fileadmin/documents/18-ORAWORLD.pdf Oracle Technology Network (OTN) – English (6 Articles) Article-1: Multiple Pluggable Database (PDBs) Replication in Multitenant Database Using Oracle GoldenGate 12c https://community.oracle.com/docs/DOC-995763 Article-2: Data Replication with Multiple Extracts and Multiple Replicats with Integrated Capture Mode Using Oracle GoldenGate 12c https://community.oracle.com/docs/DOC-995764 Article-3: Upgrade Options In Oracle 12c Multitenant Database https://community.oracle.com/docs/DOC-995765 Article-4: Bi-Directional Replication with Pluggable Database (PDB) in Multitenant Database Using Oracle GoldenGate 12c https://community.oracle.com/docs/DOC-995762 Article-5: How To Query Hive and Impala from Oracle using ODBC Heterogeneous Gateway https://community.oracle.com/docs/DOC-1002634 Article-6: Database Patching: Patch like a King with a Single Click – Database As A Service (DbaaS) https://community.oracle.com/docs/DOC-1005964 Oracle Technology Network (OTN) – SPANISH (47 Articles) Article-1: Oracle RAC 12c: "Flex ASM" y "Flex Cluster" http://www.oracle.com/technetwork/es/articles/database-performance/caracteristicas-flex-asm-y-cluster-2088714-esa.html Article-2: Oracle Exadata Database Machine: "Smart Flash Logging" http://www.oracle.com/technetwork/es/articles/database-performance/exadata-smart-flash-logging-2088700-esa.html Article-3: Oracle Exadata Database Machine: “Exachk” http://www.oracle.com/technetwork/es/articles/database-performance/exadata-database-machine-exachk-2095610-esa.html Article-4: Oracle Exadata Database Machine: “Exadata Hybrid Columnar Compression (EHCC)” http://www.oracle.com/technetwork/es/articles/database-performance/exadata-hybrid-columnar-compression-2098797-esa.html Article-5: Oracle Exadata Database Machine: “Write-Back Flash Cache” http://www.oracle.com/technetwork/es/articles/database-performance/exadata-write-back-flash-cache-2101480-esa.html Article-6: Oracle Exadata Database Machine: IO Resource Manager (IORM) http://www.oracle.com/technetwork/es/articles/database-performance/io-resource-manager-2100979-esa.html Article-7: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 1) http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-de-datos-parte1-2166616-esa.html Article-8: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 2) http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte2-2167445-esa.html Article-9: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 3) http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte3-2167449-esa.html Article-10: Todo lo que tienes que saber sobre COMMON y LOCAL en Oracle Database 12c http://www.oracle.com/technetwork/es/articles/idm/common-local-12c-2190666-esa.html Article-11: Oracle Database 12c: Una introducción a los conceptos de Respaldo, Recuperación y Recuperación a un punto en el tiempo (PITR) de PDBs http://www.oracle.com/technetwork/es/articles/database-performance/pdbs-backup-recovery-dbpitr-2192211-esa.html Article-12: Migración a la versión 12c de la base de datos Oracle sin interrupción de servicio usando Oracle Golden Gate 12c http://www.oracle.com/technetwork/es/articles/datawarehouse/oracle-golden-gate-2192209-esa.html Article-13: RMAN: Como hacer para Restaurar y/o Recuperar solo los "Tablespaces" esenciales http://www.oracle.com/technetwork/es/articles/database-performance/restaurar-recuperar-tablespaces-2228109-esa.html Article-14: Oracle Standby Database, un "amigo" para 1000 casos http://www.oracle.com/technetwork/es/articles/database-performance/oracle-standby-database-2232804-esa.html Article-15: Oracle Database 12c: Data Redaction http://www.oracle.com/technetwork/es/articles/idm/oracle-data-redaction-12c-esp-2226725-esa.html Article-16: Oracle Database 12c: Cómo usar archivos “XML Manifest” para conectar y desconectar PDBs http://www.oracle.com/technetwork/es/articles/sql/xml-manifest-pdbs-2244550-esa.html Article-17: Creación de un reporte simple usando Information Publisher Report. http://www.oracle.com/technetwork/es/articles/oem/reportes-con-information-publisher-2492705-esa.html Article-18: Oracle Database as a Service (DBaaS): Aplicando Parches con un clic http://www.oracle.com/technetwork/es/articles/database-performance/aplicar-parche-oracle-dbaas-3338001-esa.html Article-19: Oracle Database 12c Multitenant: Métodos de Upgrade http://www.oracle.com/technetwork/es/articles/database-performance/multitenant-metodos-de-upgrade-3351666-esa.html Article-20: Replicación consolidada y en cascada (DDL and DML) usando Oracle GoldenGate (11g y 12c) entre Bases de Datos Oracle (11g y 12c) http://www.oracle.com/technetwork/es/articles/database-performance/consolidada-cascada-ddl-dml-3418927-esa.html Article-21: Arquitectura y Setup de FileSystems ACFS en Oracle 12c RAC de 3 Nodos con Flex ASM http://www.oracle.com/technetwork/es/articles/database-performance/setup-filesystems-acfs-flex-asm-3427843-esa.html Article-22: Replicación de datos con múltiples procesos "Extract" y "Replicat" con el modo de captura integrada utilizando Oracle GoldenGate 12c http://www.oracle.com/technetwork/es/articles/database-performance/replicacion-datos-multiples-proceso-3661869-esa.html Article-23: Oracle Exadata Database Machine - Funcionalidad :Disk Scrubbing http://www.oracle.com/technetwork/es/articles/database-performance/exadata-db-machine-disk-scrubbing-3679915-esa.html Article-24: Replicación entre IBM DB2 LUW y Oracle Database utilizando Oracle GoldenGate Parte I http://www.oracle.com/technetwork/es/articles/database-performance/repliacion-ibm-3713613-esa.html Article-25: Clonación en Caliente de una Pluggable Database (PDB) en Ambiente Multi-Tenant con Oracle Database 12c R2. http://www.oracle.com/technetwork/es/articles/database-performance/clonacion-pdb-3713590-esa.html Article-26: Uso de OAKCLI en Oracle Database Appliance (ODA) X5-2 con Alta Disponibilidad. http://www.oracle.com/technetwork/es/articles/database-performance/uso-de-oakcli-3709129-esa.html Article-27: Replicación de múltiples bases de datos “Pluggable” (PDBs) en una arquitectura “Multitenant” utilizando Oracle GoldenGate 12c http://www.oracle.com/technetwork/es/articles/database-performance/bases-de-datos-pluggable-3708769- esa.html Article-28: Replicacion bidireccional con base de datos Pluggable (PDB) en una arquitectura Multitenant utilizando Oracle GoldenGate 12c http://www.oracle.com/technetwork/es/articles/database-performance/replicacion-bidireccional-3737802-esa.html Article-29: Reubicando Pluggable Database (PDB) en Modo READ WRITE en Ambiente MultiTenant con Real Application Cluster (RAC) http://www.oracle.com/technetwork/es/articles/database-performance/default-3754342-esa.html Article-30: Performance Profiles para PDBs en Oracle Database 12c Release 2 http://www.oracle.com/technetwork/es/articles/database-performance/perform-profile-3803116-esa.html Article-31: Consultando Impala y Hive desde Oracle usando un gateway heterogeneo ODBC http://www.oracle.com/technetwork/es/articles/database-performance/default-3679880-esa.html Article-32: Creando puntos de restauración de base de datos utilizando snapshots ZFS de Oracle Solaris http://www.oracle.com/technetwork/es/articles/database-performance/restaura-db-snapshots-zfs-oracle-3679894-esa.html Article-33: Configuración y administración de Oracle Database Vault 12c en un ambiente “Multitenant” utilizando Oracle Enterprise Manager 12c. http://www.oracle.com/technetwork/es/articles/database-performance/databasevault-12c-multitenant-3703502-esa.html Article-34: Flashback Pluggable Database (PDB) en Ambiente Multi-Tenant con Oracle Database 12c R2. http://www.oracle.com/technetwork/es/articles/database-performance/flashback-pdb-3715323-esa.html Article-35: Instalación de Parches de Servidor, Discos y Base de Datos en un Oracle Database Appliance (ODA) X5-2 High Availability (HA) http://www.oracle.com/technetwork/es/articles/database-performance/parches-discos-3803644-esa.html Article-36: Juego de Caracteres de PDBs, Como limitar IO por PDB y Como Configurar Memoria por PDB en Ambientes Multi-Tenant Usando Oracle 12c R2 (12.2.0.1.0) http://www.oracle.com/technetwork/es/articles/database-performance/juegodecaracteres-3873458-esa.html Article-37: Upgrade de Oracle Database Appliance (ODA) utilizando Re-imaging de Sistema Operativo https://www.oracle.com/technetwork/es/articles/database-performance/upgrade-oda-re-imaging-5278093-esa.html Article-38: Descubriendo Oracle Database Appliance (ODA) en Oracle Enterprise Manager Cloud Control (OEM). https://www.oracle.com/technetwork/es/articles/oem/odb-appliance-en-oem-5231544-esa.html Article-39: Oracle Database 12cR2 (12.2.0) ACFS Security y ACFS Encryption https://www.oracle.com/technetwork/es/articles/idm/acfs-sec-encryption-5143934-esa.html Article-40: Instalación y Configuración de la Infrastructura Grid e Instalación del Software de Base de Datos Oracle 12c R2 (12.2.0.1.0) en Alta Disponibilidad https://www.oracle.com/technetwork/es/articles/grid/instalacion-conf-grid-5095571-esa.html Article-41: Utilitario DBMCLI en Oracle Exadata Database Machine https://www.oracle.com/technetwork/es/articles/database-performance/dbmcli-oracle-exadatadb-4406856-esa.html Article-42: Crear una Snapshot Database en Oracle Database Appliance (ODA) X5-2 https://www.oracle.com/technetwork/es/articles/database-performance/snapshot-database-oda-4125409-esa.html Article-43: Recopilando información de diagnostico mediante Oracle Trace File Analyzer (TFA) https://www.oracle.com/technetwork/es/articles/database-performance/trace-file-analyzer-tfa-5806507-esa.html Article-44: Mejorando el rendimiento en un Real Application Cluster (RAC) usando Tablespaces Temporales Locales https://www.oracle.com/technetwork/es/articles/database-performance/local-temp-tablespace-5813489- esa.html Article-45: Oracle Database Appliance (ODA): ODABR un utilitario para Backup / Restore de sistema https://www.oracle.com/technetwork/es/articles/database-performance/odabr-backup-restore-5888353-esa.html Article-46: Beneficios e implementación de Oracle Virtual Private Database (VPD) https://www.oracle.com/technetwork/es/articles/idm/virtual-private-db-5928071-esa.html Article-47: Beneficios e implementación de Oracle Virtual Private Database (VPD) https://www.oracle.com/technetwork/es/articles/idm/virtual-private-db-5928071-esa.html Oracle Technology Network (OTN) – Portuguese (43 Articles) Article-1: Oracle Database 12cR2 (12.2.0) ACFS Segurança e Encriptação https://www.oracle.com/technetwork/pt/articles/idm/acfs-seg-e-encripta%C3%A7ao-5178123-ptb.html Article-2: Configurando Oracle Database File System (DBFS) em Real Application Clusters (RAC) no Oracle 12c https://www.oracle.com/technetwork/pt/articles/database-performance/odb-file-system-em-rac-5025666-ptb.html Article-3: Gerenciando Ambientes de Teste e Desenvolvimento se beneficiando dos snapshots do ACFS Usando o 'gDBclone' em Clusters de Aplicativo Real (RAC) em Ambientes Multitenant https://www.oracle.com/technetwork/pt/articles/database-performance/gdbclone-em-rac-5023304-ptb.html Article-4: Configurando Oracle GoldenGate com Oracle Grid Infrastructure Bundled Agents (XAG) no Real Application Clusters (RAC) On Oracle 12c https://www.oracle.com/technetwork/pt/articles/grid/configurar-ogg-com-xag-5011606-ptb.html Article-5: DBMCLI utilitário de linha de comando - Oracle Exadata Database Machine https://www.oracle.com/technetwork/pt/articles/database-performance/dbmcli-oracle-exadatadb-5011499-ptb.html Article-6: Instalação e configuração do Clusterware e RDBMS em Oracle Database 12c R2 (12.2.0.1.0) com Alta Disponibilidade (HA) https://www.oracle.com/technetwork/pt/articles/database-performance/clusterware-rdbms-or12cr2-4443115-ptb.html Article-7: Criando snapshot database (clone) no Oracle Database Appliance (ODA) X5-2 https://www.oracle.com/technetwork/pt/articles/database-performance/snapshot-db-oda-x5-2-4416187-ptb.html Article-8: Utilizando o Hive e o Impala através do banco de dados Oracle https://www.oracle.com/technetwork/pt/articles/sql/hive-e-impala-bd-oracle-4241853-ptb.html Article-9: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 1) http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-nivel-asm-banco-de-dados-2129933-ptb.html Article-10: Oracle Exadata Database Machine X3: “Smart Flash Logging” http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-smart-flash-logging-2132507-ptb.html Article-11: Oracle Exadata Database Machine: “Write-Back Flash Cache” http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-write-back-flash-cache-2164875-ptb.html Article-12: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 2) http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-asm-banco-dados-parte2-2166649-ptb.html Article-13: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 3) http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-asm-banco-de-dados-parte3-2166659-ptb.html Article-14: Oracle RAC 12c:Flex ASM e Flex Cluster http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-rac-12c-flex-asm-cluster-2172079-ptb.html Article-15: Oracle Exadata Database Machine: Exachk http://www.oracle.com/technetwork/pt/articles/servers-storage-admin/oracle-exadata-exachk-2209072-ptb.html Article-16: Tudo o que você precisa saber sobre o Common e o Local no Oracle Database 12c http://www.oracle.com/technetwork/pt/articles/idm/common-local-oracle-database-12c-2235405-ptb.html Article-17: Funcionalidade Data Redaction - Oracle Database 12c http://www.oracle.com/technetwork/pt/articles/idm/funcionalidade-data-redaction-12c-2209076-ptb.html Article-18: Oracle Exadata Database Machine: “Exadata Hybrid Columnar Compression (EHCC) http://www.oracle.com/technetwork/pt/articles/oem/oracle-hybrid-columnar-compression-2436203-ptb.html Article-19: Oracle Database 12c: An introduction to concepts backup, recovery and recovery to a point in time (PITR) of PDBs http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-databse-pitr-pdbs-2438403-ptb.html Article-20: Migração para a versão 12c do Banco de Dados sem Downtime, utilizando Oracle Golden Gate http://www.oracle.com/technetwork/pt/articles/datawarehouse/migracao-12-oracle-golden-gate-2479499-ptb.html Article-21: Criação de um relatório simples utilizando o Information Publisher Report http://www.oracle.com/technetwork/pt/articles/oem/information-publisher-report-oem-2488821-ptb.html Article-22: Oracle Exadata Database Machine: I/O Resource Manager (IORM). http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-resource-manager-iorm-2507896-ptb.html Article-23: Replicação bi-direcional com Pluggable Database (PDB) utilizando Oracle GoldenGate 12c http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-bi-direcional-com-pdbs-2931915-ptb.html Article-24: Replicação de múltiplos Pluggable Databases em um Banco de Dados Multitenant utilizando Oracle GoldenGate 12c http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-pdbs-oracle-goldengate-2941832-ptb.html Article-25: Replicação de Dados com Múltiplos processos de Extração e Replicação em Modo de Captura Integrada no Oracle GoldenGate 12c http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-dados-oracle-goldengate-2995049-ptb.html Article-26: Opções de Atualização no Oracle 12c Multitenant Database http://www.oracle.com/technetwork/pt/articles/database-performance/atualizacao-oracle-12c-multitenant-2996705-ptb.html Article-27: Criando pontos de restauração para o banco de dados Oracle utilizando snapshots do Oracle Solaris ZFS http://www.oracle.com/technetwork/pt/articles/database-performance/criando-point-in-time-snapshots-zfs-3215254-ptb.html Article-28: Database as a Service (DBAAS): Aplicação de patches de forma simplificada http://www.oracle.com/technetwork/pt/articles/database-performance/aplicando-patches-dbaas-3321593-ptb.html Article-29:: Replicação consolidada e em cascata combinadas (DDL e DML) usando Oracle GoldenGate (11g e 12c) entre Oracle databases (11g e 12c) http://www.oracle.com/technetwork/pt/articles/database-performance/replica-ddl-dml-oracle-goldengate-3410097-ptb.html Article-30: Replicação entre o IBM DB2 LUW e o Oracle Database 12c utilizando o Oracle GoldenGate - Parte 1 http://www.oracle.com/technetwork/pt/articles/database-performance/replicar-db2-database-goldengate-3496397-ptb.html Article-31: Flashback Pluggable Database (PDB) emambiente Multi-Tenant usando Oracle Database 12c R2 http://www.oracle.com/technetwork/pt/articles/database-performance/flashback-3703752-ptb.html Article-32: Clonando a quente umPluggable Database (PDB) emum ambiente Multi-Tenantusando Oracle Database 12c R2 http://www.oracle.com/technetwork/pt/articles/database-performance/pdb-multi-tenant-3746608-ptb.html Article-33: Realocando Pluggable Database (PDB) em modo READ WRITE em ambiente Multi-Tenant com Real Application Cluster (RAC) http://www.oracle.com/technetwork/pt/articles/database-performance/read-write-3755576-ptb.html Article-34: Disk Scrubbing Feature Oracle Exadata Database Machine http://www.oracle.com/technetwork/pt/articles/database-performance/disk-scrubbing-3758877-ptb.html Article-35: Pluggable Database (PDB) Character sets, IORM e Configurações de memória em um ambiente Multi-Tenant usando Oracle 12c R2 (12.2.0.1.0) http://www.oracle.com/technetwork/pt/articles/database-performance/iorm-pdb-3760315-ptb.html Article-36: Uso do OAKCLI em Oracle Database Appliance (ODA) X5-2 High Availability (HA) http://www.oracle.com/technetwork/pt/articles/database-performance/oakcli-x5-3760326-ptb.html Article-37: Pluggable Database Performance Profiles no Oracle Database 12c Release 2 http://www.oracle.com/technetwork/pt/articles/database-performance/profiles-3835567-ptb.html Article-38: Configuração e Administração do Oracle Database Vault 12c em Multitenant utilizando o Oracle Enterprise Manager Total Cloud Control 12c http://www.oracle.com/technetwork/pt/articles/database-performance/vault-3939546-ptb.html Article-39: Multi-Instances Redo Apply em Physical Standby Database Instances em um ambiente 3-Node RAC https://www.oracle.com/technetwork/pt/articles/database-performance/multiinstance-redoapply-5813499-ptb.html Article-40: Aumente a Performance usando Local Temporary Tablespaces em Real Application Cluster (RAC) https://www.oracle.com/technetwork/pt/articles/database-performance/local-temp-tablespace-5871028-ptb.html Article-41: Coletando informações de diagnóstico usando Oracle Trace File Analyzer (TFA) https://www.oracle.com/technetwork/pt/articles/database-performance/trace-file-analyzer-5958317-ptb.html Article-42: Benefícios e Implementação do Oracle Virtual Private Database (VPD) https://www.oracle.com/technetwork/pt/articles/idm/virtual-private-databas-6282211-ptb.html Article-43: Usando o recurso Recover Standby Database do serviço Dataguard no 19c https://www.oracle.com/technetwork/pt/articles/database-performance/recover-standby-db-19c-6335374-ptb.html All things ORACLE from redgate – English (2 Articles) Article-1: Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c. http://allthingsoracle.com/upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c/ Article-2: Integrated DDL and DML with Encrypt using Oracle GoldenGate 12c. http://allthingsoracle.com/integrated-ddl-and-dml-with-encrypt-using-oracle-goldengate-12c/ Author- IT Central Station – English (1 Article) Article-1: With Multi-Tenancy, You Can Set Up Background Processes And Memory At The Container Level https://www.itcentralstation.com/product_reviews/oracle-database-review- 39827-by-architec8a80?gitb_token=IWlcGsIWsWpa-0eTVVv2KQ&tid=um-npro-post Author- Spain Oracle User Group (SPOUG) – Spanish (3 Articles) Article-1: Oracle RAC 12c: "Flex ASM" y "Flex Cluster" http://blog-spoug.blogspot.com/2018/07/oracle-rac-12c-flex-asm-y-flex-cluster.html Article-2: Oracle Exadata Database Machine: "Smart Flash Logging" http://blog-spoug.blogspot.com/2018/07/oracle-exadata-database-machine-smart.html Article-3: Oracle Exadata Database Machine: herramienta “Exachk” http://blog-spoug.blogspot.com/2018/07/oracle-exadata-database-machine.html
Thursday, September 14, 2017
RAC Rolling Patch - Oracle Database 12c Release 12.1.0.2.0 - PLSQL Patch for Bug# 21519686 for Linux-x86-64 Platforms
RAC Rolling Patch - Oracle Database 12c Release 12.1.0.2.0 - PLSQL Patch for Bug# 21519686 for Linux-x86-64 Platforms
[oracle@rac1-12c ~]$
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 9973 1 0 01:53 ? 00:00:00 ora_pmon_orcl1
oracle 10278 1 0 01:53 ? 00:00:00 ora_pmon_corcldb1
oracle 15951 13690 0 01:57 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ ls -lrth p*
-rw-r--r-- 1 oracle oinstall 114K Sep 15 01:52 p21519686_121020_Linux-x86-64.zip
[oracle@rac1-12c ~]$ scp p21519686_121020_Linux-x86-64.zip oracle@192.168.2.102:/home/oracle
p21519686_121020_Linux-x86-64.zip 100% 113KB 113.4KB/s 00:00
[oracle@rac1-12c ~]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch
[oracle@rac1-12c OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-03-07AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-03-07AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac1-12c
Remote node = rac2-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1-12c OPatch]$ . oraenv
ORACLE_SID = [orcl1] ? orcl1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1-12c OPatch]$ srvctl stop instance -d orcl -i orcl1 -f
[oracle@rac1-12c OPatch]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 10278 1 0 01:53 ? 00:00:00 ora_pmon_corcldb1
oracle 19007 13690 0 02:05 pts/1 00:00:00 grep pmon
[oracle@rac1-12c OPatch]$ srvctl stop instance -d corcldb -i corcldb1 -f
[oracle@rac1-12c OPatch]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 19314 13690 0 02:06 pts/1 00:00:00 grep pmon
[oracle@rac1-12c OPatch]$ cd
[oracle@rac1-12c ~]$
[oracle@rac1-12c ~]$ cd /home/oracle/
[oracle@rac1-12c ~]$ unzip p21519686_121020_Linux-x86-64.zip
Archive: p21519686_121020_Linux-x86-64.zip
creating: 21519686/
creating: 21519686/files/
creating: 21519686/files/lib/
creating: 21519686/files/lib/libserver12.a/
inflating: 21519686/files/lib/libserver12.a/kkxm.o
creating: 21519686/etc/
creating: 21519686/etc/config/
inflating: 21519686/etc/config/actions.xml
inflating: 21519686/etc/config/inventory.xml
creating: 21519686/online/
creating: 21519686/online/files/
creating: 21519686/online/files/hpatch/
inflating: 21519686/online/files/hpatch/bug21519686.pch
creating: 21519686/online/etc/
creating: 21519686/online/etc/config/
inflating: 21519686/online/etc/config/inventory.xml
inflating: 21519686/online/etc/config/deploy.xml
inflating: 21519686/online/etc/config/actions.xml
creating: 21519686/online/etc/xml/
inflating: 21519686/online/etc/xml/GenericActions.xml
inflating: 21519686/online/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 21519686/README.txt
[oracle@rac1-12c ~]$ cd 21519686/
[oracle@rac1-12c 21519686]$ pwd
/home/oracle/21519686
[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-07-01AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 21519686
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21519686' to OH '/u01/app/oracle/product/12.1.0.2/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21519686 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-07-01AM_1.log
OPatch succeeded.
[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
21519686;
OPatch succeeded.
[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-08-40AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-08-40AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 21519686 : applied on Fri Sep 15 02:07:26 IST 2017
Unique Patch ID: 20178159
Created on 9 May 2016, 09:28:22 hrs PST8PDT
Bugs fixed:
21519686
Rac system comprising of multiple nodes
Local node = rac1-12c
Remote node = rac2-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 21486 13690 0 02:10 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ srvctl start instance -d orcl -i orcl1
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 21704 1 0 02:11 ? 00:00:00 ora_pmon_orcl1
oracle 22112 13690 0 02:11 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ srvctl start instance -d corcldb -i corcldb1
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 21704 1 0 02:11 ? 00:00:00 ora_pmon_orcl1
oracle 22885 1 0 02:12 ? 00:00:00 ora_pmon_corcldb1
oracle 23551 13690 0 02:14 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [orcl1] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 15 02:14:13 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@orcl as sysdba
Connected.
SQL> select instance_name,instance_number from gv$instance;
INSTANCE_NAME INSTANCE_NUMBER
---------------- ---------------
orcl2 2
orcl1 1
SQL> exit
Login to Node-2
==================
[oracle@rac1-12c ~]$ ssh rac2-12c
Last login: Fri Sep 15 01:59:43 2017 from 192.168.2.1
[oracle@rac2-12c ~]$ ls -la p*
-rw-r--r-- 1 oracle oinstall 116093 Sep 15 01:59 p21519686_121020_Linux-x86-64.zip
[oracle@rac2-12c ~]$ chmod -R 777 p21519686_121020_Linux-x86-64.zip
[oracle@rac2-12c ~]$ unzip p21519686_121020_Linux-x86-64.zip
Archive: p21519686_121020_Linux-x86-64.zip
creating: 21519686/
creating: 21519686/files/
creating: 21519686/files/lib/
creating: 21519686/files/lib/libserver12.a/
inflating: 21519686/files/lib/libserver12.a/kkxm.o
creating: 21519686/etc/
creating: 21519686/etc/config/
inflating: 21519686/etc/config/actions.xml
inflating: 21519686/etc/config/inventory.xml
creating: 21519686/online/
creating: 21519686/online/files/
creating: 21519686/online/files/hpatch/
inflating: 21519686/online/files/hpatch/bug21519686.pch
creating: 21519686/online/etc/
creating: 21519686/online/etc/config/
inflating: 21519686/online/etc/config/inventory.xml
inflating: 21519686/online/etc/config/deploy.xml
inflating: 21519686/online/etc/config/actions.xml
creating: 21519686/online/etc/xml/
inflating: 21519686/online/etc/xml/GenericActions.xml
inflating: 21519686/online/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 21519686/README.txt
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 11098 1 0 01:53 ? 00:00:00 ora_pmon_corcldb2
oracle 12326 1 0 01:55 ? 00:00:00 ora_pmon_orcl2
oracle 22816 22605 0 02:15 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ srvctl stop instance -d orcl -i orcl2 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d corcldb -i corcldb2 -f
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 23780 22605 0 02:16 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ cd /home/oracle/21519686/
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/12.1.0.2/db_1".
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-06AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-17-06AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac2-12c
Remote node = rac1-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-16AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 21519686
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21519686' to OH '/u01/app/oracle/product/12.1.0.2/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21519686 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-16AM_1.log
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
21519686;
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-51AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-17-51AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 21519686 : applied on Fri Sep 15 02:17:28 IST 2017
Unique Patch ID: 20178159
Created on 9 May 2016, 09:28:22 hrs PST8PDT
Bugs fixed:
21519686
Rac system comprising of multiple nodes
Local node = rac2-12c
Remote node = rac1-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac2-12c 21519686]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 24957 22605 0 02:17 pts/1 00:00:00 grep pmon
[oracle@rac2-12c 21519686]$ srvctl start instance -d orcl -i orcl2
[oracle@rac2-12c 21519686]$ srvctl start instance -d corcldb -i corcldb2
[oracle@rac2-12c 21519686]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 25197 1 0 02:18 ? 00:00:00 ora_pmon_orcl2
oracle 25829 1 0 02:19 ? 00:00:00 ora_pmon_corcldb2
oracle 26892 22605 0 02:20 pts/1 00:00:00 grep pmon
[oracle@rac2-12c 21519686]$ . oraenv
ORACLE_SID = [orcl2] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2-12c 21519686]$ cd
[oracle@rac2-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 15 02:21:10 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@orcl as sysdba
Connected.
SQL> select instance_name,instance_number from gv$instance;
INSTANCE_NAME INSTANCE_NUMBER
---------------- ---------------
orcl1 1
orcl2 2
SQL> exit
[oracle@rac2-12c ~]$ srvctl status database -d orcl
Instance orcl1 is running on node rac1-12c
Instance orcl2 is running on node rac2-12c
[oracle@rac2-12c ~]$ srvctl status database -d corcldb
Instance corcldb1 is running on node rac1-12c
Instance corcldb2 is running on node rac2-12c
Subscribe to:
Posts (Atom)