Wednesday, December 22, 2010
Oracle Infogram This Week: EBS, Data Mining, DBA, Cloud Computing, OBIEE
EBS
The holidays are upon us, so fewer postings than usual. Even the usually prolific Oracle E-Busines Suite Technology blog has only one item for the week so far:
Is RAC One Node Certified for E-Business Suite?
Data Mining
When you are up to your elbows in really gronky legacy data that seems to have been formatted using a shredder the emphasis seems more on the 'mining' part of data mining, but as this posting points out, data mining is a science and its practitioners scientists. So put on that lab coat and try to look the part: Data Scientist over at the Systems Engineering and RDBMS blog.
DBA
There's a ring of truth about this article at DBASupport.com on some of the key skills for a DBA. These are some of the realms that tend to be complex and carry a lot of responsibility (and dare I say it, culpability): Top 5 Technologies for the Oracle DBA.
Cloud Computing
People are still trying to make up their mind about what constitutes a proper cloud, how much they are going to trust the concept with their data, etc. There's plenty of activity, that is without doubt.
Eye on Oracle has some glad tidings on availability of Oracle products on Amazon's cloud: Amazon offers more Oracle apps in the cloud.
The shift away from single hard-disk hosting of data is also something Oracle is working on judging by this item over at AppsLab: Oracle Announces Oracle Cloud Office and Oracle Open Office 3.3.
OBIEE
Rob Reynolds' BI & EPM Blog is starting a useful series on Security in OBIEE 11g: Security in OBIEE 11g, Part 1
SOA
If you look up from the holiday feasts and find you are missing the server room, here is something to play with at Xenta Consultancy: Extend Pre-Built Virtual Machine For SOA Suite With Oracle Service Bus.
That's it for this week. Merry Christmas everyone!
Wednesday, December 15, 2010
Oracle Infogram This Week: EBS, Exadata, APEX, Security, Hyperion, Siebel
EBS
The latest from the Oracle E-Busines Suite Technology blog:
Heads-Up: Preparing for E-Business Suite 12.0 Extended Support
Web Cache 10.1.2.3 Certified with EBS R12 on IBM Linux on System z
E-Business Suite Certified with DB 11.2.0.2 on HP-UX Itanium and IBM AIX on Power
Understanding EBS Support Windows, Redux
Mismanaged Session Cookie Issue Fixed for EBS in JRE 1.6.0_23
EBS 12 OA Framework Training Now Available from Oracle University
Maintaining Your EBS Environment for Maximum Performance
Running Oracle E-Business Suite on Exalogic Elastic Cloud
Exadata
Over at the Oracle Nerd we have a pointer to a video on new Exadata features: Video: Exadata Hybrid Columnar Compression.
APEX
The APEX 4.0 books are starting to come out, as Surachart Opun lets us know: Oracle APEX 4.0 Cookbook Book
Security
Just when you thought it was safe to back in the waters of the shared pool, another sneaky attack vector. The Oracle Product Security Blog lets us know about it: A New Threat To Web Applications: Connection String Parameter Pollution (CSPP).
And over at the Security Inside Out blog there's a run-down of the most typical problems. I'll guarantee that none of these will bite your company until they do. And while you're parsing that sentiment, here's the link: Steps to Mitigate Database Security Worst Practices.
Hyperion
Did you know there is a maximum number of times you can add and delete dimensions in an ASO cube? So begins the Glenn Schwartzberg's Essbase Blog posting on this topic: ASO Dimension Deletion Limit.
Siebel
Siebel Essentials is in the midst of a series of 24 tips for those new to Siebel, as well as some that even those of guru-like experience levels may find new: 24 Siebel Tips: #15 Drag'n'drop attachments.
Tuesday, December 14, 2010
Check out Note:559339.1, the Diagnostic Tools Catalog. The catalog contains links to diagnostic tools such as RDA, Health Checks, ORA-600 / ORA-7445 Troubleshooter, OSWatcher and more.
Wednesday, December 8, 2010
Oracle Infogram This Week: Exadata,, Performance, Hyperion, OBI EE, BI Publisher, Docs on Kindle, VirtualBox, Sun Support, Looking Up
Exadata
Over at BI-Quotient are a few useful links to Exadata resources: Exadata books, Exadata training, Exadata in the cloud, Exadata for Xmas.
Performance
Over at the amusingly named So Many Oracle Manuals, So Little Time blog, Iggy Fernandez opines on the differences between the theoretical flexibility to be found in the works on SQL of Fabian Pascal and Chris Date and the gnarly reality of a commercial RDBMS optimizer. Interesting reading, and the third of a series of postings: Which Query is Better?—Part III (No EXPLAIN PLAN To Rule Them All). The question of how a powerful and pricey optimizer can be so finicky about dealing with variant ways of getting data from point A to point B raises another quandary for me: Why is it my modern and incredibly fast Windows boxes load slower on startup than the 286 AT that was my first DOS machine? I'll turn my iPad on (instantly) and try to figure that out.
Speaking of performance, it's time to make plans for Hotsos 2011:
More information - http://www.hotsos.com/sym11.html
Registration - http://www.hotsos.com/sym11/sym_reg.html
Hyperion
Over at In 2 Hyperion there is a brief but informative posting on: Why Not Using the Currency Option with Hyperion Planning has Benefits.
OBI EE
The ever-useful Rittman-Mead blogs bring us this item: Oracle BI EE 11g – Managing Host Name Changes. It can be a bit harrowing, so you're well advised to look into it before diving in.
BI Publisher
Did you know there are Wednesday Open Chats on BI Publisher?
Global Customer Support is hosting weekly open chat sessions with the experts from BI Publisher Support.
Everyone is invited to join the customer sessions to ask questions directly to Support.
All chats will be open from 6 am to 12 pm Mountain Time (8am-2pm Eastern, 1pm-7pm GMT).
Ask the experts!
For more information look at note: Open Chat With BI Publisher Support (Doc ID 1220984.1) https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1220984.1
Previous Chat sessions are archived in our BI Publisher community https://communities.oracle.com/portal/server.pt/community/bi_publisher/323 where Customers can also ask Questions and get information (like under the Tips and Tricks, and White Papers folders)
Docs On Kindle
I've been a Kindle user since the first day it came out (well, the second, after overnight shipping), so I'm always happy to hear about new items making their way to the eBook realm. Oracle's Jan Greenburg let us know about availability of the Enterprise Performance Management 11.1.2 Documentation Library in Kindle (MOBI) format. This enables customers to download EPM product documentation onto their Kindle or mobile device. For each EPM product, MOBI files are available for the User and Admin guides, as well as, the set of EPM System Installation guides.
MOBI files are posted in the 11.1.2 EPM Documentation library along with PDFs and HTML files. You can access the 11.1.2 Documentation Library from this link: http://download.oracle.com/docs/cd/E17236_01/nav/portal_1.htm
Important, please note the following:
1. MOBI Viewing: Our files are in Amazon Kindle-compatible MOBI format. To use these files on your Kindle, download the zip file, extract the MOBI files, and transfer them to your Kindle by using the USB cable that came with your Kindle. After connecting the USB cable, the Kindle appears as an external drive on your computer. You can then drag or copy the MOBI files onto the Kindle drive. For more information about transferring files, see your Kindle documentation.
2. These files may work on smart phones and other mobile devices that have a Mobipocket-compatible eBook reader. However, the formatting of these files has been tested only on the Amazon Kindle (Latest Generation). You can find free eBook readers online. For file transfer instructions, see the eBook reader online help or your mobile device documentation.
VirtualBox Images
James Bayer's Blog is one of several announcing the availability of Pre-built Oracle VirtualBox Images.
Sun Support
Chris Warticki's Blog - Oracle Support reminds us of the move of Sun support to MOS: SUNsetting of legacy support apps to My Oracle Support.
Looking Up
You really need to look up from the screen(s) once in a while. Last week's posting on the biggest aquarium in the world made me want to move south to Atlanta. This timelapse of the aurora borealis makes me want to move north to Norway.
Tuesday, December 7, 2010
Many Content References (CRefs) delivered with PeopleSoft applications will expire on December 31, 2010. If this is not corrected, the menu items represented by these expired CRefs will no longer be visible. Access to the portion of the application normally available through the menu is unavailable until the issue is corrected. This issue does not cause any data loss in the system.
It is critical that you review the solutions that are available in My Oracle Support, and take corrective action prior to Dec 31, 2010. There are 3 solutions, depending on the PeopleTools version(s) you are running for your application(s):
Doc ID 1183084.1 (E-CREF: How To Reset CRef Expire Dates From 2010-12-31 For PeopleTools 8.44-8.51)
Doc ID 1183075.1 (E-CREF: How To Reset CRef Expire Dates From 2010-12-31 For PeopleTools 8.40-8.43)
Doc ID 1183065.1 (E-CREF: How To Reset CRef Expire Dates From 2010-12-31 For PeopleTools 8.11-8.22)
Wednesday, December 1, 2010
Infogram This Week: EBS, Performance, Technology, Legends, Linux, ADF, Exadata, Life
Charles Hooper has a good 'get down in the trenches' technical article on hints and why they may or may not get used. It reminds me of a key I've wanted on the PC for a long time: the 'Just do what I want!' key. It would be right next to the 'Right now, dammit!' key: I ORDERED a Hint – Why Won’t You Listen to Me?
Technology
It looks like the end for Moore's Law, but being an optimist about technology, I would say it's only a pause. There are technologies in the wings that will soon get the clock moving again. So my prediction is that Moore's Law will be back on the road in a few years. The Storage Mojo blog discusses it: Moore’s Wall: the end of Moore’s Law.
Legends
Chris Date is a legend in the realm of relational database theory, one of the leading theorists in the field and this series that Surachart Opun links to on his blog looks to be a great way to spend some virtual time with the master. SQL and Relational Theory Master Class (How to Write Accurate SQL Code) by C.J. Date
Linux
Nobody likes corruption (well, leaving politicians out of the discussion, at least), so here's some wisdom on Eliminating Silent Data Corruption in Linux over at BrightTalk.
ADF
Sale announcement over at Shay Shmeltzer's Weblog (in the spirit of the shopping season) on: Get an ADF Developer Certification - Special Price Promotion
Exadata
The Pythian blogs bring us the happy news that Exadata OEM monitoring plugins are now available.
Life, the Universe, and Everything
I love going to zoos and aquariums, and I'm kicking myself that in all the times I've been Atlanta I've never been to the huge aquarium there. There's a nice film clip at this posting on it by The Laughing Squid: Georgia Aquarium, The World’s Largest Aquarium.
Official, Youbetcha Legalese
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.