Archive for the ‘tips’ Category

ADF Mobile APP development without ADF Mobile… .. PS5 – Windows tablet etc..

July 21, 2012

Food for thought…

With the release of ADF Mobile just around the corner for IOS and maybe Android why not just skip ADF Mobile and develop an ADF tablet based app for all tablet based operating systems?.. Windows, BlackBerry etc.

ADF Mobile sits on phonegap with some additional Oracle layers of magic 😉 handling items like its new mobile tag library.. With the release of ADF Ps5; Support is now in place for tablets to handle touch events, graphing DVT etc..

That’s great but there are still limitations with its current browser integrations and device access ie. file systems, media access, contacts list etc are not available to you.
– For example with WebCenter Content you can only browse and download content you are currently unable to upload new media from a source like your tablets camera gallery (in IOS).. These features are coming in next/future OS releases but aren’t available yet and require new attributes to be defined.. So when you need this type of access; what can you do?
Keep in mind ADF Mobile is not yet available.

Well why not develop a normal Phonegap (Cordova) application that loads in the server ADF rendered content? At the end of the day Phonegap is a glorified browser contained application.. All integration to the mobile device is handled by Javascript calls via websockets to the phonegap App.

All you need to do is include a reference to the Phonegap Javascript  library within your ADF page.
And use the phonegap mobile javascript library methods to give you access to features that aren’t currently available from the mobile browser..

This way you can have a reusable ADF web app that you can access from any web browser and if you need access to more device related features give your users the availability download and install the compiled Phonegap application which is not restricted to just IOS but available across a wider range of Operating Systems..

WebCenter Performance Tip: Bug fix for file lock contention on /cs/data/alerts directory

April 16, 2012

At a current customer of ours running a WebCenter Spaces based Intranet with WebCenter Content (UCM) as the backend we started running into some strange performance issues.  The customer is running on Patch Set 4 (11.1.1.5.0).  The site would slow way down at specific times during the day and become unusable for 5 minute periods. It would then clear itself up and be usable again.

During this time the user load on the site would not change so something strange had to be going on.  To diagnose the problem we turned up the system audit tracing in UCM to Full Verbose and looked at the following sections: systemdatabase, searchquery, requestaudit, file*.

The main symptom that were were first seeing was that during these times where the server became unresponsive there would be upwards of 40-50 active database connections for UCM, while the average is usually less than 5.  We also saw a lot of long running queries on the System Audit page that the DBAs told us were happening in milliseconds on the database side.

Looking at the tracing output we were able to confirm that the database queries were only taking milliseconds or even fractions of milliseconds.  So what was keeping the connections open?

A closer look at the output yielded the following for each and every request:

>filelock/7 04.09 09:48:06.221 IdcServer-140003 Reserving /proj/wcsshare/ucm/cs/data/alerts/
>filelock/6 04.09 09:48:06.227 IdcServer-140003 /proj/wcsshare/ucm/cs/data/alerts/--<no-agent>--Locked directory
>filelock/6 04.09 09:48:06.227 IdcServer-140003 /proj/wcsshare/ucm/cs/data/alerts/--<no-agent>--Released

So there was a process that was locking a directory for writing on every request.  Continuing on it became apparent this is what was keeping the connections open.

>filelock/7 04.09 09:48:07.652 IdcServer-140025 Reserving /proj/wcsshare/ucm/cs/data/alerts/
>filelock/7 04.09 09:48:07.653 IdcServer-140015 Lock bounce on loop 2
>filelock/6 04.09 09:48:07.653 IdcServer-140015 /proj/wcsshare/ucm/cs/data/alerts/--<no-agent>--Next sleep interval is 720
>filelock/7 04.09 09:48:07.654 IdcServer-140025 Lock bounce on loop 0
>filelock/6 04.09 09:48:07.654 IdcServer-140025 /proj/wcsshare/ucm/cs/data/alerts/--<no-agent>--Next sleep interval is 120
>filelock/6 04.09 09:48:07.705 IdcServer-139986 /proj/wcsshare/ucm/cs/data/alerts/--<no-agent>--Locked directory
>filelock/6 04.09 09:48:07.707 IdcServer-139986 /proj/wcsshare/ucm/cs/data/alerts/--<no-agent>--Released

As you can see in the above output  there was contention between threads on the same UCM managed server (not to mention the other 3 nodes in the cluster) for locking on that directory.  Since the lock attempt was happening on a filter in the service call it was keeping the database connection open until it could get the lock and release it.

We reached out to some contacts in Oracle development and it turned out that the issue was already fixed and in an available OPatch!  The patch in question for PS4 is 13502977: UCM 11.1.1.5.0 patch (20111230-1105). Looking at the README reveals the following:

