Oracle 9, solaris and approx 5 minutes start time. ITSM7(cmdb, asset, change and slm)
There is approx 180k records in field_dispprop. -- Jarl On 6/20/07, Tony Worthington <[EMAIL PROTECTED]> wrote:
>Am I missing something here?? No... but maybe I am? I guess it could be an Oracle thing. I suppose all the long startups I've heard of are on Oracle. Anyone on Oracle have fast (<5min) startup times with ITSM7? -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 strauss <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 06/20/2007 02:04 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Error 1053: The service did not respond.. This must be some sort of an "oracle thing", right? My ARS 7.x Servers with ITSM 7 -asset/SLM/RKM/EIE using an instance of SQL Server 2005 on a separate machine have about a 1 minute service startup time. The servers are on the same subnet and connect to the same gigabit switch, but I don't see where that would make the difference between 15 minutes, or 8, and one! Am I missing something here?? Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Wednesday, June 20, 2007 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Error 1053: The service did not respond.. Live with it? :-/ Quite a few people have gone through the same thing you just did and nobody has found a way to speed things up. It's just a huge query with all the fields of ITSM7. I also have Disable Cache VUI Display properties turned off. Some people on the list see 15 minute startup times... I see 8, and consider myself lucky. Probably not what you wanted to hear... but certainly let us know if you find a way to drop it to under 5 minues! :-) -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 "Bardsley, Michael" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 06/20/2007 01:22 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Error 1053: The service did not respond.. ** We have recently installed ARS 7 on a Windows 2003 Server into an Oracle 10G database that lives on a remote server. We have the full suite of products Incident/Problem/Change/Asset/SLM etc... We are now receiving an error at startup that I was hoping someone here could shed some light on. When we start the BMC Remedy Action Request Service we receive the following error: Could not start the BMC Remedy Action Request System Server service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. The service does start but it is taking just over 6 minutes to actually do so. Remedy Support has told me that: ?The delay in startup appears to be just in the fact that the normal startup queries ARServer runs to the db to load the data dictionary information into memory are taking a bit of time to be returned from the db. Basically ARServer is just waiting for the db to return the full result set. Here is the query I am referring to: Jun 07 2007 10:58:51.7180 */SELECT schemaId,fieldId,vuiId,propShort,propLong FROM field_dispprop ORDER BY 1 ASC,2 ASC,3 ASC Jun 07 2007 10:58:51.7500 */OK Jun 07 2007 11:01:42.2340 */COMMIT WORK? Their suggestion is to make sure that all NICs and Network Components are set to Full Duplex, yet they can not tell me why this would be the cause or the fix. Just that they have seen resolve the issue in some cases. In our environment that is easier said than done. Are switches run at Auto/Auto. We have ran sniffers and found that there is no packet loss at startup and there is no negotiation issues. My network folks can see no reason why the connection speeds would cause this issue. Has anyone else seen this in the 7.x environment and do you have some insight as to why? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
