Eye on Oracle - A SearchOracle.com Blog

Eye on Oracle:

 

A SearchOracle.com Blog


The Oracle blog with observations and commentary for DBAs and developers about the Oracle database (10g, 9i), applications (E-Business Suite, Financials, PeopleSoft), SQL and PL/SQL, training, certifications and more.

Oracle builds on database lead

The RDBMS market grew about 12% in 2007, with Oracle once again emerging as the market’s top vendor.

According to the “Worldwide RDBMS 2007 Vendor Shares” report that IDC released last week, Oracle not only increased its share of the market to 44%, but this 13% growth outpaced that of the overall market. A fact Charles Philips was eager to point out recently at Collaborate.

What factors influenced these increases, both for Oracle and the market as a whole?

According to IDC, much of Oracle’s growth was due to these reasons: the sale of options for Oracle database (i.e. RAC, Audit Vault and Database Vault), and the “unusually high early adoption rates” for the recently released Oracle 11g.

Four vendors besides Oracle dominate the market: Microsoft (who lost share this year), IBM, Teradata and Sybase. IDC attributes their overall growth to increasing competition for the midmarket segment and increased emphasis on security, data compression, and features that “offer greater flexibility and manageability in deployment.”

The IDC also predicts long-term market growth for the future. They see an increase in competition between medium-sized businesses and say that “capabilities such as Web service support, XML data support, and support for blended management of unstructured and structured data should give vendors of such capabilities a competitive advantage.”

Does Oracle deserve the top spot? Does it even matter anymore or are the database wars over?

Documenting an 11g upgrade

An upgrade to Oracle 11g (or any database upgrade for that matter) requires careful attention to planning and documentation, as Maria Anderson pointed out in her session on upgrading to 11g at Collaborate.

Maria strongly recommended keeping a document with all the contact information of people working on the upgrade, commands and stop and start times. It serves as an audit trail for compliance purposes, helps with change management and lets you easily retrace your steps if something goes wrong.

Well, Maria was kind enough to share the template she used for her 11g upgrade. You can download it here for your own use.

And, if you have any suggestions for other useful information to include or comments about how documentation helped (or saved!) your upgrade project, please share them.

Oracle’s challenges in the channel

Oracle yesterday added 33 new applications to Oracle Accelerate, its partner program, bringing the total number of available solutions to 123. Accelerate allows Oracle to work with its partners to develop applications for small and medium-sized businesses.

So how does Oracle’s partner program measure up to rival SAP?

Warren Wilson, research director at Ovum, compares similar referral programs recently launched by each company. According to Wilson, while SAP’s goal is building long-lasting relationships with its channel partners, Oracle has its eye on mainly one thing: money.

“Oracle’s lead message is the money,” he said, although he couldn’t determine which company’s method (focus on money vs. relationships) is more effective.

Technology Business Research, Inc. (TBR) said recently that it sees channel management as Oracle’s greatest challenge. They say that Oracle “intends to drive 50% of license revenue through partners; however, it still relies on its direct sales team to drive most of the revenue, and the indirect channel only contributes 44 % of new license revenue.”

Another partner-related problem they see is a shift in management, with the recent departure of several key Oracle executives managing alliances and the channel.

TBR concludes by saying that in order to reach their target of 50 % partner-generated software license revenue, “Oracle would need to shift nearly $550 million from direct sales to indirect channels to balance the contribution percentages.” TBR believes the challenge is made more difficult as Oracle attempts to restart growth in software license sales in the current difficult [financial] climate.

What do you think — will Oracle be able to change things around? Or are its partnerships fine as is? Do you think there are actually bigger (and more important) challenges?

Eating a whale sandwich — a real-life Fusion roadmap

I caught an interesting session this week at Collaborate with Floyd Teter, who’s with the Jet Propulsion Lab, a bunch of scientists in Pasadena, Calif. working for NASA.

Teter’s presentation mirrored much of what I’d heard in an earlier session Nadia Bendjedou’s “10 Things You Can Do Today to Prepare for Fusion Applications.” That presentation has apparently been making the rounds. It’s been done before with some tweaking, such as the 10 Things PeopleSoft users can do … and 10 things E-Business Suite customers… sessions we’ve covered before, yet it’s a useful one, nonetheless.

Teter’s session has one major difference, however. He’s actually a customer preparing a roadmap to Fusion applications for his business.

Well, one major difference and one minor difference. Teter’s is a much more humorous presentation (be sure to carefully read his “safe harbor statement” if you’re ever in one of his sessions). In addition to serving as systems engineer at the Jet Propulsion Laboratory, Teter is the chair of the OAUG’s Fusion Council so he’s pretty attuned to what’s happening. His roadmap is based largely on the aforementioned “10 steps” presentation. He advocates a small, incremental approach. Still, there are some differences.

