All about R12 Oracle Home Inventories

The inventories are used by the Oracle Universal Installer (ORACLE_HOME)/oui (by reference, rapidwiz installers, too) and opatch utilities.
If they are not correct for the host you are working on, the utilities may abort with all sorts of errors.
The Oracle Universal Installer can also be used to re-create the inventory, or attach a pre-existing Oracle Home.
Formatted in XML syntax, all tags either end on a single line, or have a beginning and end tag associated with each entry.
Learning the actual structure of the file can be useful when dealing with non-Production environments when you’re upgrading and downgrading components, and need to roll-back certain changes, or are experimenting with modifying the filesystem layout. This way, if the inventory has minor errors (such as when the IDX numbers get out-of-sequence due to removed components, or you have to roll-back an OEM Agent upgrade to a plugin), you will have an idea where to correct the file to make your OUI happy again.

Useful references:
Master Note For Cloning Oracle Database Server ORACLE_HOME’s Using the Oracle Universal Installer (OUI) (Doc ID 1154613.1) https://support.oracle.com/epmos/faces/DocContentDisplay?id=1154613.1
How to Create a Clean oraInventory in Release 12 using the ouicli.pl utility (Doc ID 834894.1) – https://support.oracle.com/epmos/faces/DocContentDisplay?id=834894.1R12.0 / R12.1 : How To Create, Update or Rebuild The Central Inventory For Oracle Applications E-Business Suite ? (Doc ID 742477.1) https://support.oracle.com/epmos/faces/DocContentDisplay?id=742477.1

All () references refer to your unique environment’s actual physical filesystem locations – e.g. (ORACLE_BASE) might be /u01/app/oracle on your host.

## Master location files indicating which inventory is being used (can be manually modified to re-point to older legacy homes that are not multi-home aware)

## an 11g and older Middle-tier home locator
$> cat /etc/oraInst.loc
#Oracle Installer Location File Location
#Wed Dec 01 07:15:54 EST 2010
inst_group=oinstall
inventory_loc=(INST_TOP)/admin/oraInventory

## an 11g and older Database-tier home locator
$> cat /etc/oraInst.loc
inventory_loc=(DB_ORACLE_HOME)admin/oui/(ENV_ID)/oraInventory

## a 12c home locator – will be maintained in-parallel with the 11i version for now – multiple entries delimited by colons
$> cat /etc/oragchomelist

(ORACLE_BASE)/core/12.1.0.4.0:(ORACLE_BASE)/agent_inst

## A main R12 Middle-tier inventory, with a 12.1.0.4.0 OEM Agent
## located in (inventory_loc)/ContentsXML/inventory.xml
#Notes:
# REMOVED=”T” – means ignore this during reading of the inventory
# IDX=(n)     – a unique number assigned (preferably sequentially, but not required to be in numerical sequence in the file)
# HOME NAME=  – a unique name (without spaces or special characters) – there are specific naming formats are required by RapidClone for R12 components and should not be changed, the non-R12 labels are less strict.
# Note that the 12c entries begin to include version information for each individual sub-component (REF_HOME_LOC)

$> cat inventory.xml
<?xml version=”1.0″ standalone=”yes” ?>
<!– Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. –>
<!– Do not modify the contents of this file by hand. –>
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.1.0.12.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”OracleHome3″ LOC=”(ORACLE_BASE)/tech_st/10.1.2″ TYPE=”O” IDX=”4″/>
<HOME NAME=”OracleHome1″ LOC=”(INST_TOP)/ora/10.1.3″ TYPE=”O” IDX=”1″/>
<HOME NAME=”OracleHome2″ LOC=”(ORACLE_BASE)/tech_st/10.1.3″ TYPE=”O” IDX=”2″/>
<HOME NAME=”OH742297619″ LOC=”(ORACLE_BASE)/Middleware/oracle_common” TYPE=”O” IDX=”12″>
<REFHOMELIST>
<REFHOME LOC=”(ORACLE_BASE)/Middleware/as_1″/>
</REFHOMELIST>
</HOME>
<HOME NAME=”OH1912350525″ LOC=”(ORACLE_BASE)/Middleware/as_1″ TYPE=”O” IDX=”13″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/Middleware/oracle_common”/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”agent12c2″ LOC=”(ORACLE_BASE)/core/12.1.0.4.0″ TYPE=”O” IDX=”14″>
<REFHOMELIST>
<REFHOME LOC=”(ORACLE_BASE)/sbin”/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.outl.discovery.plugin_12.1.0.2.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.oet.discovery.plugin_12.1.0.3.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emfa.discovery.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.4.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emas.agent.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.agent.plugin_12.1.0.4.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.discovery.plugin_12.1.0.7.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.agent.plugin_12.1.0.7.0″/>
</REFHOMELIST>
</HOME>
<HOME NAME=”sbin12c2″ LOC=”(ORACLE_BASE)/sbin” TYPE=”O” IDX=”2″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome4″ LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.outl.discovery.plugin_12.1.0.2.0″ TYPE=”O” IDX=”7″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome1″ LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.oet.discovery.plugin_12.1.0.3.0″ TYPE=”O” IDX=”3″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome2″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”4″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome3″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emfa.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”5″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome5″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.4.0″ TYPE=”O” IDX=”9″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome6″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”8″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome11″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emas.agent.plugin_12.1.0.6.0″ TYPE=”O” IDX=”18″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome12″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.agent.plugin_12.1.0.4.0″ TYPE=”O” IDX=”19″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome7″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.discovery.plugin_12.1.0.7.0″ TYPE=”O” IDX=”15″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome8″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.agent.plugin_12.1.0.7.0″ TYPE=”O” IDX=”10″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome4″ LOC=”(ORACLE_BASE)/plugins/oracle.apps.ebs.discovery.plugin_12.1.0.1.0″ TYPE=”O” IDX=”6″ REMOVED=”T”/>
<HOME NAME=”agent12c1″ LOC=”(ORACLE_BASE)/core/12.1.0.3.0″ TYPE=”O” IDX=”1″ REMOVED=”T”/>
<HOME NAME=”OraHome6″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.agent.plugin_12.1.0.3.0″ TYPE=”O” IDX=”11″ REMOVED=”T”/>
<HOME NAME=”OraHome9″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”16″ REMOVED=”T”/>
<HOME NAME=”OraHome10″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.agent.plugin_12.1.0.6.0″ TYPE=”O” IDX=”17″ REMOVED=”T”/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

