12-27-2011
thanks scott. I am guessing may be oracle is not installed in unix.. it is just available as a tar file in a directory called oracle.. so i think it is not installed. i appreciate your help! Is there a way to check if oracle is installed in the unix box?
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is... (9 Replies)
Discussion started by: LiquidChild
9 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. Ubuntu
I installed Oracle 10.2.1.0 in Ubuntu 10.10..my installation was well,i could even open isqlplus( http://ubuntu.ubuntu-domain:5560/isqlplus/workspace.uix ) and execute some queries..But,back in terminal when i try to login to sqlplus i am getting error (20 Replies)
Discussion started by: sandy0594
20 Replies
7. Shell Programming and Scripting
When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please. the script is a s follows
count=`sqlplus -s $ORACLE_ACCOUNT << EOF
set heading off
set wrap on
set feedback off
column ChangeNumber format a12
column... (9 Replies)
Discussion started by: jhon1257
9 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
lr_env
LR_ENV.IN(1) LogReport's Lire Documentation LR_ENV.IN(1)
NAME
lr_env - Gives information on the location of the current Lire installation
SYNOPSIS
eval `lr_env `
DESCRIPTION
lr_env prints on STDOUT shell code which can be evaled to access information on the Lire installation.
The following variables are printed:
LR_PREFIX
The prefix where Lire is installed.
LR_LIBDIR
The directory where the supporting scripts are installed.
LR_SYSCONFDIR
The directory where configuration files are installed.
LR_BINDIR
The directory where user binary are installed.
LR_MANDIR
The directory where man pages are installed.
LR_PLUGINSDIR
The directory where Lire::Plugin initializers are installed.
LR_SCHEMASDIR
The path where DLF schemas are installed.
LR_REPORTSDIR
The path where report specifications are installed.
LR_FILTERSDIR
The path where filter specifications are installed.
LR_DOCDIR
The directory where documentation is installed.
LR_SPECSDIR
The path where XML configuration specifications are installed.
LR_TEMPLATESDIR
The path where XML report templates are installed.
LR_PERL5LIBDIR
The directory where platform independant perl modules are installed.
VERSION
$Id: lr_env.in,v 1.7 2006/07/23 13:16:32 vanbaal Exp $
COPYRIGHT
Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
AUTHOR
Francis J. Lacoste <flacoste@logreport.org>
POD ERRORS
Hey! The above document had some coding errors, which are explained below:
Around line 106:
You forgot a '=back' before '=head1'
Lire 2.1.1 2006-07-23 LR_ENV.IN(1)