02-22-2006
maybe privileges
probably the user that you're using to execute script does not have prvileges on the oracle binaries. The user needs to belongs to the group (ej. dba) that usually is created previously - to the binaries installation?
once the user has privileges - the environmental variables can be "set". Another form is defining the environmental variables in .profile (file) of the user.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: janemary.a
2 Replies
2. Shell Programming and Scripting
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)
Discussion started by: dinesh1985
4 Replies
3. Shell Programming and Scripting
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)
Discussion started by: milink
3 Replies
4. 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
5. Shell Programming and Scripting
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)
Discussion started by: Tuxidow
2 Replies
6. UNIX for Advanced & Expert Users
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)
Discussion started by: vipinkumarr89
1 Replies
7. Shell Programming and Scripting
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)
Discussion started by: amitlib
1 Replies
8. Shell Programming and Scripting
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)
Discussion started by: SkySmart
3 Replies
9. Shell Programming and Scripting
My shell script it.sh.I am calling bip.sh from it.sh
#!/bin/sh
ORACLE_HOME=/var/opt/oracle/product/10g; export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin; export PATH
today=`date "+%m-%d-%Y %H:%M:%S"`; export today
CUR_DIR=$1; export CUR_DIR
LOG_FILE=$CUR_DIR/error.log;... (4 Replies)
Discussion started by: rafa_fed2
4 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 OSX
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)