Linux Oracle Database Connection Test Script

Database connection testing scripts are out there, but not all of them provide a one stop way to test more than 1 node of the RAC at the same time.  Sure you can do simple tests using “tnsping”, “nc -z” or even “telnet” to confirm the listener is up.  Actually testing a login is a […]

Quick Server Health Check On Login Using Bash Profile

I strive in being a proactive sysadmin/dba/app admin so I use a few methods to provide me critical data. For this post I’m going to cover the use of the .bash_profile and show how we can combine some commands to provide visual output so we can assess the server health each time you login. I […]

Linux Bash Script That Continues After Server Reboot

Today I would like to show you something that others have asked me alot about recently and that is the ability to run either or series of bash scripts or one bash script with multiple functions after a system has been rebooted. You might be wondering “Why would I want to do this?” A great […]

Creating multple database users with bash script (read from file)

I was just asked to create a large number of users in a database.  All of them with same default password and basic connect privileges. Rather than doing this hundreds of times I wrote a simple bash script to do it all for me. Here is the code:********************************************************* #!/bin/bash/ ######################################### Created by Michael Wilson# Created […]