Enterprise Manager 12.1.0.4.0 – Post Upgrade Tasks

Must keep up with OEM 12c Grid Control updates…

Maaz Anjum's Blog

With the new release of Enterprise Manager, I upgraded my 12.1.0.3.0 installation successfully using the superb documentation here. It is however, important to note that the post-steps are also important. For example, upgrading (at the very least) the Management Agent on the OMS host, and de-installation of the old-OMS home. Gokhan Atil wrote a good post on the actual upgrade process which is available on his blog.

Management Agent Upgrade on the OMS Host:

The upgrade process for agents has not changed since EM’s previous 12c releases.

1. Navigate to the “Upgrade Agents” link under the Setup -> Manage Cloud Control menu.

2. Select the agent(s) for the OMS Hosts and click “OK”.

3. With the Agents selected, click on “Submit”. You have the option to override the “Privileged Credentials” to run the root.sh script.

4. The submitted job takes a few minutes before it completes (hopefully successfully!).

View original post 307 more words

Advertisement

#OOW14 – @Oracle Enterprise Management for Applications SIG Mtg – 9/28 MW3003 3:30P-4:15P

http://em4apps.oaug.org/News.php

OOW14 Sunday Schedule 28-SEP-2014

We’ll be at OpenWorld 2014 in San Francisco on User Group Sunday, September 28 (Session Time Mostone West – 3003; 15:30 – 16:15): SIG9177 – OAUG Enterprise Manager for Applications SIG Meeting

Click Here to Add to Outlook/iCalendar

LinkedIn Discussion Forum created by consensus of the attendees:

https://www.linkedin.com/groups/Oracle-Enterprise-Manager-Applications-OEM4APPS-6780481

Oracle R12.1.3 e-Business Forms Freezing on Launch – UTL_FILE cause

We had a unique encounter with the issue of Forms “freezing” on launch (also when seeing FRM-40734: Internal Error: PL/SQL Error occurred; FRM-92102: A network error has occurred)

One of the key debugging actions taken is the steps related to My Oracle Support (support.oracle.com) article:

R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications ( Doc ID 438652.1 )

From this screenshot, you can see that the Forms Server is actually successfully launching (that’s why you can see the Navigator and Menu Bar), but something is not populating the actual session-related information (the menu items, the functions available,etc.)

Since we are on Single-Sign On (SSO) you might be freezing instead just after the Forms Login screen.

Turned out to be incorrect settings for the UTL_FILE_DIR parameter for the database which had been set using an online ALTER SYSTEM SET command, but would not show up until the database was re-started.  (nb UTL_FILE_DIR is notoriously picky about quotes and commas for multiple directories being specified.) The ALTER command should appear as (for 11g):

SQL> alter system set UTL_FILE_DIR=’dir1′,’dir2′,’dir3′

But often someone uses the following (which used to work in 8i, 9i, but is now invalid):

SQL> alter system set UTL_FILE_DIR=’dir1,dir2,dir3′

Once the DB was restarted, it ended up with an incorrect UTL_FILE_DIR parameter and was unable to write the session flag files to the expected temporary directory (usually APPLPTMP).

One of the DB Trace files produced during the attempt to login included:

/* Section below shows AXF framework extensions are in-use */

PARSE #47660147519768:c=0,e=899,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=27491517,tim=1408123870515184
EXEC #47660147519768:c=0,e=21,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=27491517,tim=1408123870528903
WAIT #47660147519768: nam=’SQL*Net message to client’ ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1408123870528942
FETCH #47660147519768:c=0,e=147,p=0,cr=14,cu=0,mis=0,r=1,dep=0,og=1,plh=27491517,tim=1408123870529153
STAT #47660147519768 id=1 cnt=1 pid=0 pos=1 obj=799475 op=’TABLE ACCESS FULL AXF_CONFIGS (cr=14 pr=0 pw=0 time=64 us cost=5 size=20 card=1)’
WAIT #47660147519768: nam=’SQL*Net message from client’ ela= 758 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1408123870530064
=====================