## The main Database-Tier inventory for an 11g R12 database host, with a 12.1.0.4.0 OEM Agent
## located in (inventory_loc)/ContentsXML/inventory.xml

$> cat inventory.xml
<?xml version=”1.0″ standalone=”yes” ?>
<!– Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. –>
<!– Do not modify the contents of this file by hand. –>
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.1.0.12.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME=”(ORACLE_SID)_DB__(ORACLE_SID_LOWERCASE)_db_tech_st_11_2_0″ LOC=”(ORACLE_HOME)” TYPE=”O” IDX=”1″/>
<HOME NAME=”agent12c1″ LOC=”(ORACLE_BASE)/core/12.1.0.4.0″ TYPE=”O” IDX=”2″>
<REFHOMELIST>
<REFHOME LOC=”(ORACLE_BASE)/sbin”/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emfa.discovery.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.apps.ebs.discovery.plugin_12.1.0.4.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.outl.discovery.plugin_12.1.0.2.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.discovery.plugin_12.1.0.7.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.oet.discovery.plugin_12.1.0.3.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.6.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.4.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.agent.plugin_12.1.0.4.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.agent.plugin_12.1.0.7.0″/>
<REFHOME LOC=”(ORACLE_BASE)/plugins/oracle.apps.ebs.agent.plugin_12.1.0.4.0″/>
</REFHOMELIST>
</HOME>
<HOME NAME=”sbin12c1″ LOC=”(ORACLE_BASE)/sbin” TYPE=”O” IDX=”3″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome1″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”4″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome2″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emfa.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”5″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome3″ LOC=”(ORACLE_BASE)/plugins/oracle.apps.ebs.discovery.plugin_12.1.0.4.0″ TYPE=”O” IDX=”6″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome4″ LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.outl.discovery.plugin_12.1.0.2.0″ TYPE=”O” IDX=”7″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome6″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.discovery.plugin_12.1.0.7.0″ TYPE=”O” IDX=”13″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome7″ LOC=”(ORACLE_BASE)/plugins/oracle.tugbu.oet.discovery.plugin_12.1.0.3.0″ TYPE=”O” IDX=”9″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome8″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.6.0″ TYPE=”O” IDX=”10″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome9″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.4.0″ TYPE=”O” IDX=”11″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome10″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.oh.agent.plugin_12.1.0.4.0″ TYPE=”O” IDX=”12″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome11″ LOC=”(ORACLE_BASE)/plugins/oracle.sysman.db.agent.plugin_12.1.0.7.0″ TYPE=”O” IDX=”14″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
<HOME NAME=”OraHome5″ LOC=”(ORACLE_BASE)/plugins/oracle.apps.ebs.agent.plugin_12.1.0.4.0″ TYPE=”O” IDX=”8″>
<DEPHOMELIST>
<DEPHOME LOC=”(ORACLE_BASE)/core/12.1.0.4.0″/>
</DEPHOMELIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

What’s New in Oracle Enterprise Manager (OEM) Cloud Control 12c Release 5 (12.1.0.5)

I kept getting asked what’s new in Release 5 – so here’s the summary of what’s changed since 12.1.0.4.0 (the prior release for the past 12 months):

OEM Release 5 Download Web Site
http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html

http://docs.oracle.com/cd/E24628_01/doc.121/e25353

What’s New in Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5)

  •     Oracle Cloud Management (Hybrid Cloud)
  •     Database Plug-in 12.1.0.8 Features
  •     Fusion Middleware Plug-in 12.1.0.8 Features
  •     Cloud Management Plug-in 12.1.0.10 Features
  •     Chargeback and Consolidation Planner Plug-in 12.1.0.7 Features
  •     Virtual Infrastructure Plug-in 12.1.0.2

Oracle Cloud Management (Hybrid Cloud) – This enhancement is new in Enterprise Manager Cloud Control Release 5 (12.1.0.5).
Enterprise Manager Cloud Control now provides you with a single pane of glass for monitoring and managing both your on-premise and Oracle Cloud deployments, all from the same management console. By deploying Management Agents onto the Oracle Cloud virtual hosts serving your Oracle Cloud services, you are able to manage Oracle Cloud targets just as you would any other targets. The communication between Management Agents and your on-premise Oracle management service instances is secure from external interference. Support is provided for managing Oracle Database and Fusion Middleware PaaS targets, as well as JVMD support for monitoring JVMs on your Oracle Cloud virtual hosts.

