[ClusterLabs] SAPDatabase is not starting Sybase database

Muhammad Sharfuddin M.Sharfuddin at nds.com.pk
Wed Sep 16 10:52:57 UTC 2015


SLE 11 SP 3 + online updates, pacemaker version 1.1.11.x

SAP and Sybase manually starts smoothly but cluster fails to start the 
Sybase database  with following errors:

Sep 16 14:23:53 KHIERP-PRD1 pengine[5885]:   notice: LogActions: Start   
p_SAPDB        (KHIERP-PRD1)
Sep 16 14:23:53 KHIERP-PRD1 pengine[5885]:   notice: process_pe_message: 
Calculated Transition 7: /var/lib/pacemaker/pengine/pe-input-583.bz2
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
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)
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
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: modified 
/proc/sys/net/ipv4/ip_local_reserved_ports for SAP applications (SAP 
note 401162)
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: modified 
/proc/sys/net/ipv4/ip_local_port_range from 32768-61000 to 9000-65300
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of free ports: 39512
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of reserved ports: 
26024
Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of reserved ports 
within ip_local_port_range: 24767
Sep 16 14:23:54 KHIERP-PRD1 SAPSAP_99[8072]: SAP Service SAPHostControl 
successfully started.
Sep 16 14:23:54 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:55 KHIERP-PRD1 su: (to erpadm) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: INFO: 
saphostexec on node KHIERP-PRD1 was restarted !
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:23:59 KHIERP-PRD1 su: (to erpadm) root on none
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:01 KHIERP-PRD1 kernel: [ 1414.404685] Using mlock ulimits 
for SHM_HUGETLB is deprecated
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:05 KHIERP-PRD1 su: (to erpadm) root on none
Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:08 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:08 KHIERP-PRD1 su: (to erpadm) root on none
Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
Sep 16 14:24:10 KHIERP-PRD1 su: (to erpadm) root on none
Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: The 
resource does not run any services which this RA could monitor!
Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: The SAP 
database ERP ist not running:
Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: SAP 
database ERP start failed:
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) ]
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
p_SAPDB_start_0:8029:stderr [ Operation ID: 
0050568536081EE5978A95237846DD7F ]
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
p_SAPDB_start_0:8029:stderr [  ]
Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
p_SAPDB_start_0:8029:stderr [  ]
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. ]
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

here is the SAPDatabase configuration:

primitive p_SAPDB ocf:heartbeat:SAPDatabase \
     op monitor interval="120" timeout="60" \
     op start interval="0" timeout="1800" \
     op stop interval="0" timeout="1800" \
     params SID="ERP" DBTYPE="SYB"




-- 
Regards,

Muhammad Sharfuddin<http://www.nds.com.pk>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/users/attachments/20150916/34c4b55a/attachment-0003.html>


More information about the Users mailing list