Arquivo de Outubro, 2016

[Oracle] Bundle Patch 12.1.0.2.10 – Windows 64bits – Single Tenant (non-CDB/PDB)

Posted: 26/10/2016 in Dicas
0

Olá, pessoal!

Abaixo o procedimento para atualizar bundle patch no Oracle 12c – Single Tenant (non-CDB/PDB).

Procedimento retirado do “Read Me” no suporte da oracle, segue o link para fazer o download “metalink.oracle.com”

Download do Patch 21821214: WINDOWS DB BUNDLE PATCH 12.1.0.2.10

download_patch_12c

search_patch_12c

Pré requisitos:

OPatch Utility

How to install the utility:
---------------------------

To install this patch, Please extract the file "zipped file" using unzip or winzip,
depending upon the platform. You should extract the zip file directly under the
ORACLE_HOME. Please follow the following steps for extracting the zip file of OPatch.

(1)  Please take a backup of ORACLE_HOME/OPatch into a dedicated backup
location.
(2) Please make sure no directory ORACLE_HOME/OPatch exist.
(3) Please unzip the OPatch downloaded zip into ORACLE_HOME directory.

To check the version of the opatch utility installed in the above step,
go to the OPatch directory and run "opatch version".

– Próximo passo aplicar o patch 12.1.0.2.10 (Recomendo fazer o backup antes de executar o procedimento)

1. Shut down all instances and listeners associated with the Oracle home that you are updating

sqlplus / as sysdba
shutdown immediate

2. Explicitly stop the Distributed Transaction Coordinator service (which is not an Oracle service) if it is running.

net stop msdtc

3. Set the ORACLE_HOME environment variable pointing to your Database Home, go to the directory where the patch is located and then run the OPatch utility by entering the following commands:

set ORACLE_HOME=c:\oracle\orcl\1210
set PATH=%ORACLE_HOME%\OPatch;%PATH%
set PATH=%ORACLE_HOME%\perl\bin;%PATH%

cd C:\install_ora

unzip p21821214_121020_MSWIN-x86-64.zip

cd C:\install_ora\21821214

%ORACLE_HOME%\OPatch\opatch apply

4. Steps to Run the datapatch Utility for Single

sqlplus / as sysdba
startup

datapatch_patch_12c

5. Check Patch

select patch_id, patch_uid, version, status, bundle_series, description from dba_registry_sqlpatch;

SELECT comp_id, status from dba_registry;

%ORACLE_HOME%\OPatch\opatch lsinventory

É isso ai pessoal, espero ter ajudado!

Fonte: https://support.oracle.com