OraNA :: Oracle News Aggregator

A coworker asked for this recently. If he tries to download the additional server adapter for GlassFish Java EE 5, Java EE 6 1.0.54 with his 3.5 Eclipse he gets the following error:

[... truncated to the relevant parts ;)]
Cannot complete the install because of a conflicting dependency.
Only one of the following can be installed at once:
Sun Application Servers and GlassFish Servers support 1.0.52
GlassFish Java EE 5, Java EE 6 1.0.54

He tried "check for updates" on the complete distribution but this does not work. Even downloading the packages and replacing them directly within Eclipse does not work. After some research, I believed I found a solution:

If you try to simply "install the 1.0.54 as a "new extension", you will get the above error because of the already installed .52.
What you really need is an update. Lets give it a try:

1) Start Eclipse 3.5.x. or 3.6.Mx (Make sure that the WTP (Web Tools Platform) plugins are installed.)
2) Start the installation procedure : select the Help>Software Updates>Find and Install... menu item.
3) Select "Search for new features to install" option and click Next.
4) Click New Remote Site...
5) Give a name (ie GlassFish Eclipse Site), enter the URL: https://ajax.dev.java.net/eclipse
6) Select this new site in the Sites to include in search list and click Next.
7) Select "GlassFish v2.x Java EE 5 and v3 Java EE 6 support" in the "Select the features to install" list and click Next.
8) Review the "Your original request has been modified." window and click Next.
9) Accept the terms of the license agreements and click Finish.
10) Wait for the installation to complete

This should be everything to do. But unfortunatualy this update fails due to a missing Manifest.mf within com.sun.enterprise.jst.server.sunappsrv_1.0.54.jar.

[...]
An error occurred while loading the manifest D:\Program Files\eclipse-jee-galileo-win32\plugins\com.sun.enterprise.jst.server.sunappsrv_1.0.54.jar.
java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(ZipFile.java:114)
[...]

And: btw. This even does not work with 3.6. :(

If you are running Helios (3.6) you can make a new try. All the above steps with a different URL: http://download.java.net/glassfish/eclipse/helios.
The 11th step is to confirm that you are willing to install unsigned content. if you choose yes, you are asked to restart Eclipse. This works and you are done.

You are now able to create new Server Runtimes:

• GlassFish 2.1 Java EE 5
• GlassFish Server Open Source Edition 3 (Java EE 6)
• Sailfin v2

I did not manage to get all this working with 3.5 :( Seems as if the whole server adaptor plugins situation is a mess at the moment. I hope, that this will be resolved shortly. Mainly because the GlassFish Plugins will move to the Oracle Enterprise Pack for Eclipse (OEPE) (compare this bug entry) and will be available at this url http://download.oracle.com/otn_software/oepe/helios/wtp in the future. This will happen with the next OEPE release (which is expected to arrive shortly). At the moment this page is not available.

Oracle: if you are reading this: Please provide updates for 3.5 also. Don't expect anybody to
a) use OEPE or
b) always update to the latest environments

If anybody knows a solution to this .. let me know ..

Recurring OTN Question:

How can I hide my dashboard:

Goto Administration:

Next goto manage privileges:

Next goto Catalog Personal storage:

Set the privileges:

tada:

Till Next Time

I can see this post degenerating into a rant, so I would like to preemptively appologize to anyone involved in the production of this exam. I’m guessing it’s a real pain to develop these exams, especially when some ass like me starts moaning about them. Added to that, I’m guessing the word “Expert” means slightly different things to different people…

I’ve been barking on recently that in my opinion, the most important skill required by any PL/SQL developer is SQL, with knowledge of PL/SQL itself coming in second place. Having recently taken the “Oracle Database 11g: Advanced PL/SQL (1Z0-146)” exam (mentioned here), I thought it was a little hypocritical not to sit the “Oracle Database SQL Expert (1Z0-047)” exam as well, so this morning I did just that.

Here are some of my thoughts on the exam, in no particular order of importance:

