Re: Oracle OCF Script throws "SP2-0640: Not connected"
emmanuel segura <[email protected]>
| Newsgroups | gmane.linux.highavailability.user |
|---|---|
| Message-ID | <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