New version of

A new version of is available on GitHub. Continue reading “New version of”


Oracle Enterprise Manager Audit

Why you should read this blog post? You need to take care of the Audit function from OEM CC even if you don’t want to use it. It’s enabled by default and needs to be managed! Continue reading “Oracle Enterprise Manager Audit”

kfed/kfod – What you need to know

Both utilities are rarely used – usually in case you already ran into a problem. But it’s useful to have basic knowledge because otherwise it’s hard to start with them. This blog post should give you an overview what the utilities are made for. Continue reading “kfed/kfod – What you need to know”

Check options linked into ORACLE_HOME

NEW SCRIPT! – It check the options linked into the oracle software as described in MOS note “How to Check and Enable/Disable Oracle Binary Options (Doc ID 948061.1)” Continue reading “Check options linked into ORACLE_HOME”

local_listener is set to a wrong port

The parameter local_listener of the asm instance is maintained by the clusterware and sometimes set to a wrong value. A port which is higher then the defined port of the local listener.

SYS@+ASM2> show parameter local_li
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1526))

I faced the bug only in the following configuration:

  • cluster installed with version
  • patch level newer 160119
  • more then 2 cluster interconnects
  • FlexASM

Continue reading “local_listener is set to a wrong port”


In MOSC I read about OraTcpTest and had a short look at MOS note 2064368.1 . The scope of the tool is to measure network performance for Dataguard environments.
In the past I used iperf – a default Unix tool – but it has to be installed and it’s hard to set the options exactly matching the database. Often the results were not the same as the database ones. OraTcpTest should do it better. Continue reading “OraTcpTest”


orachk is nothing new and was former known as raccheck, long time ago and the functionality increased a lot! It checks your environment for possible wrong configurations and best practices from oracle. The number of checks increase with each version. here you can see all the checks. You can check an existing installation or improve your standard configuration with the recommendations. I like to use it, after a cluster setup or upgrade or operating system upgrade. It’s not limited to Database, Clusterware or Operating System, but in this blog it is. Main MOS Note and Doku. Exachk is an own tool, but belongs to the same family. Continue reading “orachk”