• Regular Expressions: I think it is important that people understand what regular expressions can do and when it is appropriate to use them, but I don’t think it is necessary to test people on the meta-characters themselves. That’s what the docs are for.
• Analytic Functions: No sign of them in my questions from the pool. Surely analytic functions are more important than regular expression meta-characters.
• The majority of the exhibits were pointless. It seems like they were placed there to waste the time of people with bad exam technique, rather than to assist in answering the question. This was especially true of the schema diagrams, which I only referred to once when the datatype of one of the columns was important.
• Several of the questions could be answered without reading the question at all, as the incorrect answers jumped out at you because they contained blatantly incorrect statements.
• Several of the questions included the “ANY” and “ALL” comparison operators, which are barely mentioned in the documentation, and I don’t think are included in the 11gR2 documentation at all. I guess these are only included in Oracle because the are part of ANSI SQL. I can’t remember ever using them in Oracle or seeing them being used by others. I have come across them in mySQL so I knew what they were for, which was fortunate.
• There were lots of questions that included DML against inline views rather than directly against tables. It got to the point where I felt like, “If it’s got braces in it I’m going to tick it”.

I very quickly turned into a grumpy old man and started to rush through the exam, spending most of my time thinking about writing this blog post, rather than the exam itself.

In the end I got 96%, which I guess means I got 3 questions wrong out of the 70. Serves me right for rushing it so I could come home and bitch about it.

So I am now an “Oracle Database: SQL Certified Expert” as well as a grumpy old shite…

Cheers

Tim…

Becoming a bit of a tradition actually…

Trying for others to avoid the same, at least it was in 2008/2009, ordeal going thru the O.O.W. Schedule / Content builder trying to find XMLDB topics, I listed those I could find on the XMLDB OTN Forum. As said, trying to follow up on a tradition and to get myself (and hopefully you) an overview on things to come during Oracle Open World 2010 (/Oracle Develop /JavaOne). This year I think its becoming BIG regarding amounts /attendance of people if not only due to the combination of O.O.W./Develop/JavaOne on the same spot in San Francisco…

So, for me and those who are interested, just like the year before, hereby an attempt to find all XMLDB related presentations, workshops and other events during Oracle Open World 2010. I will try to add info, time and days later on (and/or you might) if I find them and/or if they become known. See for XMLDB presentations and Hands-on Lab sessions here:

• Oracle Open World 2010: XMLDB Presentations and Hands-on Labs

I hope you enjoy your presentations during O.O.W. and who knows we meet this year.

Not really into XMLDB presentations? Have a look at the 50+ Oracle ACE(D) presentations Oracle Open World and JavaOne, Oracle Develop listing here…

The R12.ATG_PF.B.Delta.3 patch (8919491) recently got released to Oracle Metalink. This patch contains a quick new feature in Applications Object Library, which could be interesting to you. In most E-Business Suite install base, customers also need to access one or more edge applications e.g. BI Dashboards etc., which are typically rendered as function links on the E-Business Suite Home Page. Some of these applications may require the E-Business Suite security context to render themselves correctly. Until now customers would have to wait for  a E-Business Suite certified way of creating links to such edge applications e.g. Discoverer, OBIEE etc.

With this patch, customers will now have the flexibility of creating function links to any such applications of their choice, with or without the E-Business Suite security context. Let me take the example of OBIEE Dashboard or Report to explain the feature.

OBIEE reports are generally organized in a folder like hierarchy so that a report can be referenced as “<my obiee report folder>/<my report>”. Let’s assume we are trying to create a link for the “New Hire Retention by Source” report, which is in “/shared/Human Resources” folder. In order to create a link on the navigator, we must create a “Function”, attach it to a “Menu” and attach the menu to desired “Responsibilities”. The function definition for this example would look like the one shown below.

Note that the Function Type has to be “SSWA jsp function”. Continue to the next page and complete the rest of the function definition.

Note the HTML Call, which says “GWY.jsp?targetAppType=OBIEE&Path=/shared/Human Resources/Recruitment/Hires/New Hire Retention by Source&Action=Navigate”. You may substitute appropriate value for the “Path” parameter, if you want to create link for another OBIEE Report. Additionally, you may also pass OBIEE specific parameters in the URL. The details are published in Oracle Metalink Note 974422.1.

