[Linux-HA] Working with heartbeat::ocf:oracle

[Dejan Muhamedagic]

Hi,

On Mon, Feb 04, 2008 at 07:54:55AM +0100, Stefano Cislaghi wrote:
> Running with root  seems not to find sqlplus binary. And it's correct,
> as normally root doesn't need oracle PATH.
> Running as oracle user seems working.
> Putting the sqlplus PATH to profiles solves problem, but is not really
> correct to use the oracle PATH in the root user.

AFAIK, all Oracle programs are run as oracle user. That'd include
sqlplus. Can you please post the output of the script when run as
root.

Thanks,

Dejan

> Stefano
> 
> On Feb 1, 2008 6:21 PM, Dejan Muhamedagic <dejanmm at fastmail.fm> wrote:
> > Hi,
> >
> >
> > On Fri, Feb 01, 2008 at 02:27:27PM +0100, Stefano Cislaghi wrote:
> > > Hello,
> > >
> > > does anyone found this function heartbeat::ocf:oracle working?
> > >
> > > In my case oracle isn't started up.without any apparent warning.
> >
> > > Feb  1 14:25:43 rman1a pengine: [4297]: info: determine_online_status:
> > > Node rman1a is online
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: group_print: Resource
> > > Group: Oracle
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: native_print:
> > > R_VIP (heartbeat::ocf:IPaddr2):       Started rman1a
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: native_print:
> > > R_DRBD        (heartbeat:drbddisk):   Started rman1a
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: native_print:
> > > R_FS_OFA      (heartbeat::ocf:Filesystem):    Started rman1a
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: native_print:
> > > R_LSNR        (heartbeat::ocf:oralsnr):       Started rman1a
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: native_print:
> > > R_ORA (heartbeat::ocf:oracle):        Stopped
> > > Feb  1 14:25:43 rman1a pengine: [4297]: WARN: native_color: Resource
> > > R_ORA cannot run anywhere
> > > Feb  1 14:25:43 rman1a crmd: [4290]: info: do_state_transition: State
> > > transition S_POLICY_ENGINE -> S_TRANSITION_ENGINE [ input=I_PE_SUCCESS
> > > cause=C_IPC_MESSAGE origin=route_message ]
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: NoRoleChange: Leave
> > > resource R_VIP      (rman1a)
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: NoRoleChange: Leave
> > > resource R_DRBD     (rman1a)
> > > Feb  1 14:25:43 rman1a tengine: [4296]: info: unpack_graph: Unpacked
> > > transition 18: 0 actions in 0 synapses
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: NoRoleChange: Leave
> > > resource R_FS_OFA   (rman1a)
> > > Feb  1 14:25:43 rman1a crmd: [4290]: info: do_state_transition: State
> > > transition S_TRANSITION_ENGINE -> S_IDLE [ input=I_TE_SUCCESS
> > > cause=C_IPC_MESSAGE origin=route_message ]
> > > Feb  1 14:25:43 rman1a tengine: [4296]: info: run_graph: Transition
> > > 18: (Complete=0, Pending=0, Fired=0, Skipped=0, Incomplete=0)
> > > Feb  1 14:25:43 rman1a pengine: [4297]: notice: NoRoleChange: Leave
> > > resource R_LSNR     (rman1a)
> > > Feb  1 14:25:43 rman1a tengine: [4296]: info: notify_crmd: Transition
> > > 18 status: te_complete - <null>
> > > Feb  1 14:25:43 rman1a cib: [5404]: info: write_cib_contents: Wrote
> > > version 0.17.1 of the CIB to disk (digest:
> > > 3c6a1676bda8b79590522c576249304d)
> > >
> >
> > You didn't provide enough information. There must have been a
> > reason why oracle didn't start. You can also test it easily
> > yourself on the command line:
> >
> > # export OCF_ROOT=/usr/lib/ocf
> > # OCF_RESKEY_sid=... /usr/lib/ocf/resource.d/heartbeat/oracle start
> >
> > Thanks,
> >
> > Dejan
> >
> > >
> > > Thanks
> > > Stefano
> > > _______________________________________________
> > > Linux-HA mailing list
> > > Linux-HA at lists.linux-ha.org
> > > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > > See also: http://linux-ha.org/ReportingProblems
> > _______________________________________________
> > Linux-HA mailing list
> > Linux-HA at lists.linux-ha.org
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
> >
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems