04-22-2011
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can someone tell me how to execute sqlplus command.
I`m Executing:
sqlplus user/pasw @/report/output/new/PlatformOut_Cdrs.sql
the error is:
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Aug 9 15:37:44 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:... (3 Replies)
Discussion started by: Nel
3 Replies
2. Shell Programming and Scripting
hello all
im trying to use in sun Solaris the information received from the top command
now i several machines that dont have install the top program so when im running the script im geting error
saying after im running this code :
set MemoryInfo = `top | grep Memory`
if (... (2 Replies)
Discussion started by: umen
2 Replies
3. HP-UX
hi,
i need bash shell script run on the crontab(Unix tru64).
i have write my shell. it's using sqlplus command and connect to oracle db.
execute cron job when i have error messege: "sqlplus: command not found"
have you any suggestion? (4 Replies)
Discussion started by: Tlg13team
4 Replies
4. Shell Programming and Scripting
Hi,
Below is my script:
#!/bin/sh
sqlplus uname/pwd@instance <<EOF
set wrap off
set feedback off
set pagesize 0
set verify off
set trimspool on
set linesize 5000
spool /arboru02/FX/scripts/customer_profile_def.txt
select... (1 Reply)
Discussion started by: ss_ss
1 Replies
5. Shell Programming and Scripting
Hi All ,
At the end I have to post my problem thinking I'll be able to get a clue.
I have done a shell script to access a table in our database to extract some logs .
Script is working when executed manually ,but when I set it up in cronjob it is not working. I know thins should be a... (2 Replies)
Discussion started by: Davinzy
2 Replies
6. UNIX for Dummies Questions & Answers
hi,
I am new to unix and trying to connect to oracle from unix.
I typed the below command and the error is sqlplus not found
$ sqlplus
-ksh: sqlplus: not found
can someone please tell me what is missing? I see that oracle is available on this unix box in the path /opt/oracle as... (7 Replies)
Discussion started by: Vijay81
7 Replies
7. Shell Programming and Scripting
Hi ,
i am new to unix i need a small clarification regarding this
sqlplus -s $USER_NAME/$PASSWD@$ORA_SID<< EOF >> SQL_CONN_LOG.log
In the above command what is the meaning of <<EOF>>
Thanks,
krishna. (2 Replies)
Discussion started by: rams_krishna
2 Replies
8. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
9. 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
10. UNIX and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT DEBIAN
ubuntu-dev-tools
ubuntu-dev-tools(5) File Formats Manual ubuntu-dev-tools(5)
NAME
ubuntu-dev-tools - Configuration for the ubuntu-dev-tools package.
DESCRIPTION
The ubuntu-dev-tools package is similar in scope to the devscripts(1) package, providing a collection of scripts which may be of use to
Ubuntu and Debian developers or others wishing to build Debian packages.
Some of these scripts have options which may be configured on a system-wide and per-user basis. These options are configured in
devscripts.conf(5).
All variables are described in the script's manpages. Package-wide variables begin with "UBUNTUTOOLS" and are listed below.
Every script which reads the configuration files can be forced to ignore them by using the --no-conf command-line option.
ENVIRONMENT
All ubuntu-dev-tools configuration variables can be set (and overridden) by setting them in the environment (unlike devscripts).
In addition, several scripts use the following environment variables:
UBUMAIL
Overrides DEBEMAIL and DEBFULLNAME when the target is clearly Ubuntu. Can either contain an e-mail address or Full Name
<email@example.org>.
DEBEMAIL, DEBFULLNAME
As in devscripts(1).
PACKAGE-WIDE VARIABLES
The currently recognised package-wide variables are:
UBUNTUTOOLS_BUILDER
This specifies the preferred test-builder, one of pbuilder (default), sbuild, pbuilder-dist.
UBUNTUTOOLS_DEBIAN_MIRROR
The preferred Debian archive mirror. Should be of the form http://ftp.debian.org/debian (no trailing slash). If not specified, the
master will be used.
UBUNTUTOOLS_DEBSEC_MIRROR
The preferred Debian security archive mirror. Should be of the form http://security.debian.org (no trailing slash). If not speci-
fied, the master will be used.
UBUNTUTOOLS_UBUNTU_MIRROR
The preferred Ubuntu archive mirror. Should be of the form http://archive.ubuntu.com/ubuntu (no trailing slash). If not specified,
the master will be used.
UBUNTUTOOLS_UBUNTU_PORTS_MIRROR
The preferred Ubuntu archive mirror. Should be of the form http://ports.ubuntu.com (no trailing slash). If not specified, the mas-
ter will be used.
UBUNTUTOOLS_LPINSTANCE
The launchpad instance to communicate with. e.g. production (default) or staging.
UBUNTUTOOLS_MIRROR_FALLBACK
Whether or not to fall-back to the master archive mirror. This is usually the desired behaviour, as mirrors can lag the masters.
If on a private network with only a local mirror, you may want to set this to no. One of yes (default) or no.
UBUNTUTOOLS_UPDATE_BUILDER
Whether or not to update the test-builder before each test build. One of yes or no (default).
UBUNTUTOOLS_WORKDIR
The directory to use for preparing source packages etc. When unset, defaults to a directory in /tmp/ named after the script.
SEE ALSO
devscripts(1), devscripts.conf(5)
AUTHORS
This manpage was written by Stefano Rivera <stefanor@ubuntu.com>.
ubuntu-dev-tools December 19 2010 ubuntu-dev-tools(5)