Oracle Cloud Management includes the following key features:

  •     Automated agent deployment and configuration
  •     Database and Java PaaS instances monitoring
  •     Incident management including notifications and ticketing integration
  •     Configuration management including Search and Inventory, comparison between on-premise and cloud instances, configuration history, and compliance
  •     Cloning between on-premise and Oracle Cloud
  •     One-off patching of Oracle Cloud database instances

Database Plug-in 12.1.0.8 Features

  • Snap Clone Leveraging Sparse Clones on Exadata
    You can now create a Test Master pluggable database (PDB) to use as the snapshot source for thin cloning on Exadata ACFS.
    For functional testing scenarios, for example on development or testing systems, business IT users now have on-demand access to production data copies without incurring the penalty of multi-terrabyte storage.
  • Data Cloning to Oracle Cloud
    With this release you have the following data cloning to Oracle Cloud options:

    • Like-to-like cloning: on premise to-from Oracle Private Cloud:
      Enterprise Manager12c PDB to 12c PDB, assuming the containers exist on both sides
      Regular non-container dedicated database to dedicated database
    • Like-to-unlike data migration:
      Regular to PDB migration where the source is an on-premise non-PDB database and the data is migrated to a cloud based PDB
      PDB to normal database migration where the source is a PDB on an Oracle PaaS cloud and data and schema are migrated to a non-container CDB on premise

Fusion Middleware Plug-in 12.1.0.8 Features

  • Generic JVM Provisioning for Private Cloud
    This feature enables self-service users to provision non-Oracle middleware components as cloud services. It also uses Enterprise Manager’s chargeback and quota management capabilities to enable administrators to limit service usage based on organizational policies.
  • JVMD Support for PaaS
    Enterprise Manager Cloud Control now enables you to deploy JVMD agents on your Oracle Cloud virtual hosts. These deployed JVMD agents can report to a JVMD engine deployed in your private network. This feature enables you to monitor the JVMs deployed on the virtual hosts running your Oracle Cloud services as well as the JVMs deployed on the hosts in your private network using a single console, for example Enterprise Manager Cloud Control deployed in your private network.
  • Middleware Self Service Portal Support for Virtual Java as a Service with Exalogic Systems
    WebLogic services that have been provisioned on Exalogic systems using Service Manager can now be viewed in the Cloud Self Service Portal as part of the Exalogic Private Cloud service family.
  • MWaaS on Solaris SPARC
    This project integrates MWaaS with the Oracle Enterprise Manager Ops Center. It provides the ability to dynamically add or remove the virtual hardware in a MWaaS cloud.

Cloud Management Plug-in 12.1.0.10 Features

  • Dynamic Scaling of PaaS Zone Through Integration with the Sun Solaris SPARC Ops Center 12c Adapter
    Enterprise Manager 12c is integrated with the Ops Center through the Sun Solaris SPARC adapter. An instance of this registered adapter is used by the associated PaaS Infrastructure zone to provision or delete VMs on demand. The communication with the Ops Center server is achieved through the use of a client kit.
    This integration enables customers to provide layered services capability in a private cloud, for example DBaaS using a Solaris VM based IaaS. Any spike in compute demand can now be handled instantly by cloud administrators.
  • DBaaS PaaS Provider Pools Integration with Ops Center
    Administrators can now increase the capacity of a DBaaS pool by clicking a single button. Doing this transparently provisions a virtual machine or cluster through the associated Ops Center adapter attached to the PaaS zone. It also deploys the requisite software components, for example Enterprise Manager Agent, Grid Infrastructure, Oracle Database and so on, through the gold image provisioning or by cloning from an existing reference member of the pool.
    Compute resource scarcity at PaaS provider level results in the failure of self service provisioning requests. This integration helps SSA administrators to respond to such failures promptly.
  • Clone to Oracle Cloud
    Administrators now have the ability to create a full clone of an Enterprise Manager 12c pluggable database amongst existing container databases within the on-premise IT infrastructure or to an Oracle Cloud. Administrators can also clone a service from on-premise to Oracle PaaS and vice-versa. The cloning is supported in two broad categories:

    •     Peer-peer clone: Clones directly from an on-premise target to Oracle Cloud.
    •     Clone through the Software Library: Administrators can archive a gold image into the Software Library in one step and then deploy it in a separate step.

Chargeback and Consolidation Planner Plug-in 12.1.0.7 Features

  • Host Consolidation Support for Oracle Cloud Shapes
    Oracle Enterprise Manager now provides host consolidation support for Oracle Cloud shapes. When creating scenarios for physical server to physical server (P2P) consolidations that target new or phantom destinations, you can choose physical machines configured in the Oracle cloud by selecting the cloud computing configuration, or shape, to use as the destination. Oracle provides a wide range of shapes to help you select a combination of processing power and memory for your instances that best suits your business requirements.

Virtual Infrastructure Plug-in 12.1.0.2

  • Dynamic Resource Provisioning Support
    Through integration with Oracle Enterprise Manager Ops Center, dynamic on-demand resource provisioning enables Oracle Cloud and self service administrators to dynamically increase or decrease resources in their private cloud setup based on usage requirements. Resources can either be infrastructure resources such as hosts (based on virtual machines) or platform resources such as middleware and database Oracle homes. Resources can be dynamically added when additional service instances need to be provisioned due to high usage or decreased if existing resources are not being used.

That’s it, in a nutshell.

A Not So Sweet Green Smoothie Recipe (Apple, Pineapple, Kale, Broccoli, Cucumber)

A Not So Sweet Green Smoothie Recipe (Apple, Pineapple, Kale, Broccoli, Cucumber)
A Not So Sweet Green Smoothie Recipe (Apple, Pineapple, Kale, Broccoli, Cucumber)

