Hi Dejan, Here's one of the output from "select status from v$instance" ; lnodbct:/appl01/app/oracle[dssd] sqlplus 'sys as sysdba'
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 14 15:42:25 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance; STATUS ------------ OPEN SQL> -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dejan Muhamedagic Sent: Monday, September 14, 2009 1:27 PM To: General Linux-HA mailing list Subject: Re: [Linux-HA] Where can I get a more update version of ocf:oracle/oralsnr scripts Hi, On Mon, Sep 14, 2009 at 10:48:15AM -0400, Bernie Wu wrote: > The oralsnr script is OK. > It is the oracle script that I had to modify. > > Here's the diff for oracle: > > 418c418,419 > < [ "`dbasql dbstat`" = OPEN ] > --- > > output="`dbasql dbstat`" > > echo "$output" | tail -1 | grep -qs '^OPEN' > 454c455 > < status="`dbasql dbstat`" > --- > > status="`dbasql dbstat | tail -1 | egrep > > '^OPEN|^STARTED|^MOUNTED' ` " > 482c483,484 > < status="`dbasql dbstat`" > --- > > status="`dbasql dbstat | tail -1 | grep '^MOUNTED' `" Hmm, where are the extra thirty or so (482-454) lines? :) Can you please provide the sample output of the sql dbstat command: select status from v$instance; And the Oracle release. Obviously Oracle changed the output. Thanks, Dejan > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Dejan Muhamedagic > Sent: Monday, September 14, 2009 7:08 AM > To: General Linux-HA mailing list > Subject: Re: [Linux-HA] Where can I get a more update version of > ocf:oracle/oralsnr scripts > > Hi, > > On Fri, Sep 11, 2009 at 03:14:18PM -0400, Bernie Wu wrote: > > Hi List, > > Where can I get a more update version of ocf:oracle and > > ocf:oralsnr startup/shutdown script. The version that came > > with Heartbeat 2.1.3 needs a lot of modifications to get it to > > work. > > The newest versions are at hg.linux-ha.org/agents. > > IIRC, neither of oracle RAs were changed much. Which > modifications do you have to make? > > Thanks, > > Dejan > > > > > TIA > > Bernie > > > > ________________________________ > > The information contained in this e-mail message is intended only for the > > personal and confidential use of the recipient(s) named above. This message > > may be an attorney-client communication and/or work product and as such is > > privileged and confidential. If the reader of this message is not the > > intended recipient or an agent responsible for delivering it to the > > intended recipient, you are hereby notified that you have received this > > document in error and that any review, dissemination, distribution, or > > copying of this message is strictly prohibited. If you have received this > > communication in error, please notify us immediately by e-mail, and delete > > the original message. > > _______________________________________________ > > 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 > > The information contained in this e-mail message is intended only for the > personal and confidential use of the recipient(s) named above. This message > may be an attorney-client communication and/or work product and as such is > privileged and confidential. If the reader of this message is not the > intended recipient or an agent responsible for delivering it to the intended > recipient, you are hereby notified that you have received this document in > error and that any review, dissemination, distribution, or copying of this > message is strictly prohibited. If you have received this communication in > error, please notify us immediately by e-mail, and delete the original > message. > _______________________________________________ > 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 The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message may be an attorney-client communication and/or work product and as such is privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
