topic Re: cluster packages in Operating System - HP-UX

cluster packages

fizan — Thu, 15 Jul 2010 00:32:53 GMT

Team,

I have created one vg, and crated one LV in that.
so i created a cluster with 2 packages on same VG
as /dev/oravg,
cluster started correctly. up & running,
out of 2 packages..
orapkg-- up, running fine.
but on 2nd SAPpkg, cmcheckconf is applied ,
showed, corrct, with no errors found, but when i apply cmapplyconf it says sql plus not found in the start.sh script.

am using same user & same script for both the packages.
orapkg is running, but sappkg is not running fine.

any ting related to vg is not correct.
whether 2 pkg can reside on same LV, VG?

Thanks

Re: cluster packages

singh sanjeev — Thu, 15 Jul 2010 01:02:18 GMT

why do not you combine the both in one PKG....i think it is not good idea to involve a single VG in two separate PKG as it may affect the activation of VG while cluster movement on node in case of failover.

it is good idea to combine both Oracle and SAP script in one ...

Re: cluster packages

njia_1 — Thu, 15 Jul 2010 01:10:07 GMT

hi fizan

Don't configure two package on same VG.

you need to create another vg and install your application and then configure the 2nd package.

thanks

Re: cluster packages

fizan — Thu, 15 Jul 2010 01:16:47 GMT

i had done that also,
created a separate /dev/sapvg and moved the sappkg to that /dev/saplv, now when i apply cmcheckconf it says no errors founf,
when i apply cmapplyconf it syas,

# cmrunpkg sappkg
Running package sappkg on node rx26-184
The package script for sappkg failed with unknown value. sappkg should not be restarted
Unable to run package sappkg on node rx26-184
Check the syslog and pkg log files for more detailed information
cmrunpkg: Unable to start some package or package instances
[rx26-184]/etc/cmcluster/sappkg
# more start.sh.log
/etc/cmcluster/sappkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/sappkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/sappkg/start.sh[2]: sqlplus: not found.
[rx26-184]/etc/cmcluster/sappkg

Thanks

Re: cluster packages

njia_1 — Thu, 15 Jul 2010 01:48:05 GMT

Hi fizan

Have you actually installed sap on the 2nd vg ?

From the "command not found" I guess you did not install the actually application and when the package startup script tried to run the sqlplus, it just could not find it.

Have a look at the start.sh and find where it calls sqlplus and make sure you have it.

thanks

Re: cluster packages

Kapil Jha — Thu, 15 Jul 2010 02:41:57 GMT

1) bad idea to have 2 package in one VG.
I don think there is a easy way to do this.
would need lot of efforts.

2)>>sql plus not found in the start.sh script.

check the start.sh script if you have sqlplus utility and check pkg logs in /etc/cmcluster
directory

BR,
Kapil+

Re: cluster packages

fizan — Thu, 15 Jul 2010 02:52:27 GMT

syslog:

Jul 14 23:39:40 rx26-191 CM-CMD[6914]: cmrunpkg orapkg
Jul 14 23:39:41 rx26-191 CM-CMD[6914]: Request from root on node rx26-191 to start package orapkg
Jul 14 23:39:41 rx26-191 cmcld[6723]: Request from root on node rx26-191 to start package orapkg
Jul 14 23:39:41 rx26-191 cmcld[6723]: Request from node rx26-191 to start package orapkg on node rx26-191.
Jul 14 23:39:41 rx26-191 cmcld[6723]: Executing '/etc/cmcluster/orapkg/start.sh start' for package orapkg, as service PKG*59393.
Jul 14 23:39:41 rx26-191 cmcld[6723]: Service PKG*59393 terminated due to an exit(127).
Jul 14 23:39:41 rx26-191 cmcld[6723]: Package orapkg run script failed: exit value 127.
Jul 14 23:39:41 rx26-191 cmcld[6723]: Examine the file /etc/cmcluster/orapkg/start.sh.log for more details.
Jul 14 23:39:41 rx26-191 cmcld[6723]: Switching disabled on package orapkg.
Jul 14 23:39:41 rx26-191 CM-CMD[6914]: Request from root on node rx26-191 to start package orapkg failed
Jul 14 23:39:41 rx26-191 cmcld[6723]: Unable to start package orapkg. Node rx26-191 is not able to run it.
Jul 14 23:40:22 rx26-191 cmcld[6723]: Service cmfileassistd terminated due to an exit(0).

Re: cluster packages

johnsonpk — Thu, 15 Jul 2010 03:41:12 GMT

your syslog shows issue with orapkg !!! and nothong realted to saspkg ,

post start.sh.log pls

Re: cluster packages

fizan — Thu, 15 Jul 2010 04:01:26 GMT

/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
/etc/cmcluster/orapkg/start.sh[2]: sqlplus: not found.
[rx26-191]/etc/cmcluster/orapkg

Re: cluster packages

njia_1 — Thu, 15 Jul 2010 05:42:59 GMT

Hi fizan

You posted both scripts from sappkg and orapkg, and they both complianted about sqlplus not found.

Can you post start.sh ?

thanks

Re: cluster packages

fizan — Thu, 15 Jul 2010 06:29:40 GMT

cmhaltcl

cmruncl

every ting looks fine.
thanks

Re: cluster packages

Kapil Jha — Thu, 15 Jul 2010 08:49:37 GMT

you need to check on yout start.sh script which is the path for sqlplus...does it exist
does your script have good PATH defined.

if you are running package on 2 separate VG it should not be a problem with cluster.

BR,
Kapil+

Re: cluster packages

Benoy Daniel — Fri, 16 Jul 2010 00:44:34 GMT

I dont think you can have 2 packages using same VG. When you try to start the package, the control script is trying do a vgchange.

Re: cluster packages

gb karki — Fri, 16 Jul 2010 12:24:16 GMT

Hi Fizan,

This is not good practice to configure the
SAP and Oracle packages in one VG.

#configure in different VG.
#Start the Oracle package first then
#start the SAP package.

good luck.

Regards
G