[Pacemaker] Oracle instance problem

[Dejan Muhamedagic]

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