10-15-2010
The best way (IMHO) to set the Oracle environment is to use the Oracle-provided oraenv script.
It saves you doing it manually, and ensures that the Oracle software and database versions match, in the event that you might have multiple Oracle versions installed.
Setting the ORACLE_HOME on its own will accomplish nothing without an ORACLE_SID. oraenv will set both.
This User Gave Thanks to Scott For This Post:
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all !
Yesterday I defined an environmental variable PATH, but today when I restarted machine, I could not see that it was stored any place.
Is there any file where I could save the settings ?
I have quite a few env.variables defined, so I need a smarter way to define.
regards
D (5 Replies)
Discussion started by: DGoubine
5 Replies
2. Shell Programming and Scripting
All
Can you help me to validate a variable only for string and digit. That is
variable should either fully alphabets or digits.
Please send me result to my mail id also: REMOVED
Thanx in advance
Regards
Deepak Xavier (1 Reply)
Discussion started by: DeepakXavier
1 Replies
3. Shell Programming and Scripting
Can someone send me a shell script to set all Oracle environment variable which is working.
I have the following script which works but not 100%. Please advice what you think is wrong.
if # Command executed from a terminal
then
ORACLE_SID=""
... (4 Replies)
Discussion started by: uuser
4 Replies
4. UNIX for Dummies Questions & Answers
In my script when I change an env variable in the parent shell it is only changed for that session - it there away to change it permanently using a script so that when I use rlogin (create a child session) that the env variable is set correctly?
Basically what I am trying to do is to pass a... (7 Replies)
Discussion started by: belfastbelle
7 Replies
5. Shell Programming and Scripting
Hi,
I'm using an array that contains compiler FLAGS
that need to be executed either before ./configure
or after the main 'make' command.
example of array containing compiler flags.
-------------------------------------------------
FLAGS="CFLAGS=\"-arch x86_64 -g -Os -pipe... (7 Replies)
Discussion started by: ASGR
7 Replies
6. AIX
I am writing a few korn scripts to be used by all our operators on several 4.1/4.2 AIX servers.
I want to create environmental variables that once set, can be read/modified by my scripts (ex: specific folders, file names, conventions, general values, ...). I thought this would be better then... (4 Replies)
Discussion started by: Browser_ice
4 Replies
7. UNIX for Dummies Questions & Answers
I am new in unix..
I am running a sql loader script where I have to specify the data file path but the file name contains spaces in it
so giving error multiple arguments
I have tried it with "" and '' but does n't work the command is :
$ORACLE_HOME/bin/sqlldr... (1 Reply)
Discussion started by: Sandip Dey
1 Replies
8. Shell Programming and Scripting
I am wondering if there is away to increment a date in c shell. What I need to do is basic, but I lack the knowledge.
I have they following environmental variable in my job scripts
setenv YYYY `date '+%Y'`
I then set YYYY to be part of my output dataset name:
setenv dd_OUTPUTP... (1 Reply)
Discussion started by: jclanc8
1 Replies
9. OS X (Apple)
Hey,
I'm recently learning Unix from the video course by Kevin Scoglund. I'm stuck at the moment where he goes into Environmenat variables. I have some issues with understanding what's the essential difference between EV and command aliases: for instance, by writing the command
alias ll='ls... (3 Replies)
Discussion started by: scrutinizerix
3 Replies
10. Shell Programming and Scripting
Hi Team,
I have a wrapper script which i have pasted below, it internally calls one python script to generate Environmental in a file called /home/oracle/myenv.sh, when i execute this script via wrapper script, its not reflecting in my current session, still showing old env variables. any... (2 Replies)
Discussion started by: kamauv234
2 Replies
LEARN ABOUT SUSE
apache::session::oracle
Session::Oracle(3) User Contributed Perl Documentation Session::Oracle(3)
NAME
Apache::Session::Oracle - An implementation of Apache::Session
SYNOPSIS
use Apache::Session::Oracle;
#if you want Apache::Session to open new DB handles:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:sessions',
UserName => $db_user,
Password => $db_pass,
Commit => 1
};
#or, if your handles are already opened:
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh,
Commit => 1
};
DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the
documentation for Apache::Session::Store::Oracle for more details.
USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to
either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have
adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order
to make you think about this problem.
This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default
maximum is 8 KB.
AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>.
SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session
perl v5.12.1 2007-09-28 Session::Oracle(3)