Just a repost so other can learn from it
Cheers
Date: Wed, 19 Dec 2007 10:05:58 -0500From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: Environment variable problem?It wasn't permissions, I fixed it
by adding my PATH to the crontab and now it works. Thanks for the help and
enjoy the Holiday
I'm running Red Hat AS 4 on a Sunfire X4200 with 4 GB RAM,
2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:58:04 EST 2007 i686 athlon i386 GNU/Linux
Perl 5.8.5 installed with DBI 1.601 and DBD::Oracle 1.19, and the Oracle
10.2.0.1 client at /usr/lib/oracle/10.2.0.1/client
On 4/11/07, tom r [EMAIL PROTECTED] wrote:
i believe that sql*plus does not use
TWO_TASK.
Sqlplus does use TWO_TASK.
10:31-ordevdb01:dv11:jkstill-18 oenv
ORACLE_SID : dv1
TWO_TASK :
ORACLE_HOME : /u01/app/oracle/product/10.2.0/10gr2dev
IAS_ORACLE_HOME :
ORACLE_BASE
gives an in depth explanation on how the TWO_TASK
environment variable can be used. however, when i tried to use it in place
of .tnsnames.ora nothing worked. i believe that sql*plus does not use
TWO_TASK.
-
[~] cat .tnsnames.ora
infra=(description=(address=(protocol=tcp)(host
]
To: dbi-users@perl.org
Cc: tom r [EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 5:47 AM
Subject: Re: TWO_TASK environment variable
I was playing with TWO_TASK myself this morning and like Tom, I cannot make
the advice in DBD::Oracle work with Instant Client 10.2.0.3. I wonder
:
use DBI 1.28
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
- Original Message - From: Martin J. Evans [EMAIL PROTECTED]
To: dbi-users@perl.org
Cc: tom r [EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 5:47 AM
Subject: Re: TWO_TASK environment variable
I
reading man DBD::Oracle gives an in depth explanation on how the TWO_TASK
environment variable can be used. however, when i tried to use it in place
of .tnsnames.ora nothing worked. i believe that sql*plus does not use
TWO_TASK.
-
[~] cat .tnsnames.ora
infra=(description=(address
Well, this is not a Perl/DBI question, really. I personnaly do not use
TWO_TASK as it is an archaic environment variable that has been around
since version 4 of the DB.
If you are interested in using the Easy Connect method, you should read
the Oracle docs:
http://download-east.oracle.com/docs
hi ron,
thanks for the response. using sqlnet.ora just doesn't work for me. i agree
with you about hidden files -- i don't like them. that's why i'd like to
find a better way. here's what happens using sqlnet.ora:
-
[~] cat sqlnet.ora
NAMES.DIRECTORY_PATH=(ezconnect, tnsnames)
[~]
db_name and
domain_name.
rr
-Original Message-
From: tom r [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007 12:37 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: Re: TWO_TASK environment variable
hi ron,
thanks for the response. using sqlnet.ora just doesn't work for me. i
agree
strings inside single quotes are evaluated by the shell. they're just passed
straight to the program.
i suspect the problem may be as you suggested: i'm using the old version 8
style sid instead of a service name, although ezconnect with the sid works
fine inside of a perl program. i'll see
On 2007-01-19 12:01:29 -0800, Jonathan Leffler wrote:
system(VAR=val /path/to/your/shell/script);
Well, that worked nicely for me with Korn Shell (and would work with Bourne
Shell), but won't work with C shell (again).
On Unix-like systems the system() function always invokes /bin/sh, not
Array BioPharma, Inc.
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 17, 2007 8:59 AM
To: dbi-users@perl.org
Subject: environment variable
how can i export a variable from program perl to shell script through
environment
variable.
Thank you
Reidy, Ron wrote:
Oscar,
Short answer - you cannot (sort of). This is because your shell script
will execute in a sub shell of your perl program.
However, you can do something like this:
# untested
system(export VAR=val; /path/to/your/shell/script.sh);
The shell also takes a series of zero
.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 17, 2007 8:59 AM
To: dbi-users@perl.org
Subject: environment variable
how can i export a variable from program perl to shell script through
environment
variable
The standard Unix semantics is this: a child process inherits the
environment from its parent. Therefore if you (export and) set an
environment variable in a process and then run a script, it will see
that environment variable.
Furthermore, _Programming Perl, 3rd ed_ by Wall et all says
On Wed, Jan 17, 2007 at 8:59AM, Oscar Gomez wrote:
how can i export a variable from program perl to shell script through
environment variable.
This is not really a DBI question, so you will have better luck
posting this type of question to perl-monks
(http://www.perlmonks.org/) or similar forum
the shell script to Perl.
Oh, by the way: What is the relation of this question to Perl's Database
Interface?
Alexander
Oscar Gomez wrote:
how can i export a variable from program perl to shell script through environment
variable.
Thank you
--
Open WebMail Project (http://openwebmail.org
On 1/19/07, Jonathan Leffler [EMAIL PROTECTED] wrote:
The solution I proposed works [...]
I sent it on the 17th. Unfortunately, I only sent it to Oscar, not to
dbi-users as well.
Sorry - my mistake - both then and earlier today.
This subject should now be closed.
--
Jonathan Leffler
On Fri, 19 Jan 2007 13:52:40 -0600, David Dooling wrote:
Hi David
If you want the Perl program to alter the environment of the
process that executed it (a shell, cron, another script, etc.),
that is not possible.
Errr, actually it is possible, at least under Windows.
And that's another good
how can i export a variable from program perl to shell script through
environment
variable.
Thank you
--
Open WebMail Project (http://openwebmail.org)
I am getting this error:
ORACLE_HOME environment variable must be set
but when I type:
echo $ORACLE_HOME
I get:
/opt/oracle/product/9.2.0
Seems the ORACLE_HOME is set.
I have Oracle 9i R2 installed on Redhat9
Can anyone help with this error?
PROTECTED]
[EMAIL PROTECTED] cc:
28 Aug 2003 06:24 PM Subject: ORACLE_HOME environment
variable must
PerlDiscuss - Perl Newsgroups and mailing lists wrote:
I am getting this error:
ORACLE_HOME environment variable must be set
but when I type:
echo $ORACLE_HOME
I get:
/opt/oracle/product/9.2.0
Just out of curiosity, what do you get when running 'env | grep
ORACLE_HOME'?
If ORACLE_HOME shows
Hi, there,
I am using DB2 Runtime client (V7.2) on linux redhat 7.3.
I am try to install DBD:DB2 (0.76)that I can run perl program to remote
access database in the DB2 server.
I have successfully install DBI. When I do
Perl Makefile.PL
It failed, and the error message is
DB2_HOME environment
the
DBD::DB2 driver. DBD::DB2 requires some of the header files and
libraries that only come with the App Dev Client in order to compile.
I have successfully install DBI. When I do
Perl Makefile.PL
It failed, and the error message is
DB2_HOME environment variable must be set to installed
page as a
cgi script, I get the following error: "ORACLE_HOME environment variable not
set". The script would not work even I set the ORACLE_HOME environment
variable explicitly in the script. How to solve the problem? Do I need to
modify the web server configuration file? Thanks in advanc
To: [EMAIL PROTECTED]
Subject: ORACLE_HOME environment variable not set
Hello,
I installed Perl DBI and Oracle DBD locally under my own unix
directory. I
wrote a test a script to retrieve data from an Oracle
database. The script
worked perfectly under command line and I got the right data from
[mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 5:04 PM
To: [EMAIL PROTECTED]
Subject: ORACLE_HOME environment variable not set
Hello,
I installed Perl DBI and Oracle DBD locally under my own unix directory. I
wrote a test a script to retrieve data from an Oracle database. The script
EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 1:50 PM
Subject: RE: ORACLE_HOME environment variable not set
Actually, I'd question this. I get the same error(though i can still
connect). I've even put debuging code into the script that we use to
start apache and it shows that $ORACLE_HOME is
30 matches
Mail list logo