As Oracle announce in there MOS Note 793512.1 EM 12c Cloud Control will be release in Q4. I would have bet it comes on 31 December, but Oracle just released EM12c for SPARC Solaris as well as for Solaris x86_64.
I was on leave for the past few weeks. After digging through tons of e-mails I finally found time to look into EM 12 Cloud Control. Unfortunately, I’ve forgotten my SYSMAN password and the EM 12c test installation is no longer running. As you say: “Holidays where one forgets everything, must be good holidays.”
My second update on the post “Howto install Oracle Enterprise Manager Cloud Control 12c Release 1”. It seems that Oracle planned to release EM12 for Solaris later this year.
Oracle has just officially released the CPU / PSU Patches for october 2011. In contrast to the previously announced 56 bug fixes, there are now 57 bugfix. It looks like another bug fix for databases has been added to the CPU / PSU bundle.
In the past few days Oracle has released a bunch of MOS Notes about Enterprise Manager Cloud Control 12c. If you plan an installation it is worthwhile to take a look inside.
Oracle has recently published the Pre-Release Announcement for the CPU Patch. This Critical Patch Update contains 56 new security vulnerability fixes for several Oracle products. 4 of these fixes are just for the Oracle Database Server.
After downloading the latest release of Enterprise Manager Cloud Control I’ve started a initial test installation. In the past I had already installed Oracle Enterprise Manager 10.2.0.5.0 and 11.1.0.1 as well as some earlier releases. Some of the installations have been rather cumbersome and frustrating. Such as the installation of OEM GC 10.2.0.5.0, where even the software and patch download was quite challenging. Followed by some silent installations with “configure later”. Big question for EM 12c, is it still the same hassle? What’s different, better or worse? Keep reading the blog post to find the answers to these and other questions.
Just a few hours ago Oracle introduced the latest version of Enterprise Manager at the Oracle Open World. The new Release is now named Oracle Enterprise Manager Cloud Control 12c. And the best part is, the version for Linux can already be downloaded from OTN.
Just realized, that the Patchset 11.2.0.3.0 has been released for Solaris SPARC 64 and Solaris x86-64
Almost a week ago Oracle has released the latest patch set 11.2.0.3.0 for Oracle 11g Release 2. So far the patch set has only be released for Linux 32bit and 64bit.
It looks that not only diamonds are forever but also tablespace quotas. Due to the fact that Oracle has a history of tablespaces, it’s kind of obvious that it also keeps information quotas. Is this an expected behavior? What could be the impact ?
Tablespace point in time recovery (TSPITR) in particular, the fully automatic TSPITR is not a 11g new feature. It is likely that this can be used without any problem. But it looks like that a bug has been introduced with the latest patchset (11.2.0.2). What is the problem and how can it be workaround?
What happens to my database when switching on Oracle standard audit? Should set AUDIT_TRAIL to the DB or to OS or XML? To answer the last question we have to consider the safe storage and analysis of audit data. Is that all? What about Performance?
Setting up database audit is fairly easy. Since the availability of DBMS_AUDIT_MGMT the housekeeping of the audit trail is just a trifle. After the introduction of DBMS_AUDIT_MGMT in an post early this February, I would like to take a closer look at the housekeeping of the Audit Trail and provide a simple example how this could be implemented.
Since a couple of week’s a bunch of patch are available for Oracle Database Firewall. The latest seems to be available since today.
When performing a database security audit various informations about users, roles and privileges have to be collected, including “who has unlimited tablespace on SYSTEM”. It is quite easy to find user with UNLIMITED TABLESPACE or a UNLIMITED quota on SYSTEM. But what when the system privilege is assigned to a role or over several roles? It is still easy if you use hierarchical queries to drill down the cascaded roles, but there is plenty to write…
When switching from Mac OS Terminal.app to iTerm I realized that the
ps
does not work as expected. A
ps -ef
throws an error even if
man ps
shows an option for -f. It seems that the compatibility can be set with a environment variable COMMAND_MODE.
For the CPU Patch test I’ll have to download a patch’s and patchset on a regular basis. Download the patch’s via a Web browser can be very time consuming. A download manager or a script based download is simplifying the patch download. As a side effect when downloading with a script, the files can be stored directly on the database or a staging server.
Installing the Oracle Database Firewall is quite easy according the documentation. Nevertheless there could be a few pitfalls when installing it in a VM environment. Plugin a physical network cable is not as plugin a virtual cabel…
Late last week Oracle published the Oracle Critical Patch Update Pre-Release Announcement – April 2011. The official Oracle Critical Patch Update for April 2011 will be released somewhen on the 19th of april. This CPU includes up to 73 security fixes for all kind of Oracle products. 6 out of them are just forfor the […]
Installing the Oracle Database Firewall is quite easy according the documentation. Nevertheless there could be a few pitfalls when installing it in a VM environment. Plugin a physical network cable is not as plugin a virtual cabel…
Just finished my presentation about audit management with DBMS_AUDIT_MGMT at the SOUG Special Interest Group Event in Baden. I’m glad having a MIFI so I can immediately upload the slides 🙂 and still have some time for the aperitif…. I’m happy for any comment on the presentation or the slides. Feel free to add a […]
On the 24 of March I’ll have a presentation on Database Audit and DBMS_AUDIT_MGMT at the SOUG SIG Event. The presentation is about 30 minutes and will cover a rough overview of DBMS_AUDIT_MGMT, latest Issues and Bugs as well some Ideas on how audit could be simplified. Have a look at the SOUG Webpage for […]
With 11g R1 Oracle introduced case sensitive passwords for database accounts based on the SHA1 hash algorithm. This feature can easily be enabled with the init.ora parameter SEC_CASE_SENSITIVE_LOGON. As soon as this parameter is set to true, all new passwords will be case sensitive. Existing passwords will remain case insensitive until they are changed.
The downside of this new feature is, that the passwords are also stored with the pre-11g database password hash. This is a potential security leak. The pre-11g password hash string from USER$ can be used to crack the case insensitive version of the password. All kind of tools, utilities, password lists etc are available to do this. As soon as the case insensitive version of the password is known, the case sensitive password can be guessed.
To get rid of this security leak, the pre-11g database password hashes have to be cleared. This blog post shows how this can be done.
I’ve recently wrote an DOAG article about Managing Audit Trails with dbms_audit_mgmt, which has been officially introduced in Oracle 11g R2. This blog post is just to link the article and provides a few more information.
Oracle released the January Critical Patch Update. Over all it includes 66 fixes, 7 out of them are just for Oracle Database Server (Database Server, Secure Backup, Audit Vault).