Mastering the Oracle Stack, One Post at a Time.
Here is a PL/SQL script to validate the database links accessible to an user. I wrote this to identify the working links after a database refresh or to verify links that connect from non-prod to prod… Hope it helps… REM Validate Database Links REM Private links under connected user and Public links REM REM … Read more
A friend of mine was working to apply the July 2013 PSU, and had to rollback two one off patch conflicts. Since the instance was cloned from production, OPatch was failing with this error… $ $ORACLE_HOME/OPatch/opatch rollback -id 12834800 The patch should be applied/rolled back in ‘-all_nodes’ mode only. Converting the RAC mode to ‘-all_nodes’ … Read more