Oracle OpenWorld 2016 in 5 Pages

 

Oracle OpenWorld 2016 Cloud Services and Products Summary

4 Days (almost 7 for me) of Product Directors and Managers spinning as many plates in the air as humanly possible, all being tossed into the Cloud with a fervor only matched by the lack of compensation being provided for conventional technology stack sales, left me with some specific value-adds for my time spent (not including the Safe Harbor information, we can’t say anything about….sshhhh.)

Note: (I’m EBS-centric and we have very little budget for hardware, so while I was amazed at the new SPARC S7 processors with on-board encryption and J/SQL optimization, alas they didn’t make it into my summary pages this year.)

AD/TXK Delta.8
Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.8 and R12.TXK.C.Delta.8 (Doc ID 2159750.1)

Configuring Oracle E-Business Suite Release 12.x Using Logical Host Names (Doc ID 1968231.1)

• e-Mail Notifications at Parent and Child Levels for Request Sets
• Save and Re-use Concurrent Program Parameters (CP Templates)
• Regex Support in Profile Option Values and FND_MESSAGES
• Multiple OA Framework Windows and Tabs in Multiple Browser Windows
• EBS Healthcheck Diagnostics
• 64-bit JDK’s on CM Tier
• adop Improvements
• Delta Sync Mode (syncmode=patch/delta) – changed rows only
• Rsync support in phase=prepare
• Custom module sync auto-supported (no custom drivers req’d)
• Standardized logging SessionID/ExecutionID/phase/node

EBS 12.2.6.AD Oracle E-Business Suite 12.2.6 Readme (Doc ID 2114016.1)

• Security Configuration Console
• JSP Whitelisting
• Redirection Whitelisting
• AD/TKX.Delta.8 incorporated
• More HTML User Interfaces: HTML alternatives to several existing Forms; interfaces offer simpler layouts and more modern user interactions.

–Examples include the Update Assets UI in Enterprise Asset Management, and AOL setup UIs for Users, Responsibilities, and Flexfields.

SecureFiles does not allow shrinking of the tablespace after deletions (AP Imaging)

Available Interconnect Cloud Service adapters:

• –PL/SQL
• –Java Beans
• –Apps Modules

Roadmap ICS adapters:

• –REST
• –Concurrent Programs
• –XML Gateway
• –BPEL/Business Services

CAAS (Cloud Adaptive Assistant Service) – The widget Larry was text-chatting with.

Mobile Foundation and Mobile Application Framework

Foundation v6 released August 2016

–Incorporates MAF 2.3.2

–Enhancements for Approvals (HR, Projects, Service Centers, Quoting, Custom Approvals)

Foundation v7 scheduled for April 2017

MAF Roadmap items:

–Airwatch and MobileIron support

–Mobile REST API’s

–EBS Integrated Service Gateway support (SOA)

PDF Version for download:       oracle_oow16_summary_jlui

Oracle OpenWorld 2016 Networking Opportunity Events #OOW16

Where I can keep track of the special events (note: these are not “parties” as so many people are misled to believe – you should expect to be contacted by sales and account professionals at each event) at OOW.  To attend one of these events:

1. You’re registered as an OpenWorld Attendee.
2. You’re either a prospect, customer, or goodwill contact for the host. That means you actually contact the host and ask to attend before OOW.
3. You visit the host’s booth at OpenWorld in order to pick up whatever is required for entry and get to know what the host actually does.
4. Do not just show up at the event and attempt to “crash” it – fair warning. You will be sold Oracle products and consulting, and like it, and start telling all your friends about it and be assimilated.

• Oracle ATG CAB Reception (members), Sat 6-8p, Grand Hyatt
• Oracle SQL Developer MeetUp, Sat 6:30-9p, 21st Amendment Brewery
• OTN Kickoff Event, Sun 1-5p, Moscone South Upper Lobby
• BIAS Corp CA, Sun 5-8p, Waterbar Restaurant
• Oracle WebCenter CAB Reception (members), Sun 6-8p, Thirsty Bear Brewing
• OOW Cloud Welcome Event, Sun 7-9p, Howard St Pavilion
• Oracle ACE Dinner (members), Sun 7-10p, Chart House (Pier39)
• JavaOne Welcome, Sun 7-9p, Cloud Plaza at Howard St
• OPN AfterDark Reception (Partner Badge), Sun 7-9p, City View at Metreon
• ePrentise CA/Hospitality, Mon-Wed 10:15A-4p, Four Seasons Hotel Suite
• Chain-Sys CA LL, Mon 12-2p, Osha Thai Restaurant
• CSS + DSI CA, Mon 5:30-8:30p, 25 Lusk
• Ataway CA, Mon 6-8p, Pub crawl
• Oracle Public Sector CA, Mon 6:30-8:30p, Jillians
• Oracle Identity Mgt and Security CA, Mon 7-9p, District Restaurant
• OSI Consulting, Mon 7:30-9:30p, North Beach Restaurant
• Denovo CA, Mon 8-11:0p, Foleys Irish House
• More4Apps CA, Tue 6-8p, Sir Francis Drake Mezzanine
• Oracle Digital Experience (DX) CAB, Tue 6-9p, Thirsty Bear Brewing
• OOW CX Central Happy Hour, Tue 6-7p, Exhibition Hall 2nd Flr
• Ataway CA, Tue 6:30-7:45p, SF Trolley Tour
• Mythics CA, Tue 6:30-9p, Slide
• OOW Social Intelligence Networking Reception, Tue 6-7:30p, MW 2nd Level CX Central
• Hitachi Client & Partner Reception, Tuesday 7:30-9:30p, Temple Club (aka Ki)
• Oracle OTN Bloggers Meetup, Wed 5:30-7p, Jillians
• OOW Appreciation Event, Wed 7-11:00p, AT&T Park (Sting, Gwen Stefani)

