dejanmm at fastmail
Oct 12, 2009, 3:49 AM
Post #8 of 8
(756 views)
Permalink
|
|
Re: Where can I get a more update version of ocf:oracle/oralsnr scripts
[In reply to]
|
|
Hi,
On Tue, Sep 15, 2009 at 03:28:02PM +0200, Dejan Muhamedagic wrote:
> 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:'".
I updated the oracle agent to "grep -v '^ENV MSG:'" since there
can't be any ill effect from that. That may help in your case.
You should update to this version, because the changes you made
don't cover all functions, so you may run into problems.
Thanks,
Dejan
> 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: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] 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: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] 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: linux-ha-bounces [at] lists [mailto:linux-ha-bounces [at] lists] 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
> > > > > Linux-HA [at] lists
> > > > > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > > > > See also: http://linux-ha.org/ReportingProblems
> > > > _______________________________________________
> > > > Linux-HA mailing list
> > > > Linux-HA [at] lists
> > > > 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
> > > > Linux-HA [at] lists
> > > > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > > > See also: http://linux-ha.org/ReportingProblems
> > > _______________________________________________
> > > Linux-HA mailing list
> > > Linux-HA [at] lists
> > > 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
> > > Linux-HA [at] lists
> > > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > > See also: http://linux-ha.org/ReportingProblems
> > _______________________________________________
> > Linux-HA mailing list
> > Linux-HA [at] lists
> > 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
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
|
showdbstat.txt
