Stefan Oehrli

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

    Eclipse Jira integration and SSLHandshakeException

    Basically I’ve solved this issue quite a while ago. Unfortunately I did not wrote any kind of documentation. That’s why I run again into SSLHandshakeException with my Eclipse installation on my new MacBook Pro, when trying to access our JIRA...
  • Stefan Oehrli

    Update agent.jar on audit vault server

    As I wrote in my post Error installing Audit Vault Agent 12.1.1 on AIX, there is a Audit Vault Agent bug 17058352 on AIX. Unfortunately it hasn’t yet been fixed in the latest bundle patch for Oracle Audit Vault and Database Firewall. If you haven’t...
  • Stefan Oehrli

    Update: ORA-00600 [kpdbModAdminPasswdInRoot: not CDB] when changing password of default account

    As discussed in my post ORA-00600 [kpdbModAdminPasswdInRoot: not CDB] when changing password of default account There is an unpublished bug 16901482 which cause an ORA-00600 when trying to set a new password for an Oracle default account like DBSNMP,...
  • Stefan Oehrli

    Oracle 11.2.0.4.0 Patchset released

    Oracle has released the patchset 11.2.0.4.0 for Oracle 11g Release 2. The current patchset is as well as the other 11g R2 patchsets a full installation. This means you will have to download quite a bit from Metalink, altogether 7 files. On My Oracle Support...
  • Stefan Oehrli

    ORA-00600 [kpdbModAdminPasswdInRoot: not CDB] when changing password of default account

    During the test on Oracle Database 12c I run into an interesting error respectively Chris Antongini has made me aware of it. If you try to change the password of an Oracle default account on a none CDB with SQL*Plus password you run into an ORA-00600...
  • Stefan Oehrli

    Oracle Database 12c New Feature: Last Login Time

    As Markus Flechtner has already mentioned in his blog, Oracle has started to record the last login time. It is a small but very useful 12c security feature and operates independently of the database audit. Nevertheless, there are some restrictions. But...
  • Stefan Oehrli

    OAV-46599 when trying to add new secure target on AVDV 12.1.1.1

    It is the second time that I run into this problem. Therefore, it is time to write a quick note before I struggle a third time. At some point adding a new secure targets no longer works and breaks with an OAV-46599. Initially I was a bit confused about...
  • Stefan Oehrli

    AVDF missing boot partition

    While working on the problem with missing RAM on the AVDF test system (see ) I realized, that the linux boot partition is not available by default. [root@melete2 log]# ls -al /boot total 16 drwxr-xr-x  2 root root 4096 Jan 11  2013 ...
  • Stefan Oehrli

    Audit Vault and Database Firewall 12.1.1 Bundle Patch 1

    Oracle just released the new bundle patch for Audit Vault and Database Firewall 12.1.1. The patch can be downloaded on metaling as RPM patch set for existing installations or as full installation images for new installations. According the readme, the...
  • Stefan Oehrli

    AVDF Linux kernel could not recognize whole RAM

    After initial setup of an Audit Vault and Database Firewall engineering system, I’ve started to add several audit vault agents and secure targets. In the beginning it went quite smoothly. But after a certain number of secured targets, there were...
  • Stefan Oehrli

    How to find latest oracle database patchset

    It is sometimes a bit of a hassle, to have the latest patch name or number on handy when you need them. Ok, you may create a search on My Oracle Support and save it as custom search. But it may happen that the search is inaccurate and the required patch...
  • 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...
  • 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 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

    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

    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

    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

    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

    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 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

    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

    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

    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

    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

    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...
Page 2 of 4 (90 items) 1234