shell script for connecting to a different user Post: 302350563

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connecting DB in the Shell Script to do SQL Query

Any link or example to write shell script for the Connecting Oracle for Quering through SQL thanks in advance ... Cheers !! Mehul Doshi

2. Shell Programming and Scripting

error connecting sql through a shell script

Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly. It was working properly earlier, no clue why i am getting this. Please find the log below: FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008 Program ended. Wed Apr 30...

3. Shell Programming and Scripting

Connecting to sybase via shell script.

Hi All, I was able to connect to sybase in shell script and also able to run few sql queries, something like this, #!/usr/bin/ksh -x temp=`echo "select name from sysobjects where type = 'U'"` results=`isql -SDS_SERVER-UAdhocUser -Pha12 <<EOF set rowcount 6 $temp go EOF` line_count=0...

4. Shell Programming and Scripting

Showing errors when connecting to sqlplus in shell script

hi, I am trying to automate the compilation of procedures stored in .sql files in Unix. Is there any way in which we can sho err if there errors are raised in the compilation? I am using the following code to connect to the sqlplus sqlplus ${SQL_USER}/${SQL_PASSWORD}

5. Shell Programming and Scripting

shell script not connecting to primary from standby site

Hi All, I am using below shell script using SQL*Plus to query the MAX(SEQUENCE#) from both databases V$LOG_HISTORY view.If the STANDBY appears to be falling behind by - 2, then alert mail should be sent... How could I achieve it with improving the below script. #!/usr/bin/ksh ...

6. Shell Programming and Scripting

Connecting to oracle database from shell script

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...

7. Shell Programming and Scripting

run shell script connecting to oracle from crontab

Hi, I have problems with running shell script connecting to Oracle from the crontab. Here is the script: #!/sbin/sh ORACLE_HOME=/opt/oracle/10g/ export ORACLE_HOME if then echo "Source path is not specified" exit fi /opt/oracle/10g/bin/sqlplus user/pass@testdb << EOF truncate table...

8. Shell Programming and Scripting

connecting servers using shell script

Hi , I have three linux servers. I want to login from one server and check some status in the other server. How to connect other server from one server using shell script. Can anyone advice on this? Thanks, Chelladurai.

9. UNIX for Dummies Questions & Answers

SQL block in a Shell Script connecting to a local and remote DB

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...

10. Shell Programming and Scripting

Shell script for connecting multiple servers and then copying 30 days old files

Shell script for connecting multiple servers and then copying 30 days old files from those server . HI , I have 6 multiple servers pla1,pla2,pla3,pla4,pla5,pla6 1. These six servers have common shared mount point /var/share 2. Running script from /var/share to connect these servers.I...

LEARN ABOUT SUSE

disco

disco(1)						      General Commands Manual							  disco(1)

NAME

       disco - Mono's Web Service Discovery Tool

SYNOPSIS

       disco [options] url

DESCRIPTION

       disco is a tool for discovering web services and for retireving the documents that describe those services.

       url is the location of a DISCO document, which includes a list of WSDL documents, XML schemas and references to other DISCO documents.

       disco downloads the DISCO document and all referenced documents (unless the -nosave option is specified), and saves them to disk.

OPTIONS

       The following options are available:

       -nologo
	      Supress the startup logo.

       -nosave
	      Do not save the discovered documents to disk. The default is to save the documents.

       -o:directory , -out:directory
	      The directory where to save the discovered documents.  By default, documents are saved in the current directory.

       -u:username , -user:username
	      The user name to use when connecting to the server.

       -p:password , -password:password
	      The password to use when connecting to the server.

       -d:domain , -domain:domain
	      The domain to use when connecting to the server.

       -proxy:url
	      The url of the proxy server to use for http requests.

       -proxyusername:username
	      The user name to use when connecting to the proxy.

       -proxypassword:password
	      The password to use when connecting to the proxy.

       -proxydomain:domain
	      The domain to use when connecting to the proxy.

AUTHORS

       Lluis Sanchez Gual (lluis@ximian.com)

LICENSE

       disco is released under the terms of the GNU GPL.

SEE ALSO

       wsdl(1), soapsuds(1), mono(1), mcs(1)

																	  disco(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connecting DB in the Shell Script to do SQL Query

Discussion started by: mehuldoshi

2. Shell Programming and Scripting

error connecting sql through a shell script

Discussion started by: nehak

3. Shell Programming and Scripting

Connecting to sybase via shell script.

Discussion started by: arvindcgi

4. Shell Programming and Scripting

Showing errors when connecting to sqlplus in shell script

Discussion started by: silas.john