Visit all those vendors and make them feel welcomed this year!

http://www.7×7.com/eat-drink/ultimate-foodie-tour-ferry-building

Oracle OpenWorld Fun Community Events There are 3 community events at OOW this year, A guided bike tour hosted by Oracle’s PL/SQL and cycling guru, Bryn Llewelyn on Saturday, September 17th at 10 a.m. A run across the Golden Gate Bridge hosted by the SQL Dev team on Sunday, October 25th at 8:30 a.m. 5th annual swim in the San Francisco Bay hosted by Oracle ACE Director Chet Justice on Monday, October 26th at 7:30 a.m.

The 2015 List of OOW Events

The 2014 List of OOW Events

The 2013 List of OOW Events

The 2012 List of OOW Events

And OakTable World is back once again, at the Creativity Museum (this year, no pre-registration required).

Agenda:

http://dbakevlar.com/2016/08/oak-table-world-2016-oracle-open-world-edition/

Agenda for Oaktable World 2016, located at Creativity Museum, is looking like:

What’s New Features in OEM AMS Applications Management Pack 13.1.1.1.0 for OEM 13c Released July 22

Per Getting Started with Oracle Application Management Pack (AMP) for Oracle E-Business Suite Release 13.1.1.1.0 (Doc ID 2045552.1)

Key Features

New EBS AMS Plugin Homepage Screenshot 13c 13.1.1.1.0

The following are brief descriptions of key features introduced in this release:

Enterprise Manager 13c Technology Uptake
Hybrid Cloud Management
System Management for Oracle E-Business Suite
Change Management for Oracle E-Business Suite

Enterprise Manager 13c Technology Uptake

Oracle Enterprise Manager 13c includes several enhancements including:

• A new Oracle Fusion Middleware technology stack
• The “Alta” user interface to enhance user experience

  

  New OEM Alta Interface 13c

• Edition Based Redefinition (EBR) support

Hybrid Cloud Managment

Oracle Application Management Suite now delivers several capabilities to monitor and manage Oracle E-Business Suite environments on Oracle Cloud and on-premises. These capabilities are delivered through the Enterprise Manager command line interface (EMCLI) for greater flexibility.

• Discovering Orchestration Virtual Machine
• Provisioning a New Oracle E-Business Suite 12.2 Instance
• Backup and Restore an Oracle E-Business Suite Instance
• Lift and Shift E-Business Suite instances from On-premise to Oracle Cloud
• Cloning E-Business Suite instances within Oracle Cloud
• Ability to run FS_Clone only option
• Apply E-Business Suite patches
• Start and Stop E-Business Suite instances on Cloud
• To create custom packages

System Managment for Oracle E-Business Suite

Discovery and Monitoring

• Real User Experience Insight (RUEI) regions integrated within the Oracle E-Business Suite Summary page
  • In this release, we have integrated five different RUEI regions within the Oracle E-Business Suite Summary page. Customers can personalize and activate one or all RUEI regions. These RUEI regions are specific to a given Oracle E-Business Suite instance and customers can view the data and drill down for detailed information.
• Auto Host Aliasing
  • Host aliasing is now automated and will attempt to match the host name in the Oracle E-Business Suite context file and the discovered host name in Oracle Enterprise Manager. If this attempt fails, you will be prompted to perform the mapping manually. Customization Manager and Patch Manager features now support host aliasing.

Change Management for Oracle E-Business Suite

Patch Manager – Oracle E-Business Suite Technology Stack Pack Deployments

• During the prior release of Application Management Suite, you had the ability to view patch recommendations for E-Business Suite applications and the technology stack. In this release, you now have the ability to deploy Database and WebLogic server patches using Enterprise Manager patch plans.

Customization Manager – Customization Discovery & Reporting

• Customization Discovery & Reporting process now includes discovery of database objects.

