Recently, a colleague of mine had some problems with pinning application procedures into the shared pool. His database was upgraded to RAC and he wanted to pin the application procedures and packages into shared pool upon the database startup.
The non-RAC version of the database was using a shell script, something like $ORACLE_HOME/local/scripts/pin_procs.sh in the script that was starting DB when the system was booted
Introduction to logarithms; yet another x86 reverse engineering exercise
We are in the process of setting up golden gate in our DB env(for reporting) and with it comes a necessity for a DR solution.
I would appreciate your feedback and any other ideas for my setup below.
Primary Site DR Site
Primary Database 1 dataguard standby database 1
In my last post, I had presumed there is a bug since I discovered an empty clusterware alert log in its conventional location i.e. $ORACLE_HOME/log/in 22.214.171.124 standard cluster.
Now she ventures into the world of blogging. She'll no doubt talk about Oracle development in some form, either SQL, PL/SQL, APEX, or for some bizarre reason, JDeveloper.
But who knows where blogging leads, huh? Check her out at
This year we had another edition of the incredible event GUOB Tech Day, which took place in São Paulo on August 8. The event featured more than 10 speakers adding new ideas and knowledge to the entire audience. I had the honor to speak personally with some of them. They include: Alex Zaballa. Oracle Ace …
Continue reading »
I tried to run a utlrp in an Oracle 126.96.36.199.0 database and saw the errors below: