Stefan Oehrli

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

    Database Audit and Audit trail purging

    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...
  • Stefan Oehrli

    Oracle Database Firewall Patch

    Since a couple of week's a bunch of patch are available for Oracle Database Firewall. The latest seems to be available since today. Continue reading →
  • Stefan Oehrli

    Find User with unlimited Tablespace Quota

    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...
  • Stefan Oehrli

    Mac OS X Terminal Compatibility Settings

    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 . Continue...
  • Stefan Oehrli

    Script to download Oracle Patch

    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...
  • Stefan Oehrli

    Oracle CPU Pre-Release Announcement – April 2011

    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...
  • Stefan Oehrli

    Oracle Database Firewall Test Environment

    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... Continue reading...
  • Stefan Oehrli

    Case Sensitive Passwords and Strong User Authentication

    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...
  • Stefan Oehrli

    Manage Audit Trails with DBMS_AUDIT_MGMT

    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. Continue reading →
  • Stefan Oehrli

    Oracle Critical Patch Update January 2011

    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). Continue reading →
  • Stefan Oehrli

    Managing Audit Trails

    I’ve recently wrote an DOAG article about Managing Audit Trails with dbms_audit_mgmt, which has been officially introduced in Oracle 11g R2. The same article will also be in the upcoming SOUG newsletter. The article itself is written in german and...
  • Stefan Oehrli

    Metalink Notes, some favorites

    If time permits, I try to have a look once a day at the Knowledge Articles listed on my My Oracle Support (MOS) Dashboard. I’ve configured my Dashboard to show recently updated knowledge articles and alerts. Before Metalink was migrated …...
Page 4 of 4 (87 items) 1234