[Pacemaker] Oracle instance problem

[Dejan Muhamedagic]

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