Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with SQL*Plus Connection
Top Forums Shell Programming and Scripting Help with SQL*Plus Connection Post 302419188 by methyl on Thursday 6th of May 2010 12:24:09 PM
Old 05-06-2010
There are examples in this current thread. We just move the connect string to the program rather than stating it in the command line.

https://www.unix.com/shell-programmin...sqlplus-4.html
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL Connection check though Scripting

Hi Guys, I wanted to check the sql connection through scripting if it is avilable then proceed else stop the process I was trying sqlplus -L username/passwd@sid if this is not sucess it gives non-zero. but if it is success it is going into the sqlplus prompt. So how could i get out... (2 Replies)
Discussion started by: Swapna173
2 Replies

2. UNIX for Advanced & Expert Users

Connection reset by peer..closing connection

Hello I'm facing the above problem while doing a performance run. I've a script which I'm launching from my windows desktop using mozilla. The script will invoke backend action on a Solaris host which in turn feeds the records to a driver located on a linux box(Cent OS). What's happening is... (1 Reply)
Discussion started by: subramanyab
1 Replies

3. Shell Programming and Scripting

Connection to Microsoft SQL Server

Hi, I am using "ksh" and trying to connect to the Microsoft SQL Server but it gives an error that is: DB-LIBRARY error: Unexpected EOF from SQL Server. Can any one please help me to resolve this issue. And i am using Putty to connect to the Unix server. Thanks (3 Replies)
Discussion started by: anupdas
3 Replies

4. Solaris

Solaris 10 ftp connection problem (connection refused, connection timed out)

Hi everyone, I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies

5. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

6. Shell Programming and Scripting

SQL query in a loop with single sqlplus connection

Hi, I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data. Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Discussion started by: lsantacana
4 Replies

7. UNIX for Dummies Questions & Answers

Test new DSN connection to sql server

I installed an odbc driver and created a DSN to connect to a sql server database on AIX 6. I want to know how to test the DSN from the command line. What syntax or commands do I use? ---------- Post updated at 11:44 AM ---------- Previous update was at 08:26 AM ---------- OK I figured out how... (9 Replies)
Discussion started by: Jdbrown239
9 Replies

8. UNIX for Advanced & Expert Users

How keep running a program n an another computer via a connection ssh when the connection is closed?

Hi everybody, I am running a program on a supercomputer via my personal computer through a ssh connection. My program take more than a day to run, so when I left work with my PC I stop the connection with the supercomputer and the program stop. I am wondering if someone know how I can manage... (2 Replies)
Discussion started by: TomTomGre
2 Replies

9. UNIX for Dummies Questions & Answers

UNIX string connection to sql server db

Hi, i have to perform a connection from unix to sql server database, using TCP protocol. I have all connection parameters (user,pwd,server_name,port,db_name). How can i perform this connection, by unix console ? is it available a command similar to this one (for oracle): sqlplus... (1 Reply)
Discussion started by: nash83
1 Replies

10. UNIX for Beginners Questions & Answers

How to use for loop to execute multiple .sql files while using SQLPLUS for db connection.?

Hello , Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this.. How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies

LEARN ABOUT LINUX

firefox

FIREFOX(1)                                                      Linux User's Manual                                                     FIREFOX(1)

NAME

       firefox - a Web browser for X11 derived from the Mozilla browser

SYNOPSIS

       firefox [OPTIONS] [URL]

DESCRIPTION

       Mozilla Firefox is an open-source web browser, designed for standards compliance, performance and portability.

USAGE

       firefox is a simple shell script that will set up the environment for the actual executable.

OPTIONS

       A summary of the options supported by firefox is included below.

   GTK options
       --gdk-debug=FLAGS Gdk debugging flags to set

       --gdk-no-debug=FLAGS
              Gdk debugging flags to unset

       --gtk-debug=FLAGS
              Gtk+ debugging flags to set

       --gtk-no-debug=FLAGS
              Gtk+ debugging flags to unset

       --gtk-module=MODULE
              Load an additional Gtk module

   X11 options
       --display=DISPLAY
              X display to use

       --sync Make X calls synchronous

       --no-xshm
              Don't use X shared memory extension

       --xim-preedit=STYLE

       --xim-status=STYLE

       --g-fatal-warnings
              Make all warnings fatal

   Firefox options
       -h, -help
              Show summary of options.

       -height value
              Set height of startup window to value.

       -width value
              Set width of startup window to value.

       -v, -version
              Print /usr/bin/firefox-bin version.

       -CreateProfile profile
              Create profile.

       -P profile
              Start with profile.

       -ProfileManager
              Start with profile manager.

       -UILocale lang-region
              Start with lang-region resources.

       -contentLocale lang-region
              Start with lang-region resources.

       -remote command
              Execute command in an already running Firefox process.  For more info, see: http://www.mozilla.org/unix/remote.html

       -no-remote
              Don't try to control an already running instance.

       -jsconsole
              Start with Javascript Console

       -chrome url
              Load the specified chrome.

       -new-window url
              Open URL in a new window if Firefox is already running.

       -new-tab url
              Open URL in a new tab if Firefox is already running.

       -preferences
              Open Firefox preferences menu.

       -safe-mode
              Disables extensions and themes for this session.

       FILES  /usr/bin/firefox - shell script wrapping firefox
              /usr/lib/firefox/firefox - firefox executable

VERSION

       3.0

BUGS

       To report a bug, please visit http://bugzilla.mozilla.org/

SEE ALSO

       mozilla(1)

AUTHORS

       The Mozilla Organization
              http://www.mozilla.org/about.html

firefox                                                          January 04, 2006                                                       FIREFOX(1)
All times are GMT -4. The time now is 07:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy