Options

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Posted on January 29, 2020 by Mike.Dietrich SE2 - Standard Edition 2 Single-/Multitenant 0

When we announced the 3-PDB-Support with Oracle Database 19c onward at OpenWorld 2019, I was very excited. According to the license documentation, this applies to Standard Edition 2 (SE2) as well. But does it work? Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Photo by Şahin Yeşilyaprak on Unsplash

The license documentation is pretty clear about 3 user-created PDBs:

https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

Check with Oracle Database 19.5.0 SE2

It’s been a while since I installed SE2 instead of EE. But everything goes smoothly. You just need to select “Standard Edition 2” in the OUI. The image you …

Database Migration from non-CDB to PDB – Migration with Data Pump

You may have realized that there are a few techniques missing describing how to do a Database Migration from non-CDB to PDB – Migration with Data Pump is one of them. I will explain the most simple approach of going to Single- or Multitenant. It isn’t the coolest – and it isn’t very fast as soon as your database has a significant size. But it is not complex. And it allows you to move even from very old versions directly into an Oracle 19c PDB – regardless of patch levels or source and destination platform.

Database Migration from non-CDB to PDB – Migration with Data Pump

High Level Overview

Endianness change

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Posted on August 13, 2019 by Mike.Dietrich Minimal Downtime Single-/Multitenant 6

There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well. This is part of a series of blog posts to make your migration from non-CDB to PDB a bit smoother.

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

When we start to look at a migration from non-CDB to PDB for an important system, regardless of migrating on-prem or to the cloud, reducing the downtime is very important. In this blog post I’d like to highlight the different aspects …

Database Migration from non-CDB to PDB – The Fallback Challenge

Posted on August 5, 2019 by Mike.Dietrich Fallback Single-/Multitenant 2

Photo by Sebastian Grochowicz on Unsplash

Database Migration from non-CDB to PDB – The Fallback Challenge

As I work with customers on upgrades and migrations for a very long time, I know how important a proper fallback is.

When you attempt a migration from a non-CDB to PDB, you need to plan …

Database Migration from non-CDB to PDB – Various Pitfalls

Posted on August 2, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 22

Photo by timJ on Unsplash

Database Migration from non-CDB to PDB – Various Pitfalls

In all the previous blog posts of this series I tried to explain specific pitfalls, and how you can workaround them. This article is meant to collect the “leftovers”, the minor issues and pitfalls which you may not …

Database Migration from non-CDB to PDB – The Patch Level Pitfall

Posted on August 1, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 0

Photo by Piron Guillaume on Unsplash

Database Migration from non-CDB to PDB – The Patch Level Pitfall

When you consolidate on a larger scale, it is very likely that you have different patch levels in your database environments. But when you attempt to plugin a non-CDB into a CDB, you may see …

Database Migration from non-CDB to PDB – The Component Pitfall

Posted on July 31, 2019 by Mike.Dietrich Flaws and Pitfalls Single-/Multitenant 6

Photo by Brett Jordan on Unsplash

The Component Pitfall

With component we mean the database component which you can find in DBA_REGISTRY – or CDB_REGISTRY. When Multitenant became available over 5 years ago, a decision had been made to make all options/components mandatory in a container database. This decision had to …

Be aware of database options selections for PDBs in DBCA

Posted on May 15, 2018 by Mike.Dietrich Single-/Multitenant 6

I did blog about several things-to-know with DBCA (Database Configuration Assistant) in the past. And one issue came up in our internal mailing list the other day. Be aware of database options selections for PDBs in DBCA. Missing one or the other “click” may bring you in trouble later on. I blogged about this already a while ago but this was only part of a larger post: Create Multitenant Databases with DBCA – Things to Know.

Be aware of database options selections for PDBs in DBCA

When you create a custom container database with DBCA you will see this …

Create Multitenant databases with DBCA – Things to Know

Posted on September 21, 2017 by Mike.Dietrich DBCA Single-/Multitenant 2

When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 12.2.0.1’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now. Be careful …

I did blog several times about the DBCA already:

And …

Remove and Clean Up Components from Oracle Database 11.2 – 19c

Posted on July 26, 2017 by Mike.Dietrich Removal 26

Remove and Clean Up Components - Oracle 11.2 - 12.2

