07-01-2012
Where is sqlplus located on the machine (mostly $ORACLE_HOME/bin)? Is that location a part of PATH value?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to write a script, in which I will connect to sqlplus and do a quary and then exit
sqlplus user/pwd@database
select count(*) from table
exit.
and write the result in a log file.
How to write it ?
Many thanks before. (1 Reply)
Discussion started by: big123456
1 Replies
2. Shell Programming and Scripting
I'm writting a shell script and at the begining I login to sqlplus by
sqlplus -l user_name/password@instance
what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again .
I know how to... (4 Replies)
Discussion started by: aya_r
4 Replies
3. UNIX for Dummies Questions & Answers
I want to execute sqlplus command from unix environment.Infact I enter
the command
Here is what I entered.
$ pwd
/u01/app/oracle/product/9.2.0_64/TSTGDPB/bin
$ ls -l sqlplus
-rwxr-x--x 1 oragdpb oinstall 1062664 Oct 18 2005 sqlplus
$ whoami
bpt3a1
$ sqlplus
/bin/ksh: sqlplus: not... (1 Reply)
Discussion started by: MSHETTY
1 Replies
4. UNIX for Dummies Questions & Answers
hi,
I have this basic query.
I have created a new user on unix.
I have given home directory and permission through chmod to create directory stucture.
Now need to connect sqlplus. What permissions should we give, so that this works?
Any help is appreciated.
Thanks,
Neha (1 Reply)
Discussion started by: nehak
1 Replies
5. Solaris
Hi,
I am trying to execte the .sql file(which contain the two different sql query) from solaris script using sqlplus command, the script is executing successfully but the issue is when i execute the script, it is not terminating automatically, for example if i put one sql statement then i have... (2 Replies)
Discussion started by: jyotisree
2 Replies
6. Solaris
Hi friends
recently i have installed SXDE 1/08 into my machine,and i installed wifi driver also
its working fine,Recently i was unable to connect to Internet,I have not changed any configurations and any installations,thing is that i got my iwk0 interface is UP and IP address also and i can... (6 Replies)
Discussion started by: srinivas2828
6 Replies
7. Solaris
I upgraded my system to Solaris 11 and everything works but I can't start my database or what (I am a noob).
OS:
-bash-4.1$ uname -a
SunOS Solaris11 5.11 11.0 i86pc i386 i86pc
-bash-4.1$ isainfo -kv
64-bit amd64 kernel modules
Database version is 11g2 Enterprise edition, installed on... (6 Replies)
Discussion started by: solaris_user
6 Replies
8. Shell Programming and Scripting
I am trying to connect to SQL plus through unix but i am getting below error
'ksh: sqlplus: not found'
note i am running this from /home/xxx
do i need to set any environmental variable for this. below is my code
echo " hello world"
sqlplus -s apps/CAF78GEN<<EOF
set heading... (4 Replies)
Discussion started by: karnatis
4 Replies
9. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
10. UNIX for Dummies Questions & Answers
I installed Oracle sqlplus on My Ubuntu 14.04 64bit version as per the instructions on:
help.ubuntu page (Unable to post the URL as i'm new user here).
I'm totally new to SQL and now i'm learning queries in my college.
I installed 64bit version of sqplus and run it executing the command:... (14 Replies)
Discussion started by: arjunmayilvagan
14 Replies
LEARN ABOUT DEBIAN
net::proxy::connector::connect
Net::Proxy::Connector::connect(3pm) User Contributed Perl Documentation Net::Proxy::Connector::connect(3pm)
NAME
Net::Proxy::Connector::connect - Create CONNECT tunnels through HTTP proxies
SYNOPSIS
# sample proxy using Net::Proxy::Connector::tcp
# and Net::Proxy::Connector::connect
use Net::Proxy;
# listen on localhost:6789
# and proxy to remotehost:9876 through proxy.company.com:8080
# using the given credentials
my $proxy = Net::Proxy->new(
in => { type => 'tcp', port => '6789' },
out => {
type => 'connect',
host => 'remotehost',
port => '9876',
proxy_host => 'proxy.company.com',
proxy_port => '8080',
proxy_user => 'jrandom',
proxy_pass => 's3kr3t',
proxy_agent => 'Mozilla/4.04 (X11; I; SunOS 5.4 sun4m)',
},
);
$proxy->register();
Net::Proxy->mainloop();
DESCRIPTION
"Net::Proxy::Connecter::connect" is a "Net::Proxy::Connector" that uses the HTTP CONNECT method to ask the proxy to create a tunnel to an
outside server.
Be aware that some proxies are set up to deny the creation of some outside tunnels (either to ports other than 443 or outside a specified
set of outside hosts).
This connector is only an "out" connector.
CONNECTOR OPTIONS
"Net::Proxy::Connector::connect" accepts the following options:
"out"
o host
The destination host.
o port
The destination port.
o proxy_host
The web proxy name or address.
o proxy_port
The web proxy port.
o proxy_user
The authentication username for the proxy.
o proxy_pass
The authentication password for the proxy.
o proxy_agent
The user-agent string to use when connecting to the proxy.
AUTHOR
Philippe 'BooK' Bruhat, "<book@cpan.org>".
BUGS
All the authentication schemes supported by "LWP::UserAgent" should be supported (we use an "LWP::UserAgent" internally to contact the
proxy).
This means we should also support NTLM, since it is supported as from "libwww-perl" 5.66. "Net::Proxy::Connector::connect" has not been
actually tested with NTLM, though. Any report of success or failure with a NTLM proxy will be appreciated.
HISTORY
This module is based on my script "connect-tunnel", that provided a command-line interface to create tunnels though HTTP proxies. It was
first published on CPAN on March 2003.
A better version of "connect-tunnel" (using "Net::Proxy") is provided this distribution.
COPYRIGHT
Copyright 2006 Philippe 'BooK' Bruhat, All Rights Reserved.
LICENSE
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2009-10-18 Net::Proxy::Connector::connect(3pm)