11-08-2006
database status script
Hi all,
take two files.
one file contains with total database list
second file contains with current running database list.(i will show the command in script)
#!/bin/bash
ps -ef |grep pmon |awk '{ print $8 $9 }'|cut -b10-|sed 's/mon_//' >/export/home/kmidatad/rundbs.txt
echo "RUNNING"
echo "================="
cat rundbs.txt
echo "================="
echo "TOTAL DATABASES ARE"
cat rundbs.txt|wc -l
echo "================="
echo "NOT RUNNING"
echo "================="
alldbsvar=`cat alldbs.txt`
rundbsvar=`cat rundbs.txt`
for i in $alldbsvar
do
a=0
for j in $rundbsvar
do
if [ $i = $j ]
then
a=1
# echo "aaa"
break
fi
done
if [ $a -eq 0 ]
then
echo $i
fi
done
echo "===================="
echo "process is completed"
echo "===================="
--------------------------------------
above example 1. alldbs.txt is the total database file
2. rundbs.txt is the current running database file.
thanks
Krishna murthy
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have activated mysql, and apache on my redhat 9 box, i went to mr BASH and wrote a php script, and it wouldn't execute.
any help?????????????????????????????????????
is there something that i need to activate???????
i have RUBY on there too,does it matter or no???
... (2 Replies)
Discussion started by: mbabeli
2 Replies
2. UNIX for Advanced & Expert Users
hi all
by using gethostbyname, i can know whether the net is available or not.
it is working fine when i activate or deactivate in neat.
the problem is when i remove cable(netcable) it is not working proparly,
i would like to know it.
am using fedora5, AMD
can u please help me .
thank... (3 Replies)
Discussion started by: munna_dude
3 Replies
3. SCO
Hi,
in our business we have a formerly (few years ago) installed computer with an openserver SCO 5.05
there are 3 network cards in it. one on board and two 3Com-cards
Looking with ifconfig (or scoadmin) they seemed to be installed correctly.
IP-Adress, netmask broadcas looks OK.
But no... (3 Replies)
Discussion started by: klex
3 Replies
4. Shell Programming and Scripting
Now i'm up to making a script from which you could activate all Linux services without being an expert. It's gonna be a powerful tool, I'll look forward to make it able to change the port which the service is assigned to. But I need some help, post some script to activate services and I'll fusion... (8 Replies)
Discussion started by: Dax01
8 Replies
5. AIX
hi Guys,
I just wondering if someone has gone through this process before. We are about to migrate all our current LPARS from a Power6 server to a new Power7 server. The only concern we have is that we are runing a few DB2 V8 databases on AIX 5.3 and basically DB2 v8 is been out of support for... (2 Replies)
Discussion started by: arizah
2 Replies
6. Shell Programming and Scripting
Hi,
I have written a function which will blink a text "Scanning...". Now in the main script when I am doing the scan in the server I want to call this function so that user will see a blinking text on the screen and at the same time script will proceed will the scan function. Once scan is... (2 Replies)
Discussion started by: suhasingale
2 Replies
7. Shell Programming and Scripting
I need to create a script to list all the databases that are in cluster environment.
The reason is that there are databases which are not in under cluster control and we need to identify those.
The easiest way to identify is:
clrt list (if SUNW.oracle_server:6, SUNW.oracle_listener:5 are not... (0 Replies)
Discussion started by: misterx12345
0 Replies
8. Shell Programming and Scripting
Hi Friends,
I was successfully able to login passwordlessly to server 1.1.1.2 from server 1.1.1.1 by following the below steps. I had already generated the keys using (ssh-keygen -t rsa) once and i am assuming i do not have to do that again.
ssh id@1.1.1.2 mkdir -p .ssh
cat... (8 Replies)
Discussion started by: srkmish
8 Replies
9. Shell Programming and Scripting
Hi Team,
I am Oracle Databse developer. I am currently working on two databases.
DB1 and DB2.
in DB1 I have a Select query which will return 100 records.
In Db2 I have a Select query which also return 100 records.
In these two tables ( in different Schemas) we have a common column.
... (2 Replies)
Discussion started by: vasuvv
2 Replies
LEARN ABOUT DEBIAN
radeapclient
RADEAPCLIENT(1) FreeRADIUS Daemon RADEAPCLIENT(1)
NAME
radeapclient - send EAP packets to a RADIUS server, calculate responses
SYNOPSIS
radeapclient [-c count] [-d raddb_directory] [-f file] [-h] [-i source_ip] [-q] [-s] [-r retries] [-S file] [-t timeout] [-v] [-x] server
{acct|auth} secret
DESCRIPTION
radeapclient is a radius client program. It can send arbitrary radius packets to a radius server, then shows the reply. Radeapclient dif-
fers from radclient in that if there is an EAP-MD5 challenge, then it will be responded to.
radeapclient is otherwise identical to radclient.
The EAP-Identity attribute, if present is used to construct an EAP Identity message.
The EAP-MD5-Password attribute, if present is used to respond to an MD5 challenge.
No other EAP types are currently supported.
OPTIONS
-c count
Send each packet count times.
-d raddb
Set dictionary directory.
-f file
Read packets from file, not stdin.
-r retries
If timeout, retry sending the packet retries times.
-t timeout
Wait timeout seconds before retrying (may be a floating point number).
-h Print usage help information.
-i id Set request id to 'id'. Values may be 0..255
-S file
Read secret from file, not command line.
-q Quiet, do not print anything out.
-s Print out summary information of auth results.
-v Show program version information.
-x Enable debugging mode.
EXAMPLE
A sample session that queries the remote server with an EAP-MD5 challenge.
( echo 'User-Name = "bob"';
echo 'EAP-MD5-Password = "hello"';
echo 'NAS-IP-Address = marajade.sandelman.ottawa.on.c';
echo 'EAP-Code = Response';
echo 'EAP-Id = 210';
echo 'EAP-Type-Identity = "bob";
echo 'Message-Authenticator = 0x00';
echo 'NAS-Port = 0' ) >req.txt
radeapclient -x localhost auth testing123 <req.txt
SEE ALSO
radclient(1)
AUTHOR
Michael Richardson, <mcr@sandelman.ottawa.on.ca>
08 September 2003 RADEAPCLIENT(1)