[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