2011-05-31 15:34:45 - Core - idcsvn:92934 - Bug 11781402-Moved locking of alerts directory into the if condition. This reduces the unncessary locking of the directory when there is no change in alerts.hda file.

Moral of the story:  If you are on PS4 or earlier of WebCenter Content (UCM), make sure you apply the latest OPatch with this fix.  If you are on PS5 or later, the fix is already included.

Fishbowl QR-Code – Guerrilla Marketing Warfare Strategy

March 5, 2012

Yes, it’s finally here!
A fun quick Cfour QR-Code has arrived..

Print it, stick it & show it off..

I’m thinking that maybe I should be adding more of these in the future posts with secret messages..

For those that are unfamiliar with QR Codes, these things have been around for years and have only been gaining in popularity.
You’ll see them on items like food product packaging (I noticed a nice one on the Jacobs Creek bottle of white, I had last night😉 down to business cards, numerous pieces of marketing material, and so much more.

All you need is a device with a camera like a mobile phone that can read them.
No more fumbling around trying to find a pen and paper or trying to remember what you came across – just a quick scan and you’re off.

For a great run down and use case of QR Codes check out Billy Cripe’s Post – 16 Awesome Uses.

Content in the Enterprise – Still Searching? Start Finding.

June 27, 2011

Fishbowl Solutions recently conducted a webinar in which we discussed our Google Search Appliance (GSA) Connector for Oracle Universal Content Management (Oracle UCM).  We had a great turnout for the event with over 100 registrants and 80 attendees.  The high-level of interest made it apparent to us that enterprise search continues to be an issue within organizations.  These issues are typically user-driven, and the frustrations center around not being able to quickly and easily find the information they need to do their jobs.  However, the bigger and more concerning issue is the inability for users to find information in those systems where they have been directed to store their documents, spreadsheets, images, PDFs, and any other content resulting from their job tasks.  Those systems where contribution is relatively easy, but consumption can be arduous, and well, frustrating.  Those systems are Enterprise Content Management systems.

Enterprise Content Management (ECM) systems provide the most value when content can be easily found, accessed, and shared from within them.  Devoid of these traits however, users start storing content on their desktops, external storage devices, file shares and the like.  Quite often, this leads to outright ECM system avoidance, which can quickly manifest into decreased collaboration and knowledge sharing as well as increased security concerns.  So frankly, this all starts with search.  If the native or 3rd-party search system does not perform as users expect, providing them with accurate, relevant search results and links to content items they know exist in the system, avoidance will indeed ensue and widespread ECM adoption will not be achieved.

When it comes to search, one size does definitely not fit all.  There are currently over 12 enterprise search systems on the market today, and some of these are specialized offerings that fit within specific verticals.  All ECM systems include some level of search functionality, but 3rd-party vendors like Google have found that ECM users want other options.  Take Oracle UCM for example.  It comes with native search capabilities provided by OracleTextSearch, which leverages the powerful Oracle 11g database.  However, to achieve the desired level of satisfaction, organizations may find that a lot of administration is necessary to manage the index of the database.  Furthermore, the user experience leaves a little to be desired.  So, what are organizations looking for when it comes to the search functionality within Oracle UCM?  Based on the questions asked and the follow up conversations we had, these 4 qualities were most important:

  • Easy to use – does not required a skilled knowledge worker to perform searches
  • Results are accurate and relevant
  • Customizable or can be “tuned” to meet organizational needs (Single-Sign-On integration, etc.)
  • Limited administration

The Google Search Appliance delivers on all of these and more.  It truly takes the power of Google.com and brings it within the firewall, providing organizations with the world’s most popular search engine for searching content across their websites, intranets, portals and file servers.  Fishbowl’s GSA Connector for Oracle UCM extends these capabilities to UCM users by providing them with an alternative for searching the content server and any UCM-based website. Fishbowl Solutions is ready to help your organization stop searching for information and start finding it.  We offer a GSA Connector Jumpstart Package which includes the GSA Connector software component plus 40 hours of consulting services.  Fishbowl is also a Google Enterprise Partner, so we can provide you with the GSA device and help you install, configure, and start using it.

For more information, please explore the following GSA Connector pages on Fishbowl’s website:

You can also contact us directly at 952-465-3426 or sales@fishbowlsolutions.com.

Video overview of WebCenter Spaces 11gr3 & tutorial

June 14, 2011

Great source for anyone interested in WebCenter Spaces and wanting a clear well presented overview –

Part 1:

Part 2:

Or if you want to jump in go check out Yannick Ongena’s (@yannick_ongena) Spaces tutorial on 11g PS3.

[Source: Yannick Ongena’s Enterprise 2.0 Blog]