VBScript

Vbsript to execute a Oracle PL/SQL Procedure

Rem Name of the PROCEDURE Dim strProc : strProc =”POPULATE_EMP_DATA” Rem Name of the DB SCHEMA Dim strSchema : strSchema = “bhive_report” ‘########## TARGET DB DSN Dim TargetDSN : TargetDSN = “devDSN” Dim TargetDBuser : TargetDBuser = “devUSER” Dim TargetDBpwd : TargetDBpwd = “devPASS” Call runPROC(TargetDSN,TargetDBuser,TargetDBpwd,strProc,strSchema) Rem Sub Routine to Execute Stored Procedure Rem Generic… Continue reading Vbsript to execute a Oracle PL/SQL Procedure

Bash Shell Script

Check Size of a File in BASH Script – alert.log oracle help

Size of a File in a directory location can be checked using a small shell script. #!/bin/bash str_LogName = “/u01/SAQIB/MyFile” int_fileSIZE=$(du -b $str_LogName | awk ‘{ print $1 }’) echo $str_LogName However, if we want to see if the size is greater than a particular amount say 3MB, we will use the following script. #!/bin/bash… Continue reading Check Size of a File in BASH Script – alert.log oracle help

Bash Shell Script

Ping a Server for Status in BASH Script [Linux]

#!/bin/bash ################################################################ # AUTHOR: Saqib Mujtaba # SCRIPT: Ping servers status in a network # DATED : 07/02/2014 # TYPE : BASH Shell Script ################################################################ array_serverIP=”192.168.01.1 10.0.0.01″ #PINGS FOR COMPUTER STATUS for ip in $array_serverIP ; do ( ping $ip -c2 &> /dev/null ; if [ $? -eq 0 ]; then echo “$ip is Up”… Continue reading Ping a Server for Status in BASH Script [Linux]

Bash Shell Script

Bash Script to Ping Servers and Checks Services Status

#!/bin/bash ######################################################################## #Script to ping servers and Checks Services [oracle,pmon,smon,tns] for Status # ####################################################################### #List of IP addresses array_serverIP=”10.0.0.1 192.168.0.1″ array_SERVICES=”oracle pmon smon tns” for ip in $array_serverIP ; do ( ping $ip -c2 &> /dev/null ; if [ $? -eq 0 ]; then echo “$ip is Up” else echo “$ip is Down” fi )&… Continue reading Bash Script to Ping Servers and Checks Services Status

Toturials

What Is Active Directory? An understanding with VB Script.

Active Directory is a special-purpose database — it is not a registry replacement. The directory is designed to handle a large number of read and search operations and a significantly smaller number of changes and updates. Active Directory data is hierarchical, replicated, and extensible. Because it is replicated, you do not want to store dynamic… Continue reading What Is Active Directory? An understanding with VB Script.