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... > 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. 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. 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
