2015

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
Uncategorized

Non-CDB Deprecated

1

Cite: “The non-CDB architecture is deprecated in Oracle Database 12c, and may be desupported and unavailable in a later Oracle Database release. Oracle recommends use of the CDB architecture.” (Oracle 12c Database Upgrade Guide, Chapter 8.1.1). What does that mean?

Non-CDB Deprecated Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Data Guard Flashback

Redundant data saving is usual for almost every database nowadays, and it does not matter if it is a RAID-1 (mirroring) or RAID-5 or anything like that. Nevertheless critical databases must be saved by a copy. This is why: By corruption of data the mirroring could be damaged as well. A data backup is not sufficient, because the restore would take too long in case of an error. Logical mistakes ([inlinecode]DROP[/inlinecode] or [inlinecode]TRUNCATE TABLE[/inlinecode]) could not be recognized or eliminated by a disk mirroring. To create such a copy there are at least two different methods: Creating an identical copy

Data Guard Flashback Blogbeitrag lesen »

By • • 6 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
Uncategorized

Non-CDB Deprecated

As always, there has to be someone pointing out the issue or solution. In this case it was Mike Dietrich (Mr. Upgrade). In the Oracle Upgrade Guide for 12c it is in black and white: Cite: “The non-CDB architecture is deprecated in Oracle Database 12c, and may be desupported and unavailable in a later Oracle Database release. Oracle recommends use of the CDB architecture.” (Oracle 12c Database Upgrade Guide, chapter 8.1.1).

Non-CDB Deprecated Blogbeitrag lesen »

By • • 1 minute of reading
Uncategorized

Automatic Segment Space Management

Automatic Segment Space Management (ASSM) helps to distribute your data across the data blocks. It’s no longer necessary to take care about the parameter PCTUSED, which was in former years responsible for the space within one Oracle block. Those days a block was filled until it reaches the high water mark PCTFREE (default 10%). At that point the block was released from the list of free blocks and as long as the low water mark PCTUSED (default 40%) hasn’t been reached again no data will be stored in that block. So only if a massive amount of data will be

Automatic Segment Space Management Blogbeitrag lesen »

By • • 6 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
Scroll to Top