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
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
    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
My Oracle Support - Download Collector page
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

Pokemon Go meme - Expectation vs. Reality
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.

[YouTube] 8th Grader Recites “White Boy Privilege” Poem! 8th Grader Recites “White Boy Privilege” Poem!
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

Unboxing the ZzzQuil
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

Shinnyo Nirvana Image

http://classconnection.s3.amazonaws.com/897/flashcards/388897/jpg/yumedono_kannon.jpg

http://sixprizes.com/wp-content/uploads/mc-escher-self-reflection.jpg

https://upload.wikimedia.org/wikipedia/commons/2/26/Okunoin_FudoMyoo.JPG

 

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

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

theoryintopractice
Courtesy of creative-remembering-techniques.com

What is a practice? Pretty much anything you do.  What is not practice? Thinking without action, although philosophically-speaking, inaction is still action, as it results in an outcome whether intended or not.

Practice in this context, is not limited to something specific you’re trying to learn, Philosophically, we could say we’re learning throughout our lives, each and every day, so that’s how our “practice” extends throughout our days, indeed throughout our lives.

But isn’t it good enough to be really loud and speak your thoughts like a broadcast?

the-brixton-evangelist
Street evangelism 1950’s Brixton, UK

What happens when you hear such a person?  Is it a moment to stop, listen and contemplate carefully what they’re saying?  Or do you mentally try to block out the extreme noise, and make a mental note to avoid that place in the future.  After all, if it works for cheerleading, why wouldn’t it work for all communication?

51176-318x283-megaphone2
Cheerleading with megaphone

If you observe the difference in context, you can see or maybe hear, the difference between an audience that wants to hear you (and can’t because you’re very far away,) versus one who is trying to tune you out and being viewed as an irritant rather than a example.

Master Shinjo once related how different types of people react to guidance with a story about Shakyamuni Buddha and his disciple Ananda walking home one night. They came across three monks who had been drinking something that was forbidden for monks at the time. The first monk quickly hid on the side of the road behind the bushes hoping not to be discovered.  The second monk averted his gaze and walked quickly past the Tathagata hoping not to be noticed.  The third monk thought that the money he spent was his own and boldly walked calmly right in front of the Buddha without care.  Master Shinjo’s notes on this encounter mention that the first monk represents readily instructable people who are open to new ideas, the second person might need more specific examples and might question reasoning but are motivated by emotional care and compassion, and the third person might need actual correction and regulation in order to learn a new behavior.  Depending on the person, your words and actions might be absorbed readily like a thirsty sponge, or discarded as so much hearsay and opinion.  For those interested in delving further into this story, next month’s podcast will explore the realms of the three areas of Intrinsic, Compassionate and Strict styles of teaching (the 3-Wheel Turning Bodies of the Buddha, Kannon Bodhisattva and Mahavairochana Achala.)

About 2 years ago, I decided that collecting guitars was not the same as actually playing them and signed up for formal lessons.  A long time had passed since I last had something that needed periodic and continued effort to get past my own mental and physical blocks to mastery, and this instrument had become one of those – the kind of situation where you can play “Stairway to Heaven” until people don’t want to hear you any more, but you can’t pick up a random music score and play it because you’re not familiar with how it goes. It’s very similar to saying, “I’m a very religious person,” and everyone nods their heads and thinks, “yes, and one day we’ll see it by actual example.” In this way, you can be doing or saying something quite clear, honest and with great intent, but without reflection upon the outcome of such actions, there really isn’t any measure for improvement or failure.

Just as much as every day we are sedentary, we lose some 1% of our muscle mass per year after 50, the same goes with both our minds, and our efforts to practice. Like that slowly leaking balloon that looks really great floating around, but it’s ever so slowly losing its helium and eventually grounds itself as a deflated rubber raisin, when we don’t do something each day to offset our little sack of karma, it too gets slowly heavier and heavier through natural entropy. To keep our momentum going and that sack staying as light as it can be, it takes daily efforts, and renewed exertion to offset the gentle though persistent waves of sediment that slowly build up over time, and eventually can solidify into much harder to break stone.  This is an example of the same person transitioning between starting out like the first monk described above, and later developing into the third monk even without intent to do so.

/* 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*/

Oracle DataGuard and Standby Database Archive Logs

Users see your wonderful DataGuard implementation like this:

Simple Oracle Dataguard Architecture
Simple Oracle Dataguard Architecture courtesy of https://appsdbatraining.files.wordpress.com

And yet, you know the actual picture looks more like this:

A map of Oracle DataGuard Architecture components
A map of Oracle DataGuard Architecture components

