topic Re: service gurad in Operating System - HP-UX

service gurad

Shaik Hyder Shakeel — Wed, 01 Apr 2009 12:58:14 GMT

what is steps by details need at SG before upgrade oracle 9i as halt package is recomended or no

Re: service gurad

Duncan Edmonstone — Wed, 01 Apr 2009 13:56:54 GMT

This is so dependent on your own configuration its almost impossible to say...

do you share executables between cluster nodes, or do you have local oracle binaries on each system?

do you monitor oracle processes?

Also when you say upgrade do you mean from or to 9i, and what are you upgrading from/to?

As usual in these forums, the metaphor here is you've gone to a mechanic and said - "I need a new engine for my vehicle" - but who knows what you're driving??

HTH

Duncan

Re: service gurad

Steven E. Protter — Wed, 01 Apr 2009 14:12:07 GMT

Shalom,

For 9i RAC
http://www.docs.hp.com/en/T1859-90038/ch03s14.html

In general, there is a lot of commonality to doing ServiceGuard and RAC.

SEP

Re: service gurad

Shaik Hyder Shakeel — Thu, 02 Apr 2009 05:03:57 GMT

it is not on every local node but in share , and i haven't monitor tools. ined to upgrade from 9i to 10g so that ineed to whay i can do regarding MCSG before start upgrade oracle by more details

Re: service gurad

Sajjad Sahir — Thu, 02 Apr 2009 05:19:27 GMT

dear Shaik

please give me cmviewcl -v output
i think u have two node cluster with slvm

please send more details

Sajjad Sahir

Re: service gurad

Duncan Edmonstone — Thu, 02 Apr 2009 05:32:08 GMT

so when you stop oracle manually (i.e. via a shutdown immediate), does it cause the package to failover?

if not, then you can probably just go ahead and upgrade to 10g without doing anything to Serviceguard.

The only thing I'd watch for is where the Oracle inventory pointer (OraInst.loc) for the OUI is... if Oracle wasn't installed by an experienced DBA, then chances are it is just in /var/opt/oracle on just one of the nodes. If it is then you'll need to do the upgrade on that node... if its somewhere else on one of your clustered filesystems you'll need to use the -invPtrLoc option on the runInstaller command line during the upgrade.

HTH

Duncan

Re: service gurad

Shaik Hyder Shakeel — Thu, 02 Apr 2009 05:51:53 GMT

my question i need halt package on sg bfeore start upgrade oracle 9i to 10g . if yes tell me steps to do that

Re: service gurad

Duncan Edmonstone — Thu, 02 Apr 2009 06:35:33 GMT

and I answered that - if you can stop Oracle manually without causing a cluster failover then NO you don't need to halt the package.

And if you don't need to halt the package, you don't need any instructions do you?

Duncan

Re: service gurad

Shaik Hyder Shakeel — Thu, 02 Apr 2009 06:43:07 GMT

thanks for your fast replay but after upgrade the home file will be change so i need to reconfigure package. what i can do?

Re: service gurad

Duncan Edmonstone — Thu, 02 Apr 2009 06:55:18 GMT

well now we're taling specifics of your environment... aboou which you bhave told us nothing...

so I'mn assuming that your last comment meant that after the upgrade your ORACLE_HOME will have changed to a new location yes?

assuming that is what you meant my next questions are:

- is that ORACLE_HOME on a new filesystem, or one of the existing filesystems in the cluster? If on a new filesystem, is that

- are you sing the Enterprise Cluster Master Toolkit Oracle integration and if so waht version. Or has someone "rolled their own" cluster integration for Oracle?

- can you post the output of:

cmgetconf -p

replacing with the serviceguard package name of your oracle instance

HTH

Duncan

Re: service gurad

Duncan Edmonstone — Thu, 02 Apr 2009 06:56:56 GMT

gaaah real finger trouble this morning, let me post that again:

well now we're talking specifics of your environment... about which you have told us nothing...

so I'm assuming that your last comment meant that after the upgrade your ORACLE_HOME will have changed to a new location yes?

assuming that is what you meant my next questions are:

- is that ORACLE_HOME on a new filesystem, or one of the existing filesystems in the cluster? If on a new filesystem, is that in the same VG as existing cluster filesystems or in an entirely new VG?

- are you sing the Enterprise Cluster Master Toolkit Oracle integration and if so waht version. Or has someone "rolled their own" cluster integration for Oracle?

- can you post the output of:

cmgetconf -p

replacing with the serviceguard package name of your oracle instance

HTH

Duncan

Re: service gurad

Shaik Hyder Shakeel — Thu, 02 Apr 2009 11:37:01 GMT

the same file system but new path for home file after upgrade . i know need to change some paramter at control file of packge as custom define run and halting the steps are:
1- stop package manualy not halting package
2- make upgrade oracle so that new path for home file at the same file system
3- reconfigure packge (control file)
4- ckeck package configuration
5-apply configuration of cluster package
please ckeck this steps and tell me the correct configuration if false

Re: service gurad

Viktor Balogh — Fri, 03 Apr 2009 13:15:19 GMT

if you only modify the cntl file, (and not the conf file)
you shouldn't apply the package configuration again.

Re: service gurad

Shaik Hyder Shakeel — Fri, 03 Apr 2009 13:36:00 GMT

i need halting package when reconfigure control file of package

Re: service gurad

Shaik Hyder Shakeel — Sat, 04 Apr 2009 05:51:31 GMT

output of cmviewcl -v
CLUSTER STATUS
sjodbcl up

NODE STATUS STATE
sjodbn1 up running

Cluster_Lock_LVM:
VOLUME_GROUP PHYSICAL_VOLUME STATUS
/dev/vgora /dev/dsk/c11t0d1 up

Network_Parameters:
INTERFACE STATUS PATH NAME
PRIMARY up 0/6/1/0 lan3
PRIMARY up 0/4/2/0 lan1
STANDBY up 0/2/1/0 lan4

PACKAGE STATUS STATE AUTO_RUN NODE
oradbpkg up running enabled sjodbn1

Policy_Parameters:
POLICY_NAME CONFIGURED_VALUE
Failover configured_node
Failback manual

Script_Parameters:
ITEM STATUS MAX_RESTARTS RESTARTS NAME
Service unknown 0 0 oracle_db
Subnet up 10.196.7.0

Node_Switching_Parameters:
NODE_TYPE STATUS SWITCHING NAME
Primary up enabled sjodbn1 (current)
Alternate up enabled sjodbn2

NODE STATUS STATE
sjodbn2 up running

Cluster_Lock_LVM:
VOLUME_GROUP PHYSICAL_VOLUME STATUS
/dev/vgora /dev/dsk/c11t0d1 up

Network_Parameters:
INTERFACE STATUS PATH NAME
PRIMARY up 0/6/1/0 lan3
PRIMARY up 0/4/2/0 lan1
STANDBY up 0/2/1/0 lan4

Re: service gurad

Duncan Edmonstone — Sat, 04 Apr 2009 07:05:01 GMT

if you keep asking the same question in multiple threads without posting the requested material, you are really never going to get a consistent answer. So stop opening new threads in which you repeat the same question and answer this which I asked before:

- are you sing the Enterprise Cluster Master Toolkit Oracle integration and if so what version. Or has someone "rolled their own" cluster integration for Oracle?

- if you're not sure we might be able to figure this out... the first stage of figuring this out is to post:

- the output of "cmgetconf -p oradbpkg"

- an "ls" of the packages directory (which presumably is /etc/cmcluster/oradbpkg)

The point is - this isn't Windows where the cluster configuration for an application is ususally restrictively consistent between different implementations - there are a dozen different ways to configure Oracle into a Serviceguard package (which is _good_ because it makes UNIX more flexible) and we don't know which way yours is configured so its very difficult to give advice...

HTH

Duncan

Re: service gurad

Shaik Hyder Shakeel — Sat, 04 Apr 2009 08:31:58 GMT

this output of ls my directory package
DBN1)/etc/cmcluster/oradbpkg $ll
total 544
-rwx------ 1 root sys 56842 Feb 14 2008 oradbpkg.cntl
-rwx------ 1 root sys 56842 Feb 14 2008 oradbpkg.cntl.bkg
-rw-r--r-- 1 root root 145889 Mar 26 19:24 oradbpkg.cntl.log
-rwx------ 1 root sys 16329 Aug 25 2007 oradbpkg.conf
attached is output of cmgetconf -p package
please i need steps to can make safe upgrade for oracle from 9i to 10g regarding to sg

Re: service gurad

Duncan Edmonstone — Sat, 04 Apr 2009 10:57:50 GMT

I know what you need but we need to know more about your environment...

So now look in the file oradbpkg.cntl

and find the section that looks like this:

# START OF CUSTOMER DEFINED FUNCTIONS

# This function is a place holder for customer define functions.
# You should define all actions you want to happen here, before the service is
# started. You can create as many functions as you need.

function customer_defined_run_cmds
{

...

}

I'm interested in what is in between the curly braces after the line:

function customer_defined_run_cmds

post that here - if it references another shell script, post the shell script here as well.

HTH

Duncan

Re: service gurad

Shaik Hyder Shakeel — Sat, 04 Apr 2009 11:17:13 GMT

in this run custome define path to start service of oracle and located at home file , this path will be change after upgrade
so i need sequense of upgrade oracle by comand line

Re: service gurad

Duncan Edmonstone — Sat, 04 Apr 2009 12:08:25 GMT

so you're saying that the actual code to start Oracle is in the customer_defined_run_cmds function rather than

sourced from another script? It would be easier for me to follow if you just posted it...

we also need to see the lines taht read something like:

SERVICE_NAME[0]="oracle_db"
SERVICE_CMD[0]="..."
SERVICE_RESTART[0]="..."

again it would be easier if you just posted the whole file...

HTH

Duncan