I must thank my fellow DBA Franky Weber Faust for his publication in his blog. We know NetCA Oracle command line for configuring the Oracle listener. NetCA stands for (Network Configuration Assistant). NetCA is used as a configuration assistant launched by the OUI at install time. It is more suitable for a batch mode for silent installations. I […]
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 […]
Installing Oracle Enterprise Linux 7.1 and Oracle Enterprise Edition 12c R2 (22.214.171.124) 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 […]
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 […]
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” […]
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 […]
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 […]
Here I would be discussing how to upgrade Oracle 11gR2 (126.96.36.199) Grid Infrastructure to Oracle 12cR2 (188.8.131.52) 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 184.108.40.206 to 220.127.116.11 later one. If you […]
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 18.104.22.168.0 Production on Sat Mar 4 03:32:22 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production
INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 126.96.36.199 .
WARNING: Current DST_UPGRADE_STATE is PREPARE !
WARNING: DST_UPGRADE_STATE in DATABASE_PROPERTIES need to be NONE
WARNING: before running upg_tzv_check.sql .
WARNING: Trying to end PREPARE window and then continue
A prepare window has been successfully ended.
INFO: Database RDBMS DST version is DSTv14 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv26 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run upg_tzv_apply.sql to do the actual RDBMS DST update.
INFO: Note that the upg_tzv_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
2. Now check the current timezone.
SQL> SELECT version FROM v$timezone_file;
1 row selected.
3. Now run the “upg_tzv_apply.txt” file. […]
Manual upgrading Oracle database 11gR2 to 12cR2 If you want to know how we upgrade an 188.8.131.52 database to 184.108.40.206 using DBUA, click here. This article explains how to upgrade 220.127.116.11 and above, and 18.104.22.168 to 22.214.171.124 manually. Manually upgrading to 12c There are many DBAs who don’t want to follow the recommended way of upgrade […]