Once the function is created, you may attach it to appropriate menu and then attach the menu to appropriate responsibilities. This will ensure that the function link for the OBIEE report is rendered on the applications navigator, when such responsibilities are accessed.

I shall post more updates shortly on this feature, where I shall discuss how customers can extend this feature to render links for custom and/or 3rd party applications.

Yes!! We are working on it!

Currently only Chrome and Safari from what I can see support websockets; but we are including this functionality. So; if you are using the AIR version of the Simdraz engine or a browser that supports websockets you won`t need to worry about AJAX request and polling even though AJAX is fast, it’s just not as fast as websockets and it also helps saves on bandwidth.

In theory less request & better performance

The R12.ATG_PF.B.Delta.3 patch (8919491) recently got released to Oracle Metalink. I wish to take the opportunity to highlight the major changes in Enterprise Search area, which are included in this patch.

Advanced Results Display Option in Enterprise Search Toolbar

Assuming you have already enabled the Enterprise Search Tool bar in OA Home page, you would notice that a “Search Results Display Preference” choice box has been added. This gives you a very flexible option of switching back and forth between our standard search results display and Oracle SES default search application. You may customize the Oracle SES search application’s results display, the way you want.

Result displayed in Standard display preference:

If you switch the display preference to “Advanced”, this is what you get:

You may need to login one more time depending on whether you have SSO in place or not. In either case, you should be able to seamless switch between the two different display options.

Export Search Results to Excel Spread-sheet

You may now export the search results, when rendered in “Tabular” style into an excel spread-sheet.

 

Sort by Displayed Attributes

Search results are displayed in the descending order of relevance by default. You may also choose to sort the results on any other displayed attribute of a search object.

Note:- Sorting is currently done on top 100 results. If the result set contains more than 100 results, you may not get the desired outcome.

See also fbi_stats.sql for reproducible test case There are often odd little details that need finishing off. The wrong index is chosen – cost based – if it starts with a virtual column and the predicate is range-based, and there is an alternative index that starts with a real columns http://forums.oracle.com/forums/thread.jspa?threadID=1064154&tstart=0

Oracle 11i Applications Working on IE8, Firefox 3.5 & VISTA and Windows 7 What you need to do is below and please follow the exact steps for this to work. I got this to work on latest Firefox 3.5 and IE8 and that too on VISTA. It also works on the current Windows 7 RTM [...]

From time to time I add links to my blog list, but highlight for a few days with  a blog posting as well.  I’ve just been browsing through http://gavinsoorma.com and it’s probably worth keeping an eye on it – especially if you’re   getting to grips with Goldengate. Filed under: Uncategorized

If you’re running an Oracle Application Server 10g instance you are probably familiar with Oracle Enterprise Manager Application Server Control. If not, go back to the manual. This is not a how-to on setting it up or using it. If you want to know how to secure it and refresh the certificate when it expires, [...]

I put together a few RPMs that can help make life easier on SRS5 on OEL (or RHEL or CentOS).

Download here.

- libflashsupport will help OSS audio support for flash10
- SunRay-addons is an rpm that contains 2 utaction scripts
1) autoresize -> will try to reset resolution based on your new DTU screen resolution when you hotdesk
2) usbdrived (Daniel Cifuentes's usbdrived script) -> pops up a nautilus window when you plug in a usb flash drive into your DTU
-) these scripts can be enabled/disabled from /etc/sysconfig/SunRay-addons

again, this is all just for fun - unsupported - but they help me and I thought I'd share

In May, I was blogging about new Oracle product release - BPM 11g. You can check this post - Oracle BPM 11g Integration with ADF and WebCenter Suite. I'm working now in this area and integrating BPM 11g Human Tasks into WebCenter Spaces 11g. Really good news for BPM people is that now we can create rich SOA type applications, it is possible to bring standard ADF Task Flows and Oracle BPM based ADF Task Flows together into WebCenter Spaces 11g Process Space.

I can access custom ADF Task Flows in WebCenter Spaces 11g, by declaring them and extending WebCenter resource catalog:


My custom ADF Task Flow is present in resource catalog - it brings filterable list of company employees and allows to modify employee details:


Through WebCenter Composer, this custom ADF Task Flow can be easily added to the Oracle BPM Group Spaces page:


From Oracle BPM Group Spaces page user can see and manage assigned BPM Human Tasks. Additionally, our custom ADF Task Flow for Employees data management is available on the same WebCenter Spaces 11g page:

In this post I continue to look at CQL aggregation queries and the issues that arise when writing real-world applications. One requirement that I have seen over and over in my interactions with CEP customers is the need to include some additional data in the output of the aggregation query, in addition to the aggregated value itself.  I shall call the addition of this additional data to the query result "enriching" the aggregation query. Enrichment examples include adding the symbol of an equity to the query result when calculating the moving average price, including the call center location when calculating the number of calls processed in the last minute, or selecting the campaign ID in the case of an advertising application that is aggregating revenue in real-time.

Let's consider some examples of enrichment queries in the context of the system monitoring example that was used in the previous post to this blog. Previously, we defined the following query

istream(
SELECT sum(severity) as totalseverity
FROM alerts[rows 3 slide 3]
HAVING COUNT (*) = 3) 

 

This query processes a stream of incoming alert events each of which contains a severity code. The query sums up the severities of every three alert events into an outgoing aggregate or "complex" event. The query makes sure that it doesn't generate any output unless there are three alert events that compose the result and it makes sure that only consecutive sequences of incoming alert events generate output. For example, consider the input stream

alerts: 2, 7, 1, 4, 10, 1, 8, ...

The query will generate the following output:

10, 15,...

 

10 (2+7+1) is the first value output, followed by 15 (4+10+1), etc.  Now, suppose that in addition to selecting the totalseverity value, we also need to include the name of the machine room where the alerts were generated. For simplicity, I shall assume that all of the alerts in the incoming stream come from the same machine room. Here is the query:

 

istream (

SELECT machineroom as mr,

       sum(severity) as totalseverity

FROM alerts[rows 3 slide 3]

GROUP BY machineroom

HAVING COUNT (*) = 3)

If we assume that all of the incoming alerts come from machine room 'mr10', this query will generate outbound events like the following:

 

('mr10', 10), ('mr10', 15), ...

Another common enrichment requirement is to enrich the aggregation result with a value from the most recent event participating in the aggregation.  For example, suppose that each incoming alert event contains the name of the system administrator who should be contacted and that we want to include the name of a system administrator in each outgoing complex event, as well. One way to do this is to use the name of the system administrator from the last event received. Here is a query that implements this strategy:

istream (

SELECT alerts.machineroom as mr,

       recent.administrator as admin,

       sum(alerts.severity) as total 

FROM alerts[rows 3 slide 3] as alerts,

     alerts [rows 1] as recent

GROUP BY alerts.machineroom, recent.administrator

HAVING COUNT (*) = 3)

Given the following input stream:

 

alerts: ('mr10','Hoyong',2), ('mr10','Alex',7), ('mr10','Eric',1) , ('mr10','Anand',4), 
        ('mr10','Seth',10), ('mr10','Andy',1), ('mr1','Manju',8), ...

This query produces the following output stream:

 

('mr10', 'Eric', 10), ('mr10', 'Andy', 15), ...

 

Notice that Eric and Andy are the administrators in the third and sixth incoming alert events, respectively.  It's worth saying a few words about how this query works conceptually, especially for those not familiar with CQL/SQL.  The query executes by first evaluating the FROM clause. The FROM clause specifies a type of join called a Cartesian product between the alerts and recent windows. Conceptually, this appends the recent row to each of the  rows in the alerts window. Then, the query groups these concatenated rows by the alerts.machineroom and recent.administrator columns, but since these columns have the same value in every row, this operation doesn't actually do anything.  Next, the HAVING clause is evaluated to see if there are three row concatenated rows or not. This test eliminates the startup events that don't include three rows. Finally, the select clause is evaluated which selects the machineroom and administrator columns (which are the same in every row) and aggregates the severity column. Note also, that the slide clause causes the query to be executed (modulo startup) once for every three events.

 

Location-based social networks are the latest fad to hit mobile phones. Foursquare seems to be getting most of the attention even though MyTown, Brightkite, and Loopt actually have more users. The concept has mobile phone users using GPS to "checkin" to establishments, including restaurants and retail stores. Checkins are rewarded differently by each system, but some benefits include getting location information (maps, hours, description), reviews, find nearby friends, or receive coupons. There's also the game angle for those that like to collect points, unlock rewards, and gain status.

Retailers would like to know when someone shows up at a store. Its a good time to entice them with an offer, or better yet attract them from a nearby competitor. CardStar, the mobile application that consolidates all your loyalty cards, is now automatically performing a checkin via Foursquare when you use your loyalty card. That marriage makes perfect sense.

Now SCVNGR is taking checkins to the next level. Retailers create challenges for users to perform in exchange for rewards. For example, a retailer may provide a coupon to anyone that checks into 2 different store locations in the same day. Users can earn points for checkins, comments, and photos they take of the store. Then when a certain point threshold is reached, they get a reward.

The flexibility of the program allows retailers to tailor the program to influence behavior better than just a simple checkin. Starting tomorrow, SCVNGR users can earn a $10 coupon at Journeys 800+ stores by winning challenges and earning points. These activities are meant to engage customers and have them get to know the shoe store.

Seems to me that supercharged checkins make a nice addition to loyalty programs.

侍で有名な山本祐介さんがblogでまとめてくださいました。ありがとうございます。
http://samuraism.jp/diary/2010/07/29/1280330031333.html

> これまでメモリリークの解析にはヒープダンプと Memory Aanalyzer が標準的？な解析方法だったと思いますが問題が２点ありました。
> １ 点はヒープダンプの取得はとても重く、運用環境での取得が難しい場合があること。もう１点はリークしているインスタンスをどのクラスローダを保持している か見極められない事です。
> フライトレコーダーはオンラインでもオフラインでも非常に軽くヒープ内の解析が行えること、またクラスローダ別に解析で きることでこの２つの問題を見事にクリアしています。

ステキなコメントありがとうございます。
また、blogでお知らせ頂いているように、OTNライセンスに統一された結果、JRMC/JFRの試用に際して時間等の制限はなくなりました。ぜひお試しください

Read the latest issue of Profit Magazine (July 2010) for a special report on Virtualization with a spotlight on Sun Ray 3 Plus Client and Sun Ray Software.

The report also links to Oracle's Virtualization Strategy Webcast as well as the latest webinar on Oracle VM VirtualBox 3.2

It would be an under statement to say that Oracle is moving full speed forward to enhance Oracle Virtualization product portfolio on all fronts. Stay tuned for more!

To get the latest updates, also follow us on twitter!

More later,
Monica

Pretty slow day today, until this video:

Watch a Flamethrower and a Fire Extinguisher Battle in Slow Motion

Be still my geeky heart.

Also interesting today, this brief history of data visualization by Shawn Allen of Stamen Design (h/t FlowingData). This is a class I wish I could take.Possibly Related Posts:

• Data Visualizations
• I Still Heart Data Visualizations
• Interesting Data Pr0n
• Data Visualization Eye Candy
• Freely Available Utilities

We have 138 PyOhio registrants so far - that's greater than the total number of attendees last year. I'm excited!

Is there a shutterbug in the house? I'm always envious of the photos taken at some conferences, like this one of Python core sprinters at EuroPython. (Hi, guys! Our contribu-palooza-ers will be joining you soon!) I want to join the fun. Our PyOhio attendees are just as pretty as any of them!

So if you enjoy taking pictures, and you're coming to PyOhio (and who wouldn't?), please don't forget your camera! Get some group shots, and let me know about them afterward. Thanks!

See you Saturday!