Not really crazy about starting days with overly sweet things.  I came up with this mix because it’s just enough sweetness to balance the bitterness of the greens, but doesn’t taste like you just downed a pureed fruit salad.

Rader Farms Frozen Smoothie Bag Mixes
Rader Farms Frozen Smoothie Bag Mixes

12 ozs (1/4 bag) of Fresh Start Fusion Daily Power frozen mix (green apple, pineapple, kale, broccoli) – it’s a Walmart thing – or just substitute the same with the individual ingredients, plus ice cubes, if you don’t want to freeze everything

Labne - kefir thick yogurt
Labne – kefir thick yogurt

4 ozs. Labne yoghurt/kefir (this is a very thick and dense yogurt, without any sweeteners or additives – several brands work, but you can substitute a home-made version by straining a non-sweetened plain yogurt in cheesecloth overnight, which will remove a lot of the extra whey liquid and create a denser protein content.)

Sprig of fresh mint

4 ozs. fresh cucumber

1 T fresh lemon juice

Blend it to desired smoothness.

Estimated nutritional content:

Calories 190 Sodium 95 mg
Total Fat 8 g Potassium 206 mg
Saturated 0 g Total Carbs 24 g
Polyunsaturated 0 g Dietary Fiber 4 g
Monounsaturated 0 g Sugars 12 g
Trans 0 g Protein 9 g
Cholesterol 0 mg
Vitamin A 90% Calcium 150%
Vitamin C 180% Iron 8%

*Percent Daily Values are based on a 2000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.
Search our food database by name:

Social Media, Explained in Java (extended)

Coffee and Social Media Icons
https://www.behance.net/JenniferHudsonTaylor

The original entries:

Facebook: I like drinking coffee.

Twitter: I’m drinking coffee.

YouTube: Watch my cat drink coffee.

Instagram: Selfie: Me and my cat sipping coffee before I leave for school today.

Pinterest: How to make coffee.

LinkedIn:  Skills – Can make great coffee

And…my new ones:

Google+: +1 for drinking coffee

Japanese Twitter: ソーシャルメディアとコーヒー かわいい!

Vine: 2 second video loop: Sip of coffee

Line: _c(_)_ (=^?^=)

Yelp: 4-stars for coffee at my home (-1 star for having to make it myself)

Foursquare: Tip – coffee is better in a cup with a cat

Swarm: 20 others are drinking coffee here.

Myspace: 10 little known songs about coffee, plus Timberlake’s cover of F. Sinatra’s Coffee song

Reddit: I hate all people who drink coffee with cats (troll)

HuffPost: Why drinking coffee with your cat makes you live longer

Blogger/WordPress/Tumblr/LiveJournal/TypePad: My thoughts on drinking coffee with cats

Flipboard: A visual magazine dedicated to cats sitting next to coffee cups

te@achthought: How to get students to drink less coffee and pay more attention to their cats

Buffer: “The only escape from the miseries of life are music and cats…” (…and coffee)- Albert Schweitzer

About.me: Why I drink coffee

Bebo: #coffeeiskewl

delicio.us: The best sites for coffee

DeviantArt: a pop-art collage of cats sitting in coffee

AdWords: Save $1 at Starbucks and PetCo NOW!

Flickr: My collection of coffee pix

Influenster: Free sample of Folger’s MicroRoast for your review

Meetup: 5PM PT @ Jon’s Koffee Hut – open invite

eVite: Having a coffee party with my cat

Amazon.com: 3-stars. Bought this coffee – my cat hated it, but I loved it.

2015-August Shinnyo Podcast Mirrors and

2015-August Shinnyo Podcast Mirrors and Seeing You – 2015-August Shinnyo Podcast Mirrors and Seeing You Paradise, Almost. Embracement and Nothingness Waking up and Making Some Coffee (not just thinking about it) Subscribe to this Podcast (RSS) or iTunes or via Flipboard What do you see when you look in a mirror? Do you look at your hair, face, expressions, youth, aging, acne, whiskers, … Continue reading 2015-August Shinnyo Podcast Mirrors and Seeing You → http://ow.ly/32pQnO

2015-August Shinnyo Podcast Mirrors and Seeing You

2015-August Shinnyo Podcast Mirrors and Seeing You

  • Paradise, Almost.
  • Embracement and Nothingness
  • Waking up and Making Some Coffee (not just thinking about it)

Subscribe to this Podcast (RSS) or iTunes or via Flipboard

Looking at your Self in a mirror
http://www.npr.org/sections/pictureshow/2012/08/07/157743116/does-the-mirror-reflect-how-you-feel

What do you see when you look in a mirror? Do you look at your hair, face, expressions, youth, aging, acne, whiskers, grey hairs, lines, dirt, oil, makeup, hemlines, shiny shoes… What do you see?

A mirror [ ˈmirər ] – a reflective surface, typically of glass coated with a metal amalgam, that reflects a clear image.

But what do you “see” in that image? Do you see your beauty? Your flaws? Do you see only what you want to see? Do you see what others see? Do you hesitate to look in a mirror?

A mirror does not judge, it merely reflects. Light and dark. Whatever is there, is there, or not. A mirror that is slightly askew, that is, seen indirectly at an angle, shows you something not directly in front of you. It can show around a corner, or something off to your side. Or a view from above or below. The light or shadows are a reflection in opposition, meaning you’re actually seeing the reverse of what is really there (unless adjusted by an optical reversing lens or otherwise image-processed.)

How you see something in a mirro
https://emmybella.wordpress.com/images-in-plane-mirrors/

