Operating System - HP-UX
1832059 Members
3148 Online
110034 Solutions
New Discussion

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

 
Tajammul_Ahmed
Regular Advisor

PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

Hi,

We have two nodes node1 and node2, always my server start the pacakages on node to, please find the logs..

your suggation will be highly appreciated..

instance of LogEntryInstTable {
timestamp = "Nov 28 13:27:21";
source = "2828";
category = "INFO";
path = "provider.cmprovider";
message = "Successfully enabled package ov-server to run on node tshpov1.";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:31:41";
source = "13273";
category = "ERROR";
path = "om.sql";
message = "Syntax error in where clause: operator '=' without left operand";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:31:41";
source = "13273";
category = "ERROR";
path = "om.sql.query";
message = "Syntax error in SQL query \"* from where = \"SGIPSubnetCondition:91.103.144.160\"\"";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:31:42";
source = "13273";
category = "ERROR";
path = "om.sql";
message = "Syntax error in where clause: operator '=' without left operand";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:31:42";
source = "13273";
category = "ERROR";
path = "om.sql.query";
message = "Syntax error in SQL query \"* from where = \"SGIPSubnetCondition:91.103.144.160\"\"";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:43:12";
source = "13273";
category = "ERROR";
path = "om.sql";
message = "Syntax error in where clause: operator '=' without left operand";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:43:12";
source = "13273";
category = "ERROR";
path = "om.sql.query";
message = "Syntax error in SQL query \"* from where = \"SGIPSubnetCondition:91.103.144.160\"\"";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:43:12";
source = "13273";
category = "ERROR";
path = "om.sql";
message = "Syntax error in where clause: operator '=' without left operand";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:43:12";
source = "13273";
category = "ERROR";
path = "om.sql.query";
message = "Syntax error in SQL query \"* from where = \"SGIPSubnetCondition:91.103.144.160\"\"";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:44:43";
source = "13273";
category = "ERROR";
path = "om.sql";
message = "Syntax error in where clause: operator '=' without left operand";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:44:43";
source = "13273";
category = "ERROR";
path = "om.sql.query";
message = "Syntax error in SQL query \"* from where = \"SGIPSubnetCondition:91.103.144.160\"\"";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:44:43";
source = "13273";
category = "ERROR";
path = "om.sql";
message = "Syntax error in where clause: operator '=' without left operand";
};
instance of LogEntryInstTable {
timestamp = "Nov 28 13:44:43";
source = "13273";
category = "ERROR";
path = "om.sql.query";
message = "Syntax error in SQL query \"* from where = \"SGIPSubnetCondition:91.103.144.160\"\"";
};
instance of LogEntryInstTable {
timestamp = "Nov 29 11:39:35";
source = "14667";
category = "INFO";
path = "provider.cmprovider";
message = "Enabling switching for package ov-server.";
};
instance of LogEntryInstTable {
timestamp = "Nov 29 11:39:35";
source = "14667";
category = "INFO";
path = "provider.cmprovider";
message = "Successfully enabled package ov-server.";
};
12 REPLIES 12
Hasan  Atasoy
Honored Contributor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

hi ajmal ,
there is a syntax error in your cluster definition files,
it is possible to send them ?

Hasan.


Tajammul_Ahmed
Regular Advisor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

Hi Hassan,

Here is the full cmcluster folder.

Thanks and best reards
Mohammed Tajammul Ahmed.
Hasan  Atasoy
Honored Contributor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

and
om.sql
please ..

Hasan.
Tajammul_Ahmed
Regular Advisor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

Hi,

can you please provide me the path of this file ?

Thanks and best regards
Mohammed Tajammul Ahmed
Hasan  Atasoy
Honored Contributor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

ajmul
please find that file by
find / -name om.sql

Hasan.
Tajammul_Ahmed
Regular Advisor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

We are using oracle 9i as our database server, when I search the file I couden't find om.sql.

Hasan  Atasoy
Honored Contributor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

then ;
please send /etc/cmcluster directory files ( as active node ) from second
node...
Hasan.
Tajammul_Ahmed
Regular Advisor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

Hi,

Here is the requested directory..

Thanks and best regards
Mohammed Tajammul Ahmed.
Hasan  Atasoy
Honored Contributor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

and lastly :)

/etc/cmcluster/ov-server/ov-server.mon

Hasan.
Tajammul_Ahmed
Regular Advisor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

Here is the files
Hasan  Atasoy
Honored Contributor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD

hi ajmul thta script depens also
/opt/OV/lbin/ovharg
could you paste it please .

Hasan.
Tajammul_Ahmed
Regular Advisor

Re: PAKAGES ARE NOT STARTING ON NODE1 USING SERVICEGUARD


sorry for delay..

Requested file is attached..