Knowledge Center Database Administration
A while ago I configured an encrypted column in a table for a customer in database 11g. To achieve this, a wallet had to be created outside the database. The main characteristic of this concept is that your data in the database is safe for unauthorized acces, so the wallet is seperated from the databases. All the advantages of this concept can be read in the Oracle documentation here.
As I am relatively new to these security concepts (not very much used), I was just curious what will happen when loosing this wallet at the operation system level. And, as database 12c has arrived, if this wallet and the encrypted data can be transported to a 12c-database (the level of backward compatibility). This is the more challenging, while 12c is not using wallets anymore, but keystores (for who is keeping his keys in a wallet…). I think it’s usefull to know that wallets actually work or don’t work in 12. Then it can be decided what effort has to be made preparing the change to keystores before any upgrade to 12c.
The steps I took:
1. Created a wallet and encrypt a column of a table in 11g.
2. Messing around on o.s.-level: deleted the wallet(s), restored the wallet, tried to recover the More >
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy and the roadmap for its close to 4000 thousand products. Concurrent with OOW is the JavaOne conference that – at a slightly smaller scale – does the same thing for the world of the Java platform, the JVM and the Java community.
AMIS each year sends a substantial delegation to attend and contribute to the conference. We speak in many sessions, ask questions in even more and do our utmost to gather information, digest it and distill the real meaning and relevant details. We have just completed our yearly review of the Oracle OpenWorld and JavaOne 2013 conferences: a 60-page PDF document that answers the ultimate question about life, the universe and everything [Oracle].
This white paper describes the major transitions that the industry at large and Oracle in specific is going through. It explains what these transitions mean to Oracle, cause in terms of product evolution and will result in for the users. The major product announcements are listed and commented on. The roadmaps for the most relevant More >
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and Thursday evening and an archivelog backup every few hours. These backups go to an NFS share, and not straight to tape. Everything is running fine until one day a new release of one of the applications messes up its data. Let’s assume that happened on a Wednesday evening.
Application management want’s you to restore the data of app_schema to just before the new misbehaving release went live.
DBA: Say what? Mgmt: Yes, we have a backup don’t we? So please put the data back to just before this release went live. We’ll come back with the exact time we want you to go back to.
What are your options? (more…)
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH partitioning. Some examples for the later two: (more…)
Afgelopen dinsdag is Oracle Database 12c beschikbaar gekomen, de nieuwste generatie van de Oracle database. AMIS biedt Oracle professionals de eerste mogelijkheid om de vernieuwingen in Oracle Database 12c in actie te zien.
Op maandag 15 juli organiseert AMIS het gratis seminar “Oracle database 12c revealed”. De AMIS specialisten die meer dan een jaar bètatesten hebben uitgevoerd laten zien wat er nieuw is en hoe we dat de komende jaren gaan inzetten.
Het programma: 16:30 – 17:00 Ontvangst 17:00 – 18:00 Oracle Database 12c: een overzicht 18.00 – 18.45 Een bezoek aan de beroemde AMIS frietkar 19.00 – 20.30 Parallelsessies met live demo’s: Nieuwe features in SQL en PL/SQL voor ontwikkelaars Nieuwe features voor database-administrators en -architecten 20:30 Borrel in het AMIS café
We hebben ruimte voor 80 mensen. Als er meer interesse is, dan openen we een wachtlijst. Schrijf je daarom snel hier in.
A small enhancement, but what a golden nugget! At least that’s what I think.
It is now possible in Oracle 12c to export data via a view. I my realm, Oracle XMLDB, that can be an interesting feature to export stored XML content in a relational format and import it, for example, in a relational table/environment. Let me show you how.
Lets create an XMLTYPE table and insert some XML into it: (more…)