[Pacemaker] 6. Re: Oracle instance problem (Dejan Muhamedagic)

Sucheta sucheta at ee.iitb.ac.in
Thu Jan 10 02:15:11 EST 2013


Hi,

Thanks a lot for the reply.
It was a problem of oracle installation. Oracle processes were running as
Oracle.bin instead of the usual ora_*_ORACLE_SID.
So had to correct it. Then the OCF script worked finely.

Also I am trying to use JBoss 7.1.1  through LCMC. But the OCF script and
LCMC parameters are for JBoss 4. Can you help me with this?


Thanks & Regards,
Sucheta

On Thu, Jan 10, 2013 at 12:33 AM, <pacemaker-request at oss.clusterlabs.org>wrote:

> Send Pacemaker mailing list submissions to
>         pacemaker at oss.clusterlabs.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> or, via email, send a message with subject or body 'help' to
>         pacemaker-request at oss.clusterlabs.org
>
> You can reach the person managing the list at
>         pacemaker-owner at oss.clusterlabs.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pacemaker digest..."
>
>
> Today's Topics:
>
>    1. Re: crm shell binaries (Dejan Muhamedagic)
>    2. Re: Oracle instance problem (Dejan Muhamedagic)
>    3. Re: Oracle instance problem (emmanuel segura)
>    4. cib.xml of version 1.0.5 (E-Blokos)
>    5. Ordering resource groups (aRaviNd)
>    6. Re: Oracle instance problem (Dejan Muhamedagic)
>    7. Re: Oracle instance problem (emmanuel segura)
>    8. Postresql streaming replication support (Keith Ouellette)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 9 Jan 2013 13:03:57 +0100
> From: Dejan Muhamedagic <dejanmm at fastmail.fm>
> To: The Pacemaker cluster resource manager
>         <pacemaker at oss.clusterlabs.org>
> Subject: Re: [Pacemaker] crm shell binaries
> Message-ID: <20130109120356.GA9708 at walrus.homenet>
> Content-Type: text/plain; charset=us-ascii
>
> On Wed, Jan 09, 2013 at 11:14:17AM +0200, Dan Frincu wrote:
> > @Dejan, @LMB
> >
> > Could you guys post binaries of crmsh for RedHat, Debian?
>
> https://savannah.nongnu.org/projects/crmsh/
>
> Take a look at the latest news item.
>
> For the lazy:
>
> http://download.opensuse.org/repositories/network:/ha-clustering/
>
> Debian packages are handled by Debian.
>
> Thanks,
>
> Dejan
>
> > Regards,
> > Dan
> >
> > --
> > Dan Frincu
> > CCNA, RHCE
> >
> > _______________________________________________
> > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> >
> > Project Home: http://www.clusterlabs.org
> > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > Bugs: http://bugs.clusterlabs.org
>
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 9 Jan 2013 13:12:05 +0100
> From: Dejan Muhamedagic <dejanmm at fastmail.fm>
> To: pacemaker at oss.clusterlabs.org
> Subject: Re: [Pacemaker] Oracle instance problem
> Message-ID: <20130109121205.GB9708 at walrus.homenet>
> Content-Type: text/plain; charset=us-ascii
>
> Hi,
>
> On Wed, Jan 09, 2013 at 03:38:08PM +0530, Sucheta wrote:
> > Hi,
> >
> > Following is the oracle instance startup problem.
> >
> > I am able to successfully start oracle listener using LCMC. However when
> i
> > tried to start oracle instance the start process seems to continue for
> ever
> > and ever. The database version used is oracle 10gR2. Please find the logs
> > and version details specified below. Please help me in this regards.
> >
> >
> > pacemaker : pacemaker 1.1.7-6-el6.x86_64
> > corosync : corosync 1.4.1-7.el6_3.1.x86_64
> > LCMC : 1.4.5
>
> Which version of resource-agents? I'd suggest updating to 3.9.3.
> The oracle RA has some important fixes.
>
> Perhaps take a look here:
>
> > Jan  9 09:23:19 VirtKirchoff oracle(res_oracle_1)[13746]: INFO: ORA-01081
> > error found, trying to cleanup oracle (dbstart_mount output: ORA-01081:
> > cannot start already-running ORACLE - shut it down first)
> > Jan  9 09:23:19 VirtKirchoff lrmd: [7559]: info: RA output:
> > (res_oracle_1:start:stderr) ls: cannot access
> > /u01/app/oracle/product/10.2.0/db_1/dbs/lk*: No such file or directory
> > Jan  9 09:23:19 VirtKirchoff oracle(res_oracle_1)[13746]: ERROR: oracle
> > ORCL can not be mounted (status: OPEN)
>
> I think that here 'startup mount' fails. You should take a look
> at the oracle logs too.
>
> Thanks,
>
> Dejan
>
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 9 Jan 2013 14:19:41 +0100
> From: emmanuel segura <emi2fast at gmail.com>
> To: The Pacemaker cluster resource manager
>         <pacemaker at oss.clusterlabs.org>
> Subject: Re: [Pacemaker] Oracle instance problem
> Message-ID:
>         <
> CAE7pJ3Ca3+78ZrCZAsUc5UGHCe6-Lp_-3iBR8N3WQJWsraudQg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello
>
> Maybe that isn't the problem, but before you try to start oracle from
> pacemaker, try to see if there is a share memory segment allocated from
> oracle and no deallocated
>
> ipcs command can help you
>
> 2013/1/9 Dejan Muhamedagic <dejanmm at fastmail.fm>
>
> > Hi,
> >
> > On Wed, Jan 09, 2013 at 03:38:08PM +0530, Sucheta wrote:
> > > Hi,
> > >
> > > Following is the oracle instance startup problem.
> > >
> > > I am able to successfully start oracle listener using LCMC. However
> when
> > i
> > > tried to start oracle instance the start process seems to continue for
> > ever
> > > and ever. The database version used is oracle 10gR2. Please find the
> logs
> > > and version details specified below. Please help me in this regards.
> > >
> > >
> > > pacemaker : pacemaker 1.1.7-6-el6.x86_64
> > > corosync : corosync 1.4.1-7.el6_3.1.x86_64
> > > LCMC : 1.4.5
> >
> > Which version of resource-agents? I'd suggest updating to 3.9.3.
> > The oracle RA has some important fixes.
> >
> > Perhaps take a look here:
> >
> > > Jan  9 09:23:19 VirtKirchoff oracle(res_oracle_1)[13746]: INFO:
> ORA-01081
> > > error found, trying to cleanup oracle (dbstart_mount output: ORA-01081:
> > > cannot start already-running ORACLE - shut it down first)
> > > Jan  9 09:23:19 VirtKirchoff lrmd: [7559]: info: RA output:
> > > (res_oracle_1:start:stderr) ls: cannot access
> > > /u01/app/oracle/product/10.2.0/db_1/dbs/lk*: No such file or directory
> > > Jan  9 09:23:19 VirtKirchoff oracle(res_oracle_1)[13746]: ERROR: oracle
> > > ORCL can not be mounted (status: OPEN)
> >
> > I think that here 'startup mount' fails. You should take a look
> > at the oracle logs too.
> >
> > Thanks,
> >
> > Dejan
> >
> > _______________________________________________
> > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> >
> > Project Home: http://www.clusterlabs.org
> > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > Bugs: http://bugs.clusterlabs.org
> >
>
>
>
> --
> esta es mi vida e me la vivo hasta que dios quiera
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://oss.clusterlabs.org/pipermail/pacemaker/attachments/20130109/c5b7f34f/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 4
> Date: Wed, 9 Jan 2013 09:27:32 -0500
> From: "E-Blokos" <infos at e-blokos.com>
> To: "The Pacemaker cluster resource manager"
>         <pacemaker at oss.clusterlabs.org>
> Subject: [Pacemaker] cib.xml of version 1.0.5
> Message-ID: <18F6219B113249288BB34EC97AAA1C56 at e1705>
> Content-Type: text/plain; charset="windows-1252"
>
> Hi,
>
> I'm planning to update pacemaker from 1.0.5 to 1.1.8
> is my cib.xml can be used as this ?
>
> Thanks
>
> Franck
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://oss.clusterlabs.org/pipermail/pacemaker/attachments/20130109/b6dd7452/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 5
> Date: Wed, 9 Jan 2013 21:28:55 +0530
> From: aRaviNd <ambadiaravind at gmail.com>
> To: pacemaker at oss.clusterlabs.org
> Subject: [Pacemaker] Ordering resource groups
> Message-ID:
>         <
> CAFhtsc1i5-kg49xAjG3nTaLJVxy91KeEGAN+1XKWzp7tBHeyEA at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
>
> I have configured 2 node cluster using pacemaker and corosync in Debian.
> One resource group is configured for cluster filesystem ocfs2 which contain
> resources dlm, o2cb, clvm etc. This resource group is cloned to run on both
> the servers.
>
> Another resource group is configured for service icinga with resources
> mysql, ido2db and icinga.
>
> I need to configure ordering constraint to start icinga resource group
> after ocfs resource group.
>
> But when i configure the ordering constraint it says no resource or
> template by name ocfs resource group name.
>
> Could you please let me know if it possible to configure ordering with
> resource group.
>
> If it is not possible how can i achieve the above configuration.
>
> Thanks in advance.
>
> Rgds,
> Aravind M D
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://oss.clusterlabs.org/pipermail/pacemaker/attachments/20130109/46b24724/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 6
> Date: Wed, 9 Jan 2013 17:04:50 +0100
> From: Dejan Muhamedagic <dejanmm at fastmail.fm>
> To: The Pacemaker cluster resource manager
>         <pacemaker at oss.clusterlabs.org>
> Subject: Re: [Pacemaker] Oracle instance problem
> Message-ID: <20130109160449.GA12740 at walrus.homenet>
> Content-Type: text/plain; charset=us-ascii
>
> Hi,
>
> On Wed, Jan 09, 2013 at 02:19:41PM +0100, emmanuel segura wrote:
> > Hello
> >
> > Maybe that isn't the problem, but before you try to start oracle from
> > pacemaker, try to see if there is a share memory segment allocated from
> > oracle and no deallocated
> >
> > ipcs command can help you
>
> The oracle RA tries to take care of that too. See the ipcrm
> parameter and the dumpinstipc command.
>
> Thanks,
>
> Dejan
>
> > 2013/1/9 Dejan Muhamedagic <dejanmm at fastmail.fm>
> >
> > > Hi,
> > >
> > > On Wed, Jan 09, 2013 at 03:38:08PM +0530, Sucheta wrote:
> > > > Hi,
> > > >
> > > > Following is the oracle instance startup problem.
> > > >
> > > > I am able to successfully start oracle listener using LCMC. However
> when
> > > i
> > > > tried to start oracle instance the start process seems to continue
> for
> > > ever
> > > > and ever. The database version used is oracle 10gR2. Please find the
> logs
> > > > and version details specified below. Please help me in this regards.
> > > >
> > > >
> > > > pacemaker : pacemaker 1.1.7-6-el6.x86_64
> > > > corosync : corosync 1.4.1-7.el6_3.1.x86_64
> > > > LCMC : 1.4.5
> > >
> > > Which version of resource-agents? I'd suggest updating to 3.9.3.
> > > The oracle RA has some important fixes.
> > >
> > > Perhaps take a look here:
> > >
> > > > Jan  9 09:23:19 VirtKirchoff oracle(res_oracle_1)[13746]: INFO:
> ORA-01081
> > > > error found, trying to cleanup oracle (dbstart_mount output:
> ORA-01081:
> > > > cannot start already-running ORACLE - shut it down first)
> > > > Jan  9 09:23:19 VirtKirchoff lrmd: [7559]: info: RA output:
> > > > (res_oracle_1:start:stderr) ls: cannot access
> > > > /u01/app/oracle/product/10.2.0/db_1/dbs/lk*: No such file or
> directory
> > > > Jan  9 09:23:19 VirtKirchoff oracle(res_oracle_1)[13746]: ERROR:
> oracle
> > > > ORCL can not be mounted (status: OPEN)
> > >
> > > I think that here 'startup mount' fails. You should take a look
> > > at the oracle logs too.
> > >
> > > Thanks,
> > >
> > > Dejan
> > >
> > > _______________________________________________
> > > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> > >
> > > Project Home: http://www.clusterlabs.org
> > > Getting started:
> http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > > Bugs: http://bugs.clusterlabs.org
> > >
> >
> >
> >
> > --
> > esta es mi vida e me la vivo hasta que dios quiera
>
> > _______________________________________________
> > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> >
> > Project Home: http://www.clusterlabs.org
> > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > Bugs: http://bugs.clusterlabs.org
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 9 Jan 2013 17:25:19 +0100
> From: emmanuel segura <emi2fast at gmail.com>
> To: The Pacemaker cluster resource manager
>         <pacemaker at oss.clusterlabs.org>
> Subject: Re: [Pacemaker] Oracle instance problem
> Message-ID:
>         <
> CAE7pJ3B78OBvnP3_+K36bfP-8zDU2nd4hgSwDEEtntdzLLeC_g at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hejjo Dejan
>
> use ocf-test to see why you have this tow errors
> 1: cannot start already-running ORACLE - shut it down first)
> 2: /u01/app/oracle/product/10.2.0/db_1/dbs/lk*: No such file or directory
>
> Thanks
>
> 2013/1/9 Dejan Muhamedagic <dejanmm at fastmail.fm>
>
> > cannot start already-running ORACLE - shut it down first)
>
>
>
>
>
> --
> esta es mi vida e me la vivo hasta que dios quiera
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://oss.clusterlabs.org/pipermail/pacemaker/attachments/20130109/27cd2c61/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 8
> Date: Wed, 9 Jan 2013 18:56:51 +0000
> From: Keith Ouellette <Keith.Ouellette at Airgas.com>
> To: "pacemaker at oss.clusterlabs.org" <pacemaker at oss.clusterlabs.org>
> Subject: [Pacemaker] Postresql streaming replication support
> Message-ID:
>         <417C5AF7C228B94490192951394BEFE7ACB6DF at AIPHLEXDAG01B.airgas.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> We have a critical application that uses PostgreSQL as its database. For
> high availability we are have the servers running as master and slaves
> using Pacemaker and openAIS/Corosync. The server pairs are geographically
> separated connected with a bridged VPN. We have Pacemaker working with our
> applications and had PostgreSQL with DRBD functioning. However, our network
> conditions was affecting the DRBD replication too greatly. I was asled to
> look at using write ahead logging (WAL) streaming mode as an alternative to
> replicating the database. I have replication without pacemaker now working.
>
>
>
>   Now I am trying to get that integrated with pacemaker. In my searches, I
> see that pacemaker with DRBD seems to be the prevelant implementation an
> most documentation was written around that. However, due to our network
> conditions, I am looking for information on doing this with WAL. I did find
> a resource agent that was wirtten for what I am doing (
> https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication).
> The issue is the example if complex with the explanation written only
> toward that example. Is there another place that I can get documentation
>  on this resource agent? Is there another way that this could be
> accmoplished that someone has tried?
>
>
>
> Please let me know.
>
> Keith
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://oss.clusterlabs.org/pipermail/pacemaker/attachments/20130109/e5f79d7e/attachment.html
> >
>
> ------------------------------
>
> _______________________________________________
> Pacemaker mailing list
> Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
>
> End of Pacemaker Digest, Vol 62, Issue 17
> *****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/pacemaker/attachments/20130110/4b4270cc/attachment-0002.html>


More information about the Pacemaker mailing list