Cloning – Automated Cloning

• You now have the ability to save the cloning interview process as templates that can be used for future purposes for Smart Clone for R12, 12.2.x procedure.
• You can add custom parameters to the cloning procedure

 

Oracle Configuration Manager Quick Tip – EBS R12.2 Disconnected Collections

Collecting Disconnected Mode OCM data for e-Business Suite R12.2
per MOS Document ID 1447334.1 - Oracle E-Business Suite Release 12.2: Release Notes for Oracle Configuration Manager

MOS Oracle Configuration Manager Collector Download screen.

This method is used whenever your EBS instance is behind a firewall and no proxy server is available to reach the OCM collector end-point (ccr.oracle.com)

The reason you want to use OCM is not only because it provides a complete catalog of your Oracle software versions, modules and plug-ins, so that they can easily be associated with a Service Request (SR) instead of the analyst asking for every RDA script being run for every component in your application and database. 

It also enables the full functionality of that Systems Tab in My Oracle Support (buried just above your Settings menu) that allows you to do light versions of lifecycle management comparisons (such as what the instance looked like 2 weeks ago versus now) without having to own the OEM Lifecycle Management license. It comes compliments of your support agreement.

This also enables the full functionality of the patch and security recommendations section vital towards identifying high priority one-off patches specific to your particular configuration and platform.

Basically, instead of having a cron job periodically automatically upload the configurations to ccr.oracle.com, you will be creating the same staged configuration file, but uploading it to your Customer Support Identifier (CSI) via a Draft Service Request (SR) or a currently Open SR via the File Attachment... feature of the SRs.

In the background of MOS is a managed file transfer handler that looks for the specifically named "ocmconfig.jar" files and when detected, route them over to the Configuration Manager engine for automatic uploading to your CSI account.

While not as convenient as the automatic cron method, for those of use with no direct internet connectivity to ccr.oracle.com, our OEM and MOS functionalities become quite limited if the configurations aren't present under our CSI's.e.g. ORACLE_BASE=/u01/app/oracle

# Oracle DB Home cd $ORACLE_HOME unset ORACLE_CONFIG_HOME export JAVA_HOME=$ORACLE_HOME/jdk cd $ORACLE_HOME/ccr # Clear prior CCR installation, if required. rm -rf $ORACLE_HOME/ccr/* cd $ORACLE_HOME unzip <patch_stage_dir>/p5567658_<ver>_<platform>.zip cd $ORACLE_HOME/ccr/bin # Run setupCCR in Disconnected mode ./setupCCR -s -d # Create ORACLE_OCM user and related grants . $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig -s <SID> -r SYS # Additional grants for APPS EBS Collector . $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh ebs_collectconfig -u <APPSUSERNAME> # Run the collection and generate the ocmconfig.jar cd $ORACLE_HOME/ccr/bin ./emCCR collect # ocmconfig.jar location $ORACLE_HOME/ccr/hosts/$HOSTNAME/state/upload # Oracle 10.1.2 iAS Home . $ORACLE_BASE/EBSapps.env run export ORACLE_HOME=$ORACLE_HOME export ORACLE_CONFIG_HOME=$INST_TOP/ora/10.1.2 export JAVA_HOME=$ORACLE_HOME/jdk # Remove prior OCM config, if needed rm -rf $ORACLE_HOME/ccr/* rm -rf $ORACLE_CONFIG_HOME/ccr/* cd $ORACLE_HOME unzip <patch_stage_dir>/p5567658_<ver>_<platform>.zip # Bugfix specific to HP-UX Itanium - verify file permissions to execute chmod 754 $ORACLE_HOME/ccr/bin/deployPackages chmod 754 $ORACLE_HOME/ccr/bin/emSnapshotEnv cd $ORACLE_HOME/ccr/bin ./setupCCR -s -d # Disconnected mode # Run the collection and generate the ocmconfig.jar cd $ORACLE_HOME/ccr/bin ./emCCR collect # ocmconfig.jar location $INST_TOP/ora/10.1.2/ccr/state/upload #Repeat for patch filesystem; . $ORACLE_BASE/EBSapps.env patch # Oracle FMW WebLogic Home # source the Domain environment . $ORACLE_BASE/EBSapps.env run . $EBS_DOMAIN_HOME/bin/setDomainEnv.sh export ORACLE_HOME=$FMW_HOME/utils export ORACLE_CONFIG_HOME=$INST_TOP/ora/FMW # Remove prior OCM config, if needed rm -rf $ORACLE_HOME/ccr/* rm -rf $ORACLE_CONFIG_HOME/ccr/* cd $ORACLE_HOME unzip <patch_stage_dir>/p5567658_<ver>_<platform>.zip # Bugfix specific to HP-UX Itanium - verify file permissions to execute chmod 754 $ORACLE_HOME/ccr/bin/deployPackages chmod 754 $ORACLE_HOME/ccr/bin/emSnapshotEnv cd $ORACLE_HOME/ccr/bin ./setupCCR -s -d # Disconnected mode # Run the collection and generate the ocmconfig.jar cd $ORACLE_HOME/ccr/bin ./emCCR collect # ocmconfig.jar location $INST_TOP/FMW/ccr/state/upload #Repeat for patch filesystem; . $ORACLE_BASE/EBSapps.env patch # Upload all of your ocmconfig.jar files (can be named uniquely - e.g. mydbocmconfig.jar) per MOS Document ID 763142.1 - How to upload the collection file ocmconfig.jar to My Oracle Support for Oracle Configuration Manager (OCM) running in Disconnected Mode.
# Also can ZIP up all of them at once and upload them to your Draft SR (or current open SR as long as you're happy with the CSI (Customer Support Identifier) that will receive the new configurations.
# Trick is have the string "ocmconfig" and .jar as the extension of each file
Have fun with your new Systems tab in My Oracle Support!

2016-07 July Shinnyo Podcast Getting Enl

2016-07 July Shinnyo Podcast Getting Enlightenment – 2016-07 July Shinnyo Podcast Getting Enlightenment Gotta Catch Them All Living with Hungry Spirits Losing My Marbles Alternative Reality The New Cycle Awakens Subscribe to this Podcast (RSS) or iTunes or via Flipboard Fear is the path to the dark side. Fear leads to anger. Anger leads to hate. Hate leads to suffering. — Yoda … Continue reading 2016-07 July Shinnyo Podcast Getting Enlightenment → http://ow.ly/xTtN502swxn

2016-07 July Shinnyo Podcast Getting Enlightenment

2016-07 July Shinnyo Podcast Getting Enlightenment

• Gotta Catch Them All
• Living with Hungry Spirits
• Losing My Marbles
• Alternative Reality
• The New Cycle Awakens

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

Courtesy of http://www.videogamesblogger.com/2015/09/19/pokemon-become-real-with-pokemon-go-in-2016-ios-android.htm/pokemon-pride-go

Fear is the path to the dark side. Fear leads to anger. Anger leads to hate. Hate leads to suffering. — Yoda

But there is more.  Suffering leads to desire. Desire leads to attachment.  Attachment leads to attainment. Attainment leads to loss. Loss leads to fear. And the cycle continues.

Augmented Reality has been around awhile, but until the little Nintendo game came up this week that shadows Foursquare’s original check-in GPS technology (leading to 4SQ points, badges and virtual hierarchies of achievement), with the connection to the popular collect-until-infinity game Pokemon, we didn’t see people walking distracted into moving traffic, getting mugged and robbed by wandering where they shouldn’t, nor putting themselves in the beyond-selfie dangerous places.

People’s desire for things they don’t have (yet) was described in the original Buddhist depiction of hungry spirits (jpn. Gakido or skt. Preta-gati) as the realm of existence that one finds a mere level above Hell itself.  (Shinnyo et.al describes ten realms of existence – six lower ones are consumed by desire or earthly limits, and 4 realms of heavenly or getting closer to Nirvana existence.)  The difference between a human and a hungry spirit is that a human has the ability or will to say “no” to desire (the spirit is kind of perpetually suffering from desire unless it transcends.)

But in my depiction of the odd cycle of fear described above, you might see how an incidence of any kind of violence, intentional or not, tends to lead oneself into the cycle, and has a relatively predictable outcome, despite rejecting the original emotion that triggered it. I remember this as a child when some other child took a marble from me (one of those “I know it was there a moment ago – Hey! Give that back! That’s mine!” moments.) While I didn’t fear losing that one marble, within six months I had started carrying around this 5lb (2kg) sack of marbles, which I’m sure provided great strength training, but was eminently impractical, especially for actually playing marble games.  Maybe that was my own little sack of karma.

Marbles back then, human lives now. I was reflecting to my life in the 80’s when our President and his staff dealt with an amazing number of fear factors all during the decade – financial ruin, insider trading, junk bonds, deregulation, AIDS, the Cold War, Iran-Contra, technology boom, Yuppies.  We responded by buying guns, putting on Walkman earphones, and going online. Maybe VR and AR are just a lead-in to realization of the world of Tommy (don’t hear, speak or see… happy, safe and secure)

But there are always those who, for whatever reason, decide to open their eyes, listen carefully, and speak up.  Their fear is transformed into compassion.  Compassion leading to caring. Caring leading to love. Love leading to enrichment. Enrichment leading to embracement. Embracement leading to freedom. Freedom leading to acceptance. And acceptance leading to enlightenment. And thus, a new infinite single-ended cycle begins.

https://www.youtube.com/watch?v=bqbM1jsIr_0

