Oracle Certification Group on Linkedin Crosses Ten Thousand Members

On May 23, 2011 - Oracle Certification Group on Linkedin cross 10,000 members. The group consists of certified professionals, certification candidates and top resourcing and HR executives from all around the world. Oracle certified professionals have Oracle Expert, Specialist, Associate, Professional or Master credentials.

To countdown the journey to 10,000 members a contest was held to guess the date when the group will cross the magic figure. Four group members guessed within 1 day of the actual date and will be awarded $25 Amazon gift certificates. The winners are as follows:
  • Pratik Kange
  • Prahlad Sharma
  • Agha Jameel
  • Joan Marc Amenós (more...)

Purple Sweaters and Oracle 11g


If you're geeky enough like me, you get a little excited whenever Oracle puts out a new version. Most of us have wondered at one time or another what it would be like to be able to beta-test the new Oracle version before it comes out. You may read the pre-release articles about the new features, if nothing else to keep ahead of the technology curve. Like geeky me, you may download the new version on the same day it comes out – maybe to play with it a little or just to see how it's different. But as intrigued (more...)

Grown Kittens Need a New Home

When Oracle announced that “Oracle Identity Manager will be the strategic Identity Administration and Provisioning product moving forward" and with Oracle Waveset going into ‘sustain and converge’ mode, I was ready to offer all of my Waveset knowledge for adoption. Having delivered Sun Identity Manager projects all the way from when it was “Waveset Lighthouse” (Sun acquired Waveset in 2003), I am personally attached to everything I engineered on top of Waveset throughout the years. For the time I spent getting to know my Waveset customers, taking care of their needs and trying to build/customize the best home possible for (more...)

1Z1-058 (1Z0-058 beta) 11g R2 RAC Expert. Answers.

Last week’s article on 1Z0-058 questions was quite popular, more popular than I expected. So if you enjoyed the questions, now it’s time to get some answers! (1) Kevin is a database administrator at Fictional Real Estate Co. All he hears everyday is location, location, location. He is asked by one of the Sales team [...]

XLA/SLA AMB Components Underlying Data Structure

For anyone dealing with R12 Subledger Accounting (SLA) configuration and troubleshooting, it can be helpful to understand how the SLA Accounting Methods Builder (AMB) Components are organized within the XLA schema of the R12 database.  Here’s an Entity Relationship Diagram (ERD) I’ve put together as a tool to utilize when needing to build queries of most SLA configurations.  This doesn’t encompass every type of SLA component (e.g. it doesn’t include Business Flow data), since I focused it on just the AMB Components I deal with the most, but includes the major components.

Here’s a PDF copy of (more...)

Finally Cool: @OracleFedApps is on Twitter

If you haven’t visited the actual blog lately and are just keeping up via  a blog reader or some other type of subscription, you might have missed that I incorporated a Twitter feed a couple months back.  I admit, my tweets aren’t going to be as entertaining as @CharlieSheen and I don’t expect to have 8 million+ followers like @BarackObama, but I’m trying to share a few experiences from the R12.1.3 Federal upgrade I’m working through.  Hoping the short info may benefit others going through the same.  Tweets are a great quick, simple way to (more...)

Last Sunday

Our production databases are backed up with one of two schedules.  Most days our backups are sent offsite and retained for 3 months before being returned.  But on the last Sunday of each month, our backups are archived for a longer period of time.  Therefore the RMAN backups and Veritas catalogs need to be retained for up to 7 years!

Us Linux DBAs love cron for scheduling jobs. These fancy software schedulers with their dependencies and clever logic have never really replaced a really dense, difficult to read crontab file. And that's just the way we like (more...)

NFC Getting Momentum

The Near Field Communication (NFC) is gaining a momentum. Its usage will be propelled via mobile devices and would give a birth to many fantastic devices and applications.

Last week Apple introduced Retail 2.0 store that effectively used NFC.

To the heels of the Apple, Google took the techbology (more...)

Instrumentation packages

At CIBER we are doing a series of knowledge sessions where several colleagues are doing a one-hour presentation about one or two package of their choice. We have already heard several very interesting presentations about DBMS_HPROF, DBMS_PARALLEL_EXECUTE, UTL_DBWS, UTL_TCP and DBMS_FGA. And this evening a colleague will do a presentation about DBMS_PREPROCESSOR and DBMS_WARNING, and I will do one

Compression and SE

While researching a corrupt block on 11g SE, we came across a number of objects that were compressed according to the data dictionary. How could that be?  Compression is not a feature of SE, or so we thought. The objects in question were all indexes.  In fact, Oracle creates compressed indexes in ?/apex/core/tab.sql even though we are on SE. Further investigation lead me to Doc 1084132.1 which

