08-22-2007
connecting to a database through a script...if not give an error msg
Hello ,
i have a problem in writing the shell script..
i have a script already written n just need to make a change in which when the script is not able to connect to the database ..it should print an error msg on the screen.
I have already seen previous posts on how to connect to the database ..but i didnt find any in which it prints out an error msg when not connected to the database... I am posting my script below.
I have tried it this way ..but it doesnt seem to work.. Somewhere i guess it is been written in a wrong way.
if[!$STOCK/sqlplus VKS#1/#vokus02@$VOKUS @range.sql]
print "Cannot connect to the Database";
thank u in advance
...................................................................................................
#!/bin/ksh
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/export/home/oracle/app/oracle/product/8.1.7/lib
export LD_LIBRARY_PATH
export ORACLE_HOME=/export/home/oracle/product/10.1.0/client_1
export STOCK=/export/home/oracle/product/10.1.0/client_1/bin
export ENT=/home/thomas/ent/uc2
VOKUS=**********
cd $ENT
# $STOCK/sqlplus VKS#1/#vokus02@$VOKUS @range.sql
if[!$STOCK/sqlplus VKS#1/#vokus02@$VOKUS @range.sql]
print "Cannot connect to the Database";
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
hello -
Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script
Cheers
(Running Solaris)
Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated
Cheers (1 Reply)
Discussion started by: penfold
1 Replies
2. AIX
Which is command I could used, to give me the kind of database ,size of database and version of database ? (4 Replies)
Discussion started by: magasem
4 Replies
3. Shell Programming and Scripting
Hi,
While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows :
Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies
4. Shell Programming and Scripting
if;
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`
I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?
Appreciate your... (4 Replies)
Discussion started by: dreams5617
4 Replies
5. Shell Programming and Scripting
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies
6. Windows & DOS: Issues & Discussions
Hi,
Am running my client in Windows and the database (IBM DB2) is in AIX machine. if I open my client its not connecting to the database at first time and failing in a particular SQL Query. But if I close the client and open again then its connecting and the query is also working fine. Don't... (0 Replies)
Discussion started by: mvictorvijayan
0 Replies
7. Shell Programming and Scripting
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies
8. Shell Programming and Scripting
Hi,
I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not?
Can anyone help me in this regard?
Appreciate your help and concern.
Thanks,
Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies
9. Shell Programming and Scripting
Hi all,
In my concern they gave a task to me do cran job like
To write a shell script for
To connect a database
it should execute a query
it should save the output of the query
after getting the output it should send a mail to you inbox for every one hour
I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies
10. Shell Programming and Scripting
Hi experts.
I have different database and schema and their passwords in one file.
In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database.
Ex: password File Format
databse schemaname password
DB1 name1 ... (1 Reply)
Discussion started by: abhigrkist
1 Replies