O'Reilly logo

Oracle 12c - Das umfassende Handbuch by Lutz Fröhlich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required