X

Archived Database Upgrade Blog

Tech

Tech

Create a database with NON-DEFAULT Time Zone

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

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...

Tech

Transportable Tablespaces - Characters Sets - Same same but different?

All credits go to Don Wolf, an Oracle Advanced Customer Support engineer from Ohio as he dug out this information :-) Thanks Don! Do database character sets...

All credits go to Don Wolf, an Oracle Advanced Customer Support engineer from Ohio as he dug out this information :-) Thanks Don! Do database character sets have to match EXACTLY for Transportable Tablespaces? That sounds like a simple question. When you look into our big slide deck the answer will be a straight "Yes". No doubts. Regardless if you would like to do Transportable Tablespaces or Full Transportable Export/Import your sources and your target's database character...

Tech

DROP PLUGGABLE DATABASE - things you need to know

Directly after my DOAG (German Oracle User Group) Conference presentation about "How Single-/Multitenant will change a DBA's life" Martin Bach (Enkitec)...

Directly after my DOAG (German Oracle User Group) Conference presentation about "How Single-/Multitenant will change a DBA's life" Martin Bach (Enkitec) approached me and told me about his experiences with the DROP PLUGGABLE DATABASE command and future recoverability. Martin discovered that once you issued the DROP PLUGGABLE DATABASE command you can't reuse a previously taken backup of this particular PDB anymore and recover the PDB into this existing CDB. I wasn't aware of...

Tech

Differences between Automatic Statistics Gathering job and GATHER_SCHEMA_STATS

Recently a customer raised a question whether there are differences between the Automatic Statistics Gathering job and a manual creation of stats via the...

Recently a customer raised a question whether there are differences between the Automatic Statistics Gathering job and a manual creation of stats via the GATHER_SCHEMA_STATS procedure. The results in performance were quite interesting. Performance after an upgrade from Oracle Database 11.2.0.3 to Oracle Database 11.2.0.4 was not good when the automatic stats job got used. But performance changed significantly to the better when schema stats were created with the downside of...

Tech

SuSE SLES 12 certified with Oracle Database 12.1.0.2

Puh ... I've got many mails over several months asking about the current status of certification of SuSE SLES12 for Oracle Database 12.1.0.2. It took a while -...

Puh ... I've got many mails over several months asking about the current status of certification of SuSE SLES12 for Oracle Database 12.1.0.2. It took a while - and I believe it was not in our hands. But anyhow ... finally ... SuSE Enterprise Linux SLES12 is now certified with Oracle Database 12.1.0.2  See Release Notes for additional package requirements Minimum kernel version: 3.12.49-11-defaultMininum PATCHLEVEL: 1 Additional Notes Edit CV_ASSUME_DISTID=SUSE11 parameter...

Tech

Oracle Database certification on Microsoft Windows 10

The MOS Note: 1307195.1  about Certification Information for Oracle Database on Microsoft Windows x64 (64-bit) got updated right before the 2015 Christmas...

The MOS Note: 1307195.1  about Certification Information for Oracle Database on Microsoft Windows x64 (64-bit) got updated right before the 2015 Christmas holidays with the official certification information for Oracle Database 12c on Microsoft Windows 10. And it says: Windows 10 O/S Information:RAC is not certified.The earliest release certified on Windows 10 is 12.1.0.2. --Mike  Previous related blog posts: Oracle Database and Microsoft Windows 10 - Aug 14, 2015 

Tech

What or who is JOX? And what happens if ...

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...

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 12c Kernelhttps://blogs.oracle.com/UPGRADE/entry/removing_options_from_the_oracle (May 27, 2015) Recently a very interesting case was logged in relation to a bug:A...

Tech

New in Oracle 12c: _optimizer_gather_stats_on_load

Received an email from Roy last night with some performance issues a customer in the US encountered recently during their upgrade testing.  One issue the...

Received an email from Roy last night with some performance issues a customer in the US encountered recently during their upgrade testing.  One issue the customer encountered has to do with tons of parallel slaves creating a massive noise on the system when they are doing a CTAS (Create Table As Select) - and the same thing happens with an IAS (Insert Append Select).. What caused this change? In this case the behavior change is well documented, even though not linked to the...

Tech

Script: Is your database ready for Oracle GoldenGate?

Oracle GoldenGate can be a good addition to a lot of upgrade and migration projects to decrease the downtime to a bare minimum, or even zero in some cases....

Oracle GoldenGate can be a good addition to a lot of upgrade and migration projects to decrease the downtime to a bare minimum, or even zero in some cases. Oracle Tech White Paper:Zero Downtime Database Upgrade using Oracle Golden Gate But before you consider Oracle GoldenGate as THE solution to decrease your downtime you may evaluate if your database is ready for OGG. For this purpose you can download scripts from MyOracle Support (MOS) to check exactly this. Complete...

Oracle

Integrated Cloud Applications & Platform Services