Mailing List Archive

Antw: Re: Oracle OCF Script throws "SP2-0640: Not connected"
Maybe it helps, but in my former life passwords tended to expire on Wednesdays
;-)

>>> emmanuel segura <emi2fast@gmail.com> 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 <Christian.Wendt@bosch-si.com>:
>> 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
>> christian.Wendt@bosch-si.com
>>
>> Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB

> 148411 B
>> Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle
>>
>>
>> _______________________________________________
>> Linux-HA mailing list
>> Linux-HA@lists.linux-ha.org
>> 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
> Linux-HA@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems


_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems