Hi Friends,
I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement.
Could anyone pls let me know.
I've tried below command which i found in some website, But it throws some error.:confused:
Executed:
perl -e 'use DBI; print... (1 Reply)
Hi All,
I am trying to connect oracle from unix mechine but i am getting an error like
Ksh: sqlplus: not found
Any one please tell me how to connect oracle from unix mechine.
I would appreciate if any one send the query.
Regards,
Ravi kumar.Gongati (2 Replies)
We have a Sun solaris 9 server (say A), with oracle 9 installed and running, at one place(say X).
We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the... (0 Replies)
I want to use Perl to connect to a remote Oracle DB
I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server.
Is this possible?
I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Hello,
Returing to Unix scripts after a long while,
This might be a simple question for most of you ,
I need to connect from a .sh script to oracle, select XYZ.nextval from dual ,
, meaning either get the Current Val or Next Val for a sequence.
How do I store the return value , I know... (2 Replies)
I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.
su - oracle -c "<< EOF1
sqlplus -s "/ as sysdba" << EOF2
whenever sqlerror exit sql.sqlcode;... (2 Replies)
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever.
requirement:
1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
LEARN ABOUT DEBIAN
vtysh
VTYSH(1) Version 0.96.5 VTYSH(1)NAME
vtysh - a integrated shell for Quagga routing software
SYNOPSIS
vtysh [ -b ]
vtysh [ -E ] [ -d daemon ] ] [ -c command ]
DESCRIPTION
vtysh is a integrated shell for Quagga routing engine.
OPTIONS
Options available for the vtysh command:
-b, --boot
Execute boot startup configuration. It makes sense only if integrated config file is in use (not default in Quagga). See Info file
Quagga for more info.
-c, --command command
Specify command to be executed under batch mode. It behaves like -c option in any other shell - command is executed and vtysh exits.
It's useful for gathering info from Quagga routing software or reconfiguring daemons from inside shell scripts, etc. Note that mul-
tiple commands may be executed by using more than one -c option and/or embedding linefeed characters inside the command string.
-d, --daemon daemon_name
Specify which daemon to connect to. By default, vtysh attempts to connect to all Quagga daemons running on the system. With this
flag, one can specify a single daemon to connect to instead. For example, specifying '-d ospfd' will connect only to ospfd. This
can be particularly useful inside scripts with -c where the command is targeted for a single daemon.
-e, --execute command
Alias for -c. It's here only for compatibility with Zebra routing software and older Quagga versions. This will be removed in
future.
-E, --echo
When the -c option is being used, this flag will cause the standard vtysh prompt and command to be echoed prior to displaying the
results. This is particularly useful to separate the results when executing multiple commands.
-h, --help
Display a usage message on standard output and exit.
ENVIRONMENT VARIABLES
VTYSH_PAGER
This should be the name of the pager to use. Default is more.
FILES
/usr/local/etc/vtysh.conf
The default location of the vtysh config file.
/usr/local/etc/Quagga.conf
The default location of the integrated Quagga routing engine config file if integrated config file is in use (not default).
WARNING
This man page is intended to be a quick reference for command line options. The definitive document is the Info file Quagga.
SEE ALSO bgpd(8), ripd(8), ripngd(8), ospfd(8), ospf6d(8), isisd(8), zebra(8)BUGS
vtysh eats bugs for breakfast. If you have food for the maintainers try http://bugzilla.quagga.net
AUTHORS
See http://www.zebra.org and http://www.quagga.net or the Info file for an accurate list of authors.
Quagga VTY shell 27 July 2006 VTYSH(1)