or Publishing a cleanup script for Oracle 12c+ At the moment I’m just for fun collecting Linux scripts from my direct colleagues. And while I was busy to think up a wiki page for internal use, for a moment I felt like Uncle Scrooge, gathering riches from other minds. Which, […]
Karin Kriebisch
How to dynamically Schedule EM Blackouts after PatchTuesday
In the organization I’m currently working for, the OS-patch schedule depends on PatchTuesday (PT) just as Microsoft, Adobe or Oracle are using. And PatchTuesday is, as you all know, the Second Tuesday of each month. But this is a schedule you can not set in the Oracle Enterprise Manager Scheduler. […]
Upgrade Failure as Blessing in Disguise?
or The Findings of an Failed Enterprise Manager Upgrade to OEM13.3 When Oracle Enterprise Manager Cloud Control 13.3 (here just called EM 13.3) came available I read the upgrade documentation and decided that the most cost-effective option for us was to stay with EM 13.2. Later, a rumor about a […]
Creating a Report of available ASM candidate disks from the OEM Repository
A while ago I was reviewing the metric extensions of our Enterprise Manager Cloud Control 13.2.0.0, we use to administer a couple of hundred databases. All acceptance and production databases are installed on Linux RAC-clusters with underlying ASM storage. One of the custom reports summarized the size and number of […]
How a double entry for LAST_ARCHIVE_TIMESTAMP can stop your audit purge in 12c
In the last nine month we were busy migrating our 11g databases to 12c rel. 2. Due to time constrictions we decided early in the project to migrate 1:1. This meant that we did not make use of the CDB/PDB-feature. During the course of the upgrades my colleagues encountered a […]
My “Sinatra-Solution” for Error Code 235 of OMSPatcher 13.8.0.2
and How I resolved it …. My Way 235 … 235 … isn’t it an Interstate in Oklahoma? Is Oracle telling me that I’m now working with only 0.72% of all naturally occurring uranium? Was I testing the maximum speed of a BMW 3series? Or did somehow an Un-locked Control File […]
The Tale of the Ardent SpringCleaning Maniac (ASM)
or If you want to get rid of stuff, you can always do a good spring-cleaning. Or you can do what I do. Move. – Ellen DeGeneres In order to prepare for a network reorganization we needed to move our current Oracle Enterprise Manager machine into another network segment. So […]
Security Features of Standard Edition (One) – Part 2
or Some Musings on the Security Implications of Oracle Database Initialization Parameters Still following the steps of a database installation, this article will muse about some Initialization Parameters with security relevance. In order to make a Standard Edition database as secure as possible we could start by looking what is […]
Security Features of Standard Edition (One) – Part 1
or A closer look on database hosts The last couple of years quite a few organizations had a difficult time and internal costs where a main focal point was to save money. License costs was one thing where many IT-managers put their question marks and so often the decision was […]
How to hide login data of sql-scripts on Windows
One of the often given advices on hardening a database is to run scripts without broadcasting your login data at the same time. According to Arup Nanda in his famous articles on “Project Lockdown” you have three options to run your scripts without letting everybody in on your password secrets: […]
How to start/stop OC4J-standalone as a Windows service
In one of the previous blog-articles a colleague of mine described how to start an OC4J-container on the command line. Which was and is correct, but… I’m a database administrator and – Sorry Rob ;-)) we don’t like to leave machines with user – or even worse – administrative accounts […]
Having trouble with JBOExceptions during deployment of your ADF application on AS 10.1.3?
or How to deploy into an application-specific OCJ4-container on Oracle AS 10.1.3 without JBOExecption during deployment when your application uses ADF Lately our developers were working on an application which uses ADF and requested an Oracle AS 10.1.3 J2EE implementation as webserver for the deployment of this Java application. The […]
Using the Distributed Configuration Manager (DCM) command shell…
At first I couldn’t remember this dcm-commands and always had to type them at least twice untill… I learned about the “shell”- subcommand which is part of Oracle iAS’s since iAS9i Rel.1. Oddly enough, this shell is almost hidden behind a cloud of silence from Oracle’s side and I haven’t […]