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 dozens of sales and account professionals at each event) at OOW. To attend one of these events:
You’re registered as an OpenWorld Attendee.
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.
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.
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.
Relatively easy installation, a new learning curve to master for post-installation maintenance and patching.
The principal changes in Release 2 of 13c are the segregation of the Cloud Management Services plugins (and related functionality) to specific licensable plugin components – namely:
Cloud Services Management – used for provisioning, allocation, and administration (think “infrastructure”) of Oracle Public Cloud-based resources (databases, development tools, middleware, etc.)
Oracle Cloud Application – a portal punch-out to access Oracle Cloud-based applications such as hosted e-Business Suite, Cloud Content Management, Cloud SOA Suite, Cloud Identity Management, etc. (think “apps”.)
This proof-of-concept testbed system was based upon the latest available installer set – Oracle Enterprise Manager Cloud Control 13c Release 2 Plug-in Update 1 (13.2.0.0) – we happen to be testing backwards-compatibility with some 10g databases before committing to the upgrade. Direct (out-of-place) upgrades are supported for version of EM 12.1.0.4 and newer.
Fusion Middleware in this release is Weblogic 12.1.3
The host system is built upon Windows Server 2012 R2, single-tier, 16GB RAM, 2 cores, also hosting the OMS repository database in a 12.2.0.1.0 EE installation. Since the DB Templates provided seemed to be specific for a 12.1.x database (and errors out in certain steps during the build), I simply created a generic database from the standard template with the pre-requisite parameter settings (e.g. _allow_insert_with_update_check=TRUE; sessions > 300; shared_pool_size (10% of SGA); etc.) , and pre-created the required tablespaces:
MGMT_AD4J_TS
MGMT_ECM_DEPOT_TS
MGMT_TABLESPACE
During the installation, the (Oracle Universal Installer) OUI will create the following new users assigned to these tablespaces:
The standard download set includes a single executable file (.exe or .bin) and several additional ZIP archives. These are to be staged in a single directory, and the ZIP files do NOT need to be pre-extracted.
Overall, the installation was straight-forward and as-documented (despite this being a Windows installation – which usually has its own quirks.) The portion that I feel has the steepest learning curve is post-installation maintenance, and particularly patching. The new tool in 13c, the OMSpatcher (Patchset 19999993 – think of it as a Java wrapper for opatch) was really designed for use specficially in a cloud-based environment and hasn’t been completely polished for use on-premise in smaller installations.
For example, it is designed to rely upon an active Weblogic AdminServer to instantiate it’s requests for inventory versioning information and component availability for patching. But if any of those components are actually in-use by the AdminServer itself, it will tend to fail to apply, and instead provide a lengthy step-by-step instruction set of how to accomplish all of the steps manually. Depending on the complexity of your OEM setup (e.g. the number of registered plugins and target types) this could take over an hour to get the patching utility to fail and then provide the manual steps.
The OEM-specific version of OPatch (Patchset 6880880) is quite different than its predecessors. While the OMSPatcher uses the prior “unzip into the existing Oracle Home” installation technique, the OPatch utility itself now is a Java installer that relies on the OUI to allow updating of component versioning and inventory adjustments. Most importantly, you will need to “install” the new version of OPatch before being allowed to continue with your planned patching:
$JAVA_PATH\java -jar $PATCH_STAGE\6880880\opatch_generic.jar -silent oracle_home=$ORACLE_HOME (being updated for OPatch)
This OPatch update needs to be applied (before patching) to every Oracle Home using 13c technology (the OMS home, the Agent Home, other FMW homes at version 12.1.3 or newer, etc.)
See MOS EM 13c: How to Apply a Patch to the Enterprise Manager 13c Cloud Control OMS Oracle Home (Doc ID 2091619.1) for details about making an OMSPatcher property file, and why you want to create one.
Final steps executed:
Build general purpose 12.2.0.1.0 database with new tablespaces.
Install Oracle Enterprise Manager Cloud Control 13c Release 2 Plug-in Update 1 (13.2.0.0)
Patch 19999993: EM OMSPatcher latest version 13.8.0.0.2 (unzip to ORACLE_HOME)
Patch 6880880: EM OPatch latest version 13.9.0.0.0 (both OMS and Agent)
cd $PATCH_STAGE\<patch#>
$FMW_HOME\OMSPatcher\omspatcher apply -analyze -property_file
$FMW_HOME\OMSPatcher\omspatcher apply -property_file [OMS_DISABLE_HOST_CHECK=true -- a useful option added to deal with virtual host names]
Patch 25163555: Tracking bug for Back-porting 24588124 oms side fix
Patch 25604219: MERGE REQUEST ON TOP OF 13.2.0.0.0 FOR BUGS 25497622 25497731 25506784
Patch 25387277: APR-2017 PSU OMS 13.2.0.0.170418
Patch 25162444: EM-BEACON Bundle Patch 13.2.0.0.161231 (Agent)
Patch 25580746: EM-AGENT Bundle Patch 13.2.0.0.170331 (Agent)
Other useful references:
Enterprise Manager 13.2 Master Bundle Patch List (Doc ID 2219797.1)
13.2.0.0.170418 Enterprise Manager Base Platform Patch Set Update (PSU) Readme for Oracle Management Server (OMS) (Doc ID 2246778.1)
alter session set current_schema=APPS;
exec AD_ZD_PREP.ENABLE_CUSTOM_USER(‘XXCUSTOMSCHEMA’);
/* Create your SELECT grants to the editioned objects as APPS user */
grant select on ap.ap_suppliers# to XXCUSTOMSCHEMA;
/* Create your custom view referencing the APPS synonym – which points to the editioned object */
create or replace force view XXCUSTOMSCHEMA.AP_SUPPLIER_NEW_V
as
SELECT *
FROM apps.ap_suppliers ;
This is the same process when creating procedures and functions with the usual caveat that unless it’s a 12c database, you cannot create materialized views on the editioned objects.
For the 11gR2 EBS users, you would stick with the existing non-editioned table object reference:
CREATE MATERIALIZED VIEW APPS.XXAP_SUPPLIER_NEW_MV
(
vendor_id,
vendor_name
)
AS
SELECT aps.vendor_id, aps.vendor_name
FROM ap.ap_suppliers aps;
/* The owning schema for the materialized view must have CREATE TABLE, VIEW AND INDEX privileges on the destination tablespace */
Prayer beads – in some cultures called “worry beads” as having something in the hand to hold, whether another person’s hand, or a string of objects, has always brought a psychological comfort to the holder.
In buddhism, you tend to see them all over the place – people holding them in their hands, a bracelet on the wrist, a string of beads hanging from their forearm, a pile of beads on an altar, someone holding up the beads in front of the altar doing something with them in mid-air. You won’t see them worn around the neck as jewelry, nor tossed around like Mardi Gras bangles. They seem to have another purpose. What could that be?
Shingon Buddhist prayer beads – different styles.
For further purposes of simplicity, the kinds of prayer beads I’ll be referring in this introduction will be the basic bead sets used by the Shingon esoteric sects. The strand has 108 beads in the circle, divided in two semi-circles by a set of tassels at either end of the loop. One tassel has an extra bead (often referred to as the Mother bead) on it. Counting in from that extra beaded tassle, there are 7 beads, followed by a different kind of bead, followed by 14 more beads, and a different bead, then 33 more beads until the other tassel. Each tassel also has 5 beads (not counting the Mother bead) on it, with a single different bead before the fluffy or ball end of the tassel. They can be made of many different materials, though natural ones are the most preferred (glass, wood, stone, marble, etc.)
There are two basic explanations beyond the “comforting thing to hold” idea for the purpose of the beads. One is symbolic or esoteric, representing the many different things affecting humans. In this version, the 108 beads represent human life problems and struggles. Zen buddhism has an interesting specificity in their definition by multiplying the six senses (sight, hearing, touch, taste, smell, and mind) by the six physical sources of sense (eyes, ears, body, tongue, nose, and brain.) This results in 36 combinations, half of which are positive, and half negative impressions. Multiplying these 36 by the past, present and future positions in time in which they may occur, leads us to the 108 delusions of attachment (or things we should be apologetic for during our path to enlightenment.)
The other is a more functional or technical explanation – counting. There are many basic actions requiring repeating 3 times (bows, chants, prostrations, etc.) which are easy enough to count by yourself. But getting to 5, 7, 21, 33 or 100 times of anything, can find you spending more energy or thought trying to remember how many you just did, rather than being immersed in the action of what you’re supposed to be doing. That’s when holding the beads in one hand while incrementing one bead each time you do something, makes it easy to physically keep track of how many actions you just performed. Simple, practical and something that won’t break your concentration or focus.
A final more psychological use is that of representation. The beads represent a reminder to be mindful of the many ways in which we as humans stray from our own paths of peace. We take care to remember that not only do we individually have all of these perceptions that lead us towards polarized emotions, but so does everyone else around us. To remember that each of us has an innate need for peace and tranquility, is to also find ways to cultivate that same awareness in others.
/* 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*/
2017-01 Shinnyo Podcast Peace Through St – 2017-01 Shinnyo Podcast Peace Through Strength – 2017-01 Shinnyo Podcast Peace Through Strength Contradiction A Strong Fence Has Two Sides Fear Builds Walls The Middle Way Subscribe to this Podcast (RSS) or iTunes or via Flipboard There is often confusion about what we think is a stereotype of a buddhist monk – shaven head, wearing … Continue reading 2017-01 Shinnyo Podcast Peace Through St → http://ow.ly/fdHr508Xfec
2017-01 Shinnyo Podcast Peace Through Strength – 2017-01 Shinnyo Podcast Peace Through Strength Contradiction A Strong Fence Has Two Sides Fear Builds Walls The Middle Way Subscribe to this Podcast (RSS) or iTunes or via Flipboard There is often confusion about what we think is a stereotype of a buddhist monk – shaven head, wearing robes, poor in material but rich in … Continue reading 2017-01 Shinnyo Podcast Peace Through Strength → http://ow.ly/D86e5087onP
Back in the 1980’s, one of the common catch-phrases in the aerospace/defense industry brought about during the Cold War years was the concept of “Peace Through Strength.” The idea was that by having or possessing technology or weaponry which instilled fear in your opponent that the entire notion of committing an act of aggression would be dissuaded by the immediate and present fear of losing the confrontation (the premise of Mutually Assured Destruction). Then we further escalated the tension by envisioning “First Strike” capability, wherein upon even the threat of a potential nuclear conflict, we’d simply launch first. But what if we disable their ability to launch, then we’ve truly won? What if they disable our ability to disable them first? This rather nauseating discussion continues even today.
But let’s examine the behavior on a much more local scale, what keeps a potential burglar from entering your home? An obvious security system? A strongly locked front door? A loudly barking dog? Think about the situation from the perspective of the thief. Seeking the path of least resistance is common human behavior, even in the most monumental efforts. Each form of deterrence presents a form of resistance – another boulder in the stream. Some thieves may be deterred by strong evidence of defense, and yet others may be actually attracted with the potential of greater rewards hiding behind an iron curtain of protection. Is what’s in Fort Knox perhaps more valuable than something sitting in an open box on the curb?
A different way of seeing the differences might be comparing a skunk and a domestic cat. When you observe skunks, you might notice they don’t travel very quickly, and are almost casual in their pursuit of food and shelter. The high contrast colors of their fur, and certainly their smell bring an aura of caution and warning to every thing that encounters them..While they have sharp claws and teeth, they rely mostly on intimidation by scent and fluffing out their body and tail fur to make themselves appear bigger, hopefully scaring away a potential predator. Cats by comparison come in a couple of noticeable varieties – those that are quite easily skittish and very wary of approaching anyone or anything, and those that seem to be affectionate to everything and anyone. To a predator, the easy target might be the affectionate kitty, whereas it might avoid entirely going after the skunk.
Is our vision of our perfect existence a world full of skunks, or kittens? Doesn’t it depend a bit on whether you’re a predator, a skunk, or someone seeking companionship? In the latter case, you might find it much more difficult to make friends with a skunk. Or not – maybe you’ve lost your sense of smell.
And why would we see “violent” monks? Because we are still human. Yes, even monks. They are still people; people who have fears. Their attachment may be to their faith believing only they can defend properly its teachings or even its existence. Perhaps they are afraid that their example is not sufficient for others to follow. Maybe they believe that by providing a tough exterior it will shield the precious contents from theft or harm.
But re-examine the thief scenario from above – and imagine that you have given up attachment in the sense that you are secure in knowing everything you will ever need to survive and prosper will eventually come back into your life when it is needed. That every challenge you face is an exercise in your ability to adapt to change and apply your creativity and draw upon the strength you have developed by helping others to succeed for themselves. And in this world, we are actually surrounded by both skunks and kittens, and predators, and each plays its own role in everyday life in nature.
The thief who has everything will still always be hungry for more (termed Asuras or hungry spirits). You however, can satiate your desire for more by deciding to view things differently. You can accept that there will always be those that hunger for more. And also accept those who are unbelievably generous. The inner peace will come from wanting nor needing either. Through that peace, you become impenetrable, and thus, strong. Simple concept, but perhaps difficult to achieve. That’s the many-faceted path of being human. Try to be thankful for that gift of having a choice.
/* 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*/
2016-12 Shinnyo Podcast Regarding Hope – 2016-12 Shinnyo Podcast Regarding Hope What is Hope? Does Hope Go Away? Creating Hope When Is Hope Lost and Found? Subscribe to this Podcast (RSS) or iTunes or via Flipboard If we define hope as wanting, wishing or imagining something that isn’t in our present existence, we could say that hope is an imaginary concept … Continue reading 2016-12 Shinnyo Podcast Regarding Hope → http://ow.ly/rrMa5082Hk0
If we define hope as wanting, wishing or imagining something that isn’t in our present existence, we could say that hope is an imaginary concept – something that isn’t real. If we think of hope as a state of consciousness, or the state in which we are visualizing this changed existence, then hope becomes a more tangible idea – something that persists.
The four virtues of enlightenment are expressed as permanence, bliss, self and purity, and in this context, the state of permanence is elusive depending on how we define our concept of hope. Each of these states is related to embracing the dynamics of change as an ever-present condition. But to also realize that hope becomes ever-present as long as we can imagine a state of improvement beyond where we are today. You give up your imagination, and you can say you gave up hope.
Nature accepts things as they are – whatever happens, happens. People like to change things, like creating clocks to track time instead of watching the sun and moon. We try to move and push our environment around to better suit what we think is easier, more advantageous, or even more efficient.
When facing extreme changes, that’s when humans often resort to despair instead of hope, losing that sense of a better tomorrow. But really, tomorrow is by its own peculiar definition, something that hasn’t happened yet. We may have a less shiny and perfect vision of that which has yet to come, but basically, it still is beyond the present. And until it happens, it’s still not our reality (barring existence in a parallel universe and warpage of time, of course.)
Our reality is how we perceive it. A fish out of water is kind of stressed, and probably certainly not happy about that. But it has relatively little capacity to change its own condition. We, by comparison, have amazing capability to change our presence, where we are, how we live, and in what manner we decide to co-exist with everything else. Question is, do you realize that potential?
Hope becomes real as we define and change ourselves, whether that means being content with whatever we have already, or transitioning and developing ourselves to see beyond our self-imposed limitations. In the path of transformation, we materialize our vision or goals into reality.
Looking at the situation in a more pragmatic light might be that we can consider ourselves either “stuck in traffic” or “faced with the opportunity to choose alternate paths to our destination.” Either way, the traffic is there. It is up to us to figure out how we perceive it and how we deal with it..
My own hope in this case is that you find that hope isn’t something someone else gives you. Hope is what you give to yourself.
I have seen what a laugh can do. It can transform almost unbearable tears into something bearable, even hopeful. –Bob Hope
/* 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*/
1317697.1Functional Diagram of the Integrated SOA Gateway in Oracle e-Business Suite
Registering the Integrated SOA Gateway included in the Oracle E-Business Suite R12.2.x instances is actually reasonably simple, but the documents make it sound much worse than it really is, simply by being several hundred pages of documentation.
The reason to do this is to expose the RESTful services interface for EBS so that other web applications can do useful things, such as check usernames for validity, lookup business process (workflow) statuses, and even query for completion of processes, such as concurrent programs. The built-in library of accessable Services is quite vast and enables lots of interconnectivity with other applications.
This is also useful if you happen to be extending the application using the Mobile Application Framework, which allows you to build custom applications for mobile devices that access all the various EBS functionalities.
References:
NOTE:1311068.1 – Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2
NOTE:1317697.1 – Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12.2
Before commencing, have the following prepared:
Unlock the ASADMIN (FND_USER) account and set the password so that it can login without a change password challenge (no expiry. required.
APPS password
Weblogic password
IP Address of ApplTier Host
Ports for ApplTier Host (both base port and WLS console – e.g. 8000 7001)
Your base port is the one in your usual EBS URL and the WLS console URL can be determined via Oracle Application Manager in the Site Map link for Weblogic Administration.
Services will be interrupted by bounce twice (2X) during installation.
Installation takes about 45 minutes to complete.
==================================== Start of SOA Integration Steps
#Register new Internal SOA Gateway Configuration
itsrv33m [/export/home/dbausr/oradev] ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkSoaConfigUtility.xml
Buildfile: $COMMON_TOP/java/classes/oracle/apps/fnd/txk/util/txkSoaConfigUtility.xml
checkenvset:
getServerDetails:
[input] Enter Oracle WebLogic Server Administration Console URL (host:port) :
[FQWLSHostname:port]
[input] Enter Oracle WebLogic Server Admin User Name : [weblogic]
getWLSAdminPasswordUnix:
echoON:
[input] Enter the password for user weblogic :
echoOFF:
getWLSAdminPasswordWindows:
getPasswordUnix:
echoON:
[input] Enter the password for user apps :
echoOFF:
getPasswordWindows:
getASADMINUser:
[input] Enter the ASADMIN user name : [ASADMIN]
getASADMINPasswordUnix:
echoON:
[input] Enter the password for user ASADMIN :
echoOFF:
getASADMINPasswordWindows:
getSOAServerDetails:
[input] Enter SOA Server Hostname : (hostname.domain)
[FQEBShostname]
itsrv36m.mwd.h2o
[input] Enter External URL of SOA Suite SOA Managed Server (protocol://managed_server_hostname:managed_server_port) : http://%5BFQEBShostname%5D:%5Bport%5D
[input] Enter Internal URL of SOA Suite SOA Managed Server (protocol://managed_server_hostname:managed_server_port) : http://%5BFQEBShostname%5D:%5Bport%5D
[input] Enter External URL of SOA Suite Admin Server (protocol://admin_server_hostname:admin_server_port) : http://%5BFQWLSHostname:port%5D
commonArgs:
checkRequiredJars:
getDbcFile:
ValidateASADMINConnection:
getJDBCURL:
addASADMINToFNDVault:
[echo] ********************************************************************
[echo] Adding/Updating ASADMIN user in fnd_vault
[echo] ********************************************************************
[echo] Connecting to the EBS database using below properties
[echo] User: apps
[echo] JDBC Url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=[FQhostname])(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=[$ORACLE_SID])))
[sql] Executing commands
[sql] 0 rows affected
[sql] 1 of 1 SQL statements executed successfully
[echo] Sucessfully Added/Updated ASADMIN in fnd_vault
createUserCredUpdationScript:
executeUserCredUpdationUnix:
[exec]
[exec] CLASSPATH=$CLASSPATH
[exec]
[exec] Initializing WebLogic Scripting Tool (WLST) …
[exec]
[exec] Welcome to WebLogic Server Administration Scripting Shell
[exec]
[exec] Type help() for help on available commands
[exec]
[exec]
[exec] Connecting to server using username:weblogic url:[SOAhost:port]
[exec]
[exec] Connecting to t3://[SOAhost:port] with userid weblogic …
[exec] Successfully connected to Admin Server ‘AdminServer’ that belongs to domain ‘EBS_domain_[ORACLE_SID]’.
[exec]
[exec] Warning: An insecure protocol was used to connect to the
[exec] server. To ensure on-the-wire security, the SSL port or
[exec] Admin port should be used instead.
[exec]
[exec] Creating user ASADMIN
[exec] Sucessfully created user ASADMIN
[delete] Deleting: $INST_TOP/logs/appl/rgf/TXK/updateuser_02_November_2016_08_17_38.py
executeUserCredUpdationWindows:
updateWLSuser:
updateSoaContextVariables:
[echo] Updating Context Variable s_soa_external_url
[echo] Updating Context Variable s_soa_internal_url
[echo] Updating Context Variable s_soa_admin_url
runAutoconfigUnix:
[echo] Running Autoconfig
[exec] Enter the APPS user password:
[exec]
[exec] The log file for this session is located at: $INST_TOP/admin/log/[session#]/adconfig.log
[exec]
[exec] AutoConfig is configuring the Applications environment…
[exec]
[exec] AutoConfig will consider the custom templates if present.
[exec] Using CONFIG_HOME location : $INST_TOP
[exec] Classpath :
[exec]
[exec] Using Context file : $CONTEXT_FILE
[exec]
[exec] Context Value Management will now update the Context file
[exec]
[exec] Updating Context file…COMPLETED
[exec]
[exec] Attempting upload of Context file and templates to database…COMPLETED
[exec]
[exec] Configuring templates from all of the product tops…
[exec] Configuring AD_TOP……..COMPLETED
[exec] Configuring FND_TOP…….COMPLETED
[exec] Configuring ICX_TOP…….COMPLETED
[exec] Configuring MSC_TOP…….COMPLETED
[exec] Configuring IEO_TOP…….COMPLETED
[exec] Configuring BIS_TOP…….COMPLETED
[exec] Configuring CZ_TOP……..COMPLETED
[exec] Configuring AMS_TOP…….COMPLETED
[exec] Configuring CCT_TOP…….COMPLETED
[exec] Configuring WSH_TOP…….COMPLETED
[exec] Configuring CLN_TOP…….COMPLETED
[exec] Configuring OKE_TOP…….COMPLETED
[exec] Configuring OKL_TOP…….COMPLETED
[exec] Configuring OKS_TOP…….COMPLETED
[exec] Configuring CSF_TOP…….COMPLETED
[exec] Configuring IBY_TOP…….COMPLETED
[exec] Configuring JTF_TOP…….COMPLETED
[exec] Configuring MWA_TOP…….COMPLETED
[exec] Configuring CN_TOP……..COMPLETED
[exec] Configuring CSI_TOP…….COMPLETED
[exec] Configuring WIP_TOP…….COMPLETED
[exec] Configuring CSE_TOP…….COMPLETED
[exec] Configuring EAM_TOP…….COMPLETED
[exec] Configuring GMF_TOP…….COMPLETED
[exec] Configuring PON_TOP…….COMPLETED
[exec] Configuring FTE_TOP…….COMPLETED
[exec] Configuring ONT_TOP…….COMPLETED
[exec] Configuring AR_TOP……..COMPLETED
[exec] Configuring AHL_TOP…….COMPLETED
[exec] Configuring IES_TOP…….COMPLETED
[exec] Configuring OZF_TOP…….COMPLETED
[exec] Configuring CSD_TOP…….COMPLETED
[exec] Configuring IGC_TOP…….COMPLETED
[exec]
[exec] AutoConfig completed successfully.
runAutoconfigWindows:
setEBSProfiles:
[echo] Updating Profile FND_SERVER_DESKTOP_USER
[java] Nov 02, 2016 8:21:24 AM oracle.apps.fnd.txk.util.TXKFMWGenericConfigUtility readPasswordFromStdin
[java] INFO: Enter APPS Password:
[echo] Updating Profile FND_SERVER_SEC
[java] Nov 02, 2016 8:21:26 AM oracle.apps.fnd.txk.util.TXKFMWGenericConfigUtility readPasswordFromStdin
[java] INFO: Enter APPS Password:
[echo] Updating Profile FND_SERVER_IP_SEC
[java] Nov 02, 2016 8:21:28 AM oracle.apps.fnd.txk.util.TXKFMWGenericConfigUtility readPasswordFromStdin
[java] INFO: Enter APPS Password:
[echo] Updating Profile FND_SQLNET_ACCESS
[java] Nov 02, 2016 8:21:29 AM oracle.apps.fnd.txk.util.TXKFMWGenericConfigUtility readPasswordFromStdin
[java] INFO: Enter APPS Password:
ebsConfigForSOA:
BUILD SUCCESSFUL
Total time: 6 minutes 36 seconds
# Verify new Profile Option Settings
SQL Statement which produced this data:
/* Formatted on 11/17/2016 7:07:54 AM (QP5 v5.300) */
SELECT n.user_profile_option_name NAME,
TO_CHAR (v.last_update_date, ‘DD-MON-RR’)”Last Updated”,
DECODE (v.level_id,
10001, ‘Site’,
10002, ‘Application’,
10003, ‘Responsibility’,
10004, ‘User’,
10005, ‘Server’,
10007, ‘SERVRESP’,
v.level_id)
LEVEL_SET,
DECODE (TO_CHAR (v.level_id),
‘10001’, ”,
‘10002’, app.application_short_name,
‘10003’, rsp.responsibility_key,
‘10005’, svr.node_name,
‘10006’, org.name,
‘10004’, usr.user_name,
‘10007’, v.LEVEL_VALUE2,
‘UnDef’)
“CONTEXT”,
v.profile_option_value VALUE
FROM fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
WHERE p.profile_option_id = v.profile_option_id(+)
AND p.profile_option_name = n.profile_option_name
AND UPPER (p.profile_option_name) IN (‘FND_SERVER_DESKTOP_USER’,
‘FND_SERVER_SEC’,
‘FND_SERVER_IP_SEC’,
‘FND_SQLNET_ACCESS’)
AND n.language = ‘US’
/* Use for Friendly PONs e.g. MO: Security Option
AND UPPER (n.user_profile_option_name) =
UPPER (”)
*/
AND usr.user_id(+) = v.level_value
AND rsp.application_id(+) = v.level_value_application_id
AND rsp.responsibility_id(+) = v.level_value
AND app.application_id(+) = v.level_value
AND svr.node_id(+) = v.level_value
AND org.organization_id(+) = v.level_value
ORDER BY v.last_update_date DESC;
NAME|Last Updated|LEVEL_SET|CONTEXT|VALUE
FND: Validate IP address|02-NOV-16|Site||D
NAME|Last Updated|LEVEL_SET|CONTEXT|VALUE
FND: Validate User Type|02-NOV-16|Site||D
# Bounce certain services (minimizes downtime – can also bounce everything)
cd $ADMIN_SCRIPTS_HOME
admanagedsrvctl.sh stop oafm_server1
admanagedsrvctl.sh start oafm_server1
admanagedsrvctl.sh stop oacore_server1
admanagedsrvctl.sh start oacore_server1
[etc for any other oacore servers]
#Verify registered payload Class ID (ensures payload can be accessed)
SQL Statement which produced this data:
SELECT class_id
FROM fnd_irep_classes
WHERE UPPER (irep_name) LIKE ‘%EBIZHOMEPAGESERVICE%’
AND class_type = ‘SERVICEBEAN’;
# Configure the ISG BPEL Payload for use by SOA Suite
ant -f $JAVA_TOP/oracle/apps/fnd/bpel/util/txk_integration_packager.xml \ -DIntegration=isg -DFMWNodeName=itsrv33m.mwd.h2o -DFMWIpAddress=[MT or Virtual host IP]
[echo] Bpel Payload is archived at $INST_TOP/logs/appl/rgf/TXK/EBS_BPEL_payload.zip
# Verify the “new” SOA Node is registred (MWD is just re-using the built in SOA)
SQL Statement which produced this data:
SELECT node_name, server_address, server_id
FROM fnd_nodes
WHERE UPPER(node_name) in(‘[hostname]’);
# A Fix for HPUX, if needed, add set +u to the line right after #!/bin/sh
# vi $FMW_HOME/user_projects/domains/EBS_domain_$TWO_TASK/bin/setDomainEnv.sh
# Warning: the following command will immediately shutdown and restart the WLS Managed Services
ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup
# Change default NAME=APPS connection to NAME=ASADMIN in WLS Admin Console.
# (you want to do this to support APPS password changes in the future – the ASADMIN
# password does not have to be disclosed to Developers once the setup is completed – just
# grant the Integrated SOA Gateway Role and Responsibility to users that need to deploy
# various services.
Data Sources -> OAEADatasource -> Configuration -> Connection Pool
[Lock & Edit]
Modify Properties user=APPS -> user=ASADMIN
Enter ASADMIN password in both password fields
[Save] -> [Activate Changes]
If the ASADMIN password is changed in the target EBS instance, then all of the following steps need to be re-executed in order to register the change with SOA:
# Clean out the prior OAEADatasource connections and definitions
Login to WLS Administration Console.
Services -> Data Sources -> [Lock & Edit] -> Select OAEADatasource -> [Delete]
Security Realms -> myrealm -> Providers -> Select IsgAuthenticator -> [Delete]
[Activate Changes]
$] cd $DOMAIN_HOME/config/jdbc
$] rm OAEADatasource-*-jdbc.xml
Repeat the SOA Integration steps again.
Otherwise, attempting REST deployments will receive an error:
Error
java.lang.SecurityException: User: ASADMIN~~[ORACLE_SID], failed to be authenticated.
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.
