Re: [Linux-HA] Antw: Re: Usage of SAPDatabase resource agent without SAPHostAgent is deprecated
Hi! As it turned out, the message was triggered by setting the DIR_EXECUTABLE parameter to "/sapmnt//exe" instead of "/usr/sap/hostctrl/exe". Unfortunately changing that directory will cause a resource restart... Regards, Ulrich >>> Dejan Muhamedagic schrieb am 06.05.2013 um 22:41 in Nachricht <20130506204146.GA4612@walrus.homenet>: > Hi Ulrich, > > On Tue, Apr 30, 2013 at 08:54:55AM +0200, Ulrich Windl wrote: >> >>> Lars Marowsky-Bree schrieb am 29.04.2013 um 17:04 in >> >>> Nachricht >> <20130429150448.gi21...@suse.de>: >> > On 2013-04-26T23:56:04, Muhammad Sharfuddin >> > wrote: >> > >> > > I just upgraded from SP1(SLES 11/HAE) to SP2, and getting following >> > > messages when I start the SAPDBInstance resource: >> > > >> > > SAPDatabase(SAPDBInstance)[22587]: [22602]: WARNING: Usage of >> > > SAPDatabase resource agent without SAPHostAgent is deprecated. Please >> > > read documentation of SAPDatabase resource agent and follow SAP note >> > > 1031096 for the installation of SAPHostAgent. >> > > >> > > there is a chapter "HA OCF Agents" in the High Availability Guide of >> > > SP2, but I found nothing new/peculiar about SAPDBInstance there. >> > >> > The warning just indicates that a new configuration is preferred for SAP >> > HA deployments going forward. The former version is still supported (and >> > working, I trust). >> > >> > When you get a chance, you should install the SAP host agent as per the >> > reference SAP note. (Which I can't look up, it seems.) >> >> The amazing thing is that the message appears even when SAPHostAgent is > installed and (saphostctl is running) on the system. So far I did not care > what the message really wants to say... > > Can you please report this issue. I'm sure the author would like > to know about it. > > Cheers, > > Dejan > >> > The warning does not indicate an error, but tries to get your attention >> > about improving your configuration during the next appropriate >> > maintenance window. It seems that worked ;-) >> > >> > >> > Regards, >> > Lars >> >> >> >> >> >> ___ >> Linux-HA mailing list >> Linux-HA@lists.linux-ha.org >> http://lists.linux-ha.org/mailman/listinfo/linux-ha >> See also: http://linux-ha.org/ReportingProblems > ___ > Linux-HA mailing list > Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
Re: [Linux-HA] Antw: Re: Usage of SAPDatabase resource agent without SAPHostAgent is deprecated
Hi Ulrich, On Tue, Apr 30, 2013 at 08:54:55AM +0200, Ulrich Windl wrote: > >>> Lars Marowsky-Bree schrieb am 29.04.2013 um 17:04 in > >>> Nachricht > <20130429150448.gi21...@suse.de>: > > On 2013-04-26T23:56:04, Muhammad Sharfuddin wrote: > > > > > I just upgraded from SP1(SLES 11/HAE) to SP2, and getting following > > > messages when I start the SAPDBInstance resource: > > > > > > SAPDatabase(SAPDBInstance)[22587]: [22602]: WARNING: Usage of > > > SAPDatabase resource agent without SAPHostAgent is deprecated. Please > > > read documentation of SAPDatabase resource agent and follow SAP note > > > 1031096 for the installation of SAPHostAgent. > > > > > > there is a chapter "HA OCF Agents" in the High Availability Guide of > > > SP2, but I found nothing new/peculiar about SAPDBInstance there. > > > > The warning just indicates that a new configuration is preferred for SAP > > HA deployments going forward. The former version is still supported (and > > working, I trust). > > > > When you get a chance, you should install the SAP host agent as per the > > reference SAP note. (Which I can't look up, it seems.) > > The amazing thing is that the message appears even when SAPHostAgent is > installed and (saphostctl is running) on the system. So far I did not care > what the message really wants to say... Can you please report this issue. I'm sure the author would like to know about it. Cheers, Dejan > > The warning does not indicate an error, but tries to get your attention > > about improving your configuration during the next appropriate > > maintenance window. It seems that worked ;-) > > > > > > Regards, > > Lars > > > > > > ___ > Linux-HA mailing list > Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
Re: [Linux-HA] Antw: Re: Usage of SAPDatabase resource agent without SAPHostAgent is deprecated
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30.04.2013 13:22, Muhammad Sharfuddin wrote: > Hello Fabian, > > On 04/30/2013 02:19 PM, Fabian Herschel wrote: >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> >> Hi Muhammad, >> >> please find my answer below... >> >> >> The new setup preferred by _SAP_ is, that you use the >> saphostagent. This new menthod gives you the following benefits >> (you might not need today) >> >> 1. Support for DB only on a server and Java (only) Instance on >> an other server (this is currently not working, because in that >> case the bootstrap files are missing at the DB server) >> >> 2. Support for Sybase (you can only control the "old" set of >> databases like DB2 (older version than 10), MaxDB and Oracle >> >> 3. You use the more generic DB Interface written by SAP and the >> DB-Vendors, so the resource agent does not need to take care >> about specialities of database but could concentrate on the SAP >> specific control of the database >> >> > thanks a lot for sharing and explaining. > > >>> correct, cluster never shows any error when it runs/start the >>> SAPInstance, though we found that whenever we run the >>> SAPInstance from cluster SAP gives us errors while login via >>> SAP Client(SAPGui). as a workarround, we stopped the >>> SAPInstance from the cluster, let the cluster runs/start the >>> other resources(IP, File Systems, and SAPDBInstance) and then >>> manually started the SAPInstance(via sap way): >>> >>> startsap -i DVEBMGS00 -v pgtprd >> >> This should not be needed - there must a something wrong - which >> error message did you get when SAPInstance was controlled by >> cluster and you login via SAPGui? >> >> If you get a SICK message about 3.0 kernel please update to a >> current SAP Kernel (I could provide the SAP Note number if >> needed). > > as said cluster always successfully starts the SAPInstance without > any error, but when we login into SAP via SAPGui there we got the > following error: "Run time Errors.START_CALL_SICK.short text > database inconsistency .start trasaction SICK". OK, this looks for me like the Linux Kernel is detected as 3.0 instead of 2.6. Could you (if needed with your SAP consultant) login and check, if there is something about the "unknown 3.0 kernel"? In this case the SAP Kernel should be updated. > > as a workaround I **only** stopped the SAPInstance from cluster(let > the IP, File Systems, SAPDBInstance remain running via cluster) > and start SAPInstance via command line "startsap -i DVEBMGS00 -v > pgtprd". > > SAP kernel version is 701, and we are running SAP on SLES 11 SP2 > via "Kernel 2.6 compatibility mode for SAP" (SAP note 1310037) Yes the 2.6 compatibility environment was only inteded to be used as a bridge between the avaialblibity of Linux 3.0 kernel and the customer to be able to update to newest SAP Kernels like 720 PL 402 or so. Sorry, that I couldn't solve that problem via this list, it now gets very SAP and support specific - if you have already opened a ticket at SUSE, please reference to that thread (my colleague already has read it :) and than we could help you with professional support. In sum its that SAP also wants you to update to the newer SAP kernels and my guess is that this is exactly your problem. While starting/stopping the instance with login-user/shell will lead into the 2.6 compat environment, the RA still runs in 3.0. ==> solution is either to change one line in RA (NOT preferred) or to update SAP kernel to current version (very appreciated and preferred :) > > > Regards, > > Muhammad Sharfuddin > ___ Linux-HA mailing > list Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: > http://linux-ha.org/ReportingProblems > -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.19 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJRf8Y0AAoJEJ1uHhrzMvZR9/QIAIKZs1RyGLfZZ9aUlJZR7EGM V7thYcSldUGn0HivtW9N+kufxJHfapJ70L1o9wAw0kTbq5CaVgt42B177zB4Kq3q 5q6db1ouDh7ZufV+6Dprhff8mplEMrTCJKDPjYnna7COYzkWYPun2FBNPmAV1pGs rBmxDBH9enZ5Piacj357Rqqs2mFhmnBeSDOIDDqMX8BBG+MIuslYOoBfyzwUTilv ECJnkAHQZcT9CsRJ6wLkQCfFSD+HzpGp3tLZhYxi9ub7SPlthCI8vJOgp5HZhbLp SvR9SCp3RG71+HLWKuCBd+u/JWDuymFnZ8jIoyUDWFVJRdkT59jsha2T2qIqbRI= =nIwo -END PGP SIGNATURE- ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
Re: [Linux-HA] Antw: Re: Usage of SAPDatabase resource agent without SAPHostAgent is deprecated
Hello Fabian, On 04/30/2013 02:19 PM, Fabian Herschel wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi Muhammad, > > please find my answer below... > > > The new setup preferred by _SAP_ is, that you use the saphostagent. > This new menthod gives you the following benefits (you might not need > today) > > 1. Support for DB only on a server and Java (only) Instance on an > other server (this is currently not working, because in that case the > bootstrap files are missing at the DB server) > > 2. Support for Sybase (you can only control the "old" set of databases > like DB2 (older version than 10), MaxDB and Oracle > > 3. You use the more generic DB Interface written by SAP and the > DB-Vendors, so the resource agent does not need to take care about > specialities of database but could concentrate on the SAP specific > control of the database > > thanks a lot for sharing and explaining. >> correct, cluster never shows any error when it runs/start the >> SAPInstance, though we found that whenever we run the SAPInstance >> from cluster SAP gives us errors while login via SAP >> Client(SAPGui). >> as a workarround, we stopped the SAPInstance from the cluster, let >> the cluster runs/start the other resources(IP, File Systems, and >> SAPDBInstance) and then manually started the SAPInstance(via sap >> way): >> >> startsap -i DVEBMGS00 -v pgtprd > > This should not be needed - there must a something wrong - which error > message did you get when SAPInstance was controlled by cluster and you > login via SAPGui? > > If you get a SICK message about 3.0 kernel please update to a current > SAP Kernel (I could provide the SAP Note number if needed). as said cluster always successfully starts the SAPInstance without any error, but when we login into SAP via SAPGui there we got the following error: "Run time Errors.START_CALL_SICK.short text database inconsistency .start trasaction SICK". as a workaround I **only** stopped the SAPInstance from cluster(let the IP, File Systems, SAPDBInstance remain running via cluster) and start SAPInstance via command line "startsap -i DVEBMGS00 -v pgtprd". SAP kernel version is 701, and we are running SAP on SLES 11 SP2 via "Kernel 2.6 compatibility mode for SAP" (SAP note 1310037) Regards, Muhammad Sharfuddin ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
Re: [Linux-HA] Antw: Re: Usage of SAPDatabase resource agent without SAPHostAgent is deprecated
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30.04.2013 08:27, Ulrich Windl wrote: Muhammad Sharfuddin schrieb am 29.04.2013 um 14:16 in > Nachricht <517e6482.2040...@nds.com.pk>: >>> I think that you should just follow that advice, i.e. read that >>> SAP >> note and install >>> SAPHostAgent. >>> >> I asked the SAP Consultant to install the SAPHostAgent issue. >> >>> See also the agents documentations: crm ra info SAPDatabase >>> >> I read it and found nothing that help me fix this issue. > > The good news is that it still works despite of the warning. The RA > is a good example how to do a simple thing with maximum complexity. > According to my little understanding that SAPHostAgent is a web > server running as root, launching the sap start script on demand. > The RA in turn sends a HTTP request to the Host Agent to start the > process. I did not care to examine how authentication works, > because I want to be able to sleep at night ;-) Oh you could sleep at night, even when I explain it: The autorization is made by a file permission of a socket on the system. So the Linux/Unix file permissions are controlling the permission to sent a set of commands to sapstartsrv / saphostagent. (Others could also be sent without that file permission - the set if comamnds needing authorization is controlled by a SAP configuration.) There are 3 (or more?) methods to authenticate: a) without (for simple unproblematic commands) b) via socket/file permission c) with username/password c) of course could not be used by the RA without introducing a security problem (and so does not try it :) I could not join your statement about the resource agent. The interface HOW to start/stop databases and instances is given by SAP, so the author of the RA implemented it in a SAP preferred way. The reason for the Webservice and to force also the RA is using it that the Webserver is THE interafce for all methods to control SAPDatabase and SAPInstances from outside. Its used by - SAP MMC - SAPMC - sapcontrol and maybe even by more... Regards Fabian > > Regards, Ulrich > > > ___ Linux-HA mailing > list Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: > http://linux-ha.org/ReportingProblems > -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.19 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJRf5RqAAoJEJ1uHhrzMvZRtPAH+wSFXab9rjLujhSiqfJvKK6X IuIPadkxc9PutiqyVLbEL5J976R27aPwiR5xuJP9TkVbygVuq+C+lvhhccEFRb/7 wB0oROFss3htK/qQGkV6oLkTARFTbfo6luWoUzDIWYE+e4BC5VeCy5EG3bUYOvSn +HIP4Chb1zCvyJqTvRjiTqp32cFpuYmSneTE3HrirrqGoD3gCkjAFlYIROgxbJ0h xCSdA8/zJt8WzcqzNUuqNHv3mrMqiifYwUXYghd8wZmmwZiz1ZZfx7mOlqxwbwiw EhqqEQUj9Or/V7q9L0Aw5OJ1Uuqt4vei7YXRqteIRX2xRrCVLR+Km1u6jQJyl+A= =qRA0 -END PGP SIGNATURE- ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
