CarajanDB Experten-Blog

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

OEM 12c Agent Deploy on Windows – no problem without Cygwin!

Agent 12c Deploy Windows 01

Right now the version for how to deploy the Agent on Windows without Cygwin. As I mentioned in my post “OEM 12c Agent Deoploy on Windows – no problem with Cygwin!” before, there are several and good reasons to look closer into Cygwin. The following Solution, I call it the dirty way, isn’t probably feasible for long-term deployment of several machines, but if it’s you choise, you’re welcome.

OEM 12c Agent Deploy on Windows – no problem without Cygwin! Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Restore Database after fatal User Error

4201.image001

Even though Oracle enhances the restore or fault tolerance capabilities with every release there are still fatal errors which lead into a major outage of the database. Those errors are mainly produced by human beings – sorry guys, but that’s how it is. In this blog I’ll show you how to restore the database to a specific SCN after a major incident. Actually, there is a true story behind this: Some years ago I had a customer whose production database was named “TEST”. Even though I told them to rename the database to somewhat meaningful the DBA was totally convinced

Restore Database after fatal User Error Blogbeitrag lesen »

By • • 5 minutes of reading
Uncategorized

OEM 12c Agent Deploy on Windows – no problem with Cygwin!

Agent 12c Deploy Cygwin 01

Oracle Enterprise Manager Cloud Control 12c offers an easy way to add various targets with the Add Targets Wizard over the GUI. Beside normal hosts, databases, listeners and ASM also Exadatas, Middlware, Cluster Services and many more, espacially for monitoring and also with more or less configuration options. But if you want to integrate a simple server first, you need a so called Agent. The agent is an application which monitores directly on the host and communicates with the Enterprise Manager.

OEM 12c Agent Deploy on Windows – no problem with Cygwin! Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

Easy replication with SharePlex

shareplex migration

It was in 1999 when I first got some information about a replication tool for Oracle database. At that time I worked for a small consultancy company and had some experience with Oracle Advanced Replication because of a telecommunication project. SharePlex looked exciting and I began to dig into the features and functions and within the next years I became more and more familiar with that product. In 2002 we had a project where the customer already used Oracle standby for disaster recovery and was not satisfied because of the following problem. Even though there was a process to create

Easy replication with SharePlex Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Multitenant Snapshot Copy

snapshot copy

Snapshot clones are available with various techniques, like clonedb with 11.2.0.3 or the already mentioned software company Delphix. The most common ones are using storage technologies like ZFS or NetApp. Starting with Oracle 12.1.0.1 it was also possible using snapshot clones with pluggable databases within the multitenant database architecture. But it was limited to file systems that support sparseness and ACFS. With the first patch set 12.1.0.2 it’s possible to use direct NFS as well for snapshot copies. As direct NFS becomes more and more popular for database storage this is a real shift towards the usage of snapshot copies.

Multitenant Snapshot Copy Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Toad – My DBA Tool

database browser

For more than 20 years my profession is the Oracle database administration. Starting in the early 90th on DEC VMS with a VT-100 terminal I’ve worked with many different tools. SQL*Plus is of course the most important one because it’s available from the beginning and replaced sqldba and later on srvmgrl. But in 1999 I had the pleasure working with a tool which was intended to help Oracle PL/SQL developers: Tool for Oracle Application Development (T.O.A.D).

Toad – My DBA Tool Blogbeitrag lesen »

By • • 4 minutes of reading
Scroll to Top