Oracle 18c

Oracle 18c preinstall RPM on RedHat RHEL

By Franck Pachot . The Linux prerequisites for Oracle Database are all documented but using the pre-install rpm makes all things easier. Before 18c, this was easy on Oracle Enterprise Linux (OEL) but not so easy on RedHat (RHEL) where(…)

18c: No Active Data Guard required (and detected) when only CDB$ROOT and PDB$SEED are opened in read-only

By Franck Pachot . When you clone a PDB on the primary CDB, you want that the same is automatically done on the standby ones. Unfortunately, for this operation, the CDB must be opened read-only. In 12.1 even the PDB(…)

ADWC – System and session settings (DWCS lockdown profile)

By Franck Pachot . The Autonomous Data Warehouse Cloud service is a PaaS managed service where we have a PDB and an ADMIN user which has most of the system privileges. For example, we have the privilege to change initialization(…)

ADWC – connect from your premises

By Franck Pachot . In the previous post about the Autonomous Data Warehouse Service, I've run queries though the Machine Learning Notebooks. But you obviously want to connect to it from your premises, with SQL*Net.

ADWC – the hidden gem: Zepplin Notebook

By Franck Pachot . In the previous blog posts I explained how to create, and stop/start the Autonomous Data Warehouse Cloud service. And I didn't show yet how to connect to it. It is(…)

ADWC – a Docker container to start/stop Oracle Cloud services

By Franck Pachot . In the previous post, I've explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There's a setup phase, and a run phase starting with(…)

ADWC: start/stop with PSM Command Line Interface

By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is(…)

ADWC: Creation of Autonomous Data Warehouse Cloud service

By Franck Pachot . You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with(…)

Oracle 18c clone PDB and Transparent Data Encryption

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with(…)

18c PDB switchover

By Franck Pachot . In multitenant, the recovery and availability are at CDB level. But customers asked for a switchover at PDB level so Oracle has done that in 18c, based on refreshable PDBs. For this test I have two(…)