09-04-2007
connecting to remote db from unix script
Hi everybody,
My bash script is trying to connect to a remote database using the 'sqlplus' binary.For this i set(export) the variable TWO_TASK to the value of database name excluding the dot extension part.
Can anyone explain me what's the significance of this TWO_TASK variable while connecting to a remote database and how the flow is happening?
Your help is appreciated
With Regards
Dileep Pattayath
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
I need help writing java code that can connect to a remote unix server, and run a script on that server. I have scoured the internet, but I have been unable to find proper documentation on how this can be accomplished. Any help is appreciated thanks. (1 Reply)
Discussion started by: developncode
1 Replies
3. Shell Programming and Scripting
Hi All,
I've a log file call netbackup.log in all the 5 servers in location usr/netbackup.log. I dont want to login in each server and check the log file. So i wanted to have a script written to have the log information at one place.
I want to have the last 2 lines from the file... (2 Replies)
Discussion started by: suri.tyson
2 Replies
4. Ubuntu
Hi,
I have an interesting problem. I cannot connect to a personal server I set up. What's interesting is that I can connect to it from the LAN using its non-local IP address. However, I cannot seem to connect to it from anywhere else.
Here's how my server is set up:
My entire home has a... (8 Replies)
Discussion started by: Altay_H
8 Replies
5. UNIX for Advanced & Expert Users
Hi All,
can some one please help me to solve this issue, its urgent:confused:
We need to FTP a file form our Unix server to an external client FTP location.
I am trying to connect to the proxy server first and then use the below USER comment to connect to the external FTP server, and its working... (3 Replies)
Discussion started by: JesusJoseph
3 Replies
6. Shell Programming and Scripting
I need to extract the data from oracle table and written the below code.
But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output.
And if I run the shell script with simple sql... (7 Replies)
Discussion started by: giridhar276
7 Replies
7. Shell Programming and Scripting
I m trying to run a batch script in remote desktop which executes unix commands on the unix server...the problem is i wnt the output in HTML format.so in my batch script i m giving the cmd like
ssh hostname path ksh HC_Report.ksh>out.html
...but it generates the HTML file in
remote desktop .i... (2 Replies)
Discussion started by: navsan
2 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a... (1 Reply)
Discussion started by: daveu7
1 Replies
9. Shell Programming and Scripting
Checking crontab job entry in 3 different hosts Hi Gurus,
I am trying to connect to remote host from current host to check crontab entries. I have started like this
ssh -n -l db2psp 205.191.156.17 ". ~/.profile >/dev/null 2>/dev/null; cd log ;ls | wc -l"
I got this error ?
ssh:... (1 Reply)
Discussion started by: rocking77
1 Replies
10. Shell Programming and Scripting
I am trying to connect to a Windows server say 10.1.1.10. This servers has a folder named RAJ in which there are multiple .zip files. All these zip files contain a text file called XYZ.txt. Now i have to merge the content of these XYZ.txt files from each of the .zip file and create a new text... (1 Reply)
Discussion started by: swapniljadav
1 Replies
LEARN ABOUT REDHAT
drop_database
DROP
DATABASE(7) SQL Commands DROP DATABASE(7)
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
INPUTS
name The name of an existing database to remove.
OUTPUTS
DROP DATABASE
This message is returned if the command is successful.
DROP DATABASE: cannot be executed on the currently open database
You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this
command again.
DROP DATABASE: may not be called in a transaction block
You must finish the transaction in progress before you can call this command.
DESCRIPTION
DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed
by the database owner (usually the user that created it).
DROP DATABASE cannot be undone. Use it with care!
NOTES
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
[dropdb(1)], which is a wrapper around this command, instead.
Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.
COMPATIBILITY
SQL92
DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.
SQL - Language Statements 2002-11-22 DROP DATABASE(7)