/* This appears to be a Session Date/Time check */
PARSING IN CURSOR #47660147509432 len=67 dep=0 uid=173 oct=3 lid=173 tim=1408123870540535 hv=1198194657 ad=’c576482b8′ sqlid=’apkw4m53qpzz1′
SELECT TO_CHAR (SYSDATE , ‘MM-DD-YYYY HH24:MI:SS ‘ ) FROM DUAL
END OF STMT
PARSE #47660147509432:c=0,e=179,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1388734953,tim=1408123870540535
EXEC #47660147509432:c=1000,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1388734953,tim=1408123870542624
WAIT #47660147509432: nam=’SQL*Net message to client’ ela= 7 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1408123870549410
FETCH #47660147509432:c=0,e=16,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=1388734953,tim=1408123870565439
STAT #47660147509432 id=1 cnt=1 pid=0 pos=1 obj=0 op=’FAST DUAL (cr=0 pr=0 pw=0 time=1 us cost=2 size=0 card=1)’
WAIT #47660147509432: nam=’SQL*Net message from client’ ela= 528 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1408123870566111
=====================

/* This is how Servlets are tracking Sessions to Users when connections are switched to other middle-tier hosts – little session flag files being placed via UTL_FILE */

PARSING IN CURSOR #47660147514600 len=63 dep=0 uid=173 oct=3 lid=173 tim=1408123870566333 hv=3366187836 ad=’c4ec76ae0′ sqlid=’axark7b4a7wtw’
SELECT VALUE FROM V$PARAMETER WHERE NAME = ‘utl_file_dir’ <——-
END OF STMT
PARSE #47660147514600:c=0,e=174,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1128103955,tim=1408123870566333
EXEC #47660147514600:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1128103955,tim=1408123870566438
WAIT #47660147514600: nam=’SQL*Net message to client’ ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1408123870566552
FETCH #47660147514600:c=7998,e=7815,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=1128103955,tim=1408123870574414
STAT #47660147514600 id=1 cnt=1 pid=0 pos=1 obj=0 op=’HASH JOIN (cr=0 pr=0 pw=0 time=7812 us cost=3 size=54 card=1)’
STAT #47660147514600 id=2 cnt=1 pid=1 pos=1 obj=0 op=’FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=2171 us cost=1 size=36 card=1)’
STAT #47660147514600 id=3 cnt=2752 pid=1 pos=2 obj=0 op=’FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=3758 us cost=1 size=49536 card=2752)’
WAIT #47660147514600: nam=’SQL*Net message from client’ ela= 890 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1408123870576789
RPC CALL:FUNCTION SYS.UTL_FILE.FOPEN(LOCATION IN VARCHAR2, FILENAME IN VARCHAR2, OPEN_MODE IN VARCHAR2, MAX_LINESIZE IN BINARY_INTEGER) RETURN FILE_TYPE;
RPC BINDS:
bind 0: dty=1 bfp=2b58be1c3ff8 flg=08 avl=46 mxl=32767 val=”/prodarmk/inst/apps/PRODARMK_ascopofinm01/temp”<———–
bind 1: dty=1 bfp=2b58be1b3ff8 flg=08 avl=22 mxl=32767 val=”YOUNGA2_MASTER_LOG.txt”

After the UTL_FILE_DIR setting was corrected, and the database re-started, Forms Launching worked correctly again.

However, there are dozens of other causes of this type of Forms Freeze issue.  Some of the other things we had to rule out were:

adadmin:

• Recompile APPS Schema
• Recompile Forms executables
• Regenerate JAR files
• Recompile menus
• Recompile flexfields

Recompile Forms Server Binaries:

• cd $ORACLE_HOME/forms/lib; make -f ins_forms.mk sharedlib
• cd $ORACLE_HOME/forms/lib; make -f ins_forms.mk install
• adrelink.sh force=y “fnd fndfmxit.so”
• adrelink.sh force=y “fnd fndrwxit.so”

Verify APPS password and FND_ORACLE_USERID encryption.

Verify APPLSYSPUB connectivity.

Verify Forms Server launch operations manually using DBC

Socket version:  http://&lthostname&gt:&ltport&gt/forms/frmservlet?config=debug1&ampform_params=+config=&ltORACLE_SID&gt.dbc

