Antw: Re: Oracle OCF Script throws "SP2-0640: Not connected"

"Ulrich Windl" <[email protected]>
Newsgroups gmane.linux.highavailability.user
Message-ID <[email protected]>
Maybe it helps, but in my former life passwords tended to expire on Wednesdays
;-)

>>> emmanuel segura <[email protected]> schrieb am 05.08.2014 um 12:37 in
Nachricht
<CAE7pJ3AMPsdE3UZb-x_CuW9AxMYMSJs6EUt-0C1KW7yGddLn+A@mail.gmail.com>:
> i'm using resource-agents-3.9.2-0.25.5 on Suse 11 Sp2 and i don't have any
"
> 
> . /usr/lib/ocf/lib/heartbeat/ora-common.sh" maybe you need to create a
> new database user
> 
> ++ local 'conn_s=connect OCFMON/OCFMON'
> ++ shift 1
> ++ local func
> ++ echo 'connect OCFMON/OCFMON'
> 
> 
> 2014-08-01 18:40 GMT+02:00 Wendt Christian <[email protected]>:
>> Hello *,
>>
>> i did a lot of research but i´m not able to get the purpose whether our 
> oracle ressource fails on Wednesday.
>>
>> Oracle start will fail with the message:
>>
>> /usr/lib/ocf/resource.d/heartbeat/oracle start
>> INFO: orcSNBGW instance state is not OPEN (dbstat output: SP2-0640: Not 
> connected)
>> ERROR: oracle instance orcSNBGW not started:
>>
>> Showdbstat throws:
>>
>> /usr/lib/ocf/resource.d/heartbeat/oracle showdbstat
>> Full output:
>> SP2-0640: Not connected
>> Stripped output:
>> <OPEN>
>> So the first method of showdbstat monitoring the DB fails, but the second 
> one succeeds.
>>
>> It is not possible to start oracle within the pacemaker cluster anymore. 
> Everytime we start it, it´ll fail. I´ve attached the bash output while 
> starting oracle with the ocf script.
>>
>> Database and OS is fine. Nothing changed in the last days.
>>
>> Do have any ideas?
>>
>> Thank you in advance.
>>
>> Mit freundlichen Grüßen / Best regards
>>
>> Christian Wendt
>>
>> Bosch Software Innovations GmbH
>> Information Technology (INST/PRV3-IT)
>> Schöneberger Ufer 89-91
>> 10785 Berlin
>> GERMANY
>> www.bosch-si.de 
>> www.blog.bosch-si.com 
>>
>> Tel. +49 30.72 61 12-308
>> Fax +49 30.72.61.12-100
>> [email protected] 
>>
>> Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB

> 148411 B
>> Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle
>>
>>
>> _______________________________________________
>> Linux-HA mailing list
>> [email protected] 
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha 
>> See also: http://linux-ha.org/ReportingProblems 
> 
> 
> 
> -- 
> esta es mi vida e me la vivo hasta que dios quiera
> _______________________________________________
> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.