There are two undo modes in oracle 12.2 Multitenant database 1. Local undo mode 2. Shared undo mode Local undo mode: In this mode, each container ( i.e PDB ) in multitenant will have their own active undo tablespace. Share Undo mode: In this mode, There will be only one undo tablespace for the instance. […]
Monthly Archives: July 2017
Move tables (online / offline) in Oracle (9i-12cR2)
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to share the procedures for performing the move of tables in Oracle Database from version 9i to version 12cR2. Here in this article I am using 12cR2 (12.2.0.1) to also be able to demonstrate the features […]
Creating Oracle Database 12cR2 with DBCA in text mode
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. A database is a collection of information that is organized so that it can be easily accessed, managed and updated.Data is organized into rows, columns, and tables, and it is indexed to make it easier to find relevant information. Data […]
Creation of Listener via NETCA in text mode
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 […]
Installing Oracle Database 12cR2 in text mode
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 […]
ACFS for Database and Flex ASM – Part II
I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Objective: Explain and demonstrate the use of ACFS for storing Oracle Home binaries and the database itself, registering the ACFS filesystem to start automatically, configuring the logs to be generated in a unified directory, and displaying ACFS behavior with the […]
Getting Started with Automatic Storage Management Cluster FileSystem (ACFS) – Part I
I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Purpose: To present the benefits and reasons for using ACFS and to initially configure ACFS for use. The Automatic Storage Management Cluster File System (ACFS) was introduced in the second release of Oracle 11g in 2009 and initially there was no […]
Oracle Cloud: Public / Private key pair update for an “Oracle Public Cloud Service” (Part II)
I must thank my fellow DBA Sebastián D’Alessandro and Joel Pérez for his publication in Spanish OTN. In this second part of the article titled “Updating the Public / Private Key Pair of an Oracle Public Cloud Service”, we will see the procedure to replace the set of keys (public / private) associated with an […]
Oracle Cloud: Public / Private Key Pair Update for an “Oracle Public Cloud Service” (Part I)
I must thank my fellow DBA Sebastián D’Alessandro and Joel Pérez for his publication in Spanish OTN. The objective of the article:- In this article, we will see the steps necessary to generate and replace the set of SSH keys (public / private) associated with an Oracle Public Cloud Service, with a new one. Background […]
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 […]