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”
The recommendation from Oracle is to switch from Patch Set Update (PSU) to Proactive Bundle Patch (PBP) only by installing a new patchset or release. i.e 188.8.131.52 to 184.108.40.206 or 12.1.0.X to 220.127.116.11. But it’s possible at any time even rolling.
The idea is quite simple:
In the environment of the cluster owner or some scripts, you may want to set a variable for the cluster installation usually called CRS_HOME, GRID_HOME or simly ORACLE_HOME.
I like to do that in an automatic and non-static way. But be careful, this means it could go wrong or is being set to an unexpected value.
The main part of this post is how get the information and how to check for an acceptable value. Continue reading “How to determine CRS_HOME”
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 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ 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 18.104.22.168
- patch level newer 160119
- more then 2 cluster interconnects
Changing the size of your disk groups (DG) is quite easy if the disk groups are empty. if the total amount of space used in all DGs is less then the smallest DG it’s possible to change the size. it’s like playing towers of Hanoi, you must move your data several times. This is not described here. Here you find instructions to change the size with empty DGs. Continue reading “Exadata storage reconfiguration with empty DGs”
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”
Network Address Translation (NAT) and SCAN listener are not working out of the box, because the scan redirect to the local_listener value, usually a IP and not a DNS name. Continue reading “SCAN-Listener and NAT”