Once upon a time, there was an Oracle RAC cluster 12.2.0.1 on SUSE Linux Enterprise Server (SLES) 12 SP2, that did not do well. Its database and ASM instances used to fail with: ORA-27300: OS system dependent operation:fork failed with status: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred at: skgpspawn3 Of […]
Oracle 12.2 sysctl.conf Default Preinstall Settings
This are the currently active settings, the oracle-database-server-12cR2-preinstall.rpm delivers on Oracle Linux 7. Maybe it’s useful for you when setting up Oracle 12.2 on SUSE / SLES where you are on your own. Maybe you also want to add Huge Pages: # Performing Databases Huge Page Settings # for SGA size 200GB and huge page […]
Oracle RAC 12.2 on SLES12 – How to disable Hardware Lock Elision Support
The Problem In the last week, I had to set up an Oracle RAC (and thus, the Clusterware) version 12.2.0.1 on SuSE Linux Enterprise Server 12 SP2 (SLES12 Sp2). The gridSetup.sh failed latest in root.sh of the first node with a kinda non-intuitive error: CRS-5804: Communication error with agent process CRS-4000: Command Start failed, or […]
Oracle RAC 12.2 High Load on CPU from gdb when Node Missing
Recently I had to battle a new issue with the quite-new Oracle Database RAC Version 12.2.0.1 on Linux x86_64. The idea of RAC is, to compensate the loss of a node or service by restarting services on other nodes. But in my case, when one node in a two-node-Cluster was down (or the crs stack […]
Restarting Oracle for Performance is like a Coitus for Virginity
Today I had another case of that … total breakdown of a live environment by infrastructure defect, bad enough. Customer rushing up the database and all apps services, just to see thousands of locks and hanging transactions. Big panic, frequent restarting of databases and applications. Getting worse, finally calling me. Told them I’ll manage that, asked […]
Oracle RMAN destination with variable restrains “not backed up” clause
Today I was a bit surprised – being always under the impression that Oracle RMAN should accept “backup backupset not backed up to destination ‘xyz’” AND work with it successfully. But I learned that in 11.2.0.4 the Oracle RMAN “to destination” containing variables restrains the “not backed up” clause. No error thrown, but just does not work […]
Oracle Database 12.2 on-premises release dates
Oracle recently announced the availability of Oracle Database 12c release 2 (12.2) for on-premises servers. https://www.performing-databases.com/en/2017/01/oracle-database-12-2-on-premises-release-dates/ Linux x86-64, Solaris SPARC and Solaris x86-64: 15-Mar-2017 Other supported platforms (Windows x86-64, IBM AIX on POWER, IBM Linux on System z, HP UX Itanium): Q2CY2017 Source: MOS DOc ID 742060.1 […]
Oracle Enterprise Linux 7: How to stop bash tab completion from escaping the dollar $
Did you ever wonder why bash in Oracle Linux, Red Hat Enterprise Linux and other recent Linuxes escapes the dollar sign ($) when completing paths with the tabulator (tab) key like that: [oracle@oratest01 ~]$ (KLM12102) ls -l \$ORACLE_BASE/diag Answer In bash >= 4.2.29 you have a “direxpand” option, which is NOT set by default. The […]
Oracle: How to identify SQL doing TABLE ACCESS FULL on a given partition
In my last post, I described a quick show case for Oracle 12c Automatic Big Table Caching. But ABTC is just a crock, nevertheless a useful one. The biggest help from Automatic Big Table Caching for “sustainable” database performance management is the temperature of segments, heated up by TABLE ACCESS FULL. In my case, after enabling ABTC […]
Oracle Automatic Big Table Caching – an improvement, not a fix
Too much TABLE ACCESS FULL in your Oracle Database? Thus, SQL elapsed time too slow for the demand? Plenty of Buffer Cache to create a temporary fix? maybe you want to consider Automatic Big Table Caching. Usually, Oracle only does Full Table Caching for small tables. Big ones will only use the Buffer Cache for the current chunk […]