Seeing your self (or Self, metaphysically-speaking) is often considered a first step towards what is expressed in many different words: enlightenment, heaven, Nirvana, truth, Shinnyo, happiness, contentment, harmony, and even peace. Regardless of how you perceive everything and everybody around you, if your own self-image isn’t clear, or acceptable to you, then it reflects on and changes how you interact with everything and everybody else.

This concept of reflection is what we can also witness in how other people (and animals) communicate and interact with us.  The words someone uses to talk with you, especially individually, are intended for your ears to hear (or eyes to see, or to touch). They aren’t really good or bad, or supportive or critical, until you interpret their meaning. Otherwise, they are just words. This is the same as when you like or dislike what you see in a mirror. It’s pretty amazing how much actual power you have over what and how you feel as you perceive the world around you.

Similarly, if you can develop your sense of how others see things, learning how to step into other’s shoes and walk in their footsteps, so to speak, you begin to see why Shinnyo refers to everyone else becoming mirrors of you. The way they act and treat you is not so much a consequence of their specific intent in one way or another, but a reaction to what you represent to them.

My friendly facilitators Steve Snyder and Michael Benner, now over at TheAgelessWisdom with whom I spent many days, weeks, hours and years in my college years learning from and with, always used to say, “Your own Love flows through your own love for You.” This translated into something like, you can’t really give what you don’t have. If you look in the mirror and accept what you see, others will, too. It’s when you can’t or won’t accept what’s there, that others become confused and don’t know what you’re really about. And if you fabricate something else about that reflection, it becomes really difficult for others to see things the same way.

Animals in their purity of absorbing the world around them, often are the clearest mirror to your own behavior. And, similarly, so are newborn babies. They perceive the world as it is. They learn from what has happened to them in the past. And that often forms the basis for how they perceive something new. When an animal has only known a world of kindness, it doesn’t really know what aggression or meanness means. Trainers often point out that you can say whatever words you want, but it’s the intent, emotion and feeling that the animals are reacting to, and learning.  That’s also why it’s crucial to do as you say, and say as you do. People learn from what you do, and not so much what you say. Mirrors show what you are, and not what you say you are.

“Be gentle, love life, and take care of each other.” — Michael Benner

Subscribe to this Podcast (RSS) or iTunes or via Flipboard

/* For more information and discussion feel free to e-mail me at jlui at jlui dot net, or twitter @jhlui1; With Gassho _()_, James*/

2015-July Shinnyo Podcast One on One Communications

2015-July Shinnyo Podcast One on One Communications

  • …as I have heard.
  • Differences Between Group and Individual Listening
  • Tailoring the Message to the Recipient

Subscribe to this Podcast (RSS) or iTunes or via Flipboard

Each of the various sutras (sacred writings) related to buddhism ends with a common phrase, “…as I have heard.”  (technically, “Thus, I have heard..” begins the phrases in Sanskrit, and we translate the grammatical structure in-reverse for English – and that’s more than you wanted to know about why there’s a difference.) Going back to the beginnings when Siddhartha was walking around talking with people about what was on his mind, many people couldn’t read written text (education being something only for the wealthy, and having a few thousand different dialects didn’t make it any easier), and so, he spoke. He also noticed something interesting about speaking with people – people listen and hear differently from each other.

http://shanghaiist.com/2015/08/05/bbc-documentary-chinese-teaching-style-british-schools.php
http://shanghaiist.com/2015/08/05/bbc-documentary-chinese-teaching-style-british-schools.php

There’s a BBC2 programme called “Are Our Kids Tough Enough? Chinese School” that is studying the differences between UK students, and those in China, relating to how and why they learn, and the struggles of attempting to teach students that are from very different social backgrounds. One of the many take-aways in the program relates to classroom management, wherein there are classroom monitors (elected by their peers) who are designated to act not only as supervisory extensions for the instructor, but also become role models for the others by demonstrating desired behavior.

The observed difference for a teacher attempting to mass educate a large group in a standardized way, without that group being very consistent and homogenous in focus and intent, becomes very chaotic.  By comparison, speaking with a smaller focused group, or even one on one, becomes much simpler for the speaker to adjust the content and manner of speaking, or even vocabulary, so that the instruction doesn’t get lost.

Similarly, when the students are given a physically engaging task to accomplish, that requires both focus and determination, they are as a population, able to achieve their individual goals at their own pace, some needing assistance from facilitators, and others determining their own path to success.

When students at Shinnyo-en attend dharma school (kind of a 5-year Masters program in Buddhist theology), the attending students are all focused on the same objectives and attending for pretty much the same reasons. In these situations, it is fairly simple to develop a standardized way to communicate a complex topic because the audience is consistent.

By contrast, when you encounter individuals asking a question, or seeking guidance, you will tend to shape your style and manner of communication to most effectively reach your goal of the other person understanding what you are trying to say.  There is also a difference in the way you speak with someone close to you, with whom you share a common connection, versus what you say to a stranger, with a corresponding difference in objective (for example, to a stranger about to misstep, you might say, “Be careful!” and go about your business; but if that same person is your child or parent, your intent and purpose become not only insistent, but also highly protective.)

This is also the difference between this podcast, going out to a random population, versus how and what I would say to an individual.  The content here is general information presented in a very common form, which some may or may not understand. But for those who reach out and ask individually for clarification, or when a familiar person encounters a situation needing similar advice, the information herein becomes tailored to the unique needs of that individual, restated in whatever ways are needed to make the message clear and understandable.

That’s the power of one on one conversation, at least so far as I have heard (and experienced it.)

