Archive for September, 2013

Few days ago, we cloned a VM test system with ASM. Changing the hostname in this case is mandatory from our network, we have lots of issues if they are duplicate.

But changing an Oracle Restart or generally, Grid Infrastructure setup’s hostname isn’t so easy – it’s written many configs. The only way is to deconfigure and configure the Grid Infrastructure stack. If you have no special services configured, it’s quite straightforward, as my colleague Benedikt Nahlovsky describes.

If there are additional / self-made services, just recreate them with your scripts (don’t forget to change the hostname in them if you used it!)

A new product …

Last week I spent some days of intense investigation and testing the new database 12c. I found lots of great stuff (even about 11g :) ), and some for sure will make it into a separate blog post. So these are just my notes of a very interesting couple of days, and maybe it can be a guide for you when starting to dive deeper into the newest RDBMS coming from Redwood Shores. Just let me know your opinion, and maybe submit a comment.

Unfortunately, many of the new features are only available in Enterprise Edition or EE plus some options or additional products. As far as I knew the need, I marked my points accordingly. But don’t rely on my information, have a look at the most recent licensing guide!

One word before we start: Do nothing before you know WHAT you do. And with a new Oracle product, you CAN’T know what you do yet. So play happily, but don’t use it in production until second PSU or first patch set and its first PSU.

Oracle Database 12c Architecture

THREADED_EXECUTION parameter — Enables Multithreaded Architecture (MTA), intended to speed up internal work and saves process spawning. No OS authentication allowed, need to use the password file (thus, “sqlplus / as sysdba” and “rman target /” do not work any more)

USE_DEDICATED_BROKER parameter — use threads, not dedicated servers

v$process STID column — holds reference to the system thread in multithreaded architecture

Multitenant Database

After speaking about mutex waits last year, this time DOAG accepted my lecture “Oracle Architektur – nicht nur für Einsteiger” about Oracle Database basic architecture for this year’s DOAG Konferenz 2013 in Nürnberg. It will be the first lesson in a brand-new stream of the conference: The so-called “Einsteigerpaket” (beginners package) allows seeing a full stream of introductory talks by only purchasing a one-day ticket for the last day (thursday).

“Oracle Architektur – nicht nur für Einsteiger” will cover basic but important concepts of the Oracle RDBMS: How it makes ACID happen, what are Redo Logs, Undo Records, Before Images, how is locking done, and where not, and why all of those old day’s features allowed Oracle to introduce sophisticated stuff like RAC, Dataguard and Flashback without breaking bones.

Nuts and bolts is the topic, but on a level every IT technican should understand. Hope to see you there: 21.11.2013, 0900h, Room 19