High-availability – the concept behind it makes every DBA shudder because every time it seems you deal with one element and have it protected, there’s another underlying component that also needs protection and redudancy, or else your solution is still insufficient.

Real Application Clusters (RAC) covers individual database host failures but is sensitive to failure of the storage subsystem or the network interconnections between the hosts.

Recovery Manager (RMAN) is your vital tool to keeping track of what’s backed up and where is it.  And its catalog of recovery information could reside locally in copies of the controlfiles, or centrally in another database.  Depends on your backup strategies, really.  Are you using SAN-based backups (snaps, virtual images, deduplicated block replication) or off-site methods that would have to be shipped back to start recovery?

But the typical first-time setup scenario, is you use the OEM-based jiffy whizbang method to setup your new DataGuard environment at the recommendation of one of the steps int the Maximum Availability Advisor (MAA), and everything’s up and running nicely.  You schedule a new weekly full backup, plus daily incremental backup as Oracle recommended practices prescribe, and notice everything’s running smoothly.

Except on your standby database, the archivelogs are piling up and not being deleted automatically.  What’s next?

This thread was a basic discussion in the Oracle Community forums of the topic:

https://community.oracle.com/thread/2388130?start=0&tstart=0

This is a typical RMAN-based configuration:

On Primary

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

On Standby ( Depends upon where backup is preformed )

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Or

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

/* if Standby Where Backups Are Not Performed  */

Source:

Data Guard Concepts and Administration 12c

http://docs.oracle.com/database/121/SBYDB/toc.htm

12 Using RMAN to Back Up and Restore FilesRMAN Configurations at the Primary Database
12.3.4 RMAN Configurations at a Standby Where Backups Are Not Performed

The following RMAN configurations are recommended at a standby database where backups are not done:

  1. Connect RMAN to the standby database as target, and to the recovery catalog.
  2. Enable automatic deletion of archived logs once they are applied at the standby database (this is also applicable to all terminal databases when the cascading or far sync instance features are in use):
  3. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

 

** However, that doesn’t really take into consideration what might happen if a final archivelog before switchover of roles doesn’t quite make it on the standby (for whatever reason, it gets corrupted during playback or something similar which results in a Database Needs More Recovery error.)

Based upon:

12.3.3 RMAN Configurations at a Standby Database Where Backups are Performed

The following RMAN configurations are recommended at a standby database where backups are done:

  1. Connect RMAN to the standby database (where backups are performed) as target, and to the recovery catalog.
  2. Enable automatic backup of the control file and the server parameter file:

3.  RMAN > CONFIGURE CONTROLFILE AUTOBACKUP ON;

  1. Skip backing up data files for which there already exists a valid backup with the same checkpoint:

5.  RMAN > CONFIGURE BACKUP OPTIMIZATION ON;

  1. Configure the tape channels to create backups as required by media management software:

7.  RMAN > CONFIGURE CHANNEL DEVICE TYPE SBT PARMS ‘<channel parameters>’;

  1. Because the archived logs are backed up at the standby database, Oracle recommends that you configure the BACKED UP option for the log deletion policy:

9.  RMAN > CONFIGURE ARCHIVELOG DELETION POLICY BACKED UP n TIMES TO [DEVICE TYPE SBT];

 

I came up with the configuration of:

 

On Standby ( Depends upon where backup is preformed )

# If no DataGuard is present (single DB host):

# Ensure daily RMAN backup job is being executed in OEM or via cron.

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

 

And setup a 2nd backup set for the Standby Host DB.  This puts the backups into the defined Fast Recovery Area and manages both the backups and archivelog retention in the same mountpoint.

 

Each has its pros and cons depending on the scenario.You need to lay out your entire architecture scheme including backup solutions and play out the various scenarios that you’re required to cover as far as your Quality of Service (QOS) guarantee to your end-user population.

And of course, if you’re using the advanced cross-WAN FarSync DataGuard implementation architecture (wherein there’s a separate Failover Archive Log (FAL) standby database whose sole purpose in life is to cache archivelogs in case the data replication stream is too much for WAN bandwidth to handle in real-time.) this all still applies because the FAL server is basically just another standby target which needs managing just as much as any regular LAN-based full DataGuard standby instance (it’s just missing the big datafiles and handles all the archivelog traffic.)  You’ll just have even more servers and services involved in keeping the whole thing running (like your Global Names Service servers and databases, which might also be RAC and DataGuard protected, or your Single-Sign On authentication services, or even the OEM Cloud Control OMS itself orchestrating all of that.)

 

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 405 other followers

%d bloggers like this: