Re: WWRUG12 - Session Question - Database Moving
have you checked the AR system ranking forms to see that the correct servers are set in the ranking forms, especially if your servers are in a server group? Date: Thu, 1 Nov 2012 15:47:17 + From: rpet...@columbia.com Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG ** I've had a couple requests for our procedure so I thought I'd add it here: We’re on AR 7.5 ITSM 7.6: On occasion we want to refresh the data within the non-production Remedy environments. This aligns all the data/configuration between environments. This is the process that we've developed. 1. Take a VMWare snapshot of the database server in the environment to be refreshed. Just in case. 2. Disable the Email Engine service 3. Disable the AR server service 4. Disable the Server Intelligence Agent in the Central Configuration Manager for Business Objects. Done on the RKM box. 5. Have a DBA backup the following 6 pre-refreshed tables (for Business Objects) for later restoration. § dbo.CMS_Aliases6 § dbo.CMS_IdNumbers6 § dbo.CMS_InfoObjects6 § dbo.CMS_LOCKS6 § dbo.CMS_RELATIONS6 § dbo.CMS_VersionInfo 6. Have a DBA Restore current production Remedy database onto the destination DB server. 7. Have a DBA restore the 6 backed up tables from above on top of the newly restored database. This keeps the Business Objects environment working as it was before. Both BO and Remedy use the same database and have their tables intermixed. 8. Start the Server Intelligence Agent in the Central Configuration Manager for Business Objects. Done on the RKM box. § Good to validate that BO is working correctly and reports the new data. 9. Start the AR server service 10. Log into the thick client for further modifications 11. Change the server in the records of the following forms: · AP:Rule Definition ( nothing changed for accounts payable – maybe revisit) · AR System Searches Preference (modified all records with new ar server) · AR System Server Group Operation Ranking (modified all records with new ar server) · AR System User Preference (Server = $NULL$) ( not changed) · BMC.CORE.CONFIG:BMC_FederatedDataInterface ( nothing to modify) · BMC.CORE.CONFIG:BMC_FederatedInterface (modified all records with new ar server) · CAI:AppRegistry (modified all records with new ar server) · EIE:CommonDialog (Help File Path) ( cant change host/internal instance) · KMS:Administration_Integration (modified all records with new ar server) · Report (modified all records with new ar server) · SRD:STAGE:MasterDataMappingList ( no records to modify) · SRM:ApplicationSettings (SRM Application Settings) ( no form) SHARE:Application_Properties (Help files web location to point to the correct Mid-Tier) ( modified all the appropriate entries – Help File Path) · SYS:Integration Management ( nothing to modify) 1. Remove any unsent mail from the Remedy mail queue 2. Remove all support group members. Don't want to confuse people. Seem to have to go back to the service desk group. May have something to do with fixed licenses. It'd be nice if you could remove more than one member at a time. 1. Remove all the distribution lists from support group notification configuration. 2. Update the email box configurations per the table below. Passwords can be found in 3. Possibly clean up the actual Exchange inbox if necessary (unlikely). This will only be the case if the environment has been down a while and can't catch up. 4. Update the license entries per the table below. 5. Change the email address of the 'remedy email' faceless account (People record) to be appropriate for the environment. § This address MUST match the address of the sender of the incoming mail (per mailbox configuration). If they don't match, the returned error will be “missing ar system user information” 6. Change the email address of the 'cab user” faceless account (People record) to be appropriate for the environment. 7. Remove the distribution list from the service desk support group. Probably redundant from above. 8. Update the pager configuration to have the appropriate 'sender' email address for the specific environment. 9. Start the email engine service 10. Send a message to the environment service desk email to validate default tickets are being created correctly. 11. Send a message to Procmail to validate those tickets are being created correctly. Clean up mail queue, remove all old production messages from the non-production environment. This will take quite a while and probably should be done overnight. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 10:31 AM To: arslist@ARSLIST.ORG
Re: WWRUG12 - Session Question - Database Moving
With Unix it is easy, you can just do a find command on IP or hostname in remedy folders to find all the references and make changes accordingly. But with windows not sure if the same approach will work with registries etc.. In either case I would suggest once your admins copy the VMs just remove/uninstall all remedy components/folders and just reinstall those again as a server group option. That way you would not miss any conf file or registry server name references. Since you are not really doing any upgrade install, just reinstalling same version the installer should not take much time. May be couple of hrs for the entire ITSM suite. Not sure how much it would help you the following. We had to rollout new ITSM env few years ago and we had to copy the db from preprod to prod during the cutover. So I went through several postings in arslist,bmc support site, bmc communities and made a list of items to do before and after. Some of the steps might be outdated or may not valid depending on the specific version so take it with grain of salt. Restore db from Development to Production: Pre db copy: 1. In production servers disable email engine,escalations in ar.conf 2. In dev server disable email mail boxes 3. Delete all pending or unwanted email entries Post db copy: 1. Update the default web path 2. Update Servername, Servergroupname, servergroup ranking entries 3. Form data changes: -- Report form entries with new Server Name -- change server name to development.fqdn or development -- SHARE:Application_Properties, HelpFile URL pointers -- SYS:Application form -- Survey URL -- CAI Application Registry -- In Connection tab, change all Server names from production.fqdn to development.fqdn -- SHR:Association -- The server name is stored in two fields on the form - Server 1 and Server 2 -- Configure Custom Form Info -- SYS:Attachments form -- CMS Configuration Management -- AP:Notifications - Check any custom notifications with Server links -- AP:Rule Definition (Server = @) -- AR System Server Group Operation Ranking -- AR System User Preferences -- Change Report Server values from production to development for any user account you are going to log in with on development -- AR System Administrator Preferences -- Partial List Settings - Partial List Details:Other - Pack List Settings -- AR System Searches Preference -- Delete records from original server -- AR System User Central File -- Delete records for user -- KMS:Administration_Integration-- Change Server Name and Short Description -- SRD:STAGE:MasterDataMappingList -- SRM:ApplicationSettings, if SRM installed, to point to correct web path -- AST:ARServerConnection -- AR Login Info -- AST:ComplianceARBased_Advanced--AR System License Type Compliance -- SYS:Escalations -- SYS:Attachments -- SLM:ConfigPreferences -- Update Dashboard MidTier URL -- SLM:RuleActionSetValue_base -- Found four records to change with SLA_destination Server Name = production.fqdn,Changed all of them to @ -- SLA data sources, service agreements, and service targets with milestones, after the db had been restored -- CHG:CCMCalendar:PrintActionWUT -- Active Links that contain server references -- AREmail Configuration -- update with production email accounts -- Table fields -- check with sql select distinct tfserver from field_table -- AIS:GlobalPreferences form (Atrium Impact Simulator) -- AIE EIE:ApplicationSettings form (field name: Help File Path) -- AIE EIE:BackUpLoadFlag form entries (field names: Host, Internal Instance Name,InstanceName) -- AIE EIE:DataExchange form entries (field names: Instance Name, zTmpInstanceAlias) -- BMC.CORE.CONFIG:BMC_FederatedInterface records (Field name: ARServerName) -- IEORA:RuleHelper (field name: Path) -- EIE:CommonDialog (Help File Path) -- Reinstall and Reconfigure AIE and all Data Exchanges -- Check in remedy metadata(AL,FL tables) to see any hard code server references. 4.The mid-tier configuration, where you specify the Data Visualization server 5.If you have customised any of the OOB notification messages to include a hardcoded a url then you need to change the server name reference. 6. Make sure all the integrations (webservices,scripts,apis,dblinks) pointing to correct environments. 7.Enable email engine,escalations. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
WWRUG12 - Session Question - Database Moving
I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
I'd really like to see the steps also :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 11:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
Claire, I wasn't in that session with you, but I had a utility pointed out to me on BMCDN that takes care of these steps for you, or claims to. Might be work a look https://communities.bmc.com/communities/docs/DOC-7710 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 9:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
Thanks LJ! This might work, except, some things have been modified already. I'm looking for the one or two items that may have been missed and if I use the tool, it could change something else. So I still need the list. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Wednesday, October 31, 2012 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving Claire, I wasn't in that session with you, but I had a utility pointed out to me on BMCDN that takes care of these steps for you, or claims to. Might be work a look https://communities.bmc.com/communities/docs/DOC-7710 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 9:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
Clair: I think you are on windows.. but I have see alot of this with solaris as well.. Look at plugin performance configurations..tuning the javaplugin configuration, with the queue does help.. they are offloading a ton these days to plugin side.. which I don't like much.. personally.. On Wed, Oct 31, 2012 at 11:25 AM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
Susan, Was it Mark Gemmell's presentation titled Huge projects - How to survive when your project hits a home run. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. Date: Wed, 31 Oct 2012 17:30:37 + From: claire.sanf...@memorialhermann.org Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
Hi, or you can do it the easy way using this free utility: http://www.missingpiecessoftware.com/products/remedy-restore-tool If you enter all environment licenses into Production, you can then restore to the environment you require without having to re-apply the licenses. The only thing you need to do is update the DB owner once you have restored the DB then update the references using the MPS Remedy Restore Tool. It does almost all the references, but if there is something I have missed let me know and I will include it. Take the headache out of doing it manually and you can select the options you want to update. Cheers Carl http://www.missingpiecessoftware.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: 31 October 2012 17:49 To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving ** We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. Date: Wed, 31 Oct 2012 17:30:37 + From: claire.sanf...@memorialhermann.org Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers
Re: WWRUG12 - Session Question - Database Moving
I need to be more clear... We copied the entire production server to a new development server. Not the best way to do it I KNOW! Not my decision. I have a new license key. The new Dev server is licensed. I have to know exactly where in the system I need to modify/change the old server references to the new server name. Server Name: ProdRemedy to Server Name: DevRemedy Config.properties Ar.cfg Etc... Server Name: ProdRemedy to Server Name: DevRemedy From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Wednesday, October 31, 2012 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving ** Hi, or you can do it the easy way using this free utility: http://www.missingpiecessoftware.com/products/remedy-restore-tool If you enter all environment licenses into Production, you can then restore to the environment you require without having to re-apply the licenses. The only thing you need to do is update the DB owner once you have restored the DB then update the references using the MPS Remedy Restore Tool. It does almost all the references, but if there is something I have missed let me know and I will include it. Take the headache out of doing it manually and you can select the options you want to update. Cheers Carl http://www.missingpiecessoftware.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: 31 October 2012 17:49 To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving ** We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. Date: Wed, 31 Oct 2012 17:30:37 + From: claire.sanf...@memorialhermann.orgmailto:claire.sanf...@memorialhermann.org Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end
Re: WWRUG12 - Session Question - Database Moving
Claire, there are a ton of new places.. about 40.. on the solaris side.. but I have actually found that doing so does not always make it work as well as the original, but I have not tested the linked software to go with my changes so it is hard for me to give you anything. BMC NEEDS to NORMALIZE its code .. that is for sure.. Servername $BASE/SERVERNAME file with the servername in it.. Referenced in all it's binaries would be nice.. for example. cause the servername is all over the place and in multiples.. Sorry 8-( On Wed, Oct 31, 2012 at 2:05 PM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: ** I need to be more clear… ** ** We copied the entire production server to a new development server. Not the best way to do it I KNOW! Not my decision. ** ** I have a new license key. The new Dev server is licensed. ** ** I have to know exactly where in the system I need to modify/change the old server references to the new server name. Server Name: ProdRemedy to Server Name: DevRemedy Config.properties Ar.cfg Etc… ** ** Server Name: ProdRemedy to Server Name: DevRemedy ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Carl Wilson *Sent:* Wednesday, October 31, 2012 1:01 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: WWRUG12 - Session Question - Database Moving ** ** ** Hi, or you can do it the easy way using this free utility: ** ** http://www.missingpiecessoftware.com/products/remedy-restore-tool ** ** If you enter all environment licenses into Production, you can then restore to the environment you require without having to re-apply the licenses. The only thing you need to do is update the DB owner once you have restored the DB then update the references using the MPS Remedy Restore Tool. ** ** It does almost all the references, but if there is something I have missed let me know and I will include it. Take the headache out of doing it manually and you can select the options you want to update. ** ** Cheers Carl ** ** http://www.missingpiecessoftware.com ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *ravi rai *Sent:* 31 October 2012 17:49 *To:* arslist@ARSLIST.ORG *Subject:* Re: WWRUG12 - Session Question - Database Moving ** ** ** We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. Date: Wed, 31 Oct 2012 17:30:37 + From: claire.sanf...@memorialhermann.org Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may
Re: WWRUG12 - Session Question - Database Moving
You will still need to do all the references to the new system, so this is still valid once you update the system names. System names will need to be updated in a number of spots just to get the AR Server started: plugin.server.xml (both AR and CMDB) ar.cfg armonitor.cfg Windows Registry ... then you can run the Restore Tool to do the rest of the references. I have done a couple of VM's this way renaming the actual server name - always forget to do the Registry. Cheers Carl http://www.missingpiecessoftware.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: 31 October 2012 18:06 To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving ** I need to be more clear. We copied the entire production server to a new development server. Not the best way to do it I KNOW! Not my decision. I have a new license key. The new Dev server is licensed. I have to know exactly where in the system I need to modify/change the old server references to the new server name. Server Name: ProdRemedy to Server Name: DevRemedy Config.properties Ar.cfg Etc. Server Name: ProdRemedy to Server Name: DevRemedy From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Wednesday, October 31, 2012 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving ** Hi, or you can do it the easy way using this free utility: http://www.missingpiecessoftware.com/products/remedy-restore-tool If you enter all environment licenses into Production, you can then restore to the environment you require without having to re-apply the licenses. The only thing you need to do is update the DB owner once you have restored the DB then update the references using the MPS Remedy Restore Tool. It does almost all the references, but if there is something I have missed let me know and I will include it. Take the headache out of doing it manually and you can select the options you want to update. Cheers Carl http://www.missingpiecessoftware.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: 31 October 2012 17:49 To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving ** We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. Date: Wed, 31 Oct 2012 17:30:37 + From: claire.sanf...@memorialhermann.org Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called P to V copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -Original Message- From: Action
Re: WWRUG12 - Session Question - Database Moving
Thanks for the KB link! One thing we do is add entries in the hosts file that directs any traffic trying to go to the production servers back to the dev/test/QA counter part. There are very few cases where we would ever want dev/test/QA to connect to production. Jason On Oct 31, 2012 11:50 AM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: ** I received this reply from BMC Support – very well documented. When I searched the KB, this was not there. Or maybe I just didn’t search it well enough. ** ** Knowledge Article - Making Server Name Changes When Using a Duplicated or Migrated Environment Knowledge Article ID:KA364225 ** ** I am also including a link to the knowledge article as there is an embedded document which contains more information. ** ** https://kb.bmc.com/infocenter/index?page=contentid=KA364225 * * ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Carl Wilson *Sent:* Wednesday, October 31, 2012 1:19 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: WWRUG12 - Session Question - Database Moving ** ** ** You will still need to do all the references to the new system, so this is still valid once you update the system names. ** ** System names will need to be updated in a number of spots just to get the AR Server started: ** ** plugin.server.xml (both AR and CMDB) ar.cfg armonitor.cfg Windows Registry ... ** ** then you can run the Restore Tool to do the rest of the references. ** ** I have done a couple of VM's this way renaming the actual server name - always forget to do the Registry. ** ** Cheers Carl ** ** http://www.missingpiecessoftware.com ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Sanford, Claire *Sent:* 31 October 2012 18:06 *To:* arslist@ARSLIST.ORG *Subject:* Re: WWRUG12 - Session Question - Database Moving ** ** ** I need to be more clear… ** ** We copied the entire production server to a new development server. Not the best way to do it I KNOW! Not my decision. ** ** I have a new license key. The new Dev server is licensed. ** ** I have to know exactly where in the system I need to modify/change the old server references to the new server name. Server Name: ProdRemedy to Server Name: DevRemedy Config.properties Ar.cfg Etc… ** ** Server Name: ProdRemedy to Server Name: DevRemedy ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Carl Wilson *Sent:* Wednesday, October 31, 2012 1:01 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: WWRUG12 - Session Question - Database Moving ** ** ** Hi, or you can do it the easy way using this free utility: ** ** http://www.missingpiecessoftware.com/products/remedy-restore-tool ** ** If you enter all environment licenses into Production, you can then restore to the environment you require without having to re-apply the licenses. The only thing you need to do is update the DB owner once you have restored the DB then update the references using the MPS Remedy Restore Tool. ** ** It does almost all the references, but if there is something I have missed let me know and I will include it. Take the headache out of doing it manually and you can select the options you want to update. ** ** Cheers Carl ** ** http://www.missingpiecessoftware.com ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *ravi rai *Sent:* 31 October 2012 17:49 *To:* arslist@ARSLIST.ORG *Subject:* Re: WWRUG12 - Session Question - Database Moving ** ** ** We dont use any tool do it manually and it is working for us. ARS 7604 sp3 SQL Windows Backup -License -AIE Settings (Data exchange and AIE instance) -Email Configuration Copy Database Restore -License -Email setting -AIE settings -Change CAI Application Registry for server name-SRM -SRM mid tier link -Application settings-SRM -update server name on SRS_CFGAdvanceInterface-SRM -Update Server ranking form for server name -Server Group Read somewhere that copying the FTS conf and Collection directory will reduce the time needed for reindexing and improve performance but have not tried that in our environment.Not seen any performance issues so far. Ravi. Date: Wed, 31 Oct 2012 17:30:37 + From: claire.sanf...@memorialhermann.org Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every