Feed aggregator

Why Mark Hurd won’t come to Quest – but you should

Andrews Consulting - Fri, 2011-04-01 09:31
Every year I look forward to Collaborate, this year especially as I sit in Connecticut watching snow fall on April Fools Day. Orlando is certain to be nice this time of year, but my excitement about the event goes way beyond the prospect of finally feeling warm again. Every past trip to Collaborate has been […]
Categories: APPS Blogs

The Last Post...

Lisa Dobson - Thu, 2011-03-31 04:05
...at least here, on this blog as I’ve moved over to blog.lisadobson.com now.I’ve copied all the posts from here across to the new blog, but I will also be leaving them here for a while, for anyone coming here through searches for old stuff.For all the new stuff, pop over to my new blog...See you on the other side!Lisahttp://www.blogger.com/profile/16434297444320005874noreply@blogger.com4

Choosing The Right Directory For The Cloud - Recording of Mark Wilcox Webcast from March 24, 2011

Mark Wilcox - Thu, 2011-03-31 00:14

Last week I delivered a webcast on Choosing the Right Directory For the Cloud and the recording for the event is now live.

Even if you don't really have any interest in directories on the cloud - I encourage you to listen to the Q&A after my short (about 20 minutes) presentation.

Lots of interesting questions - most of which are not directory-centric.

Posted via email from Virtual Identity Dialogue

Database Web Services Callout utility

Kuassi Mensah - Wed, 2011-03-30 13:11
Following OTN migration to UCM, the link to the Wev Services Callout is broken; while i am fixing it, you can download it from here.

Here it the link again http://download.oracle.com/technology/sample_code/tech/java/jsp/dbws-callout-utility-10131.zip

SAGE Computing Services Success: Forms upgrade to 11g

Chris Muir - Wed, 2011-03-30 08:51
I don't normally write these sort of blog posts, but Oracle's been keen to let customers know how simple the upgrade of Oracle Forms 10g to 11g is. One of the major sticking points for customers is that this requires a move from Oracle Application Server and OC4J to WebLogic Server, a foreign application server platform to many traditional Oracle sites.

SAGE Computing Services assisted the Department of Treasury and Finance in Western Australia in undertaking such an upgrade in late 2010, and we can attest to the fact that this is an easy process, Oracle's WebLogic Server is fully capable of running your production Oracle Forms systems.

For those interested Oracle has recorded the success in a whitepaper.

So now there's no reason to upgrade to Apex or ADF, just upgrade your Forms system instead!

Making It Easier For Developers To Access LDAP

Mark Wilcox - Tue, 2011-03-29 02:41

One of the reasons why I think LDAP has always had slow adoption by developers is most of their tools provided great abstractions for dealing with databases (like Hibernate, Toplink/JPA, ADF Business Components, etc) while LDAP trailed.

However, at Oracle we do have some great ways to fix this problem.

And not just by trying to make LDAP look like a database.

There are three ways to do this:
1 - You can use OVD's Web Interfaces - either REST (OVD HTTP/Web Gateway) or SOAP (DSML v2)
2 - Oracle Platform Security Services User/Role API
3 - Oracle Platform Security Services Identity Governance Framework ArisID

Posted via email from Virtual Identity Dialogue

How To Query OVD, OID, DSEE Using SQL

Mark Wilcox - Tue, 2011-03-29 02:24

One of the perpetual questions in LDAP is "how to query via SQL". I even wrote a post on this 3 years ago.

And while it doesn't occur very often anymore - it popped up again this week. So I suspect there might be others.

First - to be clear - SQL is very different than LDAP. SQL is simply a standardized query language for querying a relational database. Each database has a different protocol - that's why each database must provide its own database driver even for a standard connection API like JDBC (or ODBC or .NET ADO).

Second - if you have access to an Oracle database (even Oracle XE) you can use the DBMS_LDAP PL/SQL API to query an LDAP server. And a very useful trick to perform with that is to create a database view that maps to a DBMS_LDAP call. When you go this route - you can have your PL/SQL expert write one package and then anything that can connect to the view - can use the data without needing to use PL/SQL or LDAP.

Third - If you are using Java - you can use the JDBC-LDAP library. JDBC-LDAP is a JDBC driver we wrote almost a decade ago at OctetString. Because there was so little demand for it - we actually released it as open-source and donated to OpenLDAP. And you can get pre-built binaries here.