I will start a series of blog posts on how to remove and clean up components from Oracle Database 11.2 – 19c.

Precaution

This series of blog posts is not meant to recommend the removal of any options from an Oracle Database. It is not meant to create any sort of negativeness on any of the components or options. It’s is only meant to give you some advice and guideline in the case you’ll need to remove something.

The OUI (Oracle Universal Installer) installed everything on disk – and there’s a very good reason to do this. The purpose of …

SQL*Plus Banner looks different since Oracle Database 12.2

Posted on May 3, 2017 by Mike.Dietrich Behavior Change 0

Did you recognize that the login messages displayed when you start SQL*Plus in Oracle Database 12.2.0.1 looks different than in releases before?

SQL*Plus banner in Oracle Database 12.2.0.1:

$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 2 11:23:10 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

SQL*Plus banner in Oracle Database 12.1.0.2 and before:

$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue May 2 11:24:15 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c

What or who is JOX? And what happens if …

Posted on December 2, 2015 by Mike.Dietrich Removal 2

Are you worried because of the title of this blog post? Don’t worry … it will be about the Oracle database and not about miraculous additives.

Months back I wrote about how to remove options from the Oracle database’s kernel by either using chopt or linking options off:

Removing Options from the Oracle Database kernel in 12c

Recently a very interesting case was logged in relation to a bug:
A customer had linked off the JOX option from the database kernel.
.

What is JOX?

Well, do a quick search for “JOX” in the Oracle Documentation and …

Removing Options from the Oracle Database kernel in 12c

Posted on May 27, 2015 by Mike.Dietrich Removal 5

Remove Options from the Oracle Database Kernel - chopt

Sometimes people have the desire to remove options from the database kernel (i.e. from the oracle executable).

It’s a matter of fact that by default you’ll get plenty of things linked into your kernel in Oracle Database 12c.

In case you’d like to remove things the chopt utility does still exist in Oracle Database 12c – but you may recognize a difference between Oracle 11.2 and Oracle 12.1. Anyhow, ideally you’ll do these changes before you create a database directly after the installation has been completed. See the documentation for Post Installation Tasks first:

Oracle 11.2 – chopt utility

Rules Manager and Expression Filter getting removed

Posted on November 12, 2012 by Mike.Dietrich Removal 1

I doubt that many people are using the Oracle features “Rules Manager” and “Expression Filter” as usually people handle these things (such as ensuring that a zip code or a car number plate has a certain format) within the application code and not inside the database. Oracle Beehive for instance uses that just on the side.

Anyway, just learned today that Rules Manager and Expression Filter components will get removed once our next database release most likely called Oracle Database 12c will get released. So before upgrading to Oracle Database 12c you can remove EXF and …

Database Registry: Component Dependencies

Posted on July 4, 2011 by Mike.Dietrich Removal 4

Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 11.2.0.2 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.

Database Component Dependencies
Example: Component Dependencies in Oracle Database 11.1

As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components. If you’ll query DBA_REGISTRY (or the underlying REGISTRY$) you’ll spot all the installed (and usually configured) database components. And the …

Options

Can you have more than 1 PDB with Standard Edition 2 (SE2)?

Check with Oracle Database 19.5.0 SE2

Database Migration from non-CDB to PDB – Migration with Data Pump

High Level Overview

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Database Migration from non-CDB to PDB – The Fallback Challenge

Database Migration from non-CDB to PDB – The Fallback Challenge

Database Migration from non-CDB to PDB – Various Pitfalls

Database Migration from non-CDB to PDB – Various Pitfalls

Database Migration from non-CDB to PDB – The Patch Level Pitfall

Database Migration from non-CDB to PDB – The Patch Level Pitfall

Database Migration from non-CDB to PDB – The Component Pitfall

The Component Pitfall

Be aware of database options selections for PDBs in DBCA

Be aware of database options selections for PDBs in DBCA

Create Multitenant databases with DBCA – Things to Know

Previous posts

Remove and Clean Up Components from Oracle Database 11.2 – 19c

Precaution

What or who is JOX? And what happens if …

What is JOX?

Removing Options from the Oracle Database kernel in 12c

Rules Manager and Expression Filter getting removed

Database Registry: Component Dependencies

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter