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>

_______________________________________________
Users mailing list: [email protected]
http://clusterlabs.org/mailman/listinfo/users

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org

Reply via email to