Re: Using GRID Infrastructure to control third party applicaitons?

-Mark

On Mon, Jan 25, 2016 at 2:03 PM, Andrei Dumitru <andrei048_at_gmail.com> wrote:

> Hi Mark,
>
> We have also used 11g GI to control OEM in a cold failover cluster and
> it worked. The script used is just a customised version of the example
> given here[1].
>
> [1]
> http://docs.oracle.com/cd/E11882_01/rac.112/e41959/resatt.htm#CWADD91495
>
>
> Cheers,
> Andrei
>
> On Mon, Jan 25, 2016 at 5:45 PM, Ilmar Kerm <ilmar.kerm_at_gmail.com> wrote:
> > Hi
> >
> > We have run it successfully for years to provide high availability for
> MySQL
> > and currently I'm also setting it up to have a cold standby for Oracle
> > database in Windows.
> >
> > I haven't seen the attributes START_PROGRAM,STOP_PROGRAM and PID_FILES.
> Are
> > they new in 12.1?
> > In 11.2 I've only used attribute ACTION_SCRIPT that points to the script
> > that handles startup/stop and check actions.
> >
> > Could you have problem with the check action? After start and stop
> actions
> > clusterware will also invoke check action to verify that startup/shutdown
> > was successful.
> > You could verify it from scriptagent logfile:
> > $CRS_HOME/log/<hostname>/agent/crsd/scriptagent_<username>
> > It logs all the actions executed and the responses.
> >
> > My old presentation about this topic:
> >
> http://www.slideshare.net/ilmarkerm/making-mysql-highly-available-using-oracle-grid-infrastructure
> >
> > Ilmar
> >
> > On Mon, Jan 25, 2016 at 5:28 PM, Mark J. Bobak <mark_at_bobak.net> wrote:
> >>
> >> Hi all,
> >>
> >> Has anyone sucessfully done this? In my case, I've managed to figure
> out
> >> how to create teh necessary resource, but it doesn't actually work.
> >>
> >> What I'm tying to do, is start up a Glassfish server (running on the DB
> >> server, single instance, in my case), with a dependency on the
> database. I
> >> have ORDS (formerly known as APEX Liostener) deployed in Glassfish, and
> if I
> >> just start Glassfish via init.d, it will start before the database, and
> gets
> >> stuck reporting 404, even after the db starts, until I bounce Glassfish.
> >> So, I want to start if from GI home, using crs/has, and have a
> dependency on
> >> the db, to solve the startup sequence issues. (Also, to make it
> >> (presumably?) stop and stat automatically whenever the DB is bounced.)
> >>
> >> So, I created the resource, like so:
> >> crsctl add resource glassfish -type generic_application -attr
> >> "START_PROGRAM='/etc/init.d/glassfish_domain1
> >> start',STOP_PROGRAM='/etc/init.d/glassfish_domain1
> >>
> stop',START_DEPENDENCIES='hard(ora.orcl.db)',STOP_DEPENDENCIES='hard(ora.orcl.db)',PID_FILES=/var/run/glassfish.pid"
> >>
> >> This seems to have worked, no error is returned, and one can query the
> >> resource and see it exists:
> >> crsctl status res glassfish
> >> NAME=glassfish
> >> TYPE=generic_application
> >> TARGET=OFFLINE
> >> STATE=OFFLINE
> >>
> >> But, when I try to start it, I get this:
> >> crsctl start res glassfish
> >> CRS-2672: Attempting to start 'glassfish' on 'my_new_test'
> >> CRS-2674: Start of 'glassfish' on 'my_new_test' failed
> >> CRS-2679: Attempting to clean 'glassfish' on 'my_new_test'
> >> CRS-2681: Clean of 'glassfish' on 'my_new_test' succeeded
> >> CRS-4000: Command Start failed, or completed with errors.
> >>
> >> And, at the end, the glassfish server is, in fact, running. So, it
> >> thinks it failed to start, but it starts, then it does the clean, and it
> >> thinks it cleaned everything up (remove logifle and pid file and kill
> >> process) but it in fact remains running.
> >>
> >> I suspect that there is a 'tamplate' for the startup/shutdown script? I
> >> found a doc on MOS, that says my script must accept
> 'start','stop','clean,
> >> and 'check' as parameters. When I run my sript from the command line,
> it
> >> works beautifully, and those parameters all work as expected.
> >>
> >> So, my next guess is return values? Not sure what to try next...
> >>
> >> Has anyone gotten this to work? Any idea what I'm missing from my
> script?
> >>
> >> Thanks,
> >>
> >> -Mark
> >
> >
> >
> >
> > --
> > Ilmar Kerm
>

--
http://www.freelists.org/webpage/oracle-l