12-30-2011
Hi Scott,
the enviornment details (like the ORACLE_SID, ORACLE_HOME, path etc) that you showed in one of your previous posts, is that stored in a file? if yes, can you please tell me which location this file has to go to and the name of the file?
Actually I have the details to set up the env. and I executed the commands and exported them.. but it worked in that unix session. I closed that session and opened an another one, but it is not working..
Thanks!
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
sb2-session
sb2-session(1) sb2-session man page sb2-session(1)
NAME
sb2-session - manage scratchbox2 sessions
SYNOPSIS
sb2-session [COMMAND [PARAMS]]
DESCRIPTION
sb2-session is used to create attachable scratchbox2 sessions. You can save session even when you haven't done '-S session' during sb2
startup.
Note that you can give parameters to attach command which are passed verbatim to sb2. If there is only one session to attach, it is
selected automatically.
If no command is given, help text is printed.
COMMANDS
help shows help text
save saves current session
list lists detached sb2 sessions
delete SESSION
deletes given session
attach [SESSION [PARAMS]]
attaches to a given session
setenv VARIABLE VALUE
store a value for an environment variable
showenv
show stored environment variables
EXAMPLES
Basic usage is:
[SB2 .. ] $ sb2-session save # save session
[SB2 .. ] $ ^D # exit
Later we can then attach to this session:
% sb2-session attach
If there are more than one saved session, then:
% sb2-session list
session.XXXX TARGET_ARM My Comment
session.YYYY TARGET_ARM My Comment 2
session.ZZZZ TARGET_MIPS
% sb2-session attach session.YYYY
Here we pass '-eR' to sb2 and we only have one saved session:
% sb2-session attach -- -eR
'--' marks end of parameter list for sb2-session.
setenv VARIABLE VALUE can be used to add environment variables, that will become active when a saved session is later taken into use
(either by sb2-session attach or by sb2 -J).
setenv VARIABLE VALUE does not change environment of sessions that are already active.
showenv lists environment variable settings which have been stored with this tool. It does not show environment variables from other
sources.
SEE ALSO
sb2(1)
AUTHOR
Mika Westerberg
2.2 21 December 2010 sb2-session(1)