Subscribe to this Podcast (RSS) or iTunes or via Flipboard

/* For more information and discussion feel free to e-mail me at jlui at jlui dot net, or twitter @jhlui1; With Gassho _()_, James*/

@Oracle R12 EBS HTTP Server Error Child Could Not Open Sslmutex Lockfile

HTTP Server Error “Child Could Not Open Sslmutex Lockfile” (Doc ID 562624.1) addresses a non-critical, but annoying issue (because it tends to fill up the $INST_TOP/logs/ora/10.1.3/Apache directory with big error logs every day – every mouse click on a OA Framework page generates an error entry).

mod_ossl: Child could not open SSLMutex lockfile /apps/oracle/oas/10.1.3.1/Apache/Apache/logs/ssl_mutex.10549 (System error follows)
System: No such file or directory (errno: 2)

And sort of randomly, your HTTP service will show “Stop” on the adapcctl.sh status screen. But it’s probably still actually running (the processes still show up when ps -ef | grep httpd – and the OA Framework still seems to be responding).

applmgr@myhostname$> $SCRIPT_TOP/adapcctl.sh status

You are running adapcctl.sh version 120.7.12010000.2
Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...
Processes in Instance: ENV_ID.myhostname
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status 
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   16788 | Alive  
OC4JGroup:default_group          | OC4J:forms         |   16709 | Alive  
OC4JGroup:default_group          | OC4J:oacore        |   21689 | Alive  
HTTP_Server                      | HTTP_Server        |   16494 | Stop

OEM will show the HTTP service as being down, even though the pages are probably still responding:

R12 EBS OEM AMS monitor HTTP Service down screenshot
R12 EBS OEM AMS monitor HTTP Service down screenshot

Implementation for e-Business Suite R12 is relatively easy (just modify 2 configuration files and bounce Apache), but making sure the changes stick after AutoConfig runs means you do need to learn about the configuration templates in $FND_TOP/admin/templates.

These are the skeletal files used during AutoConfig (adautocfg.sh) that regenerate all those files used to control the middleware and database software configuration.  These are the files you that contain warning headers written into each and every one of them warning you not to make direct changes to the configuration file itself like:

# ###############################################################
#
# This file is automatically generated by AutoConfig.  It will be read and
# overwritten.  If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
# ###############################################################
)

## Execute on every R12 MT server running HTTP/web services – Apache downtime required during change.
# Stop Apache
$SCRIPT_TOP/adapcctl.sh stop

#  Before change
applmgr@myhostname $> cd $INST_TOP/ora/10.1.3/Apache/Apache/conf
applmgr@myhostname $> grep mutex *

ssl.conf:SSLMutex  file:/ptcharmk/inst/apps/${ENV_ID}/logs/ora/10.1.3/Apache/ssl_mutex

# Append a line to the existing custom template
echo -e “\nAcceptMutex pthread\n” >> $FND_TOP/admin/template/custom_conf_1013.tmp

# Modify the existing SSL template (doesn’t seem to have a custom include on this one)
vi $FND_TOP/admin/template/ssl_conf_1013.tmp
=============

Comment:  # SSLMutex  file:${INST_TOP}/logs/ora/10.1.3/Apache/ssl_mutex
Insert:     SSLMutex sem

# Execute AutoConfig

$SCRIPT_TOP/adautocfg.sh -appspass=$APPS_PW

# Re-Start Apache
$SCRIPT_TOP/adapcctl.sh start

