Dear Dejan Muhamedagic
We have used your oracle resource script to build an Oracle Cluster on SLES11 
HAE. Many TNX for that.
 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”
 
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"
 
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:  [email protected]
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.
 

Attachment: oracle
Description: Binary data

_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Reply via email to