Oracle Database on Amazon Cloud – Now Available


Amazon has kept its promise of making Oracle 11g available on per hour billing. Finally, after its announcement in Feb 2011, Oracle 11g database is now available on Amazon RDS. Which means you can use Oracle database on cloud with the same per hour billing rates (pay-as-you-go model) you pay for other resources.
Amazon RDS brings Oracle Standard One, Standard and Enterprise editions on RDS. It’s now the 2nd database to be available on RDS; MySQL was available for quite some time now. As I had mentioned in my earlier post, Oracle will be available under 2 difference (more...)

FREE OTN Developer Day in Poland June 15

Our FREE OTN Developer Day is going global.
We are going to be in Poland on June 15.
Go here to see the event overview and register.

This is a BYOL (Bring Your Own Laptop) event so that you can keep everything you work on.
These days concentrate on hands-on labs and using the various tools rather than just sitting through presentations.

Hope to see you there!

2012 starts next week!

Uncategorized
| May 24, 2011
Some retailers always rush things a bit by starting to sell Christmas items in September. In a similar way, Oracle likes to jump the gun by starting its Fiscal Year 2012 on June 1. This unusual schedule impacts the way Oracle interacts with its customers in a number of important ways. First, all energy in [...]

1Z1-058 (1Z0-058 beta) 11g R2 RAC Administration Expert

If you get emails from Oracle University, you might have received a notification that 1Z1-058 (1Z0-058 beta) “Oracle 11g R2 RAC Administration” exam is now available. It earns you an 11g R2 RAC Oracle Certified Expert (OCE), but you need to be an 11g DBA Oracle Certified Professional (OCP) first to get that. If you [...]

Java Debug Problem “Source not found.”

Uncategorized
| May 22, 2011

Quick Hint:
When you try to debug java code in eclipse, if you get “Source not found.” error with red letters. Here is the solution:
Down Arrow Icon Next to Debug Icon > Debug Configurations > Classpath Tab > Add Projects to User Entries
Add your project that cannot debug to this location.


Cold Backup RMAN Fun and Games

Here's an RMAN oddity.  If anyone could explain it, I'd be grateful.

We were moving a database to a new server.  Same OS, same version of Oracle (10.2.0.4).  The database is in Archivelog mode, but to keep things easy, we decided to do an offline, consistent backup.

So, we shutdown the database, then mounted it and performed an RMAN backup to a flash_recovery_area on a shared NFS filesystem:

backup device type disk database plus archivelog include current controlfile;
The backup worked fine. So we logged on to the new server, made sure that we could (more...)

Oracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms

The E-Business Suite Technology Group recently released a whitepaper: Extending E-Business Suite 12.1.3 using Oracle Application Express. In summary, "This new whitepaper outlines how to extend Oracle E-Business Suite 12.1.3 (and higher) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail." For some time now EBS customers have used APEX to extend EBS, with the release of this whitepaper the EBS Tech group has acknowledged it's growing (more...)

IMPDP Stuck with wait event – "wait for unread message on broadcast channel"

I was trying to run data import using impdp and the job was stuck with wait event "wait for unread message on broadcast channel".
This is an idle wait event as per oracle, that means oracle is waiting for something to happen for the session to proceed.

I googled and checked metalink but couldn't really find a solution and my job was stuck indefinitely.
From one of the forums online I figured out an old (more...)

eBS 12.2 : summer sleep

We went throught the updated RCD docs today on metalink and very little has been added for HCM. Succession planning got some extra features.For Payroll, they only announced that Enhanced Retropay will be the only supported flavor of Retropay. So when you upgrade to 12.2, and your localisation is not yet on Enhanced Retropay, you have to pay attention.

NoCOUG Journal – Ask the Oracle ACEs – Why is my database slow?

Dave Abercrombie mailed me earlier that the May 2011 NoCOUG Journal is already out and can be viewed online at http://www.nocoug.org/Journal/NoCOUG_Journal_201105.pdf.

I met Dave at Hotsos 2011 when he attended my presentation.. apparently we have the same interest about Statistics, Linear Regression, AWR, AAS and he’s got awesome blogs about it at http://aberdave.blogspot.com. Also being the Journal Editor at Northern California Oracle Users’s Group, he invited me to write a short article about the question:

Why is my database slow?

The NoCOUG Journal having a very wide readership with the last issue being downloaded around 6000 times from (more...)