General :: Connect To OracleDatabase Through Shell Script
May 12, 2011
Query1:
Actually for executing the sql query in shell script we require uname and password,the same uname and password required for 70 scripts because in 70 scripts i am executing the sql query's. If we using same uname and password in 70 scripts that is repetation problem. I want the solution for once i asked run time uname and password only once these are helpful to all remaining scripts... how it can possible?
Query2:
And for every sql query executing in the each shell script i am connecting to OracleDatabase... I want the solution for connecting only once and using this connection to each and every script... what is the solution for this?
View 3 Replies
ADVERTISEMENT
Mar 4, 2010
So I have my new Dell Latitude 2100 (toy) on my network running Ubuntu 9.10 as delivered. I added openssh and the service is running. I can connect to the machine from another using Nautilus or Gnome Commander over ssh. However, I cannot connect from a shell(?)
ken@taylor12:~$ ssh taylor13
ssh: connect to host taylor13 port 22: Connection timed out
Firestarter shows a connection from taylor12 to taylor13 on port 22 - the Gnome Commander connection over which I am currently transferring some files.
View 4 Replies
View Related
Oct 4, 2009
I have a CentOS dedicated server running ProFTP. I have created user accounts which are meant for FTP access only but the users cannot connect to the FTP unless their shell access is /bin/bash
Here is an example line that is outputted when I use this command:
This user can access the FTP fine, but he can also access SSH which I don't want to allow him to do. If I set his shell access to /bin/false then he can't connect to the FTP.
What can I use in instead of /bin/bash to allow FTP but don't allow SSH?
View 2 Replies
View Related
Sep 15, 2010
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.
View 1 Replies
View Related
Aug 15, 2011
I want to connect to an FTP server from the Linux command line. The server is configured behind a proxy.
If I call:
echo $ftp_proxy
I get a result like this:
abc.def.ghi.jkl:8080
If I call:
ftp -pn $ftp_proxy
I get a unknown host error.
How can I connect to the FTP server using the Linux command line?
View 1 Replies
View Related
Jun 15, 2011
MACHINE: HP Proliant DL260G5OS: SLES 11 SP1kernel: Linux xserver 2.6.32.12-0.7-default #1 SMP 2010-05-20 11:14:20 +0200 x86_64 x86_64 x86_64 GNU/LinuxIt is used as remote xserver in a LAN.I have configured /usr/lib/restricted/bin/.rbashrc with some environment variables but when the users logon in the system finally is executed $HOME/.bashrc and some environment vars are overwritten.
View 2 Replies
View Related
Apr 27, 2011
I would like know when it is necessary or advisable to write a shell script instead of shell function ?
View 3 Replies
View Related
May 31, 2011
how can i connect remotly to Oracle Database using shellscript?.is oracle client is require for connect to oracle db remotly?
View 2 Replies
View Related
Jan 18, 2011
I am wondering if I can open a shell or new terminal thing from within the terminal in a unix/linux enviroment. Particularly a commandline only one where there is no GUI. Is this doable? how do I do it?
View 3 Replies
View Related
Feb 15, 2010
I'm trying to connect OpenVPN server using shell command.
I've installed all needed packages (I guess)
if type
Code:
sudo openvpn client.ovpn
and i've got messages:
Code:
Mon Feb 15 12:29:25 2010 OpenVPN 2.1_rc19 i486-pc-linux-gnu [SSL] [LZO2] [EPOLL] [PKCS11] built on Oct 13 2009
[Code]....
but i can't see tap0 interface and cannot ping any address at remote location.
I tried this config file at Windows OpenVPN client and all works fine.
View 2 Replies
View Related
Mar 14, 2010
I want to change my default shell to tcsh. I used
Code:
usermod -s /bin/tcsh username
command as given at url
But if I open a new shell, it is still a bash shell.
How do I make my default shell as tcsh?
View 6 Replies
View Related
Jul 26, 2010
I am using ubuntu10.04-server 64bit AMD with fluxbox. After I ran Matlab in a shell (without GUI) the shell does not display characters anymore, but will execute any command, I just can't see the characters that I'm typing.. I use aterm and xterm, does anybody know why that is, am I missing a package?
View 1 Replies
View Related
Apr 14, 2011
Is there any way I can switch my desktop shell from unity to, say, gnome-shell? I can switch using other console shell I like (bash, csh, fish, etc.). Assume that there is a stable alternative desktop shell, I should be able to choose, too.
(For console shell, we goes to /etc/passwd. But for desktop, I can't find the way to config.)
View 2 Replies
View Related
May 21, 2009
Is there a way to export a variable to parent shell in shell scripting ?
View 3 Replies
View Related
Jun 5, 2011
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....
View 10 Replies
View Related
Jun 25, 2010
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.
View 4 Replies
View Related
Mar 21, 2011
I have installed linux 10.10 and i want to connect internet through USB Bsnl EVDO modemprocedure/commands to connect to internet
View 5 Replies
View Related
Jun 15, 2010
I am using Red Hat Linux Enterprise version 5. I've noticed people sometimes running commands with a couple of & options. For example, in the below command, there are two & signs. What is the purpose of them? Are they always used together with nohup?
nohup foo.sh <script parameters> >& <log_file_name> &
View 6 Replies
View Related
Sep 2, 2010
I was working on a shell and got some weird exceptions in my program.Just as a reference, I want to save all that is there on my shell to a text file. I do not just want the command history but also all the results that those commands produced at the shell.Is there some built-in utility to do this? I have kept the shell open for now, so that I can take the backup. Also, I am using xterm and it does not allow selecting all the way upto the top of the shell, so the ultimate way is to take the backup one screen at a time.
View 2 Replies
View Related
May 2, 2011
I was wondering if it is somehow technologically possible for Windows to add some sort of Linux interface? I think it would win over many programmers to develop on Windows.
View 4 Replies
View Related
Mar 1, 2011
I have achieved the following in the terminal:-
ftp> open <name of server>
name <insert log in>
password: <password>
[code]...
View 1 Replies
View Related
May 19, 2010
I've had my prompt change whenever I :sh (:shell) out of VIM, but can't for the life of me remember how?. The idea is to change the prompt to something like [SH] <your usual prompt here>, so that I know that VIM is running in the background.. I often logout of the shell, because I think VIM is open.
View 3 Replies
View Related
Jun 30, 2011
I just upgraded my OS and find that I have a generic type terminal.How would I go about getting the Bourne again shell?
View 14 Replies
View Related
Mar 12, 2011
ill have this question on the test maybe : In dir00 directory create files year01.txt, year02, ...year05.txt with January calendar for 2001-2005 years in it.-i'm lost. i execute this : cat | cal 01 2001 > year01.txt
View 12 Replies
View Related
May 26, 2011
how to write own shell in linux?i want to know procedure of shell programming.
View 5 Replies
View Related
Feb 15, 2011
What is shell scripting? what is 'bash'?
View 14 Replies
View Related
Dec 15, 2009
I've created a simple script based menu. This menu will be accessed by only a certain users via ssh.When user logs in, the menu will automatically run. (configured at user's .bash_profile).How do I force the session to close when user hits Ctrl-C or Ctrl-Break ?In a nutshell, I don't want user to have access to shell.
View 11 Replies
View Related
May 20, 2009
Hello.I am using Opensuse 11.1 (just installed),gnome-based .My problem is,I can only login as root,cos the tty's attached to my normal user(non-privileged)keep crashing(I checked this with last).Is there any way I can fix this?I reinstalled several times,nothing to do.
View 9 Replies
View Related
Jul 20, 2010
How to login as root in linux shell?
View 3 Replies
View Related
Sep 3, 2010
I occasionally use screen within linux. Every now and then my connection plays up and I lose access to the ssh shell, when I try to reattach myself to the screen instance this is what I get:
There is a screen on:
2690.pts-0.localhost (09/03/10 12:56:08) (Attached)
There is no screen to be resumed. What I could do in this case? I guess screen believes I'm still attached, while I'm not.
View 2 Replies
View Related