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
