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.
When I run it it works as follows..
./setenv.sh
HTML Code:
Valid Oracle SIDs are :
mdmop
mdmt
mdmp
Enter the Oracle SID you require (def: mdmop): mdmt
Oracle SID is now mdmt, Oracle Home is /u001/app/oracle/product/9.2/home
ga016dhd -> echo $ORACLE_SID
mdmop <== Not really set to mdmt(even if it said it is)
ga016dhd -> echo $ORACLE_HOME
/u001/app/oracle/product/9.2/home
[/home/oracle/script - oracle]
I think when the script executes it does execute export ORACLE_SID=$ORACLE_SID based on the values passed but once it is done executing the default values was set back ???? any reason why ??
Hi,
I'm exporting an environmental variable from a C program using putenv function. I'm calling the exe of the C program from shell script. But when I display the environmental variables from the Shell script, My varaible is not getting displayed.
Can anyone please tell me how to get it in... (2 Replies)
Dear Folks,
I am facing an issue in getting a value of a variable.Let me explain the scenario.
I am having a list file say files.list in which I have mentioned
1 FILE1
2 FILE2
Then I am having an set_env.ksh in which I mentioned
FILE1=/clocal/data/user/userdata.txt... (4 Replies)
Hi,
Getting below error on executing the shell script which initiates sqlplus
How to set oracle enviornment variables in the shell script ?
With Regards (3 Replies)
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)
I have a request from a programmer to set an env variable for him. I know how to do it for bash shell by adding the following line to .bash_profile
export $VAR=/home/code/project/
But this will be applicable only when he is in his bash shell. What is the procedure to be followed to make... (2 Replies)
i want to set environmental variables in solaris and redhat.
it should show the current directory and the default shell should be bourne shell. along with it should show the hostname..
like this
hostname{/home/vipin/data}# ifconfig
Thanks in advanced.:wall:
Please use code tags.... (1 Reply)
Hi,
I have a function that is suposed to generate a AWR report:
#-----------------------#
gen_awr()
#-----------------------#
{
sqlplus -s admin/admin@OCEAN11<<ENDOFSQL
define num_days = ''
define report_type = "html"
define begin_snap =$snap1
define end_snap =%snap2
define... (1 Reply)
i set a variable from the command line:
export GANG="james,roy,martin"
i can access this variable ($GANG) from a script. but each time i run the script, the variable keeps getting bigger. more info keeps getting added to it.
Is there anyway i can make the $GANG variable contain the... (3 Replies)
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)