/* That’s it for this session. Thank you for listening. For more information feel free to e-mail me at jlui at jlui dot net, or twitter @jhlui1 With Gassho, James*/

Save

Save

Save

Save

Save

Save

Save

Save

Influenster Sends ZzzQuil -A Sleep Aid Sample

Zzzquil Influenster Free Sample

Arrived this morning as a free sample from Influenster (the consumer product survey and test market company) a little late for the 4th of July fireworks sounding like open warfare all night long, the makers of NyQuil have produced a new version of a gel cap called ZzzQuil (Vicks).

What it is: 25mg of Diphenhydramine HCL – better known as Benadryl (the anti-histamine), the FDA has also qualified this particular pharmaceutical for sleep assistance use in addition to its more conventional use as an anti-histamine.

As a sleep-aid, Diphenydramine is also the key active ingredient in other sleep aid formulations, such as Sominex (Prestige Brands) , Unisom (Chattem), and Nytol (Glaxo Klein Barney.)

Anyone who has taken Benadryl or any other DPH-based anti-histamine has probably experienced the drowsiness that is brought on by the DPH effects.  Some of the formulations used for anti-histamine application include stimulants, such as caffeine, or maca to counteract these effects.  Other forumulations, such as Tylenol PM, or Unisom, actually double the dosage to 50mg to have a “faster” onset effect.

This is simply Vicks introducing, a non-pain relieving formulation of its already popular NyQuil product line, excluding the acetominaphen (pain relief), and dextromethorphan (anti cough/anti mucus) components to bring a Proter & Gamble version of the product to market with a recognizable brand behind it.  We’ll see if the pricing is any more aggressive for the formulation – but bottom-line, DPH makes you sleepy, quite fast.

2016-06 June Shinnyo Podcast – The Three

2016-06 June Shinnyo Podcast – The Three-Wheel Dharma Bodies http://ow.ly/9Lxd501iReZ

2016-06 June Shinnyo Podcast – The Three-Wheel Dharma Bodies

2016-06 June Shinnyo Podcast – The Three-Wheel Dharma Bodies

• Why Three (and not 4 or 12?)
• Intrinsic – The Nirvana Buddha
• Compassionate – Kannon Boddhisattva
• Strict – Mahavairochana Achala

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

 

Let’s explore further the realms of the three areas of Intrinsic, Compassionate and Strict styles of the Shinnyo Teaching (the 3-Wheel Turning Bodies of the Buddha, Kannon Bodhisattva and Mahavairochana Achala.) Throughout the volumes of dharma teaching are a seemingly never-ending list of numerically related lists and figures. Some examples:

• Four Means of Embracement
• Four Immeasurable Minds
• Four Noble Truths
• Four Dependables
• Four Grave Offenses
• Four Virtues
• Four Illusions
• Four (or Eight – depending on which edition you’re reading) Sufferings
• Five Cardinal Sins
• Six Periods of the Buddha’s Life
• Six Paramitas
• Seven Levels of Consciousness
• Eight Tastes
• Eight-fold Noble Path
• Ten Realms of Existence

Yea! – Memorize all those, and you probably still haven’t found enlightenment (but people may be very impressed with your mastery of lists.)  Every teacher comes up with their own way to help remember what you’re supposed to learn. Master Shinjo Ito noticed that the Nirvana Sutra (aka the Mahaparinirvana Sutra) kept reinforcing the basis of buddhism being founded on what are known as the Three Jewels – the Buddha, the Sangha (or community), and the Dharma (or teaching).  Alone, each element exists, but only together do they form the basis for what we know as Buddhism.

Relating back to last month’s podcast about Practice, and the story of the three kinds of practitioners, he also thought about the common threads between each of the myriad sub-schools of Buddhism – each of which had a particular focal point of study (quite parallel to the various sub-sects of Christianity and Catholocism focusing on different saints, or missionaries, or how Shinto groups each have their own particular Kami (or god) as reference for their respective focus.) Within the founding of Shinnyo’s goals was the objective to unify and fuse the esoteric practices commonly found under the compassionate wisdom sects with the elements of the exoteric sects promoting determined practice, and disciplined self-regulation. Translating the three essential Buddhist elements into objective examples to study,we get:

• Buddha => Buddha => Insight/Self
• Sangha => Kannon (aka Guanyin) => Compassion/Ego
• Dharma => Achala (aka Acala, Fudo Myo) => Discipline/Super-Ego

Coming from a psychology background, I tend to translate the religious themes into scientific or concrete-reasoning examples for my own consumption, but nonetheless, I think you may start to see how things fit together in this model. Within every person lies the buddha nature inside, and each person also has free-will, and also moral or ethical boundaries.  And it is the process of both self-examination of these values, and the outward expression (or practice) of these values that form the person we know.

