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.
Stefano On Feb 1, 2008 6:21 PM, Dejan Muhamedagic <[EMAIL PROTECTED]> 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 > > [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 > _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
