DBCA

ORA-39405 with impdp when you have mixed time zone versions

Today, Gisela, a former team mate from CSS/ACS Support contacted me regarding an issue seen at a customer. She reported an ORA-39405 with impdp when you have mixed time zone versions. But how can this happen? And what are the potential workarounds? Since some of our hosted environments got into the same situation already, this may be worth a blog post and some explanation.

ORA-39405 with impdp when you have mixed time zone versions

Photo by Benjamin Voros on Unsplash

Why does this happen?

You never cared about DST (Daylight Savings Time) files and versions of your database? This isn’t unusual, and in many environments actually not a problem …

Creating CDBs and non-CDBs with less options

Posted on August 8, 2018 by Mike.Dietrich Best Practice DBCA Single-/Multitenant 4

I wanted to write up this blog post a long time ago. When Helen Vanderheide did ask me a few weeks ago if she can omit catoctk.sql during the creation of the database, I realized that I should update my previous blog posts about Creating CDBs and non-CDBs with less options. And of course, the following is usable with non-CDBs as well.

You’ll find an example and especially the component dependency matrix below as well as many links to related blog posts at the end. If you don’t want to read all this, just scroll down to the Summary…

Do you have to execute catbundle.sql when you create a new 11g database?

Posted on April 25, 2018 by Mike.Dietrich DBCA 4

Do you have to execute catbundle.sql when you create a new 11g database? Roberto Valsania asked this question once he read my blog post about whether you have to execute datapatch after creating a new 12c database: Do you have to execute catbundle.sql when you create a new 11g database?

I’d bet you all are aware that Oracle Database 11.2.0.4 will go out of Waived Extended Support by end of 2018. But that doesn’t answer the question. So I did a quick experiment and created a fresh 11.2.0.4 database to answer the question.

Do you have to execute catbundle.sql when you create a new 11g database?

First of all, let me clarify …

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 …

Use your own templates in DBCA to create databases

Posted on July 12, 2017 by Mike.Dietrich DBCA 6

Another advice regarding database creation:
Use your own templates in DBCA to create databases.

This way you can configure not only the options and components to create but also redo log layout, your set of parameters and much more. And it is less error prone than a “create database” script.

Use your own template in DBCA

Creating your own template in DBCA (Database Configuration Assistant) is quite easy and straight forward. In DBCA select “Manage Templates”:

Use your own templates in DBCA to create databases

DBCA – Choose “Manage Templates” to create a new template

and create a new template:

DBCA – Specify a name for your new templateDBCA-Templates

Always create databases as CUSTOM databases

Posted on July 11, 2017 by Mike.Dietrich DBCA 9

I’m giving this advice to customers for many years:
When you create a fresh Oracle database ALWAYS create databases as CUSTOM databases. Via template or not doesn’t matter.

Always create CUSTOMER databases In the DBCA better use your own and wisely configured template rather than the prebuilt (we used to call them: seed) databases. The seed databases for “Data Warehouse” and “General Purpose or Transaction Processing” have all options and components included. I use them for testing from time to time.

As the upgrade duration mainly depends on the number of installed components I’d recommend to choose the components to install, and …

Does DBCA execute “datapatch” in Oracle 12.2?

Posted on May 25, 2017 by Mike.Dietrich DBCA Oracle Database 12.2.0.1 3

Does the Database Configuration Assistant (DBCA) execute “datapatch -verbose” in Oracle 12.2 when you create a new database?

Does DBCA in Oracle 12.2 execute datapatch when you create new database? I was curious if this misbehavior from the previous release has been fixed. Good news: It got fixed with Oracle Database 12.2.0.1. The DBCA does execute “datapatch -verbose” automatically now when you create a new database. In the previous release this did not happen – you had to execute it manually after creating a new database.

DBCA 12c and “datapatch.pl” – things to know

Quick Test Scenario

I …

Create a database with NON-DEFAULT Time Zone

Posted on December 8, 2016 by Mike.Dietrich DBCA Time Zone - DST Transportable Upgrade / Migration 2

One requirement of Transportable Tablespaces (and of course Full Transportable Export/Import as well) is to have identical database character sets AND identical time zone settings.

Problem

Source database has a lower time zone setting than the default target database in the destination home.

Lets assume you’d like to migrate an Oracle 11.2.0.4 off IBM AIX and migrate it into Oracle 12.1.0.2 on an Exadata meaning Oracle Linux 6. The source time zone version if it has never been upgraded would be TZ V14 – whereas the new Oracle 12.1.0.2 database you’d create would get TZ V18 by default.

Time Zone Setting Oracle Database

Solution 1

DBCA 12c and “datapatch.pl” – things to know

Posted on August 17, 2015 by Mike.Dietrich DBCA Flaws and Pitfalls Oracle Database 12c Patch Recommendation 26

A few weeks ago I did blog about the DBUA (Database Upgrade Assistant) not executing ‘datapatch’ (i.e. not applying the SQL changes involved with a SPU/PSU/BP) automatically:

DBUA 12c and “datapatch.pl” – things to know

For DBUA, please note that this behavior DOES NOT APPLY to command line upgrades done with catctl.pl – as you can see from this somewhat disturbing messages during the upgrade in phase 65 and phase 69 (which are not errors but just informational messages for datapatch’s execution):

Datapatch phases command line upgrade catctl.pl

But afterwards I have learned that things are worse.
The same behavior is true when you create

DBCA

ORA-39405 with impdp when you have mixed time zone versions

Why does this happen?

Creating CDBs and non-CDBs with less options

Do you have to execute catbundle.sql when you create a new 11g database?

Do you have to execute catbundle.sql when you create a new 11g database?

Create Multitenant databases with DBCA – Things to Know

Previous posts

Use your own templates in DBCA to create databases

Use your own template in DBCA

Always create databases as CUSTOM databases

Does DBCA execute “datapatch” in Oracle 12.2?

Does the Database Configuration Assistant (DBCA) execute “datapatch -verbose” in Oracle 12.2 when you create a new database?

Quick Test Scenario

Create a database with NON-DEFAULT Time Zone

Problem

Solution 1

DBCA 12c and “datapatch.pl” – things to know

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts