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
How i will use sqlplus in shell script? Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
I'm working on a script to table the outputs of various commands that depend on each other. The commands are these:
Code:
[root@kybsdc2 ~]# raw -q /dev/raw/raw1
[root@kybsdc2 ~]# sginfo -a /dev/dm-5 | grep Serial
[root@kybsdc2 ~]# multipath -ll
which give these outputs:
Code:
#/dev/raw/raw1:bound to major 253, minor 5
#Serial Number 'P3e8hZWrsSeX'
#netapp (360a9800050336538685a577273536558) dm-5 NETAPP,LUN
[size=1.0G][features=1 queue_if_no_path][hwhandler=0][rw]
[code]....
Also the RAW13 device has completely wrong output due to 1 occurring more times throughout the sequence causing more information to be displayed then needed. The last point is if I could somehow remove the '' in the serial number outputs and the = sign from the device sizes. I guess I will have to either put a whole lot of logical IF or CASE statements in but somehow I need to streamline and make this code dynamic!
I'm using MYTHTV with AT&T's U-Verse system. AT&T apparently turns off the set-top box if the box doesn't receive any commands after some number of hours. When this happens the box takes so long to turn on that it doesn't process the lirc IR channel change command. I've rewritten my channel changer to add a lockfile, and added a cron entry to kick off an entry to just "ping" the set-top box once an hour. But, OK, I'd like to play the bandwidth saving game and not do this if there isn't anything in the "record" table.
So, how would I write a script that will check the number of rows in the "record" table in the "mythconverg" database and exit if there are zero rows? I'm afraid I don't know how to even start this. Here is my "keepalive.sh" script that does the pinging:
Code:
#!/bin/sh
#if there are no rows in the record table, just exit this script
# lock the lockfile - MUST be same one as channel lock
while [ `lockfile "/tmp/mythchanlock.lck"` ]
[Code]....
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 View Relatedi 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 Relatedwant 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 Relatedi have the following script which when run from the linux sercer does not give me the sqlplus prompt. it does the su and leaves it there insted of continuing. The target is to run the script and it shd su and login to sqlplus
<#!/bin/sh
su -l oracle
export ORACLE_SID=MYDB
sqlplus user/password
#>
~
I want to gave much details as possible. working directory (~/a1/shell) in the shell directory i have Makefile. also in the shell directory i have subdirectory's (obj, src, include)
My current Makefile
Quote:
#What needs to be built to make all files and dependencies
clean:
# End of Makefile
I wanted it so: all .o files are created in the obj subdirectory, and my application, sshell, is created in the shell directory.
I am getting this error when i run the make run: No rule to make target 'shell.h', needed by 'shutil.o'. stop
Provided this example code with a few givens:
- a database connection has already been made and proven to work
- the variables $newname, $newnumber and $oldnumber have a value; $newname is type varchar(25), the other two are integer).
PHP Code:
$params=array($newname,$newnumber,$oldnumber);$new_result=pg_query_params($db,"UPDATE mytable SET name=$1, number=$2 WHERE number=$3",$params);$new_number_rows=pg_affected_rows($new_result);
I get an error, and when looking on the database end I the query with the $1 $2 and $3 instead of assigned values; pg_last_error() shows: Quote: ERROR: syntax error at or near "WHERE" LINE 1: WHERE number=$3 ^
Since the given name may contain quotes, or someone may try sql injection, I wanted to use this safe(r) function;
I'd like to use a perl script to update a fields in mysql database when pianobar (command line pandora radio player) starts a new song. Pianobar has the ability to run a script based on events, I'd like to take advantage of and use perl toparse the artist,song,album and update the corresponding fields. Then later retrieve them and display them with php/html. I am by no means proficient with perl. I started to use bash, but it looks like perl will be much more efficient and and less time consuming.
Code:
#! /usr/bin/perl -wT
use strict;
[code]...
I would like to unzip a simple PHP code files, to have a online PHP contact / phone book. Simply, slow, and not database oriented over complicated setups into settings. I have a PHP / web provider (free), not apache. WITHOUT SQL (like before it may exists) something like this [URL]
View 14 Replies View RelatedI've a program which manages my pdf and references. I wish to put some of the information on my website but that program (Mendeley) does export only in XML (or bibtex). I'd like to simply convert the XML output files to SQL in order to create or update an SQL database.I'm not an expert in either XML or SQL (use only PHPMyadmin). Does someone get help me to figure out?
View 2 Replies View RelatedI'm a truly ordinary shell scripter (and unfortunately I know nothing about any higher-level language), but I have an important script to run to count the number of files in our client directories.
Problem is that while we've not got a lot of clients (circa 100), they might have a LOT (> 1000s) of files.
And my script is REALLY slow code...
PS How slow? Well I started a cron job at 0005 yesterday, and as of 0930 today its only a little over half-way through all our clients.
For my IPT assignment i need to make a database for a company and basically my only problem is i can't work out how to password protect a single table in the database.
I tried clicking encrypt with password but that encrypts the entire database.
I am using MS office 2007.
How to compare oracle database table contains using (Perl/Shell)scripts.
View 4 Replies View Relatedmy database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies View RelatedI want to download some specific information(age of the building, value, square feet, etc.) from a county auditor's website:[url]
For every property in the county and ultimately match it to a .dbf file I already have containing geographic information for each parcel.
The website only displays information for a single address at a time in response to a query form asking for either the parcel ID# or street address. I have a table of all the county's parcel ID#'s and valid addresses-about 350,000 or so of them.
I imagine there must be some way to automatically crawl the website inputting the information from my tables into the form and gathering specific information in some sort of format that could then be matched to corresponding information in my .dbf file.
Recently I got a very rare database issue, it says: Error: Couldn't read status information for table clients_copy () mysqldump: Couldn't execute 'show create table `clients_copy`': Table 'adm_retail.clients_copy' doesn't exist (1146) Error: Couldn't read status information for table dt_mx_emp ()
[Code]...
Error: Cannot connect to the database because: INSERT command denied to user 'webuser'@'localhost' for table 'visitor'
[Code]...
I'm trying to configure realtime in my asterisk server and I'm running into this problem:
Code:
res_config_mysql.c: Table cc_sip_buddies not found in database. This table should exist if you're using realtime.
[code]....
I need a shell script to back up and restore a postgresql database.
View 1 Replies View RelatedI 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 Relatedi want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View RelatedI just installed Gnome Shell in Ubuntu 11.04 through UGR Linux and everything works fine! The only problem is that I cannot run make and make install. I get the following errors:
Code:
alexandros@Autobot:~/gnome-shell/source/gnome-shell-extensions$ make && make install
Making all in extensions
make[1]: Entering directory `/home/alexandros/gnome-shell/source/gnome-shell-extensions/extensions'[code]........
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....
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.
What I need is a database that can show a Timeline and have the basic functions for searching by date and other criteria. Not in a hurry is for a future project. Any clues?
View 6 Replies View RelatedFirst i get drupal package :-
"sudo wget http://ftp.drupal.org/files/projects....tar.gz"
this will download the Drupal file into current directory.
> unpack the files issue the command
"tar -zxvf drupal-6.13.tar.gz"
this will extract the files into a folder in home directory > make a directory in the web root folder to keep the Drupal files in. To do this type in
"sudo mkdir /var/www/drupal"
> move the Drupal content over to the web folder. Type in
"sudo mv drupal-6.13/* drupal-6.13/.htaccess /var/www/drupal"
> set up folders for media associated with the site to do this issue "sudo mkdir /var/www/drupal/sites/default/files"
[Code]...
i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
View 2 Replies View Related