Oracle

  • All
  • General
  • Oracle
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
Oracle

Oracle 12c Unified Auditing – Part 2

Bild1

Unified Auditing was introduced with Oracle 12c 12.1.0.1 and one idea is to combine standard auditing (AUD$) with fine grained auditing (FGA_LOG$). AUD$ and FGA_LOG$ still exists and if you like you can use your existing and well accepted auditing procedures. Some documents stated that the same auditing which was introduced with Oracle 11g is still running but that’s not one hundred percent true. If you don’t change the standard database setup the “old” AUD$ table exist but will stay empty in contrast to 11g. A new partitioned table with a somewhat cryptic name (CLI_SWP$2dc5e8db$1$1) is populated in the schema

Oracle 12c Unified Auditing – Part 2 Blogbeitrag lesen »

By • • 4 minutes of reading
Oracle

Oracle 12c Unified Auditing – Part 1

With Oracle 12c it is all getting better! And that includes the new auditing possibilities as well, which can be grouped as “Unified Auditing”. First of all unified auditing basically does not mean anything more but the previous functions, standard auditing and fine-grained auditing, being combined. This means that we are dealing with three (!) different methods now, because the “former” ones still exist, even if they are disabled by default – despite what is said in several documents. I can also just partly agree on the claim, that the same commands as in Oracle 11g are being recorded. Only

Oracle 12c Unified Auditing – Part 1 Blogbeitrag lesen »

By • • 4 minutes of reading
Oracle

Manage Audit Data

SYSTEM Tablespace Size

Over the last couple of years I was asked repeatedly because the SYSTEM Tablespace is constantly growing. The reason is pretty simple: Since Oracle 11.2 DDL commands not executed with SYSDBA privilege and all logins (failed or successful) are logged in the AUD$ table. And against some documentation this table is located in the SYSTEM tablespace and not in SYSAUX.

Manage Audit Data Blogbeitrag lesen »

By • • 6 minutes of reading
Oracle

Extended Data Types with VARCHAR2(32767)

JA-Blog-042514-1

In the Oracle 12 New Features Guide you will find this sentence: “The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes“ Increasing the allotted size for these data types allows users to store more information in character data types before switching to large objects (LOBs). This is especially useful for brief textual data types and the capabilities to build indexes on these types of columns.” ( Oracle® Database New Features Guide 12c Release 1 (12.1) E17906-16 Page 1-13 What great news! Especially if you want to upgrade your database to

Extended Data Types with VARCHAR2(32767) Blogbeitrag lesen »

By • • 7 minutes of reading
Oracle

VARCHAR2(32767) – Sense or Nonsense?

Maximum Columnsize for VARCHAR2 is now 32k! With Oracle12c you can define a column of data type VARCHAR2, NVARCHAR2 or RAW with a maximum length of 32767 Byte (but not CHAR!). But why is that useful? Datatype CLOB or NCLOB are fit better for pure text fields of a certain size. They can be handled in chunks instead of manipulating the entire text at once and with the SecureFile option which is now default for CLOB and BLOB in Oracle12c the storage is much more efficient.

VARCHAR2(32767) – Sense or Nonsense? Blogbeitrag lesen »

By • • 4 minutes of reading
Oracle

Automatic Memory Management – it’s great isn’t it?

As you might have read in my previous blogs I did some tests with Oracle 10g and 11g on Linu 6 Update 1 – and it works even though there is no official support from Oracle. Due to a presentation for the German Oracle User Group (DOAG) I did some tests with Automatic Memory Management and in this blog I like to share some experiences with you.

Automatic Memory Management – it’s great isn’t it? Blogbeitrag lesen »

By • • 7 minutes of reading
Oracle

Oracle RAC 11.2.0.3 on VMware ESXi

grid installation

The system was build up to test some tools, i.e. the new Oracle Cloud Control 12c, Toad for Oracle and Spotlight (Quest Software) with their RAC components and the HLMM (Herrmann & Lenz Monitoring Module). And this was not about “certificated” configurations or even to set up a productive environment, but about creating a RAC database with minimum effort.

Oracle RAC 11.2.0.3 on VMware ESXi Blogbeitrag lesen »

By • • 7 minutes of reading
Scroll to Top