Once you have JDBC-LDAP then you can use it similar to any other JDBC driver.

And even do a SQL query - though it has a strong LDAP flavor:

ResultSet rs = stmt.executeQuery("SELECT cn, uniquemember FROM subTreeScope;dc=example,dc=com WHERE objectclass=groupofuniquenames");

This says "retrieve the cn and uniquemember attributes from any groupofuniquenames objects under the dc=example,dc=com branch"

In LDAP terms - the start of the statement lists which attributes you want (this could be * for all attributes), Scope & searchbase is set on FROM and WHERE clause is the LDAP filter.

And here is an example of what the results look like (captured from my output in Netbeans):

Sort by : null
numColumns is 4
cn:Directory Administrators
cn:Accounting Managers
cn:HR Managers
cn:QA Managers
cn:PD Managers
BUILD SUCCESSFUL (total time: 1 second)

Posted via email from Virtual Identity Dialogue

Information Rights Management supports IE9

Simon Thorpe - Mon, 2011-03-28 19:03


Hi, just a brief note to mention that we released an IRM Desktop last week to provide compatibility with IE9. The new IRM Desktop is compatible with 10g and 11g IRM Servers, and is available via our patch delivery mechanism in the Oracle Support site. Customers can download it from their and distribute it to their users as and when required.

To recap, the latest IRM Desktop supports Microsoft Office from 2000 through 2010 for Office formats and RTF and text, Outlook likewise for sealed email, Adobe 9 and X for PDF, MS IE 7 through 9 for HTML, XML and some image formats, and MS SharePoint 2007 and 2010.

For searching encrypted content, it also supports Windows Explorer Search from XP through Windows 7, Windows Indexing Service on XP and 2003, and SharePoint Indexing Service 2003 and 2008.

UPDATE: A number of people have contacted me to ask how to get hold of the patch kit. If you are an Oracle customer, you can go to support.oracle.com and log in using your customer service id to access patches and knowledge base articles and much more. The IRM patch for IE9 should be found by searching for 10410462. If you use IRM as part of a service run by one of our customers, then the service provider should be making the patch available to you.


OID Supports 400,000 (Four Hundred Thousand!!) Operations Per Second on 500 Million User Database. AKA OID Eats Facebook Database For Breakfast

Mark Wilcox - Mon, 2011-03-28 08:36

It's funny - in the Internet - we can forget that no matter how popular new technologies are - like Twitter or Facebook that their other less "fashionable" (after a few drinks you might even say "dead" :)) technologies like SMTP, IMAP and of course LDAP that still handle far more social networks than these two systems do.

And we've seen this because in the past year - there has been a number of new opportunities around building new extremely large (e.g. larger than 10 million) directory servers.

Typically this is because companies are either launching new cloud services or consolidating older user databases into standards-based approaches. This isn't just the usual suspects (e.g. telco) either. Insurance agencies, retailers and others who have large customer bases that need to use a directory service for customer-facing portals, messaging, etc all are looking into these types of solutions.

At Oracle both OID and DSEE are strategic options for directory services. We love them both :).

But because OID uses the Oracle RDBMS for its storage - when it comes to these extremely large directories it gives customers some unique capabilities that don't exist with any other directory product.

In particular:

  • ability to scale to extremely large number of entries without needing to split the entry database into multiple instances (called partitions)
  • can leverage Oracle Exadata database machines

And we have put this together into a new whitepaper.