First of all, there are some things that make the Jet Propulsion Lab unique. A scientific organization, it works on consensus– everyone has to agree– so projects can take a long time. Additionally, it’s not chasing customers, it’s chasing government funding that tends to go down each year, Teter said. Each business owner can make their own business process, so integration and flexibility are very important. Primarily an Oracle shop, the lab runs E-Business Suite 11.5, but “whether you’re on JD Edwards, PeopleSoft, E-Business Suite or Siebel, it doesn’t matter,” Teter said. Preparation is key.

Teter offered a few more nuggets during his session:

  • “This thing is a whale sandwich. You take this one bite at a time.”
  • On the PL/SQL developers at the lab– “All those folks have grown up in a procedural language and getting them to make the leap to object oriented is a nightmare. I’ve been at it three years now. If I’m lucky, 15% have made the leap. The other 85%? If they don’t make the leap, I’m going to have to look elsewhere.”
  • On Oracle Portal to Web Center — ” I still haven’t heard of a migration path.
    Workflow Oracle does not support the migration to BPEL.”
  • On Mod PL/SQL — “It’s gone in R12. We use Mod PL/SQL in my shop a lot.”
  • On loose coupling and its place in Fusion– “I’ve integrated two applications on two databases and I have a couple pieces of point-to-point integration. If Oracle comes out with a change to database design, as long as they’re just adding new stuff, I shouldn’t have to worry about them. It’s a lot like working with Lego bricks — I can pull out a piece here and put it in over there and my basic structure is still intact.”
  • On the first Fusion Application release– “One of the things you need to know about Fusion Applications is the first full release will not be a full replacement for E-business Suite or anything else. We already know manufacturing is not on the table for the first full Fusion release.”
  • On why he’s making the upgrade to E-Business Suite 12– “There is still a chance my business will not go to Fusion at all, they’ll stick on E-business suite until someone tells them they have to move. I think I can do that better from release12. Plus, on R12, I get the benefits of Fusion middleware.”Finally, perhaps the most useful piece of information Teter offered is a look at the documentation he’s done for the Jet Propulsion Lab’s Fusion roadmap. You can find it at his blog at http://orclville.blogspot.com/search/label/Roadmap. There’s one condition.

    “There’s a reason I share this thing,” he said. “Feedback. I’m no genius. Ask my wife. I know I’ve missed some things. If you see something that looks like a gap, tell me.”

  • CaSe SEnsITive PasSWoRds and other Oracle 11g features

    Last year, much of the attention at Collaborate focused on new features coming in database 11g.

    Now that it’s been released and digested by early adopters and beta testers, people are getting a handle on what they like. Case sensitive passwords in the database seem to be an early winner at sessions here in Denver.

    It was one thing Daniel Morgan, of the University of Washington, an Oracle ACE director and beta tester, mentioned in a session he led “11g New Features for Application DBAs and Developers.”

    “They have now changed passwords to be case sensitive and it’s about time they did,” Morgan, a member of the Puget Sound Oracle User Group, said. “One of the problems we’ve had for a long time is case sensitivity. People could put them in any way and they seemed to work.”

    It also caught the attention of Maria Anderson, of Petro Canada, who led a session on avoiding the pitfalls of an 11g upgrade (we’ll be posting an article on that session later this week).

    Real application testing has been a hot topic with 11g as well, but something Oracle is doing just fine getting the word out itself.

    “I figure Oracle sales people are really good at their job, they can talk about real application testing,” Morgan said.

    Another feature that stands out for Morgan is the flashback archive.

    “This is one of the best new features in 11g,” he said. “Flashback archive solves a problem that came with the creation of flashback.

    “Every table we’ve done in Oracle has always been a query as of system change number — a point in time. With 10g Oracle introduced flashback query so we could see as of particular time stamp.”

    For example, a DBA who forgot to run a daily report at 9 a.m. for their manager could use flashback query at 2 p.m. and set the parameters to get the 9 a.m. information.

    “With 11g, flashback archive allows you to take undo information as it’s evaporating out of undo table space and put it into an archive and track it,” Morgan said. “You can check it as far as 100 years back.”

    Phillips slams SAP, brags about databases at Collaborate ‘08

    Oracle may not be done yet.

    In his opening keynote address at Collaborate ‘08 here in Denver, Oracle president Charles Phillips outlined Oracle’s strategy to dominate the database, middleware and applications markets.

    The database market seems to be well in hand. To applause from the audience, Phillips cited recent Gartner figures that said last year was the first time Oracle had more database market share than IBM and Microsoft combined.

    “If you’re an Oracle database customer, you can rest easy,” Phillips said.

    Not that there was much chance of Oracle’s database business folding. Nonetheless the 7,000 members of Oracle’s three major user groups, the Independent Oracle User Group, the Oracle Applications User Group and Quest, still like to hear that their vendor is staying aggressive.

    Oracle needs the user groups to help keep people informed, Phillips told the audience. No small task considering there are now 6,000 products at Oracle and more companies are joining the fold every day, willingly or unwillingly, a point Phillips joked about in his address.

    “There’s a new person almost every day at Oracle because of the acquisitions,” he said. “So if you’re not a customer yet, we’ll get you sooner or later.”

    That’s what happened with BEA. Five years ago, Oracle decided to enter the middleware market, perfect timing given the emergence of the Internet and industry integration standards.

    “Now we’re over $1 billion in revenue [in middleware],” he said. “We surpassed BEA and now we get to buy them. That’s the way it works.”

    The moment also presented Phillips with an opportunity to brag about Oracle’s application integration architecture (AIA) strategy announced last year at the show. AIA provides packaged, SOA technology, built on standards-based middleware, to integrate Oracle applications. Initial packages focused on some of the most common integrations, like order to cash integrations between Siebel and Oracle E-Business Suite. More packaged integrations will be released later this year.

    An Oracle address can’t go by without a swipe at SAP — and AIA provided Phillips the perfect opportunity.

    “If we don’t have [the integration] you want, you can take the platform yourself and build it,” he said. “That includes legacy applications and the mother of all legacy applications, of course, is SAP. In the course of all these acquisitions, [companies] are finding they’re Oracle applications shops now, they’re just using SAP for general ledger.”

    Future development, Phillips said, will focus on marrying Web 2.0 features into both Oracle’s enterprise and industry-specific applications.

    “You look at off-the-shelf applications and off-the-shelf is only about a third of what you do every day,” he said. “We hadn’t been addressing these industries.”

    Finally, in the one bit of news released yesterday, Phillips announced Oracle is extending Premium Support for Oracle E-Business Suite 11.5.10 another year later than planned, to November 2010.

    “When we said we were going to end support, we heard you’re not quite ready to upgrade,” he said. “Based on the input you’re giving us we do listen, we do react.”

    Is Yahoo the next PeopleSoft?

    Last month I posted about a New York Times article in which Larry Ellison touted Oracle’s acquisition strategy. He wondered why more companies didn’t follow in his footsteps by pursuing hostile takeovers.

    Now, Microsoft has made an announcement which Ellison will surely be pleased with (according to his own professed strategies anyway). Microsoft CEO Steve Ballmer gave Jerry Yang and the Yahoo! management team this ultimatum Saturday morning: unless you agree to a deal within the next three weeks, we will go hostile and take the bid to a proxy fight.

    Analysts are now comparing Ballmer’s words to Ellison’s five years ago, when Oracle issued its hostile bid to PeopleSoft. In Market Watch analyst Therese Poletti’s article, Yahoo seems headed the way of PeopleSoft, she compares Yang’s spiteful attitude to that of PeopleSoft head Craig Conway:

    “[Such an attitude] is a dangerous position for the well-known Web pioneer. Conway lost his job when — in the heat of the merger battle — he made untruthful statements about his company’s business to analysts. Conway later admitted in a deposition that those statements were ‘absolutely not true’ and that he was ‘promoting, promoting, promoting.’

    The same could be said about Yahoo. In March, Yahoo released a presentation to investors with what many have since described as unrealistic expectations and forecasts…”

    Although Ellison’s bid for PeopleSoft was ultimately successful, this acquisition was a prolonged, two-year process, much of which took place in court and resulted in the falling of Oracle stock prices and PeopleSoft sales.

    The damage was done on both sides, but Oracle came out the victor. And Poletti thinks Oracle’s success is indicative of that of similar corporations:

    “The software giant’s track record has suggested that companies with deep pockets and resolve eventually get what they want regardless of the preferences of their adversaries.”

    What do you think– Is Yang digging himself into a deeper hole by not giving in? Is his battle simply a losing one, whose fate is bound to mirror those of companies bought out by Oracle? If you were in Yang’s position, what would you do?

    The Oracle security debate

    Oracle DBAs:  To what do you attribute problems with Oracle security?

    a.) poorly designed software
    b.) failure to apply  patches and maintain software
    c.) lack of financial resources
    d.) all of the above

    This question has recently made a small stir in the blogosphere, and not everyone can agree on an answer.

    Bex Huff, in his “technology, lifehacks, and all that good stuff” blog, says: “Unlike James McGovern, I don’t believe security problems are entirely due to bad software or clueless developers… I’d argue most security problems are due to improperly configured and improperly maintained software. However, I also believe that blaming the implementation team is a cop-out. Instead, developers need to realize that security is a process, not a product.”

    Huff goes on to highlight what he sees as the critical process of Oracle security: applying patches. He doesn’t seem to understand why fewer than 20% of Oracle customers apply their rolling security patches.

    In his blog “Enterprise Architecture: from Incite comes Insight,” James McGovern says he has the answer: Applying patches is costly. And, he says, it’s not all the fault of the user: “Can we acknowledge that the patch existed because the base software wasn’t written with security in mind in the first place?”

    In McGovern’s later blog post, “If software vendors really cared about security,” he outlines some questions for enterprise companies to ask vendors before purchasing software. For example: what features does the product have that helps ensure it’s designed securely?

    So, yes, the best and most practical answer is probably “d.” But do you see any of these factors as having more of an impact? Do you think either Huff or McGovern has a better understanding of the issue?