This note describes the process of upgrading an Oracle 12c Release 2 Non-Container Database to Oracle 19c and also converting the Non-CDB database to a Pluggable Database (PDB). The entire upgrade process is automated using the latest Oracle autoupgrade utility – autoupgrade.jar which is part of the new Oracle 12c database software release as well […]
This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the note …..
This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the note …..
This note is a step by step guide to installing and configuring an Oracle 12c Release 2 Real Application Clusters environment using VirtualBox. This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the […]
New in Oracle 12c Release 2 is the ability for scripts to be executed through the Data Guard broker DGMGRL command-line interface very similar to like say in SQL*Plus. DGMGRL commands, SQL commands using the DGMGRL SQL command, and OS commands using the new HOST (or !) capability can be bundled into a script file […]
Oracle 12c Release 2 now provides the ability to reissue the previously executed SQL*Plus commands. This functionality is similar to the shell history command available on the UNIX platform. This feature enables us to run, edit, or delete previously executed SQL*Plus, SQL, or PL/SQL commands from the history list in the current session. We can […]
Data Redaction was introduced in Oracle Database 12c Release 1 (read a note on this) where we could hide or mask sensitive data in tables from non-privileged users. The data was ‘redacted’ at query run time and was stored in the database in its normal non-redacted form. The redaction could be full (no original data […]
This note describes the new features related to the Oracle Database Multitenant option which have been introduced in Oracle 12c Release 2 (12.2.0.1). The hands-on exercises included in the note demonstrates the use of the following new multitenancy features: Hot Cloning Refreshable Pluggable Databases Support for pluggable databases with multiple character sets Proxy Pluggable Databases […]
A number of enhancements to the Oracle database Partitioning option have been introduced in Oracle Database 12c Release 2. These include: Automatic List Partitioning Multi-Column List Partitioning Read-only Partitions Filtered Partition maintenance operations Online conversion of non-partitioned to partitioned table Partitioned External Tables Similar to the interval partitioning method which was introduced in Oracle […]
In an earlier post I had mentioned one of the new features in Oracle Database 12.2 was the ability to set SGA and PGA memory related parameters even at the individual PDB level. So it enables us to further limit or define the resources which a particular PDB can use and enable a more efficient […]
In the earlier 12.1.0.2 Oracle database version, we could limit the amount of CPU utilization as well as Parallel Server allocation at the PDB level via Resource Plans. Now in 12c Release 2, we can not only regulate CPU and Parallelism at the Pluggable database level, but in addition we can also restrict the amount […]
One of the new multitenancy related features in Oracle 12c Release 2 is Application Containers. In 12c Release 1, we could have a Container database (CDB) host a number of optional pluggable databases or PDBs. Now in 12.2.0.1, the multitenancy feature has been enhanced further and we can now have not only CDBs and PDBs […]
One of the real nice new features in Oracle 12c Release 2 (12.2.0.1) is the ability to create an Oracle Data Guard Standby Database using DBCA (Database Configuration Assistant). This really does simplify the process of creating a standby database as well and automates a number of steps in the creation process which were earlier […]
I recently performed an upgrade of an Oracle 12c Release 1 (12.1.0.2) Grid Infrastructure environment hosted on a RAC Virtual Box environment on my laptop to the latest release 12c Release 2 12.2.0.1.0 version. Here are some points to be noted related to the upgrade process: The Grid Infrastructure 12c Release 2 (12.2) software is […]
Oracle 12c Release 2 (12.2.0.1) was officially released for on-premise deployment yesterday. I tested an upgrade of one of my test 12.1.0.2 databases using the Database Upgrade Assistant (DBUA) and the upgrade went smoothly. The Parallel Upgrade command line utility catctl.pl has a number of changes and enhancements as compared to 12c Release 1 and […]
The Oracle Database In-Memory 12c Release 2 New Features webinar conducted last week was well received by a global audience and feedback was positive. For those who missed the session you can download the slide deck from the link below. Feedback and questions are welcomed! 12.2_InMemory_new_features
I recently upgraded EM 12c version 12.1.0.1 to EM 12c Release 2 (12.1.0.2) on a Linux 64 bit platform. Here are few of the things to keep in mind and some notes I made which may be helpful to others planning the similar upgrade. The 12c Release 2 software is made up of three zip […]
