<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<small>SLE 11 SP 3 + online updates, pacemaker version 1.1.11.x<br>
<br>
SAP and Sybase manually starts smoothly but cluster fails to start
the Sybase database with following errors:<br>
<br>
Sep 16 14:23:53 KHIERP-PRD1 pengine[5885]: notice: LogActions:
Start p_SAPDB (KHIERP-PRD1)
<br>
Sep 16 14:23:53 KHIERP-PRD1 pengine[5885]: notice:
process_pe_message: Calculated Transition 7:
/var/lib/pacemaker/pengine/pe-input-583.bz2
<br>
Sep 16 14:23:53 KHIERP-PRD1 crmd[5886]: notice: do_te_invoke:
Processing graph 7 (ref=pe_calc-dc-1442395433-81) derived from
/var/lib/pacemaker/pengine/pe-input-583.bz2
<br>
Sep 16 14:23:53 KHIERP-PRD1 crmd[5886]: notice: te_rsc_command:
Initiating action 19: start p_SAPDB_start_0 on KHIERP-PRD1
(local)
<br>
Sep 16 14:23:53 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: WARNING:
saphostexec is not running on node KHIERP-PRD1, it will be started
now
<br>
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: modified
/proc/sys/net/ipv4/ip_local_reserved_ports for SAP applications
(SAP note 401162)
<br>
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: modified
/proc/sys/net/ipv4/ip_local_port_range from 32768-61000 to
9000-65300
<br>
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of free
ports: 39512
<br>
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of reserved
ports: 26024
<br>
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of reserved
ports within ip_local_port_range: 24767
<br>
Sep 16 14:23:54 KHIERP-PRD1 SAPSAP_99[8072]: SAP Service
SAPHostControl successfully started.
<br>
Sep 16 14:23:54 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:55 KHIERP-PRD1 su: (to erpadm) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: INFO:
saphostexec on node KHIERP-PRD1 was restarted !
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:23:59 KHIERP-PRD1 su: (to erpadm) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:01 KHIERP-PRD1 kernel: [ 1414.404685] Using mlock
ulimits for SHM_HUGETLB is deprecated
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:05 KHIERP-PRD1 su: (to erpadm) root on none
<br>
Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:08 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:08 KHIERP-PRD1 su: (to erpadm) root on none
<br>
Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
<br>
Sep 16 14:24:10 KHIERP-PRD1 su: (to erpadm) root on none
<br>
Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: The
resource does not run any services which this RA could monitor!
<br>
Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: The
SAP database ERP ist not running:
<br>
Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: SAP
database ERP start failed:
<br>
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]: notice:
operation_finished: p_SAPDB_start_0:8029:stderr [ Error: Command
execution failed. : Database user authentication failed: No access
to SecureStore or DB_CONNECT/SYB/SADB_USER or
DB_CONNECT/SYB/SADB_PASSWORD is missing in SecureStore or password
is incorrect. Provide credentials for user sapsa via command input
or provide access to SecureStore. (fault code: 127) ]
<br>
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]: notice:
operation_finished: p_SAPDB_start_0:8029:stderr [ Operation ID:
0050568536081EE5978A95237846DD7F ]
<br>
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]: notice:
operation_finished: p_SAPDB_start_0:8029:stderr [ ]
<br>
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]: notice:
operation_finished: p_SAPDB_start_0:8029:stderr [ ]
<br>
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]: notice:
operation_finished: p_SAPDB_start_0:8029:stderr [ Error: Database
user authentication failed: No access to SecureStore or
DB_CONNECT/SYB/SADB_USER or DB_CONNECT/SYB/SADB_PASSWORD is
missing in SecureStore or password is incorrect. Provide
credentials for user sapsa via command input or provide access to
SecureStore. ]
<br>
Sep 16 14:24:13 KHIERP-PRD1 crmd[5886]: notice:
process_lrm_event: LRM operation p_SAPDB_start_0 (call=57, rc=1,
cib-update=200, confirmed=true) unknown error<br>
<br>
here is the SAPDatabase configuration:<br>
<br>
primitive p_SAPDB ocf:heartbeat:SAPDatabase \<br>
op monitor interval="120" timeout="60" \<br>
op start interval="0" timeout="1800" \<br>
op stop interval="0" timeout="1800" \<br>
params SID="ERP" DBTYPE="SYB" </small><br>
<br>
<br>
<br>
<br>
<div class="moz-signature">-- <br>
<font size="1">Regards,<br>
<br>
</font>
<font size="2">Muhammad Sharfuddin</font><font size="1"><a
href="http://www.nds.com.pk"></a></font><br>
<br>
</div>
</body>
</html>