Shell Script to Run SQLPLUS against all databases running on a server...
#!/usr/bin/bash #--------------------------------------------------------------------------- # Written by : David Mann @ http://ba6.us # Script Name : alldatafiles.sh # Description : Provides list of all datafiles for each running database on # on a machine #--------------------------------------------------------------------------- ORATAB=/etc/oratab echo "INSTANCE_NAME, FILE_NAME" # Step through running instances ps -ef |…
