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

[Miroslav Strugarevic]

On Feb 4, 2008 5:37 PM, Miroslav Strugarevic <strugarevic at gmail.com> wrote:
> Hi,
>
> can you please run oracle script from terminal and see what happens...
> # usr/lib/ocf/resource.d/heartbeat/oracle start
>
> You didn't gave use enough data for troubleshooting :(
>
> p.s. Sorry for my bad English
>
>
> On Feb 4, 2008 5:30 PM, Stefano Cislaghi <s.cislaghi at gmail.com> wrote:
> > But see here. On my system in ha.cf there's
> >
> > crm yes
> > apiauth cibmon   uid=hacluster
> > respawn hacluster /usr/lib/heartbeat/cibmon -d
> >
> > [root at rman1c ~]# id hacluster
> > uid=498(hacluster) gid=496(haclient) groups=496(haclient)
> >
> > [root at rman1c ~]# ps -ef | grep hea
> > root      4075     1  0 17:14 ?        00:00:00 heartbeat: master
> > control process
> > nobody    4078  4075  0 17:14 ?        00:00:00 heartbeat: FIFO reader
> > nobody    4079  4075  0 17:14 ?        00:00:00 heartbeat: write: ucast eth0
> > nobody    4080  4075  0 17:14 ?        00:00:00 heartbeat: read: ucast eth0
> > nobody    4081  4075  0 17:14 ?        00:00:00 heartbeat: write: ucast eth1
> > nobody    4082  4075  0 17:14 ?        00:00:00 heartbeat: read: ucast eth1
> > 498       4087  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/ccm
> > 498       4088  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/cib
> > root      4089  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/lrmd -r
> > nobody    4090  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/stonithd
> > 498       4091  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/attrd
> > 498       4092  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/crmd
> > root      4093  4075  0 17:14 ?        00:00:02 /usr/lib/heartbeat/mgmtd -v
> > 498       4094  4075  0 17:14 ?        00:00:00 /usr/lib/heartbeat/cibmon -d
> > 498       4097  4092  0 17:14 ?        00:00:00 /usr/lib/heartbeat/tengine
> > 498       4098  4092  0 17:14 ?        00:00:00 /usr/lib/heartbeat/pengine
> > root      4347  3431  0 17:29 pts/0    00:00:00 grep hea
> >
> > In a strange way system use id and not name. Very strange. Oracle not
> > run. In the log file I can read again problem with sqlplus. Now
> > sqlplus is in /etc/profile so is visible by all users, fake or not.
> > Can be all a problem related to ha?
> >
> > Thanks
> > Ste
> >
> > _______________________________________________
> > 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
> >
>
Hi,

sorry I forgot to mention one little thing :)

Try to bind Oracle parameters to oracle script directyle.
Insert something like this into the script:

OCF_RESKEY_sid=SID; export OCF_RESKEY_sid
OCF_RESKEY_home=/opt/oracle/product/10.2.0; export OCF_RESKEY_home
OCF_RESKEY_user=oracle; export OCF_RESKEY_user

Don't use GUI to populate Oracle parameters for the script and try then:

# /usr/lib/ocf/resource.d/heartbeat/oracle start