When recompiling entire schemas, for instance, after an import, occasionally you might end up in a situation where compiling some packages would de-compile others.
In this case, If your are not using a state of art tool or if your are doing this work from the golf course(!) and you only have access to sql plus, one way to do it is just compiling the package bodyes. This way it will not cause any de-compilations of the dependent objects.
For instance, issue a statement like… Continue
Added by Filipe Martins on January 30, 2009 at 4:00am —
When installing Grid Control agents on a Linux or Unix platform, a recommended practice is to install as a user that doesn’t own the ORACLE_HOMEs to be monitored. This poses a challenge when configuring monitoring for some targets, particularly those based on Oracle Application Server 10g. This post
lists some changes you can make to work around a variety of target discovery and metric collection errors.
Added by John Piwowar on January 26, 2009 at 1:38pm —
Wow! A record number of people got certified as Oracle 10g OCA these past few months!
–– Some OCP encouragement
Added by Harold Green on January 23, 2009 at 12:49pm —
We are opening the call for papers for the first CLOUG (Chilean Oracle Users Group) National Conference at Santiago, Chile.
Topics we are particularly interested in hearing , but not limited to:
- Developer; Forms, JDeveloper, J2EE, JSF, XML, Web Services, APEX, BPEL, SOA, Hubs, .Net, and Fusion Middleware
- App’s; all incl GL, AR, AP, HR, Payroll, CRM,
- Higher Education
Added by Francisco Munoz Alvarez on January 23, 2009 at 2:38am —
The new Oracle EBS R12: Install, Patch and Maintain Applications exam (1Z0-238) just went live! New update on the Oracle Certification Blog: http://bit.ly/2Aqkce
Added by Harold Green on January 21, 2009 at 11:48am —
When upgrading your Oracle application certification, you have two things that are working in your favor: http://bit.ly/6BRv
Added by Harold Green on January 15, 2009 at 9:24am —
I have started my own blog at http://dbatrain.wordpress.com/ to discuss DBA training, DBA certification and other issues of interest to Modern Oracle DBAs. I will also post my articles and presentations on the site.
I hope you find it useful.
Added by Joel Goodman on January 15, 2009 at 3:04am —
If you haven't done it yet, be sure and opt-in for Oracle Certification communications so you can get the E-Magazine.
Added by Harold Green on January 14, 2009 at 8:51am —
Harald van Breederode, co-author of the DBA 2.0 booklet published last year has started a blog which will be of interest to Oracle DBAs, Unix Administrators and Storage Administrators. You will find his blog at http://prutser.wordpress.com/
Added by Joel Goodman on January 14, 2009 at 2:00am —
I've just finished my most successful opensocial
application ever. With Friends Interaction
you can let you visitor sync their friends with yours and improve the visibility of your own profile.
hides friends you and your visitor have in common and only shows those that your visitors don't know yet increasing their interest in visiting frequently your own profile.…
Added by Filipe Martins on January 13, 2009 at 9:00am —
Certification Magazine's Deanna Hartley met with us last week to discuss some questions and issues as a result of our recent blog series on certification and cheating. Read "Preventing Cheating on Certification Exams"
Added by Harold Green on January 12, 2009 at 12:27pm —
Virtualization - Oracle’s catch-up
Once upon a time :-), almost 4-5 years back, the customer’s thought process behind cost reduction was off shoring, process and operations improvement. Since the time is changing which changes the thought process, hence increases customer demands. Today’s customer thought behind cost reduction is no more limited towards old jargons but has also got expanded into technology transformation. And when we talk about technology transformation… Continue
Added by Sumit Singh Chadha on January 12, 2009 at 3:26am —
The purpose of this article is to outline the steps for Re-Synchronize/Refresh a single table if it is out of sync with source site in one-way replication between two ORACLE databases in Streams environment.
Steps for Refreshing a Table in Streams:
If one of the tables on the Target site is out of Sync with Source site then follow below steps to re-synchronize both:
1. Stop Capture Process on Source(S)
Added by @Ravi on January 11, 2009 at 5:30am —
Let start this New Year with a new mentality or a new resolution if you prefer call this way, let stop being reactive and start being proactive. Being proactive will reduce your database administration costs and increase your level of efficiency, and best of all, save your hours of sleep when you are on call.
Why check the problems only when they are critical, or when is too late and the database is down, or the users are screaming?
Being proactive… Continue
Added by Francisco Munoz Alvarez on January 10, 2009 at 11:30pm —
All-new/fresh look at Prometric!
Read more about it on the Oracle Certification Blog: http://bit.ly/rZ9s
Added by Harold Green on January 9, 2009 at 1:55pm —
Oracle Certfied Professionals Blog
features Ben Prusinski this week.
Read this interesting weekly feature at http://tinyurl.com/6tyuxe
Added by OCP Advisor on January 9, 2009 at 9:00am —
The unsettling news of the global economy is unwelcome to IT professionals looking to improve their careers.
Read the latest post from the Oracle Certification Blog: "Certain Measures for Uncertain Times."
Added by Harold Green on January 7, 2009 at 10:20am —
Just making a reference here to my Oracle Lite Blog
Added by Greg Rekounas on January 6, 2009 at 6:23am —
This is Sujana from iRUS Infotech!!!
We have excellent openings for Oracle DBA's for an experience level of 3 - 7yrs in Hyderabad with a CMM Level5 fortune50 company..
Should have performed all DBA Activities.
Should have worked on Solaris environment and in production support.
Willing to work only in night shifts.
Interested candidates can mail me your resume to firstname.lastname@example.org for further process… Continue
Added by Sujana on January 5, 2009 at 9:28pm —
This is Sujana from iRUS Infotech!!!
We have excellent openings for Oracle DBA's with a relevant experience of 4yrs in Hyderabad with a CMM Level5 fortune50 company..
The candidate should have hands on experience in using RAC, RMAN, Dataguard, Upgradation and all the regular DBA activities.
Interested candidates can mail me your resume to email@example.com for further process.
Thanks and Regards,
Added by Sujana on January 5, 2009 at 9:22pm —