# After Change
applmgr@myhostname $> cd $INST_TOP/ora/10.1.3/Apache/Apache/conf
applmgr@myhostname $> grep -i utex $INST_TOP/ora/10.1.3/Apache/Apache/conf/*

custom.conf:AcceptMutex pthread
ssl.conf:# SSLMutex  file:${INST_TOP}/logs/ora/10.1.3/Apache/ssl_mutex
ssl.conf:SSLMutex  sem

# Confirm semaphore mode is activated

applmgr@myhostname $> grep -i mutex $INST_TOP/logs/ora/10.1.3/Apache/*
$INST_TOP/logs/ora/10.1.3/Apache/error_log.1437091200:[Fri Jul 17 11:58:14 2015] [notice] Accept mutex: pthread (Default: fcntl)
$INST_TOP/logs/ora/10.1.3/Apache/error_log.1437091200:[Fri Jul 17 12:12:12 2015] [notice] Accept mutex: pthread (Default: fcntl)

As mentioned in the MOS document (Doc ID 562624.1), you may need to use ipcs -a to view hanging semaphore processes after making this change, and use ipcrm -s to kill the hanging processes if Apache refuses to startup after making this change and a different issue causes Apache’s processes to hang.

New feature in the 12.1.0.4.x OEM agents – Metrics Browser

Actual content being collected depends on what plugins are available on the agent.

https://(agenthostname):(port)/emd/browser/main

(agenthostname):(port) obtained from $AGENT_HOME/bin/emctl status agent


oem_agent_metric_browser_login_ss1Metric Browser Login

Top of Form

Enter user ID and password:
Agent UserName or root Password

PDP Type
None Sudo PowerBroker

RunAs Username Profile name (only applicable if PowerBroker)
And then click this button:

Bottom of Form


Screenshot of OEM 12.1.0.4.0 Agent Metric Browser
Screenshot of OEM 12.1.0.4.0 Agent Metric Browser

EMAGENT 12.1.0.4.0

Health Meter Score Schedule Properties Upload System Top Target/Metric Cpu Reports System State Dumps Agent Key Performance Charts Agent KPI Charts
100.0 Schedule Properties Upload System Top Target/Metric Cpu Reports System State Dumps Agent Key Performance Charts Agent KPIs

Target List

TargetType TargetName BrokenCode BrokenReason Status Version Runtime Version Blackout Status Master ScheduleStatus HealthScore Severities Schedule CollectionItems Target Events
Host (hostname) 0 MONITORED 4.4 2 false true OPERATIONAL 99.6 Severities Schedule CollectionItems Events
Oracle Concurrent Processing (ORACLE_SID)-Core Managers for Concurrent Processing 0 MONITORED 12.03 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Custom Oracle Concurrent Program (ORACLE_SID)-AUS_FNDGSCST 0 MONITORED 12.02 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Custom Oracle Concurrent Program (ORACLE_SID)-(ORACLE_SID)_7BK_AGING 0 MONITORED 12.02 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle E-Business Suite Custom Objects (ORACLE_SID)-Oracle E-Business Suite Custom Objects Configuration 0 MONITORED 12.01 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Internal Concurrent Manager (ORACLE_SID)-Internal Concurrent Manager 0 MONITORED 12.02 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle E-Business Suite Node (ORACLE_SID)-Infrastructure (ORACLE_SID)_(hostname)-Database Context 0 MONITORED 12.03 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle E-Business Suite Patch Information (ORACLE_SID)-Oracle E-Business Suite Patch Information Configuration 0 MONITORED 12.03 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle E-Business Suite Workflow (ORACLE_SID)-Workflow Infrastructure 0 MONITORED 12.02 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Workflow Agent Listener (ORACLE_SID)-Oracle Workflow Agent Listener 0 MONITORED 12.01 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Workflow Background Engine (ORACLE_SID)-Workflow Background Engine 0 MONITORED 12.01 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Workflow Notification Mailer (ORACLE_SID)-Oracle Workflow Notification Mailer 0 MONITORED 12.01 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Database Instance (ORACLE_SID) 0 MONITORED 5.3 2 false true OPERATIONAL 99.3 Severities Schedule CollectionItems Events
Database Instance (ORACLE_SID) 0 MONITORED 5.3 2 false true OPERATIONAL 100.0 Severities Schedule CollectionItems Events
Oracle E-Business Suite (ORACLE_SID)-Oracle E-Business Suite 0 MONITORED 12.03 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Agent (hostname):(port) 0 MONITORED 12.4 6 false true OPERATIONAL Severities Schedule CollectionItems Events
Agent proxy (hostname):(port)_proxy 0 MONITORED 12.01 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Home OraDb11g_home1_(hostname) 0 MONITORED 2.0 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Home OraDb11g_home2_(hostname) 0 MONITORED 2.0 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Home agent12c1_(hostname) 0 MONITORED 2.0 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Oracle Home agent12c2_18_(hostname) 0 MONITORED 2.0 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Listener LISTENER_(hostname) 0 MONITORED 2.7 2 false true OPERATIONAL Severities Schedule CollectionItems Events
Listener (ORACLE_SID)_(hostname) 0 MONITORED 2.7 2 false true OPERATIONAL Severities Schedule CollectionItems Events

Timestamp = 2015-06-16T10:37:34.693-07:00

Logout https://(hostname):(port)/emd/browser/logout

Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved

Each clickable link allows you to see what each metric being collected is actually collecting, and what the current values that are being passed to the OEM OMS Repository look like.

This is referenced in the My Oracle Support document:

List Of All Metrics In Enterprise Manager 12c Cloud Control (Doc ID 1678449.1)

e-Business Suite Patches ONE-OFF, or Family Pack – My @Oracle Support Searches

One-off patch, then [Search]

Patches & Updates Name or Bug Number (Simple)
Patches & Updates Name or Bug Number (Simple)

Click on the Patch# (link):

Patch Search Results
Patch Search Results

Showing that this particular patch was not superceded by a Family pack release:Patch DescriptionBut in the README.txt – the giveaway is the “Target Mini-pack/Family Pack/Release” – 12.1.4/12.2 means this won’t be incorporated into a 12.1.3 Family pack and will only be included in an eventual 12.1.4 upgrade, or in the 12.2 upgrade.  It would remain a ONE-OFF status for 12.1.3.

Patch README.txt
Patch README.txt

The other approach is going from the RPC downward:

Patches & Updates Product or Family (Advanced)
Patches & Updates Product or Family (Advanced)

For a Functional Overview of this patch please review EBS: R12.1: Receivables

Recommended Patch Collection (RPC), Feb 2015  (Doc ID 1980300.1)

Refer to Doc ID 954704.1 for all Financials Feb 2015 RPCs.

nb – In case it’s useful – you can make a browser shortcut for any My Oracle Support Document ID’s by using the search URL: https://support.oracle.com/epmos/faces/DocContentDisplay?id=(documentID#)

Slow Oracle Database Performance on a NetApp (10g, 11g, 12c) Tips

http://www.netapp.com
http://www.netapp.com

If you have a NetApp storage appliance, device, SAN, whatever you want to call it, review this first (NetApp Best Practices for Oracle Databases – published March 2014): http://www.netapp.com/us/media/tr-3633.pdf

The quick and dirty (for those experiencing Production issues right now):

The database-side init.ora:

grep filesystemio $ORACLE_HOME/dbs/initSID.ora

*.filesystemio_options=’SETALL’

The options for filesystemio_options can be summarized as follows:

  • ASYNCH: Asynchronous I/O. Oracle should submit I/O requests to the operating system for processing. This permits Oracle to carry on with other work rather than waiting for I/O completion and increases parallelization of I/O.
  • DIRECTIO: Direct I/O. Oracle should perform I/O directly against physical files rather than routing I/O through the host operating system cache.
  • NONE: Use synchronous and buffered I/O. In these configurations, the choice between shared and dedicated server processes and the number of dbwriters will become more important.
  • SETALL: Use both asynchronous and direct I/O. (preferred for NetApp)

Note: The filesystemio_options parameter has no effect in DNFS and ASM environments. The use of Direct NFS (DNFS) or Automatic Storage Management (ASM) automatically results in the use of both asynchronous and direct I/O.

However…. Because you might end up cloning to an environment that doesn’t support DNFS (remember it’s stuck in the ORACLE_HOME/rdbms/lib object binary), you should have it set to SETALL anyway to allow fall-back to standard NFS (but with asynch and DI/O.).

[This refers to the: cd $ORACLE_HOME/rdbms/lib ; make -f ins_rdbms.mk [dnfs_on / dnfs_off] used to enable and disable DNFS (you also need the /etc/oranfstab created to support this – server:   local:   path: export: mount: etc…)]

If you have 11.2.0.4.x or later (12c) there’s a new DNFS-related init.ora parameter critical for managing packet requests by the database to avoid packet flooding the NFS file server:  Without it (i.e. older versions) DNFS only works well on dedicated DNFS storage because an oracle database on modern hardware can easily over-whelm the NetApp’s ability to service TCP packets (can send upwards of 4,000+ requests per second)

$> grep dnfs $ORACLE_HOME/dbs/initSID.ora

*.dnfs_batch_size=128

On the Linux OS side:

$> grep tcp /etc/sysctl.conf

sunrpc.tcp_slot_table_entries = 128

$> grep nosharecache /etc/fstab

hostname.corp:/vol/testoracled/d01     /u01/app/Oracle              nfs rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=65536,wsize=65536,nointr,nosharecache

hostname.corp:/vol/testdata            /u01/app/Oracle/oradata     nfs rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=65536,wsize=65536,nointr,nosharecache

Incidentally, if you want to measure your I/O rates, I have been using SLOB (Silly Little Oracle Basher – http://kevinclosson.wordpress.com/slob/ ) with one small modification to the iostat command in the runit.sh script to capture the I/O activity on all the shares (iostat -mn instead of -xm):

#      ( iostat -xm 3 > iostat.out 2>&1 ) &
( iostat -mn 3 > iostat.out 2>&1 ) &
misc_pids=”${misc_pids} $!”
( vmstat 3 > vmstat.out 2>&1 ) &
misc_pids=”${misc_pids} $!”
( mpstat -P ALL 3  > mpstat.out 2>&1) &
misc_pids=”${misc_pids} $!”

All this besides the usual OEM recommendations (bigger log_buffer, manage SGA size, get block sizes correct), dropped latency from over 40000ms to < 80ms on heavy load, and is producing 12000 IOPS on the same device.

This is an R12 e-Business Suite environment running on an 11.2.0.3.13 (PSU JAN2015) database (5TB).

What triggered this investigation was that the Log Writer process (LGWR) began dumping trace files about 6 months ago with entries that look like:

*** 2014-12-21 19:49:29.827
Warning: log write elapsed time 9988ms, size 1KB

After investigating all the usual suspects about slow disk, I happened upon the aforementioned NetApp white paper. This occurs when multiple hosts are competing for resources under a single NetApp appliance environment (multiple enclosures, multiple dedicated or shared aggregates, etc.)

Situation addressed and under control.

Smartphone Tablet Art Controller App – WiFi Digital Photo Frames Managed by Template

Simple concept – we’ve bought those digital photo frames that can take various memory cards and flash drives to display our photos. And some of them have become WiFi enabled so you can load pictures from your favorite online cloud storage (i.e. Photobucket, Flickr, Snapfish, etc.)

But what about an app to manage such frames all around your house (or office, or college, or whereever?)

Start with a basic photo library app that can build normal collections and folders, but extend the functionality to allow multiple digital photo frames (or even Smart TV’s with WiFi photo RSS feed capability) to be loaded on-demand with your choice of photos on-demand.

SDWiFiCardUse WiFi compatible SD cards like these to provide the basic connectivity, but assign each device (which usually end up with a local IP address) as a controllable frame within the collection application (e.g. Frame 1 (living room), Frame 2 (kitchen), Frame 3 through 5 (hallway), etc.) Now assign those IP’s to a template “gallery” for the App to manage the content and placement.

Simple uses might be: changing all the digital frames in your house to display your best children’s photos during Mother or Father’s Day.  Load historical photos during national holidays. Celebrate a big birthday with a rolling series of funny or serious This is Your Life photos, all being loaded and timed automatically to change at pre-determined intervals.

More advanced use might be professional gallery management, so you can provide previews of gallery forthcoming openings by using inexpensive 11×14 digital frames to give guests an idea of what’s coming next.  Or artists might even end up programming the templates as interactive media showcases or exhibitions unto themselves.

The smartphone or tablet component (or any touchscreen capability)

Set of touchscreen smartphones
Set of touchscreen smartphones

makes it easier to drag and drop photos to specific frames in the template – imagine the application having a basic floorplan of your house with the various digital frames in placeholder positions, so you could drag and drop photos into them as collection sets.  And save them.  And load them instantly.

@jhlui1 #DreamBig #ChangeTheWorld

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

Follow

Get every new post delivered to your Inbox.

Join 358 other followers

%d bloggers like this: