Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE RAC 10.1.0.2 SERVICEGUARD Question

SOLVED
Go to solution
Luk Vandenbussche
Honored Contributor

ORACLE RAC 10.1.0.2 SERVICEGUARD Question

Hi,
Installed oracle RAC on serviceguard cluster with the extension for rac installed.
After the root.sh, vipca was executed which asked me my virtual IP adress.
I have not configured to startup DB at startup of my package, but when i start my package the instance is started automaticly.
My questions are
- Where is this configured
- Do I have to modify my package.ctnl file?
- Which package monitor options do I need to use?
6 REPLIES
TwoProc
Honored Contributor

Re: ORACLE RAC 10.1.0.2 SERVICEGUARD Question

It's possibly going to be in the package.cntl file, in a section titled

# START OF CUSTOMER DEFINED FUNCTIONS

Possibly in:

function customer_defined_run_cmds
{

You might see something like...
/etc/cmcluster//.sh start

HTH
We are the people our parents warned us about --Jimmy Buffett
Bob_Vance
Esteemed Contributor
Solution

Re: ORACLE RAC 10.1.0.2 SERVICEGUARD Question

I haven't played with SGextRAC, yet, but I believe that the instance is being started by CRS just as it is without SG and SGextRAC.
You should be able (as oracle user) to do:

$$ srvctl disable instance -d yaya -i yaya3

Then, on a reboot, CRS should not start it.
You could then control it in your package, if you want, via:

$$ srvctl enable instance -d yaya -i yaya3
$$ srvctl start instance -d yaya -i yaya3

and to stop it

$$ srvctl disable instance -d yaya -i yaya3
$$ srvctl stop instance -d yaya -i yaya3

Remember that instances don't fail over under RAC -- only the VIP moves.

hth
bv
"The lyf so short, the craft so long to lerne." - Chaucer
Luk Vandenbussche
Honored Contributor

Re: ORACLE RAC 10.1.0.2 SERVICEGUARD Question

Thx Bob,

So the structure it complety different as in an active/passive Oracle Serviceguard environment
Bob_Vance
Esteemed Contributor

Re: ORACLE RAC 10.1.0.2 SERVICEGUARD Question

Well, as I said, I haven't played with SGextRAC + SG, yet; only RAC10g with no SG, but I would say that the answer to your last question

>>So the structure it complety different as in an
>> active/passive Oracle Serviceguard environment

is YES.

However, now I'm confused by your situation.
I just noticed that I misread your original post. You said the the instance didn't start until you started the *package* -- I was thinking that it started right after the install and on rebooting -- this is normally (no SG) the case. You should have noticed that at the end of the DBCA that the instances were being started.

Where did the package come from? Did you create it from scratch or did you use the Oracle toolkit? What does the Pkg control; e.g., just the LAN and VGs? Are you using RAW shLVOLs? Are you using redundant LAN connections?

Also, normally, CRS would start everything at boot. However, in this case, the instances wouldn't be able to start without their data if you are using shLVOLs, which normally the PKG would be controlling.

Looking at the HP online DOCO, there seems to be no discussion of the new 10g stuff and I don't know whether the Oracle toolkit (the HP-written Pkg control scripts) has been updated to accommodate it.

Of course, you don't need to use the Oracle toolkit to do Oracle under SG -- I never have; you can modify the control scripts your own way and so you could do this for the 10g environment.

I would be interested in seeing your PKG config and control scripts and cluster config script.

((BTW, I would recommend applying the 10.1.0.3 patchset, but you'll have to also apply a couple of other patches after that.
I can send you some info on that if you get to that point))
"The lyf so short, the craft so long to lerne." - Chaucer
Luk Vandenbussche
Honored Contributor

Re: ORACLE RAC 10.1.0.2 SERVICEGUARD Question

Problem solved
Bob_Vance
Esteemed Contributor

Re: ORACLE RAC 10.1.0.2 SERVICEGUARD Question

You're not going to tell us what you found ?>)

bv
"The lyf so short, the craft so long to lerne." - Chaucer