I must thank my fellow DBA Franky Weber Faust for his publication in his blog. This is an article about Installing Oracle Database 12cR2 in text mode using the response file. Oracle Database 12cR2 Installation Process via response file This is the response file I used, feel free to download it: db_install.rsp. Adjust the response file according to […]
Category: ORACLE 12CR2
Installing Oracle Enterprise Linux 7.1 and Oracle Enterprise Edition 12c R2 (12.2.0.1) Part II (RDBMS Installation)
Introduction: I must thank my fellow DBA Rodrigo Mufalani for his publication in Portuguese OTN. Throughout my career as a DBA, I had to do hundreds of Oracle installations on virtually all supported Operating Systems, sometimes for testing, even some not supported by Oracle. My vision is that installing Oracle in a Linux environments has improved […]
Installing Oracle Enterprise Linux 7.1 and Oracle Enterprise Edition 12c R2 (12.2.0.1) – Part I
Part I (OS installation) Introduction: I must thank my fellow DBA Rodrigo Mufalani for his publication in Portuguese OTN. Throughout my career as a DBA, I had to do hundreds of Oracle installations on virtually all supported Operating Systems, sometimes for testing, even some not supported by Oracle. My vision is that installing Oracle in a Linux […]
Oracle Data Guard 12cR2 “Multitenant”(Part -3)
I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. Continuing with the sequence of Oracle Data Guard 12c articles in “Multitenant” Architecture: PDBs behavior, we will end the series by analyzing what happens in the Data Guard “DG” when we delete and when we do an “unplug” […]
Oracle Data Guard 12cR2 “Multitenant”(Part -2)
I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. In previous article: Oracle Data Guard 12c in “Multitenant” Architecture: Behavior of PDBs (Part I) we observed how the process of configuration Data Guard 12c in multitenant architecture is reduced, simplifying thus habitual tasks of the previous versions […]
Oracle Data Guard 12cR2 “Multitenant”(Part -1)
I must thank my fellow DBA César Aguilar and Joel Pérez for his publication in Spanish OTN. The following article is part of a series that describes the behavior of “Pluggable databases (PDB)” in a Disaster Recovery and High Availability environment designed with Oracle Data Guard 12c on a base Of Container data, it will […]
Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]
RDBMS DST Upgrade
After upgrading to Oracle 12.2, we face the issue of RDBMS DST timezones.Then either check support id 1585343.1 or else follow the below step 1.Connect to “sqlplus” and run the “upg_tzv_check.txt” file. If you want to download the content of upg_tzv_check [oracle@oracle122 admin]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sat Mar 4 […]
Manual upgrading Oracle database 11gR2 to 12cR2
Manual upgrading Oracle database 11gR2 to 12cR2 If you want to know how we upgrade an 11.2.0.4 database to 12.2.0.1 using DBUA, click here. This article explains how to upgrade 11.2.0.2 and above, and 12.1.0.1 to 12.2.0.1 manually. Manually upgrading to 12c There are many DBAs who don’t want to follow the recommended way of upgrade […]
Upgrade Oracle 11gR2 (11.2.0.4) database to 12cR2 (12.2.0.1)
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything […]