Stefan Oehrli

This blog is a mirror of http://www.oradba.ch
  • Stefan Oehrli

    DOAG / SOUG Security-Lounge at Basel

    The DOAG regional group is organizing together with SOUG a Security Lounge on the 24th of April. I'll attend this event with two short presentations on Database Security and Oracle Auditing. Continue reading →
  • Stefan Oehrli

    Update: DOAG / SOUG Security-Lounge at Basel

    Slides of the two presentation from the Security Lounge organized by SOUG and DOAG regional group Freiburg. Continue reading →
  • Stefan Oehrli

    Important links around the Oracle CPU / PSU April 2012

    A few weeks ago oracle officially released the CPU / PSU Patches for April 2012. The Critical Patch Updates contains 88 security fixes across all products. But only 6 out of this 88 fixes are for Oracle databases. This post will summarize a bit the information...
  • Stefan Oehrli

    Oracle Database Security Seminar – New dates

    Oracle Germany organizes two additional Database Security Seminar. I'm once again participate with my presentation "Oracle Security - How much should it be?" Continue reading →
  • Stefan Oehrli

    Oracle TNS Poison vulnerability

    A few days after the last critical patch update Oracle had to post security alert for CVE-2012-1675. The issue also known as "TNS Listener Poison Attack" is affecting any Oracle Database Server. As a personal reference I have summarized the...
  • Stefan Oehrli

    Enterprise Manager Cloud Control 12c Release 2

    Oracle announced the general availability of Enterprise Manager Cloud Control 12c Release 2. The release introduces a bunch of new and improve capabilities for deploying and managing business applications in an enterprise private cloud, such as Java Platform...
  • Stefan Oehrli

    Oracle CPU / PSU Pre-Release Announcement October 2012

    Today Oracle has published the Pre-Release Announcement for the october CPU Patch. This Critical Patch Update contains 109 new security vulnerability fixes for several Oracle products. 5 of these fixes are just for the Oracle Database Server. Continue...
  • Stefan Oehrli

    Oracle CPU / PSU Pre-Release Announcement January 2013

    Once again, Oracle has published the Pre-Release Announcement for the first CPU Patch in 2013. This Critical Patch Update is reasonably small and contains 86 new security vulnerability fixes for several Oracle products. Only one of these fixes is just...
  • Stefan Oehrli

    New Oracle Audit Vault and Database Firewall

    In the hustle and bustle of the Christmas season, it went under that Oracle had released a new version of Oracle Audit Vault respectively Oracle Audit Vault and Database Firewall. This weekend I found some time to take a first look into the new release...
  • Stefan Oehrli

    Oracle released CPU / PSU January 2013

    As announced in my post about Oracle’s pre-release announcement of last week, Oracle has now released the first Critical Patch Updates for 2013. Overall this CPU contains 86 new security fixes across several Oracle products like Database Server...
  • Stefan Oehrli

    SOUG Special Intrest Group Baden March 21st

    In about two weeks I will participate at the SOUG special interest group at Baden. I will present a paper entitled “New Security Features in latest generation of Oracle Database“. Where latest generation of Oracle Database not stand for an...
  • Stefan Oehrli

    DOAG SIG Security

    Just a couple of hours ago I’ve lecture a presentation about the latest Generation of Database Technology at the DOAG SIG Security in München. It is a sneak preview on a few upcoming security improvements. Unfortunately I do not yet have the permission...
  • Stefan Oehrli

    DOAG 2013 Datenbank

    As I announced a while ago in SOUG Special Interest Group Baden March 21st I’ll speak again about some improvements in the latest generation of Oracle Database. The content of the presentation is a mixture of the presentations I’ve lectured...
  • Stefan Oehrli

    Use of DEFAULT_CLEANUP_INTERVAL

    Following a question to the blog post Database Audit and Audit trail purging, I noticed something interesting about the DEFAULT_CLEANUP_INTERVAL parameter. On one hand, it is mandatory to initialize the audit trail and to define a DEFAULT_CLEANUP_INTERVAL...
  • Stefan Oehrli

    Fast lane to ORA-00600 service requests

    There are several way’s to find information on internal oracle errors like ORA-00600 and ORA-07445. Looking up google is one of them, but not in any case the best one. If you are using Oracle Metalink you may just search for the ORA-00600 and the...
  • Stefan Oehrli

    Pivot query on Automatic Workload Repository

    I’ve just tried to get a few information from the Automatic Workload Repository (AWR). I actually wanted to put together an overview of various system metrics from DBA_HIST_SYSMETRIC_SUMMARY to create a chart. Unfortunately the data is stored as...
  • Stefan Oehrli

    Oracle Database 12c somehow available

    Since a few hours Oracle Database 12c is available for download on Oracle eDelivery platform. Currently it is just available for Linux x86_64. I assume that the official release is getting closer. I’ll post more details on that as well on a couple...
  • Stefan Oehrli

    Oracle Database 12c

    Oracle still hasn’t officially announce the new Oracle Database 12c release. But since OTN database overview has been changed to 12c, I guess it is now somehow official. As rumors hinted, one of the main innovations are pluggable databases now named...
  • Stefan Oehrli

    Oracle 12c New Security Features

    I’ve just uploaded the slides for my lecture Oracle 12c new security features, as I had promised this in my previous posts. (See also DOAG 2013 Datenbank or DOAG SIG Security). The slides is a consolidation of my presentations on the New Security...
  • Stefan Oehrli

    Enterprise Manager Cloud Control 12c Release 3

    Oracle just released Enterprise Manager Cloud Control 12c Release 3. (see Oracle Enterprise Manager Downloads ) for all supported platforms. Is assume this release is related to Oracle Database 12c which has been released about a week ago. The new release...
  • Stefan Oehrli

    Error installing Audit Vault Agent 12.1.1 on AIX

    The Problem During the setup of the current audit vault agent 12.1.1 on AIX, I’ve run into issues. Depending on the configuration of the AIX environment, the agent can not be installed at all. avagent@achilles:/u00/app/avagent/ [avagent]...
  • Stefan Oehrli

    Oracle released CPU / PSU July 2013

    About a week ago Oracle has released the July Critical Patch Updates. Overall this CPU contains 89 new security fixes across several Oracle products like Database Server, MySQL Server, Sun Product Suite, WebLogic Server etc. For Oracle Database Server...
  • Stefan Oehrli

    Oracle 12c new password verify function

    Even with Oracle Database 12c, the quality of the database passwords is not enforced by default. A password verify function with the corresponding password resource limits has to be developed individually. As a basis one can use the script to setup the...
  • Stefan Oehrli

    Query alert log from sqlplus

    It is not really a novum that you can directly query the alertlog from SQLPlus. Tanel Poder and others already have discussed this a while ago. Somehow I can never remember the name of the X$ view when I need it. So it is time to sum up the information...
  • Stefan Oehrli

    Oracle database binaries with perl

    Perl and Oracle has not always an easy past. Depending on the OS type and Oracle Version it can be quite nerve racking to compile DBI and DBD::Oracle. In addition to DBD::Oracle there are also other binary Perl modules that are not so easy to compile...
Page 1 of 4 (85 items) 1234