The Intrinsic stream is our model or would-like-to-really-be-one-day self.  If everything in the world were perfect, and this were Utopian existence, these are our target elements to existence in a super-happy care-free world.  To really imagine or visualize this stream takes more than imagining a bunch of good luck comes to you; for example, you get a trillion dollars. Is having that being happy?  Or is it the potential to spend it, the happy part?  Or is it obtaining anything you want, the satisfaction you want?  And once you have everything, are you happy yet? Power, money, control, success, respect, admiration, love – what is going to get you to that happy place, and keep you there?  Our example given to us, is to imagine the opposite – never worrying about how much you have or don’t, surrounded by compassion, and being really satisfied with whatever happens to come your way.

As you noticed, compassion is part of our Utopian vision for our self. And it’s a dilemma, that to be cared for by others, you have to care about them, too.  If it’s just a one-way situation, not only does it not sustain over the long-term, but starts to transform into other things – envy, greed, jealousy, and even hatred. You might even see all this one-way caring as false – people are doing it just to get something from you. That’s paranoia, and not part of our happy place at all.

Discipline is not control, nor is it about punishment. Knowing that you have a genuine sense of where you want to be, and that you care that others can help you in creating that reality, now you need to actually pursue it and not just let it fade into the night as a nice dream.  To do that, is the work. But it’s not work if you enjoy what you’re doing. Just like any career formed around something you love to do, it transforms what was mundane, busy and irritating because it just must be done, into something gratifying and even pleasurable. Like building a house you get to live in, you take pride in doing a great job at something when you know what qualities went into creating it.  You don’t do it because you have to, you do it because you want to. Kingdoms are not strong because of the King by themselves. They become transformed because every single member contributes towards making the whole a greater presence of stability, growth, and even respect.  Each person’s discipline to go above and beyond becomes the Sangha, which ultimately satisfies the Self. And since somewhere inside you is a buddha wanting to emerge, the cycle perpetuates itself.

/* That’s it for this session. Thank you for listening. For more information feel free to e-mail me at jlui at jlui dot net, or twitter @jhlui1 With Gassho, James*/

TRCSESS – Trace Information for Various Oracle Sessions or Modules – Quick & Dirty Tip

Database Sessions view from Oracle SQL Developer

— Find your session

SQL> /* a Dell TOAD type query */