In this white paper we showed how we got OID 11g on an Exadata machine containing 500 million entries (e.g. roughly the size of Facebook's 2010 user population) - were able to get it to 400K operations per second.

And that was only on a Exadata half-rack.

With 10gb Ethernet (as opposed to Infiband).

Meaning -  we're not even close to maxing out the performance here.

Yet we're easily lapping the field and doing it with less management overhead.

Or in other words - if you find you need a new large-scale directory, there really isn't any reason to be looking at any other directory vendor.

Because no other vendor gives you two proven options to scale to these numbers. You can either choose to scale horizontally by data partitioning using DSEE leveraging existing commodity hardware  or you can avoid partitioning by utilizing the power of Oracle RDBMS with OID with or without the unique capabilities of Oracle Exadata.

Posted via email from Virtual Identity Dialogue

The Cost of Mediocre

Jeff Hunter - Sun, 2011-03-27 05:11
Over the years I've written tons of scripts to monitor all sorts of things on the database.  Some of those scripts turned out to be helpful on an ongoing basis and some ended up dying on the vine when new features of Oracle came out. One of my scripts looks at the top processes in a database from the CPU's perspective.  In other words, how much time did the process use on the CPU over it's

Concatenation, Concatenation, Concatenation

Oracle WTF - Sat, 2011-03-26 04:08

I'm still not sure what this one does, but you have to be impressed by 11 nested CONCATs.

(And by the way, you also have to be impressed by the inventor of the CONCAT function who evidently considered two arguments sufficient, unlike, say LEAST, GREATEST, DECODE, COALESCE and BIN_TO_NUM. But not NVL. Who knows what goes through these people's heads.)

   ( p_xyz_id_out OUT NUMBER,
     p_input_array IN myarrayrectype )
   p_xyz_id_out := NULL;

      INSERT INTO xyztab
                                    p_input_array.xyz_11 || ' ',
                                    p_input_array.xyz_12 || ' '),
                                  p_input_array.xyz_13 || ' ' ),
                                p_input_array.xyz_21 || ' ' ),
                              p_input_array.xyz_22 || ' ' ),
                            p_input_array.xyz_23 || ' ' ),
                          p_input_array.xyz_31 || ' ' ),
                        p_input_array.xyz_32 || ' ' ),
                      p_input_array.xyz_33 || ' ' ),
                    p_input_array.xyz_41 || ' ' ),
                  p_input_array.xyz_42 || ' ' ),
                p_input_array.xyz_43 ),
            1, 512 )
      RETURNING xyz_id INTO p_xyz_id_out;
END ins_xyz;