Servlet version:  http://&lthostname&gt:&ltport&gt/OA_HTML/frmservlet?config=debug1&ampform_params=+config=&ltORACLE_SID&gt.dbc

Oracle Database 12c – Interactive Quick Reference

Happened to run into this while Googling around.  It’s quite useful and well-produced for anyone interested in learning about the 12c RDBMS architecture, V$ views, how the processes relate to each other, and need an overview of how the Container and/or Pluggable multitenant features work.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/poster/OUTPUT_poster/poster.html

Sample Oracle 12c Database Interactive Quick Reference Pages

2014-08 Shinnyo Buddhism Podcast – The L

2014-08 Shinnyo Buddhism Podcast – The Lights of Reflection – 2014-08 Shinnyo Buddhism Podcast – The Lights of Reflection Shiny Points of Light on the Freeway (of Life) Finding the Brightness (in Everyone) Seeing Beyond the Grime and Noise Cleaning a Little Every Moment Subscribe to this Podcast (RSS) or iTunes Have you ever driven down the road on a sunny morning and looked at […] http://ow.ly/2Lyvdt

2014-08 Shinnyo Buddhism Podcast – The Lights of Reflection

2014-08 Shinnyo Buddhism Podcast – The Lights of Reflection

• Shiny Points of Light on the Freeway (of Life)
• Finding the Brightness (in Everyone)
• Seeing Beyond the Grime and Noise
• Cleaning a Little Every Moment

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

Have you ever driven down the road on a sunny morning and looked at the other cars? Usually in the early morning, or late afternoon, sunlight seems to reflect off of the cars in front of us, and often the cars coming towards us in the opposite direction. The sunlight doesn’t seem to pay attention to the particular make or model of the cars. Nor does it seem to always be brightest on the biggest ones, or the fastest ones, or even the oldest ones. Sometimes all of the cars are very bright; and other times a random few seem to glimmer back at you.  Sunlight doesn’t pay any attention to how much a car is worth, nor how it was manufactured.

When we talk about every person having a Buddha nature within, sometimes it’s hard to imagine _every_ person having one. So, instead, look at the lights reflected on the cars.  Can you predict which ones will be bright, versus the ones which have no reflection at all?  Are the light reflections based upon where they came from, how they were built, or how expensive they were to buy? And yet, every single car, at one point or another, will reflect light; and sometimes that light cannot be seen by you, because of your perspective. But that same car could be brilliant to another person. Sometimes the person inside a car cannot see any reflections at all, especially upon their own vehicle.

And that’s how this concept of Buddha nature works. And the challenge becomes to imagine every single car you see before you and behind you with its own brilliant reflection, whether or not it’s immediately obvious or apparent. Even if that brightness is hidden behind years of dirt and rust, it’s still in there lying quietly beneath the grime.  That little light even is there if the vehicle is angrily honking at everyone, or smashed in an accident. Or even if the car sits idly every day, there is a reflection there somewhere waiting for someone to see it.

Also think about your own shiny reflection, that for the most part, you cannot see yourself. You can polish yourself to shine as brightly as possible. You can appreciate when others see those reflections becoming visible to others. And you can even come to appreciate when someone else notices a dull spot that can use a little more attention, because they would like your brilliance to shine brightly, too. Shinnyo members think a lot about cleaning, because it’s often a direct analogy to not only hygiene, but also to our spiritual cleanliness. Looking at our own limitations, prejudices, criticisms and need to get rewarded, or finding fault in others can be thought of as dirt sitting in our own spiritual vessels.  Every time we go to fill ourselves up with the waters of good or positivity, the more dirt and sediment that sits at the bottom, the quicker that same water becomes cloudy or even muddy once all that dirt is stirred up by the water.

So we learn to start with ourselves – cleaning out the dirt at the bottom of our own lives first. We ask others to see if our vessel is clean; or simply take note when someone else points out we have some dirt left over within. And we polish and sweep and wipe as many times as needed to keep our little containers ready to fill with pure water. Of course, just like any pail left outside, it will start to collect more dirt and dust as it sits, because that’s part of being a part of the great outdoors of society and the world. But if you keep cleaning a little each and every day, that task becomes easier and simpler each time.