Infrastructure at your Service

Tag

PDB Archives - Page 2 of 12 - Blog dbi services

Oracle Team

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

By | Oracle | One Comment

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 needed to be opened read-only (Ludovico Caldara reported this in his blog). This, as far as I know, was fixed in 12.2 where MRP reads the files without the need to have the PDB opened….

Read More
Oracle Team

Change Data Capture from Oracle with StreamSets Data Collector

By | Business Intelligence, Database Administration & Monitoring, Oracle | 11 Comments

By Franck Pachot . With this trend of CQRS architectures where the transactions are streamed to a bunch of heterogenous eventually consistent polyglot-persistence microservices, logical replication and Change Data Capture becomes an important component, already at the architecture design phase. This is good for existing products vendors such as Oracle GoldenGate (which must be licensed even to use only the CDC part in the Oracle Database as Streams is going to be desupported) or Dbvisit…

Read More
Oracle Team

ADWC – System and session settings (DWCS lockdown profile)

By | Oracle | No Comments

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 parameters: SQL> select * from dba_sys_privs where grantee=user and privilege like ‘ALTER S%’;   GRANTEE PRIVILEGE ADMIN_OPTION COMMON INHERITED ——- ——— ———— —— ——— ADMIN ALTER SESSION YES NO NO ADMIN ALTER SYSTEM YES NO…

Read More
Oracle Team

PDB RMAN backups available after plugging in on a new CDB with Oracle 18c

By | Database Administration & Monitoring | One Comment

With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18. The first step consist in running a rman backup on pdborig: [email protected]:/u00/app/oracle/ [DB18] rman target sys/[email protected] Recovery Manager: Release 18.0.0.0.0 – Production on Tue May 15…

Read More
Oracle Team

Oracle 18c clone PDB and Transparent Data Encryption

By | Database Administration & Monitoring | One Comment

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 dbca just from PDBseed to from unplugged PDBs: Now in version 18c we can create PDBs from existing PDBs as follows (for this test TDE is disabled): You can choose the Pluggable Database you want…

Read More
Oracle Team

18c PDB switchover

By | Oracle | 4 Comments

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 multitenant database on an Oracle Cloud service in 18c: CDB1 and CDB2. The only special thing I did was disable the mandatory TDE encryption, because I was not able to have the switchover working. With…

Read More
Oracle Team

18c, Cloud First and Cloud Only features: think differently

By | Cloud, Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading the latest release software? Now we need to think differently. Because: The new software is released on Cloud first The major new features will never be available on-premises The Cloud here means the Oracle Cloud –…

Read More
Oracle Team

Multitenant, PDB, ‘save state’, services and standby databases

By | Oracle | 3 Comments

By Franck Pachot . Creating – and using – your own services has always been the recommendation. You can connect to a database without a service name, though the instance SID, but this is not what you should do. Each database registers its db_unique_name as a service, and you can use it to connect, but it is always better to create your own application service(s). In multitenant, each PDB registers its name as a service,…

Read More
Oracle Team

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By | Oracle | No Comments

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just copy the wallet because the wallet contains all CDB keys. Usually, you can be guided by the error messages, but this one needs a little explanation and an example.

Read More