SELECT ROUND (BITAND (s.ownerid, 65535)) parent_session_sid,
ROUND (BITAND (s.ownerid, 16711680) / 65536) parent_session_instid,
RAWTOHEX (SADDR) AS saddr,
s.SID,
s.SERIAL#,
s.AUDSID,
RAWTOHEX (PADDR) AS paddr,
s.USER#,
s.USERNAME,
s.COMMAND,
s.OWNERID,
s.TADDR,
s.LOCKWAIT,
s.STATUS,
s.SERVER,
s.SCHEMA#,
s.SCHEMANAME,
s.OSUSER,
s.PROCESS,
s.MACHINE,
s.PORT,
s.TERMINAL,
UPPER (s.PROGRAM) PROGRAM,
s.TYPE,
s.SQL_ADDRESS,
s.SQL_HASH_VALUE,
s.SQL_ID,
s.SQL_CHILD_NUMBER,
s.SQL_EXEC_START,
s.SQL_EXEC_ID,
s.PREV_SQL_ADDR,
s.PREV_HASH_VALUE,
s.PREV_SQL_ID,
s.PREV_CHILD_NUMBER,
s.PREV_EXEC_START,
s.PREV_EXEC_ID,
s.PLSQL_ENTRY_OBJECT_ID,
s.PLSQL_ENTRY_SUBPROGRAM_ID,
s.PLSQL_OBJECT_ID,
s.PLSQL_SUBPROGRAM_ID,
s.MODULE,
s.MODULE_HASH,
s.ACTION,
s.ACTION_HASH,
s.CLIENT_INFO,
s.FIXED_TABLE_SEQUENCE,
s.ROW_WAIT_OBJ#,
s.ROW_WAIT_FILE#,
s.ROW_WAIT_BLOCK#,
s.ROW_WAIT_ROW#,
s.TOP_LEVEL_CALL#,
s.LOGON_TIME,
s.LAST_CALL_ET,
s.PDML_ENABLED,
s.FAILOVER_TYPE,
s.FAILOVER_METHOD,
s.FAILED_OVER,
s.RESOURCE_CONSUMER_GROUP,
s.PDML_STATUS,
s.PDDL_STATUS,
s.PQ_STATUS,
s.CURRENT_QUEUE_DURATION,
s.CLIENT_IDENTIFIER,
s.BLOCKING_SESSION_STATUS,
s.BLOCKING_INSTANCE,
s.BLOCKING_SESSION,
s.FINAL_BLOCKING_SESSION_STATUS,
s.FINAL_BLOCKING_INSTANCE,
s.FINAL_BLOCKING_SESSION,
s.SEQ#,
s.EVENT#,
s.EVENT,
s.P1TEXT,
s.P1,
s.P1RAW,
s.P2TEXT,
s.P2,
s.P2RAW,
s.P3TEXT,
s.P3,
s.P3RAW,
s.WAIT_CLASS_ID,
s.WAIT_CLASS#,
s.WAIT_CLASS,
s.WAIT_TIME,
s.SECONDS_IN_WAIT,
s.STATE,
s.WAIT_TIME_MICRO,
s.TIME_REMAINING_MICRO,
s.TIME_SINCE_LAST_WAIT_MICRO,
s.SERVICE_NAME,
s.SQL_TRACE,
s.SQL_TRACE_WAITS,
s.SQL_TRACE_BINDS,
s.SQL_TRACE_PLAN_STATS,
s.SESSION_EDITION_ID,
s.CREATOR_ADDR,
s.CREATOR_SERIAL#,
s.ECID,
stat.cpu – stat.CPU_this_call_start cpu_this_call,
stat.CPU,
stat.UGA_memory,
stat.PGA_memory,
stat.Commits,
stat.Rollbacks,
si.Block_Gets,
si.Consistent_Gets,
si.Physical_Reads,
si.Block_Changes,
si.Consistent_Changes,
p.program “OSProgram”,
p.spid,
p.pid
FROM V$SESSION S,
V$SESS_IO si,
V$PROCESS p,
(  SELECT ss.sid stat_sid,
SUM (
DECODE (sn.name, ‘CPU used when call started’, ss.VALUE, 0))
CPU_this_call_start,
SUM (
DECODE (sn.name, ‘CPU used by this session’, ss.VALUE, 0))
CPU,
SUM (DECODE (sn.name, ‘session uga memory’, ss.VALUE, 0))
uga_memory,
SUM (DECODE (sn.name, ‘session pga memory’, ss.VALUE, 0))
pga_memory,
SUM (DECODE (sn.name, ‘user commits’, ss.VALUE, 0)) commits,
SUM (DECODE (sn.name, ‘user rollbacks’, ss.VALUE, 0))
rollbacks
FROM v$sesstat ss, v$statname sn
WHERE     ss.STATISTIC# = sn.STATISTIC#
AND (   sn.name = ‘CPU used when call started’
OR sn.name = ‘CPU used by this session’
OR sn.name = ‘session uga memory’
OR sn.name = ‘session pga memory’
OR sn.name = ‘user commits’
OR sn.name = ‘user rollbacks’)
GROUP BY ss.sid) stat
WHERE     (    (s.USERNAME IS NOT NULL)
AND (NVL (s.osuser, ‘x’) <> ‘SYSTEM’)
AND (s.TYPE <> ‘BACKGROUND’))
AND si.sid(+) = s.sid
AND p.addr(+) = s.paddr
AND stat.stat_sid = s.sid

— Setup a Client Trace:

SQL> exec dbms_monitor.client_id_trace_enable (client_id=>'<terminal or client string>’);
PL/SQL procedure successfully completed.

— Setup a trace for all matching session threads for a module:
SQL> exec dbms_monitor.serv_mod_act_trace_enable (service_name=>'<ORACLE_SID or SERVICE_NAME>’, module_name=>'<MODULE from V$SESSION>’);
PL/SQL procedure successfully completed.

Visit your trace directory (in 11gR2 and up, you can consolidate the various dump locations using the init.ora parameter diagnostic_dest='<filepath>’)

# *.trc looks through every trace file in the directory for the matching module string
# Can also use any of the other options to search for specific sessions:
# [action=action_name]
# [clientid=client_id]
# [session=session_id]

oracle > trcsess output=mytrace.trc module=”<MODULE from V$SESSION>” *.trc

# Then just execute your normal tkprof command to format the consolidated output

oracle > tkprof mytrace.trc myformattedtrace.txt sys=no sort=exeela explain=<user/pwd>

# Voila!  All the traces for a specific session, module, or action at a specific time.

— Don’t forget to disable your tracing afterwards!

SQL> exec dbms_monitor.client_id_trace_disable (client_id=>'<terminal or client string>’);
PL/SQL procedure successfully completed.

— Setup a trace for all matching session threads for a module:
SQL> exec dbms_monitor.serv_mod_act_trace_disable (service_name=>'<ORACLE_SID or SERVICE_NAME>’, module_name=>'<MODULE from V$SESSION>’);
PL/SQL procedure successfully completed.

ORA-24247: network access denied by access control list (ACL) Demantra

When attempting to execute a new

ORA-29273: HTTP request failed

ORA-24247: network access denied by access control list (ACL)

ORA-06512: at “SYS.UTL_HTTP”, line 1491

ORA-06512: at “DEMANTRA_INTG.AU_TRIGGERWORKFLOW”, line 17

ORA-06512: at “DEMANTRA_INTG.XXDM_UPDATE_CONTAINER_DATA”, line 228

ORA-06512: at “DEMANTRA_INTG.XXDM_BUILD_CONTAINER”, line 344

ORA-06512: at line 1

Starting Demantra: Hardware. LOG. JAVA Compatibility ACL / SYS_GRANTS. SYNC WKS. Setup MAIL (Doc ID 1372253.1)

Here is an example of Demantra installed directory where the sql files located:

C:\Program Files (x86)\Oracle Demantra 12.2.4.1\Demand Planner\Database Objects\Oracle Server\admin

SYS_GRANTS

SYS_GRANTS.SQL or ACL error

Have you met this error on db_exception_log? ~ This is how you can fix it!:

29273 : ORA-29273: HTTP request failed
ORA-06512: at “”SYS.UTL_HTTP””, line 1817
ORA-24247: network access denied by access control list (ACL)”

SYS_GRANTS.sql performs the following:
– Adds EXECUTE privileges to access DBMS_CRYPTO (UPGRADE_PASSWORDS): Provides the highest level of user password encryption.
– Adds EXECUTE privileges to access DBMS_LOCK: Provides as SLEEP operation for improved concurrency.
– Adds EXECUTE privileges to access V_$PARAMETER so that Oracle Demantra can better adapt to your database configuration.
– (10g only) Adds GRANT privileges to access the package UTL_HTTP, which enables Oracle Demantra to send notification messages to the application server and engine.
– (11g only) Adds an ACL to enable HTTP communications for Oracle Demantra to send notification messages to the application server and engine.

Find it in Demantra_Folder\Demand Planner\Database Objects\Oracle Server\admin
or directly in the root of the Demantra installation package.

Please also verify you have the correct data in
SQL> select * from sys_params where lower(pname) like ‘%url%’;

You need to run this script manually after installing or upgrading Demantra only if you did not specify a database user with full SYSDBA privileges when running the Installer.

1. !! Login AS sys, WITH sysdba privileges:

2. C:\> cd DEMANTRA_INSTALL_DIRECTORY

3. C:\DEMANTRA_INSTALL_DIRECTORY> sqlplus SYS@SERVER as sysdba@sys_grants.sql DM_SCHEMA_USER ACL_for_WebServerURL ACL_for_EngineServerURL

Example execution:

C:\DEMANTRA_INSTALL_DIRECTORY> sqlplus SYS@SERVER as sysdba@sys_grants.sql DM_SCHEMA_USER ‘/sys/acls/demantra.xml’ ‘ /sys/acls/demantra.xml’

OR by Default: if you are not sure, they will be created if they do not exist, or updated in /sys/acls/demantra.xml:

SQL> @sys_grants.sql DM_USER ACL_DEFAULT ACL_DEFAULT;

General Checks:

— select * from dba_network_acls;

— select * from dba_network_acl_privileges;

Check also in sys_params or Business Modeler

— AppServerURL and

— EngineServerURL

— select * from sys_params where lower(pname) like ‘%url%’;

Check:
— SQL> select * from DBA_tab_privs where grantee = ‘DEMANTRA’ ; — (dem schema)
— Be sure from system user run if needed entry for APPS user against demantra.xml in dba_network_acl_privileges table: BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE ( ‘/sys/acls/demantra.xml’, ‘APPS’,TRUE,’connect’); COMMIT; END;
—Also check entry for UTL_HTTP table for the query – select * from DBA_tab_privs where grantee = ‘DEMANTRA’ ;

Check

For failed login problem to Collaborator Workbench, check if sys_grants is needed to be applied again:

1. SQL> select distinct encryption_type from user_id; — This should return a single value like “SHA-1”

2. SQL> select encryption.get_highest_desc() from dual; — This should return the same value returned in step (1).

If the result of (1) is “SHA-1” but the return of (2) is something else, then you need to fix your sys_grants.

 

References:

Document: 454369.1 Roles and Privileges that are granted to the Demantra database during the install process
Document: 730883.1 Additional Database Privilege needed for Demantra Schema when Running on Oracle 11g Database
Document: 1064995.1 Additional Configurations needed when Running Demantra on Oracle 11g Databases
Oracle Demantra Installation Guide for Release 7.3 Document: 825082.1

2016-05 May Shinnyo Podcast – Practice –

2016-05 May Shinnyo Podcast – Practice – 2016-05 May Shinnyo Podcast – Practice What is a Practice? Why do we Practice (and not Preach?) The Story of Buddha and the 3 Monks Practice is Not Perfect Balance of Time – Working with Karma Subscribe to this Podcast (RSS) or iTunes or via Flipboard What is a practice? Pretty much anything you do. … Continue reading 2016-05 May Shinnyo Podcast – Practice → http://ow.ly/X67g500xssz