Hi, On Fri, Jan 30, 2009 at 01:21:22PM +0900, Junko IKEDA wrote: > Hi, > > We have also tested oracle/oralsnr RA, > but we didn't find any probrems about the environment variable. > > > 1.) The environment variable PATH is defined but not exported in function > > setoraenv(). > > well, it sure is fummy that the defined value isn't exported...
I've never seen PATH not exported. Are you sure it is not? You can check by running e.g. export | grep -w PATH > > 2.) The environment settings are prepared but not exported to the oracle > > owner in the else part of function runasdba(). > > "su" command with "-" opution can refrect the user's environment, right? > RA, itself, would be executed by "root" user, > but it seems that "su - oracle" call the oracle user's environment > correctory and sql command is executed as expected. 'su -' is used exactly because the environment should be set correctly by the profile scripts of the oracle user. > The above two points are the same to oracle RA. > Could you please tell me some trouble examples which these bugs(?) would be > a couse? > If I get something wrong, please point it out. I suspect that the problem may be with the environment of the oracle user. It would be interesting to see how exactly the RA fails. Thanks, Dejan > Thanks, > Junko > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of > > [email protected] > > Sent: Monday, January 26, 2009 9:42 PM > > To: [email protected] > > Subject: [Linux-HA] Bug report heartbeat-2.1.4-2.1 (SUSE Linux Enterprise > > Server 10 x86_64, 2.6.16.60-0.33-smp) - oracle, oralsnr > > Importance: High > > > > Hi all, > > > > we found some bugs in "/usr/lib/ocf/resource.d/heartbeat/oracle" and > > "/usr/lib/ocf/resource.d/heartbeat/oralsnr". > > > > Bugs in "/usr/lib/ocf/resource.d/heartbeat/oralsnr": > > > > 1.) The environment variable PATH is defined but not exported in function > > setoraenv(). > > Fix: exchange the line > > export LD_LIBRARY_PATH LIBPATH > > by the line > > export LD_LIBRARY_PATH LIBPATH PATH > > > > 2.) The environment settings are prepared but not exported to the oracle > > owner in the else part of function runasdba(). > > Fix: exchange the line > > su - $ORACLE_OWNER > > by the line > > su $ORACLE_OWNER > > > > Bugs in "/usr/lib/ocf/resource.d/heartbeat/oracle": > > > > 3.) The environment variable PATH is defined but not exported in function > > setoraenv(). > > Fix: exchange the line > > export LD_LIBRARY_PATH LIBPATH > > by the line > > export LD_LIBRARY_PATH LIBPATH PATH > > > > 4.) The environment settings are prepared but not exported to the oracle > > owner in the else part of function execsql(). > > Fix: exchange the line > > su - $ORACLE_OWNER -c "$sqlplus -S /nolog" > > by the line > > su $ORACLE_OWNER -c "$sqlplus -S /nolog" > > > > Are these bugs known and already fixed? > > If the bugs are already fixed please send us the bugfix. > > If the bugs are not yet fixed please validate our changes and give us a > > feedback / send us your bugfix. > > > > Fixed Versions: > > > > > > > > Original files: > > > > > > > > > > Best regards, > > Helfried Tatzl > > > > Helfried Tatzl, DI > > System Administration > > -------------------------------------------------- > > Tel.: +43 3842 805-915 > > Fax: +43 3842 805-900 > > [email protected] > > www.KNAPP.com > > -------------------------------------------------- > > KNAPP Systemintegration GmbH > > Waltenbachstra?e 9 > > 8700 Leoben, ?sterreich > > -------------------------------------------------- > > Firmenbuchnummer: FN 138870x > > Firmenbuchgericht: Leoben > > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
