Learn how to use native Linux services to manage Observers in Data Guard Fast-Start Failover configurations, and build more durable, reliable, and simple solutions than scripting alone!
All tagged scripts
Learn how to use native Linux services to manage Observers in Data Guard Fast-Start Failover configurations, and build more durable, reliable, and simple solutions than scripting alone!
Finding missing archive logs when gaps are many and random is a tedious exercise. Learn how to use awk to find and generate restore scripts for the missing files! My contribution for #JoelKallmanDay!
Adding certificates to a wallet for SSL/TLS access can be tedious and time consuming, particularly when multiple sites are involved. The answer? Automate it!
Oracle enforces complexity rules for passwords when creating databases. How do you generate random passwords while guaranteeing the rules are met, particularly when automating database creation?
How do you report on all your SIDs, or automate processes to run against everything that’s installed (or just running) on a database server? bash scripting, of course! Here are some scripts I use to generate a variety of output for LInux and Solaris systems.
In RAC, services can be “pinned” to specific, preferred, nodes. This allows DBAs to control activity on individual nodes and even force different types of activity to run on a particular node. How can you tell when they’ve been relocated and need attention? This script will help!