Programming :: Checking Database It Running Or Not By Using Shell Script?
Jul 21, 2011
1. i need to check whether the oracle database is running or not if it is running it will run auto mount script.nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt&nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &2. For every 1 hour i need to check above mount points is mounted or not if it is not mounted it should be mounted.
View 3 Replies
ADVERTISEMENT
Mar 28, 2009
I need to check whether a shell script variable contains non-zero numeric data to proceed. The variable should contain numeric values, but may in fact contain zeroes, blank space or nothing. So far, I have tried various combinations of:
Code:
if test $variable
then
if test $variable -gt 0
then
echo "good data exists"
else "no good data exists"
fi
fi
It partially works, but I get either "too many arguments" or "integer expression expected".
View 2 Replies
View Related
Jul 22, 2010
i want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.
View 2 Replies
View Related
Jun 2, 2009
want to write a shell script to copy database archivelog files sequential from one directory to another directory within a server. I am hereby enclosing the sample archivelog file name. Archive log filename : log_0000118432_1.arc (Here number 0000118432 will be sequentially incremented by 1 for next filename). Here the catch is all Archivelogs must be copied to destination directory. Previously copied files should not be copied.
View 3 Replies
View Related
Feb 8, 2010
How can I make shell script to use sqlplus to update some database table? This is what I'd like to make:
- login to db server (I have create ssh-keygen to bypass the login session)
- login sqlplus / as sysdba
- update status set status='END' where status='BEGIN';
- commit;
- quit;
I'm using oracle 10g database and SLES 9.0
View 3 Replies
View Related
May 12, 2011
i get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
View 1 Replies
View Related
Jul 8, 2011
I am using Shell Script to run my Java program. I have written a Cron job to invoke Shell Script every day at 7pm. Cron job is running every day at 7pm ,but it is not invoking my shellscript and also I am not getting any error message. I am able to run same shell script from cmd propmt using bash, and also I am able to invoke the same script from mainframes Universal command job. Same ShellScript and Same cronjob is working fine in my Dev server. But in my QA server it is not working.
View 7 Replies
View Related
Jul 23, 2010
I could run this code in PHP.
PHP Code:
[Code]....
But there is problem here. I have to close and open Internet Explorer to see my changes effect on iptables! Is there a way that I don't have to restart the IE?
View 3 Replies
View Related
Feb 20, 2011
I am facing problem of trying to access parameters to be given to shell script within a java prg.
I have following code to run the process within java but the parameter is not recognized within $ or without it also.
Code:
View 13 Replies
View Related
May 19, 2010
I want to start servers which are running on my pc with one shell script.
what I wrote is.
#!bin/sh
cd /home/HUNT/server1
gnome-terminal
sh script/server start_with_output
[Code].....
Result I got is:
A new terminal opened with current directory as /home/HUNT/server1 and server started running.
What I didn't get: second terminal and second server were not running.
View 6 Replies
View Related
Jul 14, 2011
Running a program with arguments using a shell script
View 1 Replies
View Related
Jan 10, 2011
I want to run gallist pkge from iraf for several times.. The step for running that
is:>xgterm &
>ecl &
ecl>noao
noao>artdata
artdata>epar gallist (I set some parameter) then by writing gallist iraf terminal the pkge is run:
artdata>gallist
I want this pkge is run for 1000 time and all output result are collected in only one file.
View 1 Replies
View Related
Jan 5, 2011
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies
View Related
May 29, 2011
I have created a shell script to customise mv command, now i have achieved to accomplish all the functionality of mv by using alias. But i found difficulty in accomplish the funcionality with options [Like mv -i or mv -f etc.]. I thought about logic which check the first argument whether its starting with a minus [-] or not. if its starting with argument it will set a flag and execute accordingly. But whenever this condition is checked it shell script will throw error of destination operand missing. But the same will work with out option.
Note: I have used an minus[-] expression for decreasing a counter on the script above. The below mentioned is the portion of script. Sry for troubling Im not gud @scripting.
for i in $*
do
{
argument=`expr $argument - 1`
if [ $argument = 0 ];
then
exit
[Code]....
View 5 Replies
View Related
Feb 12, 2010
i have just started working on LINUX. how to check if there are some bad scripts running on the server.
View 3 Replies
View Related
Sep 10, 2010
While executing df command on an AIX Console, by mistake I ended the line with an ampersand:
[Code]...
View 5 Replies
View Related
Jun 4, 2010
I need a shell script to back up and restore a postgresql database.
View 1 Replies
View Related
Jul 22, 2011
I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies
View Related
Oct 12, 2010
I have been running 10.4 with no problems for some time now. Today when I booted up it started checking the drive for errors, and I just left it to do its thing. I came back to this warning screen: Ubuntu is running in low-graphics mode.Your screen, graphics card, and input device settings could not be detected correctly.
I've tried all of these with no luck. When I select to run to low graphics mode, it says "Stand by one minute while the display restarts...OK".I select OK and then it gets stuck checking for battery state.I try to reconfigure the graphics, and nothing happens when I select any of the options on the next screen.
View 9 Replies
View Related
Jun 19, 2010
i want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies
View Related
May 10, 2011
I searched and found several solution but those are distro specific. I need to find out if distro is running in live mode (from CD, USB) instead it's installed on hdisk. The solution should be independent of distribution.
View 7 Replies
View Related
Jul 25, 2011
how do I create a shell script that looks for connections running on a oracle database. e.g connection name is CONNECT and database name is DBTEST. I want to know what processes with the name CONNECT are running in database called DBTEST. Am creating the script on the server side. I know about the ps -ef | grep command but how to point to a particular database I don't know.
View 4 Replies
View Related
Jun 5, 2011
I am trying to create a shell script similar to ls, but which only lists directories. I have the first half working (no argument version), but trying to make it accept an argument, I am failing. My logic is sound I think, but I'm missing something on the syntax.
Code:
if [ $# -eq 0 ] ; then
d=`pwd`
for i in * ; do
if test -d $d/$i ; then
echo "$i:"
code....
View 10 Replies
View Related
Jun 25, 2010
Is there some type of functional way to read things in the Python shell interpreter similar to less or more in the bash (and other) command line shells?
Example:
Code:
>>> import subprocess
>>> help(subprocess)
...
[pages of stuff to read]
...
I'm hoping so as I hate scrolling and love how less works with simple keystrokes for page-up/page-down/searching etc.
View 4 Replies
View Related
Jan 25, 2010
Code:
I am trying to do a search to check if the input is using alphabets and nothing else.
I tried using [[:digit:]] and [[:alpha:]] but none seems to work
When i use digit, it read 22.k as alphabet and not as a wrong syntax.
For alpha , it does not allow me to input data which has spaces such as " hello world".
View 1 Replies
View Related
Dec 17, 2010
@work we use Zabbix and also IP-audit for monitoring. Each day we have a list of outgoing SMTP-servers on our IPaudit server.
This script will take that list and check them all against a whole bunch of DNSBL's
# cat /usr/local/sbin/check_rbl
Code:
#!/bin/bash
#####################################################
# check_rbl
#####################################################
# 17-12-2010 by JP van Melis
#
[Code].....
View 15 Replies
View Related
May 12, 2011
I get some trouble setting up good environment in linux.. i have problem regarding connecting php(under linux) to a sybase server(under windows),,, is there anyway connecting this two technologies?..
View 7 Replies
View Related
Jan 18, 2010
what i am trying to do is to allow the user to key in data such as "23.23" or "24" , as it is the price of certain objectsHow am i able to design a check which will allow me to prevent users from typing in input such as "ab.21" or "rfrr" as this field is purely a numerical field. The problem i am facing is i tried using this search code.
Code:
echo "read this"
read this
[code]....
View 14 Replies
View Related
Sep 18, 2010
I am trying to figure out how i would go about finding out where system call is made and error checking is not done. I have code below, if somebody can point me in the right direction where system call is made but error checking is not done.Quote:
#include "shell.h"
#include <stdio.h>
#include <string.h>
[code]....
View 5 Replies
View Related
Nov 8, 2010
I need to allocate a % of the total system memory for a buffer but what is the best method to determine how much memory is in the system? So far the only way I have found is to get the pages of memory:
Code:
long sysconf(_SC_PHYS_PAGES)
Is that the only option?
View 2 Replies
View Related
