I promised my 9 year old son that I would run the school 5K fun run with him, little did I know it would clash with Oracle OpenWorld. I had a 5k run at 10am in Belmont and then a presentation to the OAUG GL Special Interest Group at 11am 20 mile sNorth in San Francisco. I was worried about the pace my son could do but we managed to average 9.5 minute miles even with a stop to tie a shoe lace and a lot of traffic of all ages and speeds. We had just enough time snap the picture below and then he went for the pancake breakfast with the rest of his friends and I ran another half mile to my car and headed to the Moscone Center. No time to change and straight up on stage, with 10 minutes to spare before I was due to speak. After that I caught up with a colleague who’s here from the UK over lunch and was home in time to upgrade my son’s home minecraft server to 1.8, write a blog and check on my demos for tomorrow’s Oracle Applications User Experience (OAUX) EXPO.
later this evening I was pleased to see this tweet from Steve Miranda, our EVP who is also balancing his heavy workload at OpenWorld with family commitments too.
So all in all a good day, here’s hoping the rest of the week is just as enjoyable.
You have Encountered an unexpected error. Please contact the System Administrator for assistance.
On checking the $EBS_DOMAIN_HOME/servers/oacore_server1/logs/oacore_server1.out, we found this error:
oracle.ias.cache.CacheFullException: J2EE JOC-017 The cache is full.
at oracle.apps.fnd.cache.AppsCache.get(Unknown Source)
at oracle.apps.fnd.functionSecurity.Grant.getGrantArray(Unknown Source)
We tried bouncing services and deleting $EBS_DOMAIN_HOME/servers/oacore_server1/cache. None of those actions helped. Things got back to normal only after the Xmx, Xms,and permsize startup parameters for the oacore JVM were changed in weblogic console on Gary's suggestion:
-XX:PermSize=512m -XX:MaxPermSize=512m –Xms4096m –Xmx4096m
I also changed it in the context file:
Old: s_oacore_jvm_start_options">-XX:PermSize=128m -XX:MaxPermSize=384m -Xms512m -Xmx512mNew: s_oacore_jvm_start_options">-XX:PermSize=512m -XX:MaxPermSize=512m –Xms4096m –Xmx4096m
The oacore_server1 and oacore_server2 were bounced after this. We haven't seen that error ever since.
There is a support.oracle.com article: Receive Intermittent Error You Have Encountered An Unexpected Error. Please Contact Your System Administrator (Doc ID 1519012.1)CauseThere are user accounts having extremely high numbers of FUN_ADHOC_RECI_XXXXXXX / FUN_ADHOC_INIT_XXXXXXX assigned.
Users have an extremely high number of (ADHOC) ROLES assigned to them, so when these attempt to login this fills the JOC ( Java object cache ) and causes it to run into it's limits resulting in the errors reported. Once bounce is done all is working fine until such an user logs in again.
While working in AGIS and creating and progressing batches, in the workflow there are several ad hoc roles created which remain on the system and do not get end dated or deleted. This can cause performance issues.
Ad Hoc Roles in WF_LOCAL_ROLES starting with FUN_ADHOC_RECI_XXXXXXX ; FUN_ADHOC_INIT_XXXXXXX with no expiration_date.
A. Run the following SQL to verify if there are accounts having extreme numbers of roles assigned
SQL> SELECT user_name, count(*) FROM wf_user_roles WHERE role_name <> user_name GROUP BY user_name ORDER BY 2;
B. Run following for particular user
SQL> SELECT distinct role_name FROM wf_user_roles
WHERE user_name = cp_user_name
or (user_name = (SELECT name FROM wf_local_roles wlr, fnd_user fusr
WHERE fusr.person_party_id = wlr.orig_system_id
AND wlr.orig_system = 'HZ_PARTY'
AND fusr.user_name = cp_user_name
AND rownum < 2))
AND role_name <> user_name;
Note: Replace cp_user_name with name of user having high number of ADHOC roles
SolutionTo implement the solution, please execute the following steps:
1. Ensure that you have taken a backup of your system before applying the recommended solution.
2. Follow the steps given in document to purge the WF_LOCAL_ROLES for the AGIS transactions in 'COMPLETE' status.
AGIS: HOW TO DELETE AD HOC ROLES CREATED IN WORKFLOW (Doc ID 1446561.1)
3. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.
We had also logged SR with Oracle where they pointed us to the very same article and also asked us to do the following:
1. How to find out the existing adhoc roles?
select name, start_date, start_date, expiration_date
where orig_system = 'WF_LOCAL_ROLES'
order by name;
2. Define an expiration date for the ad hoc role:
exec WF_DIRECTORY.SetAdHocRoleExpiration (role_name=> >,expiration_date=>sysdate-1);
3. Periodically, purge expired users and roles in order to improve performance.
This purges all users and roles in the WF_LOCAL_ROLES,WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables whose expiration date is less than or
equal to the specified end date and that are not referenced in any notification.
Parameter: end_date Date to purge to.
For more information, please refer to Oracle Workflow API Reference on page 2 – 128.
Use the workflow API's to purge the ad hoc roles:
After end dating the adhoc roles, the expired adhoc roles can also be purged by running the Purge Obsolete Workflow Runtime Data concurrent program. Make sure the "Core Workflow Only" parameter set to N.
Oracle also shared 3 open bugs (unpublished, can be read only Oracle employees) for this issue:
Bug 19025537 : ORACLE.IAS.CACHE.CACHEFULLEXCEPTION: J2EE JOC-017 THE CACHE IS FULL.
Bug 11772304 : JOC INVESTIGATION WITH 12.2
Bug 19582421 : R12.2 THE CACHE IS FULL; EXCEPTION IN OACORE_SERVER1 LOG.
This is number three in my Focus on Oracle OpenWorld Series and this one is in on my home turf, it was the talk of Las Vegas earlier this year at Collaborate. I have explained the difference between Fusion Accounting Hub and Financial Accounting Hub before, but now we have the Accounting Hub Reporting Cloud Service. I’ll be talking about this briefly in the OAUG GL SIG meeting and there is also a session from my boss, Rob Zwiebach that will cover it (spoiler alert, we might use some of the same slides), but he will also have Alex from our internal finance org to give talk about their experience running the accounting hub for the last few years. Rob’s session details are below:Introducing Oracle Fusion Accounting Hub Reporting Cloud Service [CON8404]
Existing Oracle E-Business Suite customers now have an out-of-the-box coexistence strategy. With Oracle Fusion Accounting Hub Reporting Cloud Service, you can have the power of Oracle Fusion Reporting in the cloud. This session explains the benefits and details of Oracle Fusion Accounting Hub Reporting Cloud Service.
Alex SanJuan – VP Finance, Oracle
Rob Zwiebach, VP Financial Application Development, Oracle
Tuesday, Sep 30, 4:45 PM – 5:30 PM – Westin Market Street – Metropolitan II
I already have a number of customer meetings lined up to discuss accounting hub and a few more I’m trying to squeeze in, so it is shaping up to be an exciting new chapter for the Accounting Hub.
Anyone who reads my blog regularly might be tired of me praising user groups, but I believe it is worth repeating myself. The type of information sharing you get from user groups is unique and very valuable, it is important for Oracle to support that, be aware of it, but not interfere. I have been involved with the Oracle Apps User Group via the GL SIG for several years now but I will never push my agenda, I listen, provide information or presentations that are requested and I learn. Many of my colleagues will tell you the same. So Sunday is User Group day at OpenWorld and I look forward to seeing a lot of familiar faces and learning something new. I have a bit of a schedule crunch this year, 12 months ago I committed to run the 5k “Dolphin Dash” School fundraiser with my 8 year old son, I didn’t think for a minute it would fall on the same date as OpenWorld. So I have to run a 5k at 9am and then dash into San Francisco to present at the GL SIG for 11am, if I arrive in my running gear, still sweating please accept my apologies. I will stay around for more of the sessions and always I will be active on twitter, so you can find me that way too.
At the GL SIG I’ll be talking about and briefly showing the new Accounting Hub Reporting Cloud Service, which I am very excited about. You will also hear from Lakshmi Sampath from Dell about SLA on their upgrade to R12. The full agenda is below, I hope to see a lot of you there.
Agenda GL-SIG @ OpenWorld 2014 on Sunday, September 28th, 11.00am
Location – Moscone W – 3005
- Introduction to the SIG
- Proactive support presentation
- Sponsor message (Excel4Apps)
- Lakshmi (SLA on Upgrade @ Dell)
- David Haimes new Accounting Hub Cloud Reporting Service
- Open questions
We will be joined by our Oracle colleagues to tell us about ProActive support and their leading practices to deliver content and help to the Oracle user community.
Excel4Apps will be helping us by sponsoring the meeting at this conference.
In the past many oracle apps customers have looked elsewhere for their reporting needs – until now – see a preview of “Accounting Hub Reporting Cloud Service”. See how many finance users are using their favorite tools for reporting – Smartview, Cubes, and related functionality to get their financials. Fusion Account Hub Reporting Cloud Service is a new subscription service provides out of the box integration with EBS R12 General Ledger for reporting. This session will provide an introduction to the new service, how it connects, works with EBS data, the reporting capabilities available and what it does and does not support. Come listen to David Haimes, Senior Director, Financials Product Development t alk about the new service.
Hear what Lakshmi Sampath from Dell has to say about their upgrade to R12. The presentation covers the R12 Upgrade Case-Study at Dell providing details on what happens during upgrade to R12 in various subledgers (PO, AP, AR, PA, FA) with respect to SLA. This presentation will also provide details on strategies for data conversion to SLA model during upgrade, and cover critical lessons learned during the upgrade @ DELL.
This is the first of a series of posts I am planning leading up to Oracle OpenWorld which starts in less than a week. I have a few different focus areas this year, so I’ll write a little about each of them.
I’ve been talking about collaboration in ERP for quite some time and was also very flattered to have TheAppsLab and Ulan for the UX team cover what we have done in their blogs too. I call it Socializing the Finance Department, it isn’t about more Pot Luck Lunches and after work drinks, it is about using social tools in a secure and efficient manner, embedded in your ERP system, tied to your transactions and business flows to make you more productive.
The Oracle Social Network(OSN) is part of the infrastructure we build our cloud applications on, so it is pervasive in our cloud apps. There are a lot of good sessions, see here for the complete OSN list. I will be on a panel discussing the best use cases for social in enterprise applications, Tuesday September 30th 5pm – 5:45pm - Moscone West – 3022, full details here.
We won’t be doing a demo, but here is one video to give you a taste of what we will discuss, or check out my post Can chatting make us more productive? for another video. TO be honest, if you catch during the #oow week, I’m usually happy to show this off, so feel free to ask me.
According to the CEB Corporate Leadership Council High Performance Survey, 2012, the average worker collaborates with 10 or more people to accomplish day to day tasks. That is a lot of chatting. We think that this chatting needs to be be tied to the business transaction you are working with and the best way to do that is by having the collaboration tool as part of your ERP application. This is what you get with Oracle ERP Cloud. I have discussed what social is in the ERP Cloud world in my earlier post Socializing the Finance Department that you can review to get a background. The key message here is that the collaboration must be tied to a transaction. Take a look at the video below to illustrate the point and see it in action.
I think you will agree this type of chatting, or as Alan Leposfsky (@alanlepo) of Constellation Research would call it, purposeful collaboration, clearly does make you and your organization more productive.
The minimal 5-entryway hatchback contends with a climbing workforce of minicars that gimmicks the MINI Cooper that dispatched the stage inside the U.s., the new Fiat 500, the Mitsubishi i electrical auto, and a couple of two-seat passages, the developing old savvy Fortwo and the new Scion iq.
actually assuming its 12-foot-1-inch length is unequivocally three toes shorter than a Chevrolet Cruze smaller 4-entryway vehicle, the Spark does not so much show up as little as it seems to be. best in scale- -stopped beside an amusement utility auto, as a sample -is its fitting measurement prominent.
The creators have accomplished all that they may to blanket the Spark's extents. its a tall auto roosted on little 15-inch wheels, however stress strains, dark plastic boards that proceed with the window line, and a vast Chevy twin-opening grille help to conceal the chunk sided, scorn nosed field-on-wheels show up.
The handles for the back entryways are stowed away operating at a profit plastic trim, which Chevy says gives the auto a "roadster like" appear. we don't in all actuality buy that, however outwardly the back entryways don't fundamentally learn as entryways on first look. while the back completion is everything except vertical, a long top spoiler stretches out to edge the back window opening, offering profundity to the back and bettering the Spark's aeromechanics too.
inside, the textured hard-plastic dash makes no attempt and camouflage what its through copying another topic. so also, the seats are unashamedly manufactured material. however constitution color embeds on the entryway trim, inside the entryway boxes, and on the dashboard include a sprightly stress. They take notice the painted inside steel found in economy autos of the Sixties, despite the fact that inside the Spark they may be all body-color plastic presented for effect.
Like its vast sibling the Sonic, the Spark has a "motorbike model" instrument case mounted on the direction section. It suits a speedometer and a little auto learning show. the base Spark has a little monochrome center showcase, yet all LT trim levels work a 7-inch coloration touchscreen show inside the heart stack.
there is only one motor in the Spark, a 84-pull 1.2-liter four-barrel Ecotec that puts out eighty three lb-toes of torque. The Spark comes same old with a five-velocity handbook gearbox, and a four-pace automated transmission will likewise be requested for an extra $925. Forceful driving with the aide can hustle the little Spark by means of town acceptably, however the robotized is, honestly, a puppy. Its first gear is inordinate sufficient that quickening a long way from stoplights shows up excruciatingly steady, and it would not appear to offer such a great amount of punch at any velocity or in any apparatuses. this is one auto for which the handbook gearbox may be the main conceivable choice.
The 2013 Chevrolet Spark lt for sale with the aide transmission is EPA-evaluated at 32 mpg city, 38 mpg thruway, for a blended score of 34 mpg- -comparable to the rest inside the class, however sensibly lower than a considerable amount of bigger reduced vehicles, which benefit from higher the study of air. the programmed model is accessible in lower, at a consolidated 32 mpg (28 mpg city, 37 mpg road). The Spark runs on consistent evaluation gas, in spite of the fact that; the Fiat 500 prescribes top rate gas.
The Spark's ride is somewhat firm, by and by it dealt with broken NY city roads with aplomb- -despite the fact that riders had been mindful of each knock, pothole, edge, and swell. its tall enough that travelers will truly feel the Spark inclining toward difficult corners, nonetheless its reasonably little wheels and tires toiled grave to convey the road. the electric force direction deals some interstate feel, and though its barely ever as charming to throw round as the MINI Cooper, the Spark can trade paths into spaces diverse autos couldn't fit into, and it is a delight to stop. Our starting force provided for us no probability to test the Spark at 75-mph turnpike speeds.
within, the Spark's seats are physically movable yet agreeable -if a tad bit thin for broad channeled American travelers. The back seatback is upright, yet with to some degree arrangement between front- and once more seat riders, four adult male people can possess the Spark and go in reasonable house. that is more than can additionally be expressed for the MINI Cooper or Fiat 500, actually assuming the Mitsubishi i electric auto -the main other 5-entryway hatchback on this arrangement -bargains also shocking back seat space too.
With the back seat up, the Spark has 11.four cubic feet of load territory -enough to hold 10 to 12 full paper staple gear without issues -which grows to 31.2 cubic toes when the 60/40 part back seat is flipped and collapsed down. A payload net is close by as a feature of the higher trim levels, as are rails to mount baggage bearers on the top.
The 2013 Chevrolet Spark lt for sale has been intended to satisfy all present and future U.s. security necessities, and springs ordinary and not utilizing a less than 10 airbags. It has now not yet been appraised for accident wellbeing by method for either the NHTSA or IIHS. The Spark has not least complex electronic dependability keep watch over and electronically monitored slowing mechanisms, yet moreover doorway seat-cinch pretensioners and same old Hill start help- -a decent trademark for youthful drivers. Outward innovative and insightful is great, together with respectable back three-quarter perceivability over the intention energy's shoulder for switching (no back creative and judicious Polaroid is possible). All Sparks come standard with GM's Onstar gadget and 6 free months of bearer.
quickly for a minicar, all Sparks come typical with air-con, vitality windows, a back window wiper, and a drive pc. Furthermore Chevy contemplated that one methodology to make the Spark appear to be considerably less machine like
Tomorrow Oracle is hosting a Bay Area Heart Walk at it’s HQ campus and it should be a huge event, not only raising valuable funds but also raising awareness of the importance of a heart healthy lifestyle. Since the beginning of this year I have been doing regular walking meetings and have enjoyed the benefits to both my health and my productivity. I also found many other people already doing walking meetings and others who have been inspired to start them. I’ve really enjoyed the overwhelmingly positive responses and encouragement.
Highlights of the event include the Semi Official Oracle house band, Scope Creep, check out this YouTube clip, you may recognize some of the faces including my boss on drums, who I can confirm does not appreciate my joke – what do you call somebody with no talent who hangs with musicians? – answers in the comment section please.
I will be walking with ‘Team Erb’ led by the energetic and enthusiastic (except when it comes to twitter) Janine Erb, who is one of the singers in the YouTube clip above. We have close to 100 people in the team and I’m looking forward to walking with and talking to people I have known and worked with for a long time and also making some new friends. If you are there tomorrow, come and say hi. I’ll take some pictures and probably tweet during the event.
This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!
The Passport was once actually a re-badged Isuzu Rodeo, a truck-based SUV inbuilt Indiana, at a plant that Subaru and Isuzu shared on the time. the primary era Passport, sold from 1994 via 1997, offered a collection of a one hundred twenty-horsepower 2.6-liter four-cylinder engine, paired with a 5-pace handbook gearbox, or a a hundred seventy five-hp 3.2-liter V-6--and an available four-pace automated transmission. Rear-wheel power was same old, and all-wheel pressure might be ordered as an choice. Trim ranges have been base and EX.
2002 honda passport check engine light flashingIn 1998, a 2nd-era Passport used to be introduced. It used to be still based on a truck chassis, nevertheless it came with extra relief and safety options than the earlier adaptation, and was considerably extra refined. The 4-door game-utility vehicle came usual with a 205-hp three.2-liter V-6, matched with a 5-speed guide gearbox on base versions, though a four-speed computerized transmission was additionally on hand.
The second Passport was once offered in two trim ranges: the LX will be ordered with the 5-velocity guide, with four-wheel-pressure as an possibility, and the extra upscale EX came with the 4-velocity automatic, once more with both force possibility. while the spare tire on the base LX was established on a swinging bracket on the tailgate, the EX relocated it to a service beneath the cargo house. For the 2000 version year, the Honda Passport received a handful of updates, together with non-compulsory 16-inch wheels on the LX and available two-tone paint treatments.
2002 honda passport transmission dipstick locationWhen taking into account the Passport as a used car, patrons should comprehend that the 1998-2002 models have been recalled in October 2010 as a result of body corrosion in the basic house where the rear suspension was mounted. Any autos with out seen corrosion have been handled with a rust-resistant compound, but reinforcement brackets were to be installed in those with more extreme rust. In some cases, the damage was once so extreme that Honda simply repurchased the autos from their homeowners. Used-automotive shoppers taking a look at Passports must be sure to in finding out whether the car had been via a remember, and what--if anything else--was achieved.
2002 honda passport keyless remote
2002 honda passport o2 sensor location
2002 honda passport picture gallery
2002 honda passport transmission problems
2002 honda passport starter replacement
Mazda's Miata feels very nearly large in correlation to the S2000. The cockpit is confined regardless of how little the tenants. The high shoulders of the S2000 keep the driver and traveler, and the controlling wheel sits low even at its most noteworthy alteration point. Strangely for Honda, the controls aren't laid out neatly (there's not a considerable measure of dash space to do so), and the enormous red Start catch appears to be more like a contrivance. There's a lot of dark plastic, as well, for the sake of sparing weight.
The 2009 Honda S2000 is one of the slightest reasonable large scale manufacture autos on the planet. There's practically no inside or trunk stockpiling, the cockpit's more confined than the mentor situates on a Boeing 757, and its evaluated above $30,000. It is an exemplary roadster sportscar with back wheel drive, a ragtop to open on sunny days, a six-pace manual transmission, and a rev-cheerful four-barrel motor.
2009 red honda convertible s2000
A year ago Honda presented the S2000 CR, the club-racer adaptation of the standard S2000. The CR gets a full-body flight optimized unit, superior Bridgestone tires, firmer suspension settings, a thicker hostile to move bar, and new wheels. A lightweight aluminum hardtop that cuts weight by around 90 pounds replaces the delicate top component. Inside, the CR gets different material seats with yellow sewing, another aluminum shifter handle, and carbon-fiber resemble the other much the same trim boards.
Standard supplies on the 2009 Honda S2000 incorporates electronic dependability control and non-freezing stopping devices, however side airbags—a gimmick now found on almost all new vehicles—aren't accessi
although the 2009 Honda S2000 has a dated design, the bottom edition stands out for its spectacular mix of fashion and performance, regardless of the overwhelming additions on the CR.
automobiles.com studies other exterior highlights embody trendy “excessive-intensity-discharge headlamps and 17-inch alloy wheels” that come usual on the 2009 Honda S2000. Edmunds resorts essentially the most distinguished criticism of the exterior of the 2009 Honda S2000, noting that whereas the brand new aerodynamic items on the CR “reduce excessive-velocity aerodynamic lift by way of about 70 p.c,” additionally they “cut back the car’s overall visual appeal with the aid of, oh, 79 %.” evaluations read through ebizsig.blogspot.com convey that the exterior styling of the 2009 Honda S2000 is a large success, and Kelley Blue e-book says the Honda S2000 “strikes an awfully un-Honda like, slightly depraved poise” that may “resemble an angry cobra about to strike.”
honda s2000 fiche technique 2009
Kelley Blue e book notes that “CR models include an aerodynamic physique kit,” together with “raise-reducing front and rear spoilers and a removable aluminum onerous high instead of the traditional cloth” model on the standard Honda S2000.
according to the reviewers at Edmunds, the “2009 Honda S2000 is a compact two-seat roadster that’s provided in two trims: same old and CR.” each trims share the same normal profile, which automobiles.com calls a “wedge-formed profile that stands except for different roadsters.”
ConsumerGuide approves of the internal structure on the 2009 Honda S2000, claiming that the “S2000 has a comfortable cockpit, so everything is shut at hand,” and whereas the “digital bar-graph tachometer and digital speedometer usually are not the sports activities-automotive norm,” they're “simple to learn.” Edmunds chimes in, noting that “just about all the controls you’ll ever want are set up inside a finger’s extension of the guidance wheel.” one of the most cooler interior features to find its method right into a manufacturing car is the “new top-power Indicator” on the 2009 Honda S2000 CR, a feature that cars.com says will flash “a inexperienced light when top power is reached.” Kelley Blue ebook gushes the 2009 Honda S2000’s “inside is stuffed with excellent surprises,” including a “giant pink start button on the sprint” and “the long heart console [that] sits up excessive, affording you the perfect perch on which to rest your arm.”
2009 honda s2000 performance specs
The 2009 Honda S2000 enjoys better handling because of the quicker guidance ratio and new tires, and the CR variation is a monitor-necessary contender that can hold its personal against more expensive European and American competition.
The EPA estimates that the 2009 Honda S2000, whether in standard or CR kind, will get 18 mpg within the city and 25 on the highway. Most cars as robust because the 2009 Honda S2000 pay a big penalty on the gasoline pump, however the small engine blended with lightweight development on the Honda S2000 yields a moderately frugal efficiency machine.
evaluations read by way of ebizsig.blogspot.com convey that the engine is happiest when operating flat-out. cars.com notes that “once it reaches 5,000 rpm or so, the S2000 lunges ahead like a rocket,” and Edmunds adds that “piloting the 2009 Honda S2000 takes some getting used to, on the grounds that height energy is delivered at nearly eight,000 rpm.” ConsumerGuide reviewers love the engine and find the Honda S2000 “offers a stunning provide of usable power across a extensive rpm vary, mixed with ultrahigh-revving excitement.” although two diverse versions of the 2009 Honda S2000 are on hand, Edmunds studies that the only engine offered is a “2.2-liter four-cylinder that churns out 237 hp at a lofty 7,800 rpm and 162 pound-feet of torque at 6,800 rpm.” Honda has tuned the engine on the Honda S2000 almost to the breaking point, with automobile and Driver commenting that “the S2000’s 2.2-liter four is mainly maxed out.”
modified honda s2000 turbo 2009 picture
evaluations learn by using ebizsig.blogspot.com additionally compliment the S2000’s transmission for its easy shifts and brief throws. Kelley Blue e book claims that the engine and transmission combination makes for “startlingly-quick efficiency,” whereas the chassis provides “outstanding nimbleness” to the 2009 Honda S2000 package deal. vehicles.com states that the four-cylinder engine on the S2000 Honda “mates with a six-speed handbook transmission” that ConsumerGuide says will supply “manageable take hold of motion” and a “slick, quick-throw gearbox.”
As excellent as the engine/transmission mixture is, coping with continues to be a trademark of the 2009 S2000. automobiles.com holds nothing back in praising the “razor-sharp steerage, disciplined coping with and athletic cornering ability” of the 2009 Honda S2000. Kelley Blue e book reviewers rave about the “just about flat cornering conduct and intensely crisp response that allows” the 2009 Honda S2000 “to barter the corners with positive tenacity.” The membership Racer is even more impressive, with automotive and Driver reporting it “is simply harder and sharper, with much less physique roll and tire scrubbing and extra nook composure and stability underneath braking.” sadly, the associated fee for all that efficiency is bad journey quality, and ConsumerGuide points out that “nearly every small bump and tar strip registers during the seats.” On the positive aspect, ConsumerGuide also comments that “braking is swift and simply modulated” whether or not you might be driving on the street or the monitor.
2009 honda s2000 horsepower
2009 honda s2000 owner's manual
2009 honda s2000 pictures
2009 honda s2000 price new
Oracle 12c Real Application Security and Standard Database Auditing - Warning Database Logins Not Logged
Oracle 12c introduces several major new security features. Data redaction is one new feature and Real Application Security (RAS) is another. Per Oracle, RAS is the next generation Virtual Private Database (VPD) and is installed with Oracle Enterprise Edition – no additional license required. RAS is a new declarative and granular authorization model and is designed to be an application security platform for end-to-end application security. For those developing APEX applications (also installed with Enterprise Edition), RAS will certainly become an integral tool.
With RAS, developers define security policies instead of having to create and maintain PL/SQL code. Most notably, RAS however extends the security solution to define both application users and roles separate from database users and roles.
RAS allows for the creation of users, complete with user names and passwords, and stores them in the database. RAS users are not stored in DBA_USERS. RAS users are defined in DBA_XS_USERS, and their passwords are stored in SYS. XS$VERIFIERS.
With 188.8.131.52, RAS users can also directly connect to the database. It appears that with 184.108.40.206, RAS users can be defined with a flag to allow or disallow direct database logons. As any database security monitoring and logging solution should be monitoring database logon activity, it should be known that RAS users will NOT show up in standard Oracle database auditing. Standard database auditing instead picks up login activity by the generic user XS$NULL. Because it is designed to be part of an application, RAS has its own logging and auditing solution.
Basic logon activity for RAS users, however is logged in SYS.UNIFIED_AUDIT_TRAIL. Even if you have NOT enabled Unified Auditing in 12c, SYS.UNIFIED_AUDIT_TRAIL is being populated. Why this is the case will be the topic of another blog post. If you have compliance requirements to log and audit database logons, you will need to monitor SYS.UNIFIED_AUDIT_TRAIL for RAS user activity as well as for the creation of RAS users if not also potentially configuring RAS auditing. The example below should get you started.
With the below you can test for yourself how standard database auditing logs RAS user logons:
- Ensure auditing for create session is enabled, if not: audit create session by access;
- Create Real application security user
- Set password for Real Application Security user
- Review both dba_users and dba_xs_users to see for yourself where RAS users are defined.
- Log into the database with: INTEGRIGY_RAS_USER/oracle
- Look at your auditing and see a logon from XS$NULL instead of INTEGRIGY_RAS_USER
select * from sys.aud$ order by 1 desc
- Now look at SYS.UNIFIED_AUDIT_TRAIL. You will see XS$NULL for the DBUSERNAME but you will see 'INTEGRIGY_RAS_USER' in XS_USER_NAME.
select dbusername,xs_user_name ,event_timestamp
where xs_user_name = 'INTEGRIGY_RAS_USER'
order by event_timestamp
If you are not familiar with XS$NULL, XS$NULL is created when the database component Oracle XML Database (XDB) is installed. XDB is now a mandatory component of 12c and as such, XS$NULL must exist in the database. Per Oracle, XS$NULL is an internal account that represents the absence of a user in a session. It is used by the lightweight session infrastructure for APEX, RAS and XDB and the name of this user is hard coded in those modules. Because XS$NULL is not really a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges, and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL.
If you have questions, please contact us at email@example.comReferences
Summary of Real Application Security http://www.oracle.com/technetwork/database/security/real-application-security/real-application-security-1964775.html
Oracle Documentation for Real Application Security http://docs.oracle.com/database/121/DBFSG/intro.htm#DBFSG10000
Is the XS$NULL user a required account? (Doc ID 1556725.1) https://support.oracle.com/rs?type=doc&id=1556725.1
Curious I executed adopreports
Enter the APPS username: apps
Enter the APPS Password:
Online Patching Diagnostic Reports Main Menu
1. Run edition reports
2. Patch edition reports
3. Other generic reports
Enter your choice : 3
Other Generic Reports Sub Menu
1. Editions summary
2. Editioned objects summary
3. Free space in important tablespaces
4. Status of critical AD_ZD objects
5. Actual objects in current edition
6. Objects dependencies
7. Objects dependency tree
8. Editioning views column mappings
9. Index details for a table
10. Inherited objects in the current edition
11. All log messages
12. Materialized view details
13. Database sessions by edition
14. Table details (Synonyms, EV, etc.)
15. Count and status of DDL execution by phase
16. Back to main menu
This is a great utility for R12.2
R12.2 URL Validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists,
URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.
This occurs for any user that is newly created. The user_guid column is not populated. Here is the Solution:
ssoreg_r12_linux erppgai1 DEV appspassword cleanup
ssoreg_r12_linux erppgai1 DEV appspassword dereg
./oamreg_linux erppgai1 DEV appspassword undeployag
./oamreg_linux erppgai1 DEV appspassword deployag
./oamreg_linux erppgai1 DEV appspassword reg
UTL_FILE_DIR is the database initialization parameter the Oracle Database uses to determine what operating system directories and files PL/SQL packages, functions, and procedures may read from or write to when using the standard UTL_FILE database package. The directories specified in the UTL_FILE_DIR parameter may be accessed by any database user, which can be a security issue. In Oracle 9iR2, Oracle released new functionality called “Directories” that provides a more secure and robust capability to access operating system directories and files. The advantages of using Directories over UTL_FILE_DIR are –
- Read and/or Write access to a Directory can be granted to individual database accounts or roles
- A Directory can be added without having to bounce the database
- Directory name is used in the UTL_FILE.FOPEN statement rather than the directory path, which allows changes to the directory path without modification to the PL/SQL source code
The UTL_FILE database package is used to read from and write to operating system directories and files. By default, PUBLIC is granted execute permission on UTL_FILE. Therefore, any database account may read from and write to files in the directories specified in the UTL_FILE_DIR database initialization parameter.
Oracle usually assumes that PUBLIC has execute permission on UTL_FILE, therefore, many Oracle product installations do not specifically grant execute permission on UTL_FILE to Oracle installed database accounts. Consequently, revoking execute permission on UTL_FILE from PUBLIC will result in errors in a number of standard Oracle database utilities and The Oracle E-Business Suite. Also, some Oracle products and third party products will grant execute on UTL_FILE to PUBLIC during the installation of the product.
We do not recommend revoking execute permission on UTL_FILE from PUBLIC in database instances running the Oracle E-Business Suite and other complex applications (i.e., SAP, Peoplesoft, Oracle Clinical, etc.) due to the possibility of encountering errors in the application and third party products. Only revoke execute permission from PUBLIC in database instances where the application, third party products, and all database management tools can be thoroughly tested. All Oracle delivered products must be tested since Oracle often assumes UTL_FILE is granted to PUBLIC and does not provide the necessary grants when any products are installed – this includes products like Enterprise Manager Grid Control and Apex.
Security considerations with UTL_FILE can be mitigated by removing all directories from UTL_FILE_DIR and using the Directory functionality instead.Oracle E-Business Suite and UTL_FILE_DIR
The combination of UTL_FILE being granted to PUBLIC and UTL_FILE_DIR being publicly accessible creates a significant security issue for the Oracle E-Business Suite. The Oracle E-Business Suite uses UTL_FILE_DIR to read and write concurrent manager request temporary files. Also, UTL_FILE_DIR is extensively used by most organizations to access interface and conversion data files from PL/SQL interface programs.
In the Oracle E-Business Suite, UTL_FILE_DIR is usually set to include at least the directories specified in $APPLPTMP and $APPLTMP – in the default installation this will include at least “/usr/tmp”. Frequently, additional custom directories will be included for custom interfaces and other custom programs.
By accessing the APPLSYSPUB database account, an attacker can easy read and write interface data files. Depending on the exact configuration, implemented modules, and custom interfaces, this could allow access to sensitive information including social security numbers and credit card numbers.Migrating From UTL_FILE_DIR
For Oracle E-Business Suite customers, migrating from UTL_FILE_DIR to Directories requires only minimal changes and may require no source code changes depending on the design of the interfaces and other custom programs. The steps are as follows -
- Identify where UTIL_FILE is used
- Create Directories
- Change FOPEN calls to use Directories
- Edit UTL_FILE_DIR to remove physical Directories
Step One – Identify Where UTIL_FILE Is Used
The most difficult issue is identifying the packages, functions, and procedures using the physical directories in UTL_FILE_DIR. The UTL_FILE_DIR physical directories are only directly referenced by the UTL_FILE.FOPEN function. The FOPEN specifies the operating system directory and file name to open. All subsequent read, write, and close function calls use the file handle returned by FOPEN.
The following SQL may assist in identifying uses of UTL_FILE_DIR in FOPEN statements –
SELECT * FROM dba_source WHERE upper(text) like '%FOPEN%' AND name like '%<custom prefix>%' AND owner = 'APPS'
If the calls to FOPEN are not in a common function and are not accessed through some other indirection, it should be fairly straightforward to find and change the necessary FOPEN references in any custom PL/SQL packages, functions, and procedures. If the physical directory paths are stored in a table or in a concurrent program definition, then no changes to the source code are required.
At this time, converting the standard the Oracle E-Business Suite directories ($APPLPTMP and $APPLTMP) is not recommended as this is not supported by Oracle. Theoretically it should work without any issues, however, the Oracle E-Business Suite references the directories in multiple places including the $APPLPTMP and $APPLTMP environmental variables, system profile options (e.g., “ECX: XSLT File Path”), and potentially in some configuration files.
Step Two – Create Directories
The following general steps are required to change the references from UTL_FILE_DIR to Directories. Please note that the directory name MUST always be in uppercase in all UTL_FILE.FOPEN statements, otherwise errors may be encountered
For each custom directory in UTL_FILE_DIR, execute the following SQL statements in each development, test, and production database instance –
CREATE OR REPLACE DIRECTORY <name> AS '<physical directory path>';
GRANT READ, WRITE ON DIRECTORY <name> TO APPS;
as an example –
CREATE OR REPLACE DIRECTORY TMP_DIR AS '/usr/tmp';
GRANT READ, WRITE ON DIRECTORY TMP_DIR TO APPS;
The directories “/usr/tmp” and “../comn/temp” and any other directories specified in $APPLPTMP and $APPLTMP should remain in UTL_FILE_DIR, since these directories are required by Oracle.
Step Three – Change FOPEN Calls to Use Directories
Once directories have been created the next step is to edit your code to use them. The process is straightforward. If a physical directory is specified in the UTL_FILE.FOPEN statement, change the hard-coded path to the Directory name.
As an example –
FILE_ID := UTL_FILE.FOPEN('/usr/tmp', 'dummy.txt', 'W');
change to –
FILE_ID := UTL_FILE.FOPEN('TMP_DIR', 'dummy.txt', 'W');
Two pointers to keep in mind:
- Always be sure to use the directory name in uppercase and it must be enclosed in single quotes
- If the physical directory is specified in a table or as a parameter in a Concurrent Program definition, then just specify the Directory name rather than a physical path – /usr/tmp becomes TMP_DIR
Step Four – Edit UTL_FILE_DIR to Remove Physical Directories
Remove all the custom physical directories from UTL_FILE_DIR. The standard Oracle directories of ‘/usr/tmp’, ‘../comn/temp’, etc. should not be removed. The database must be bounced for the change to take effect.
If you have questions, please contact us at firstname.lastname@example.orgReferences
- Using CREATE DIRECTORY Instead of UTL_FILE_DIR init.ora Parameter”, Oracle Metalink, Metalink Note ID 196939.1 https://support.oracle.com/rs?type=doc&id=196939.1
In our blog post on 16-May, we provided guidance on Java JAR signing for the E-Business Suite. We are continuing our research on E-Business Suite Java JAR signing and will be presenting it in a forthcoming educational webinar. Until then we would like to share a few items of importance based on recent client conversations -
- Apply latest patches - The latest patches for Oracle E-Business Suite JAR signing are noted in 1591073.1. There are separate patches for 11i, 12.0.x, 12.1.x and 12.2.x. To fully take advantage of the security features provided by signing JAR files the latest patches need to be applied.
- Do not use the default Keystore passwords - Before you sign your JAR files change the keystore passwords. The initial instructions in 1591073.1 note that a possible first step before you start the JAR signing process is to change the keystore passwords. Integrigy recommends that changing the keystore passwords should be mandatory. The default Oracle passwords should not be used. Follow the instructions in Appendix A of 1591073.1 to change both keystore passwords. Each password must be at least six (6) characters in length. If you have already signed your JAR files, after changing the keystore passwords you must create a new keystore and redo all the steps in 1591073.1 to create a new signed certificate (it is much easier to change the keystore passwords BEFORE you sign your JAR files).
- The keystore passwords are available to anyone with the APPS password - Using the code below anyone with the APPS password can extract the keystore passwords. Ensure that this fact is allowed for in your polices for segregation of duties, keystore management and certificate security.
SQL> set serveroutput on
This will output the passwords in the following order:
store password (spass)
key password (kpass)
If you have questions, please contact us at email@example.comReferences
- 16-May-2014 Integrigy Blog post Oracle E-Business Suite Security - Signed JAR Files - What Should You Do
- Enhanced JAR Signing for Oracle E-Business Suite, 19-March-2014, Doc ID 1591073.1 https://support.oracle.com/rs?type=doc&id=1591073.1
- Oracle Tutorial on Java JAR signing: http://docs.oracle.com/javase/tutorial/deployment/jar/intro.html