Hi Bernie, On Tue, Sep 15, 2009 at 08:39:50AM -0400, Bernie Wu wrote: > Hi Dejan, > Here's the output from the new oracle RA : > > # ./oracle showdbstat > Full output: > ENV MSG: Server Express environment enabled > SP2-0640: Not connected
Hmm, expected the Full output to include everything. Looks like the /nolog option drops most stuff. > Stripped output: > <ENV MSG: Server Express environment enabled > OPEN> OK. The question is how to get rid of that "ENV MSG: ...". Is there an option to suppress that output? Any idea? If not, perhaps we could just do "grep -v '^ENV MSG:'". Thanks, Dejan > I also turned debug and verbose on and reran the oracle RA. The output is > attached as showdbstat.txt > > If there is anything else you want me to try, let me know. > > Bernie. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Dejan Muhamedagic > Sent: Tuesday, September 15, 2009 6:36 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 Bernie, > > On Mon, Sep 14, 2009 at 03:46:14PM -0400, Bernie Wu wrote: > > 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> > > Thanks for the output, but I'd actually need that with some sets > beforehand, sorry about not being more specific. You should > simulated what the oracle RA does (the dbasql() function): > > connect / as sysdba > set feedback off > set heading off > set pagesize 0 > > It's important that the output is stripped of everything but the > actual result. If that can't be done, then more changes are > needed. I just implemented a new action showdbstat which you may > use to print what I need. You'll just have to run the script from > the command line: > > # export OCF_ROOT=/usr/lib/ocf > # OCF_RESKEY_sid=YOURSID .../oracle showdbstat > > Get the new RA from http://hg.linux-ha.org/agents. > > BTW, you can run the new script from any location, i.e. you don't > have to overwrite the existing oracle RA. > > Thanks, > > Dejan > > > > -----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 > _______________________________________________ > 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