Thanks BB for this one, which she or he (I can't say more for witness protection reasons) sent me a while ago and I almost forgot about.

I didn't post it at the time because I couldn't understand what it did. Looking at it again though, that's all part of the fun. Here's part of the conversation we had about it:

Me: Thanks BB - love it. I'm slightly puzzled by p_input_array though. Is it an array?

BB: An array of records.

Me: Yikes. So what does the target table look like? I suppose each 'xyz_nn_' column must be a nested table.

BB: In the actual system they're parts of node tuples. xyz_11, xyz_12, xyz_13, all indicate "scores" for pairings of the first node with 1, 2, 3, respectively. Hard to explain without giving away too much about the system. However, they're scalars.

Me: Glad we got that cleared up. Can I say parts of node tuples without endangering your job at NASA?

Oracle E-Business Suite and APEX White Paper

David Peake - Fri, 2011-03-25 12:21

The Oracle E-Business Suite and Oracle Application Express teams are proud to announce the release of the Extending Oracle E-Business Suite Release 12 using Oracle Application Express white paper.

Oracle E-Business Suite delivers a wide range of functionality to handle core areas of your business processing needs. However, there are situations where you want to extend your information systems beyond the range of Oracle E-Business Suite. Many times these necessary extensions are meant to handle unique industry conventions, specific customer requirements, or perhaps to offer some other competitive edge. Sometimes these change requests are simple enough, but other times more extensive customizations are needed. In these scenarios, Oracle Application Express, also known as Oracle APEX, provides an easy way to create supplemental applications that are easily integrated with your Oracle E-Business Suite and its data.

This paper outlines how to extend Oracle E-Business Suite 12.1.3 (and up) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail.

You can find the paper on the APEX OTN Site > Learn More > Extending Oracle E-Business Suite Release 12 using Oracle Application Express {Under Technical Information and White Papers}

All the necessary files are also available from My Oracle Support Note: 1306563.1

This document helps customers and partners implement integrated Application Express extensions to the Oracle E-Business Suite Release 12.1.3 and up. The document is complete with a worked example. This solution also requires Oracle E-Business Suite Patch 9659153

Dutch Oracle User Group's Apex Day 2011

Tony Andrews - Fri, 2011-03-25 06:32
This week I attended the Dutch Oracle User Group (OGh)'s Apex Day as a presenter, along with an ex-colleague from Northgate, Nigel Blair. We were talking about how we converted 1500+ Forms modules to Apex. There was quite a lot of interest from the 250 people present. We hope the interest wasn't due to a mix-up in the agenda that had us down as Nigel Andrews and Tony Blair!Luckily we were on Tony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.com0http://tonyandrews.blogspot.com/2011/03/dutch-oracle-user-groups-apex-day-2011.html

Upgrading to Oracle 11gR2

Jeff Hunter - Fri, 2011-03-25 05:11
I am about half way through upgrading all my dbs to Oracle 11gR2 from various versions of 10gR2.  Out of all the upgrades I've performed from 7.0 up to 10gR2, the 10g to 11g upgrade is by far the most hassle free of all. I have abandoned the GUI upgrade tool this time.  The GUI tool is fine, but internal issues prevented me from running the GUI remotely.  This meant that somebody had to be

Best practices for building cloud based applications

Debu Panda - Fri, 2011-03-25 00:07
I wrote another article outlining some best practices for building cloud based applications. You can read the article at http://www.devx.com/architect/Article/46602?trk=DXRSS_LATEST

I am writing this blog using my iPad and blogger is not iPad friendly

OTN Dev Days Database Toronto

Kuassi Mensah - Thu, 2011-03-24 18:00
Toronto: OTN Dev Days Database is coming to you; we are still taking registration and There Is Such A Thing As Free Lunch.

OVD-EUS: Questions and Answers About Mapping Database Users, Roles to AD Users and Groups

Mark Wilcox - Thu, 2011-03-24 03:19

More OVD-EUS AD Q&A from sales:

Question: which AD object types are used to store Oracle users and roles in AD
Answer: There are two ways to deploy OVD-EUS. Option 1 - uses OID (or DSEE) to store the EUS metadata, thus the only attribute used in AD is the orclcommon attribute used to store the password hash (assuming using EUS password authentication). Option 2 - The EUS meta-data is stored in a branch explicitly created to store this data and the AD schema is extended to support this.

Question: are any roles added  to AD by default with the schema extension
Answer: No.

Question:  which oracle accounts are typically excluded from integration
Answer: In 10g database you cannot use sysdba users. In 11g any user can be used.

Posted via email from Virtual Identity Dialogue

Call for Papers for Oracle OpenWorld 2011

OCP Advisor - Wed, 2011-03-23 19:37
Oracle OpenWorld 2011 will be held this year from October 2-6, 2011 in San Francisco, CA. If you want to get a free conference registration, respond to the call for papers and submit a presentation proposal. If your submission is selected, you get a FREE registration!

This year the site for presentation proposal submission is a new one. So you have to register on the site first and then submit. Read the submission guidelines before your submit your proposal. There are strict character limits on abstracts and other sections.

The title should be 80 characters or less which is about 10-17 words. A creative title always helps to catch the selection committee's attention. My first submission at Oracle OpenWorld a decade ago was "Eyes Wide Shut - Migrate Your Enterprise to Oracle Applications". Thanks to Tom and Nicole, both the movie and my session had a public viewing. The abstract has to be 750 characters or less which is about 80-100 words. Review the Primary Track and Optional Track before selecting the appropriate one. Selecting the right track increases your chances of acceptance. One can aslo add tags to the submission, so the abstract is searchable using multiple criteria. Session Type can be either conference session or panel. Session category includes best practices, case study or product strategy / roadmap. The last one is usually reserved for Oracle speakers. For the first time, one can add a video link supporting the proposal content. Perhaps a creative spot on Youtube may come in handy. The official requirement is to have a video that provides more information or background on your topic.

Call for papers close on Sunday, March 27, 2011 at 11.59 Pacific Standard Time. So put on your thinking caps and showcase your success stories for the last 12 months at the largest enterprise application technology conference in the world. Get ready to get noticed!


Jeff Hunter - Wed, 2011-03-23 17:11
I haven't done any research on this yet, so I don't know if it is fixed in a subsequent patch or a later version.  But seriously, a space? SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release - 64bi

OGh APEX day 2011

Rob van Wijk - Wed, 2011-03-23 17:01
Yesterday I attended OGh's APEX day. Previous year was already pretty successful with 150 people attending. This year the maximum of 150 people was reached in only a few days, so we scaled up the event to a maximum of 250 people, and in the end we still had to disappoint several people. And this year we had several sponsors as well: Oracle, Ciber, Transfer Solutions and Itium. These must be signsRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com2


Subscribe to Oracle FAQ aggregator