Instance Caging - Managing Multiple Database Instances on a Single Server

Instance caging is another small but useful feature of Oracle Database 11g Release 2. Thanks to it the database resource manager is able, to limit the number of CPUs that can be used by a given instance simultaneously. This feature allows Oracle DBAs to easily manage Oracle Instance CPU consumption.

There are two typical approaches to instance caging for a server:

• Over-provisioning:
  In this approach, the sum of the CPU limits for each instance exceeds the actual number of CPUs on the system.
• Partitioning:In this approach, the sum of allocate CPUs for each instance is equal to the number of CPUs on the server

ASM Processes parameter setting is dependent on the number of databases that connect to ASM

Setting init.oraparameter ASM instance
Use default values sesettings. Only processes parameter may need modification.
Processes parameter setting is dependent on the number of databases that connect to ASM processes= 25 + 15n, where n = # databases connected to ASM.
If max processes is reache on ASM, this indicaties offten on hanging processes of cluster agents or RMAN processes

Oracle Goldengate first acquaintance

The Oracle's strategic solution for real time data integration. Oracle GoldenGate provides low-impact capture, routing, transformation, and delivery of transactional data across heterogeneous environments in real time

Oracle GoldenGate (OGG) Presentation Transfer-Solutions 

RAC Configuration Audit Tool - RACcheck

RACcheck

RACcheck is a RAC Configuration Audit tool designed to audit various important configuration settings within a Real Application Clusters (RAC), Oracle Clusterware (CRS), Automatic Storage Management (ASM) and Grid Infrastructure environment.

Oracle Cloud File System - Grid Infrastructure ASM features “ACFS”

Licensing policy for ASM Cluster File System (ACFS), now called Oracle Cloud File Systerm, is free to use in combination with any Oracle RDBMS version. De files must have a relation with the RDBMS, including non-Oracle files related to the RDBMS application. See the citation below

Citation from the Oracle documentation:

A restricted use license to use Oracle Cloud File System is included with all editions of the database specifically for storing Oracle Database-related configuration files, including Oracle Database software binaries and homes, Oracle Database software administrative files, and Oracle Database software diagnostic files. Customers wishing to store their own data files, or non-Oracle Database software files including data files, binaries, administrative files, and diagnostic files, in Oracle Cloud File System must separately license Oracle Cloud File System.

This means "Extra charging for “user data” files like RMAN backups, exports and other database related files just makes life more difficult for clients that have committed to running their business on Oracle Clusters."

Oracle Cloud File System Licensing Requirements. This MOS 1322405.1 try to be an attempt to clarify the situation on Oracle CloudFS (0ACFS) Oracle Licence.

WARNING: Subscription for node down event still pending in Listener log

In the listener log file you constantly get the following warning message.

WARNING: Subscription for node down event still pending.

The warning messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification  Service (ONS). This subscription to ONS is introduced in Oracle 10g for RAC environment. Listener subscription to ONS is useful to use advanced features like Fast Application Notification events(FAN) , Fast Application Fail over (FAF) and Fast Connection Failover (FCN) in RAC. So in a non-RAC environment subscription to ONS is not needed. So in a standalone system we can disable it and thus avoid warning message.

Point of Interest Oracle GoldenGate

Point of Interest for Oracle GoldenGate

View more presentations from joord01.

Oracle performance and Time Measurements Within a Virtual Machine

Customers often ask to what extent they can trust performance measurements and timing results of the Oracle database within a virtual machine. To fully understand the performance of applications running in a virtual machine, we can give some general guidance.