About

Martin Klier

usn-it.de

Create Oracle Data Guard Standby with DBCA

Demands of Automation You can easily create an Oracle Data Guard Standby Database with the Database Configuration Assistant DBCA. That’s especially interesting if you have automation at work, and are not keen on configuring stuff all over the place. This is available in version 19c upwards. DBCA uses RMAN DUPLICATE FOR STANDBY with an auxiliary […]

read more

ORATOP in Oracle 19c

In 19c , the useful utility “oratop” is shipped with the Oracle Home installation. It was linked to the recent libaries, and its command line syntax changed. Error This leads to errors when calling one of the old “download” binaries like oratop12c-64.bin in a 19c environment: /home/oracle/bin/oratop12c-64.bin: error while loading shared libraries: libclntshcore.so.12.1: cannot open […]

read more

Oracle on SLES12 SP2 – Avoiding Cgroup Task Limit

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 […]

read more

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 […]

read more

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 […]

read more

Chemnitzer Linux Tage 2015

Last weekend, I had the chance to attend the Linux Days Chemnitz. It’s an annual meeting of the German Linux family with roundabout 2,500 attendees and a FANTASTIC atmosphere. It was two days of hearing tech talks, enjoying rich nerd content and talkin’ shop. […]

read more

New German Linux Forum (forum.linux-talk.de)

In the last weeks, some folks were busy to build a new German Linux Forum “forum.linux-talk.de”, since the predecessor was systematically ruined by the commercial owners. Especially Jean (wdp) and Hendrik (Nilpferd) invested much time and money into building the new environment. So the new forum is completely free of ads and commercials, and the […]

read more