Monitoring Oracle I wrote these Solaris Unix scripts for a book project about 10 years ago. They are dated but I have used them myself recently to construct useful monitoring scripting in Linux. Display active dedicated connections as shown below. Execute the command below excluding |wc -l to view connected dedicated server processes. ps -ef …
Monthly Archives: September 2015
Monitoring Oracle Standby with Solaris Scripting
Validating Archives Between Production and Standby Databases I wrote these Solaris Unix scripts for a book project about 10 years ago. They are dated but I have used them myself recently to construct useful monitoring scripting in Linux. On the Production Database #!/bin/ksh ORACLE_HOME=/<mount-point>/oracle/product/8.1.7 LD_LIBRARY_PATH=/<mount-point>/oracle/product/8.1.7/lib:/usr/ucblib:/usr/openwin/lib JAVA_HOME=/<mount-point>/oracle/product/jre/1.1.8 ORACLE_SID=<SID> ORACLE_SBIN=/<mount-point>/oracle/product/8.1.7/sbin ORACLE_ALERT=/<mount-point>/oracle/admin/sudbp/bdump PATH=/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/openwin/bin:/usr/ucb:/usr/local/bin:/usr/sbin:/usr/X/bin:$JAVA_HOME PATH=${PATH}:$ORACLE_HOME/bin:$ORACLE_HOME/sbin host=`hostname` if [ -z …
Continue reading “Monitoring Oracle Standby with Solaris Scripting”