Joords Oracle DBA blog

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

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

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

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.

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 fi...

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 for Oracle GoldenGate View more presentations from joord01 .