dejanmm at fastmail
Nov 13, 2009, 8:07 AM
Post #2 of 2
(487 views)
Permalink
|
|
Re: small fix for "oracle" resource when using more than one Oracle instance
[In reply to]
|
|
Hi,
On Thu, Nov 12, 2009 at 05:17:50PM +0100, Zimmermann, Pierre wrote:
> Dear Dejan Muhamedagic
> We have used your oracle resource script to build an Oracle Cluster on SLES11 HAE. Many TNX for that.
Welcome.
> Coz we use more than one Oracle instance we were forced with a small problem:
>
> Oracle was not able to start due to a missing SID. (we have not set the ORACLE_SID variable in the profile, because we have more than one)
> But the SID was given as a parameter for the oracle resource instead.
> The problem was, that the variable $ORACLE_SID was not forwarded to the sqlplus statement in the execsql function. It get lost after the “su - $ORACLE_USER”
That shouldn't have happened, but obviously it does. I could
swear that I tested it with multiple Oracle instances, but that
was ages ago.
> So our solution was to set the ORACLE_SID explicit in this statement within the “su –“ in Line 256. This works fine:
> su - $ORACLE_OWNER -c "export ORACLE_SID=$ORACLE_SID; $sqlplus -S /nolog"
That certainly wouldn't hurt, but I can see that there are more
variables exported. I guess the best would be to create a
temporary file and then to source it. Any chance that you test
oracle/oralsnr with the patch from these changesets:
changeset: 1535:c9662d9664cf
tag: tip
user: Dejan Muhamedagic <dejan [at] hello-penguin>
date: Fri Nov 13 17:05:21 2009 +0100
summary: Dev: oracle/oralsnr: add dumporaenv function
changeset: 1534:bbb8076083ab
user: Dejan Muhamedagic <dejan [at] hello-penguin>
date: Fri Nov 13 17:03:49 2009 +0100
summary: Medium: oracle/oralsnr: export variables properly
Also attached.
Cheers,
Dejan
>
> cu
> Taras Grytsulyak and Pierre Zimmermann
>
> Mit freundlichen Grüßen / Kind regards
>
> Pierre Zimmermann
> Professional Systems
>
> SMP Management AG
> Heidenkampsweg 101
> D-20253 Hamburg
>
> M: +49 162 2 4444 - 29
> F: +49 162 50 2 4444 - 29
>
> T: +49 40 3289 1980 - 0
> F: +49 40 3289 1980 - 99
>
> E-Mail: Pierre.Zimmermann [at] smp-it
> Internet: http://www.smp-it.com
>
> Rechtsform: AG - Vorstand: Marcus Heese – Olaf Gnosa – Stefan van der Weck
> Aufsichtsratsvorsitzende: Doris Dierbach
> Registergericht: Amtsgericht Hamburg - Registernummer: HRB 104985
> P Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken - Please think about the environment before printing this email.
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
|
oracle
