Your last paragraph says it all. You need this job... but the fact is, the job may or may not need you (and in most case it's a not).
The only way to survive in Oracle is to ensure that you are the best at what you doing and more importantly, what you doing is still relevant to the market. This way, even if Oracle doesn't need you anymore, someone else will.
Remember, that Oracle doesn't normally hire idiots (well, most of the time). Hence, if you are in Oracle (and even if you had been in Oracle), you aren't too bad. But if you don't believe in yourself, don't expect Oracle or anyone to believe in you.