July 2015

Oracle

Oracle 12c DBUA and Datapatch

upgrade12c 1

Meanwhile all customers applying Oracle databases should work on switching their database to Oracle 12c. While for Standard Edition Users there still is the restriction that only version 12.1.0.1 is available, Enterprise Edition Users can apply version 12.1.0.2. It is matter of course that besides the Basic release the current PSU (Patch Set Unit) is loaded. Performing an installation last week as part of a project, I noticed a small but important commit: If you perform the Upgrade from 11g to 12c with the dbua (Database Upgrade Assistant), the command datapatch is not performed automatically (even though the documentation says

Oracle 12c DBUA and Datapatch Blogbeitrag lesen »

By • • 3 minutes of reading
Oracle

Move Partitions between Tables

You might wonder why you should move a partition from one table to another but actually there are several reasons. The following one came up in a session I had with a customer who wants to archive “old” data. The actual data is partitioned (INTERVAL) and initially his idea was to move the rows to the archive table with INSERT AS SELECT. The archive table has to stay for a minimum of 10 years but is very seldom used. As there are global indexes on the current table with about 300 million rows we couldn’t simply keep the old data

Move Partitions between Tables Blogbeitrag lesen »

By • • 5 minutes of reading
Oracle

Caution, 12c Oracle Home User cannot be changed!

01 Oracle LRM-00109

Be careful when installing Oracle 12c on Windows. The first stumbling block, the Oracle Home User could produce a lot of trouble for you later. If you are used to running your Instance and Listener with an extra Account for Exports to Windows Shares, NAS devices or RMAN Backups to external storages for example with Avamar, a toughtless click at software installation could destroy all your work and efforts. It only remains to set up everything from scratch because the once selected user is not changeable.

Caution, 12c Oracle Home User cannot be changed! Blogbeitrag lesen »

By • • 3 minutes of reading
Uncategorized

Standard Edition 2

No Standard Edition and Standard Edition One anymore! In the Oracle MOS Note 2027072.1 Oracle announces that from Oracle 12c 12.1.0.2 on there won’t be a Standard Edition and Standard Edition One anymore, but only a “Standard Edition 2” that is limited on servers with two sockets. However the Standard Edition 2 contains Oracle RAC for two nodes maximum. How the licensing will look like and what consequences this brings to upcoming upgrades or migrations remains to be seen. We keep you posted! Addition from July 8th 2015: All Information regarding Standard Edition 2 was deleted from the MOS website!

Standard Edition 2 Blogbeitrag lesen »

By • • 1 minute of reading
Scroll to Top