Oracle 12c - Das umfassende Handbuch

Kapitel 29

Real Application Clusters

718

29.4 Real Application Clusters administrieren

Die Administration einer RAC-Datenbank erfordert einige Besonderheiten zu

beachten. Behalten Sie stets im Hinterkopf, dass es sich immer noch um eine

ganz normale Oracle-Datenbank handelt, die von mehr als einer Instanz

bedient wird. Bevor wir uns weitere Details anschauen, wollen wir überprüfen,

ob die erstellte RAC-Datenbank und die Cluster-Umgebung korrekt installiert

wurden.

29.4.1 ORAchk

»ORAchk« ist ein Health Check-Werkzeug für Oracle-Datenbankserver, Datenban-

ken und RAC. Es war früher bekannt als »RACcheck Oracle Configuration Audit

Tool« und verfügbar auf der Oracle Support-Website. Die Stärke des Tools liegt

darin, dass es Prüfungen in fast allen Bereichen einschließlich RAC und Cluster-

ware durchführt. Prüfen wir also den soeben erstellte Oracle-Cluster mit der RAC-

Datenbank.

-------------------------------------------------------------------------

Cluster Resources

-------------------------------------------------------------------------

ora.mitpr.db

1 ONLINE ONLINE mitpr1 Open,STABLE

2 ONLINE ONLINE mitpr2 Open,STABLE

. . .

Listing 29.9: Neue Cluster-Komponenten

$ ./orachk

Checking ssh user equivalency settings on all nodes in cluster

Node mitpr2 is configured for ssh user equivalency for oracle user

Searching for running databases . . . . .

List of running databases registered in OCR

1. MITPR

Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

---------------------------------------------------------------ßß-------------

Oracle Stack Status

-----------------------------------------------------------------ßß-----------

Host Name CRS ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB

------------------------------------------------------------------------------

mitpr1 Yes Yes Yes Yes Yes Yes MITPR1

mitpr2 Yes Yes Yes Yes Yes Yes MITPR2

------------------------------------------------------------------------------

. . .

29.4

Real Application Clusters administrieren

719

=============================================================

Node name - mitpr1

=============================================================

Collecting - ASM DIsk I/O stats

Collecting - ASM Disk Groups

Collecting - ASM Diskgroup Attributes

Collecting - ASM disk partnership imbalance

Collecting - ASM diskgroup attributes

Collecting - ASM initialization parameters

Collecting - Active sessions load balance for MITPR database

Collecting - Archived Destination Status for MITPR database

Collecting - Cluster Interconnect Config for MITPR database

Collecting - Database Archive Destinations for MITPR database

Collecting - Database Files for MITPR database

Collecting - Database Instance Settings for MITPR database

Collecting - Database Parameters for MITPR database

Collecting - Database Properties for MITPR database

Collecting - Database Registry for MITPR database

Collecting - Database Sequences for MITPR database

Collecting - Database Undocumented Parameters for MITPR database

Collecting - Database Workload Services for MITPR database

Collecting - Dataguard Status for MITPR database

Collecting - Files not opened by ASM

Collecting - Log Sequence Numbers for MITPR database

Collecting - Percentage of asm disk Imbalance

Collecting - Process for shipping Redo to standby for MITPR database

Collecting - RDBMS Feature Usage for MITPR database

Collecting - Redo Log information for MITPR database

Collecting - Standby redo log creation before switchover for MITPR database

Collecting - /proc/cmdline

Collecting - /proc/modules

Collecting - CPU Information

Collecting - CRS active version

Collecting - CRS oifcfg

Collecting - CRS software version

Collecting - CSS Reboot time

Collecting - CSS disktimout

Collecting - Cluster interconnect (clusterware)

Collecting - Clusterware OCR healthcheck

Collecting - Clusterware Resource Status

Collecting - DiskFree Information

Collecting - DiskMount Information

Collecting - Huge pages configuration

Collecting - Kernel parameters

Collecting - Maximum number of semaphore sets on system

Collecting - Maximum number of semaphores on system

Collecting - Maximum number of semaphores per semaphore set

Collecting - Memory Information

Collecting - NUMA Configuration

Kapitel 29

Real Application Clusters

720

Das Ergebnis wird in einer Zip-Datei und einer HTML-Datei zusammengefasst.

In der HTML-Datei finden Sie sowohl eine Zusammenfassung als auch detaillierte

Hinweise zu den gefundenen Warnungen und Problemen bis hin zu Links auf

Artikel der Oracle Support-Website.

Collecting - Network Interface Configuration

Collecting - Network Performance

Collecting - Network Service Switch

Collecting - OS Packages

Collecting - OS version

Collecting - Operating system release information and kernel version

Collecting - Oracle Executable Attributes

Collecting - Patches for Grid Infrastructure

Collecting - Patches for RDBMS Home

Collecting - Shared memory segments

Collecting - Table of file system defaults

Collecting - Voting disks (clusterware)

Collecting - number of semaphore operations per semop system call

Collecting – slabinfo

Preparing to run root privileged commands mitpr1.

. . .

Collecting - Network interface stats

Collecting - Number of RDBMS LMS running in real time

Collecting - OLR Integrity

Collecting - Root user limits

Collecting - Verify no database server kernel out of memory errors

Collecting - root time zone check

Data collections completed. Checking best practices on mitpr1.

------------------------------------------------------------------------------

WARNING => Without ARCHIVELOG mode the database cannot be recovered from an

online backup and Data Guard cannot be used. for MITPR

WARNING => Local listener parameter is not set to local node VIP for MITPR

INFO => Hugepages configuration is NOT Correct for MITPR

WARNING => NIC bonding is not configured for interconnect

WARNING => NIC bonding is NOT configured for public network (VIP)

WARNING => OSWatcher is not running as is recommended.

. . .

-----------------------------------------------------------------------------

1 Recommended CRS patches for 121010 from /opt/oracle/app/12.1.0/grid

-----------------------------------------------------------------------------

Patch# CRS ASM RDBMS RDBMS_HOME Patch-Description

-----------------------------------------------------------------------------

17735306 no no /opt/oracle/app/oracle/product/12.1.0/dbhome_1GRID

INFRASTRUCTURE SYSTEM PATCH 12.1.0

-----------------------------------------------------------------------------

. . .

Listing 29.10: Die Prüfungen von ORAchk