Re: Moving databases and switching server names within
Dear Joe: Thank you for the clue. I was easily able to do with with 6.3 but it has really bit us with our 7.1 to 7.5 upgrade. BTW: We were unable to get the system to upgrade because our assignment engine was only 7.1.0. Patch 0. Parch 3 was the first to put an entry into SHARE:Properties. This destroyed our CMDB install,m requiring database rollback before attempting again. We had so many problems upgrading that we abandoned the effort, stripped the database, and did fresh installs. Fortunately our 7.1 system only contained the foundation data, not thousands of Service Desk records. (Those are still safe in our 6.3 system.) As for doing teh same install over and over again, there are two .xml files that hold all the settings from each install. Blow these away and it will install again. Otherwise it checks these files before touching anything. Each of the installers has their own set (ARS, CMDB, ITSM, and SLM). We did our work on Redhat Linux with Oracle 10g. Thorin From: Joe DeSouza [mailto:joe_rem...@yahoo.com] Sent: Tuesday, May 26, 2009 4:37 PM Subject: Re: Moving databases and switching server names within ** Thorin, If you are talking about server names in the definitions, there is a easier way out.. Take an XML definition file and look for the tag Server-Name This tag will have the offending value so you can do a simple search and replace for what you want to do. And then reimport the def file.. Joe From: Marty.Thorin thorin.ma...@we-energies.com To: arslist@ARSLIST.ORG Sent: Tuesday, May 26, 2009 5:29:50 PM Subject: Moving databases and switching server names within ** Good afternoon: I need to copy a fully loaded Remedy 7.5 server and its database to another machine. Copying and updating the Linux files is easy. I just copy then hunt and replace every instance of the old server's name with the new server name. I thought the Oracle 10g database would be just as easy. (All tablespaces keep the their same name so it is ARSystem everywhere. I will be changing the database server's name.) Last time I brought up Remedy then went to the Admin Console and updated the e-mail engine. I am hesitant to do this because this did not catch all of the instances of the old name. Our 7.1 servers were a mess. We first built the production server with the development database. Then I cloned this to create the development server attached to the production database. Then we fixed it so production server with production database and development server with development database. We started over for our 7.5 installs. I just finished doing the 7.5 production server with its 7.5 production database. The older 7.1 development server is still running. Because of a bug, you must use the default password for ARAdmin when doing a 7.5 ARS install. We quickly ran into Oracle lockouts. Changing the ARAdmin password to the same value as the development server was using fixed the problem. So somehow I missed at least one reference to the production database in the database. (Fortunately for me, the server name change is a one letter change: 'p' for production becomes 't' for test'. The names are the same length.) Does anyone have a list of where to look so I am sure I get all of the instances found in the Oracle database? Thank you, Thorin _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Moving databases and switching server names within
Good afternoon: I need to copy a fully loaded Remedy 7.5 server and its database to another machine. Copying and updating the Linux files is easy. I just copy then hunt and replace every instance of the old server's name with the new server name. I thought the Oracle 10g database would be just as easy. (All tablespaces keep the their same name so it is ARSystem everywhere. I will be changing the database server's name.) Last time I brought up Remedy then went to the Admin Console and updated the e-mail engine. I am hesitant to do this because this did not catch all of the instances of the old name. Our 7.1 servers were a mess. We first built the production server with the development database. Then I cloned this to create the development server attached to the production database. Then we fixed it so production server with production database and development server with development database. We started over for our 7.5 installs. I just finished doing the 7.5 production server with its 7.5 production database. The older 7.1 development server is still running. Because of a bug, you must use the default password for ARAdmin when doing a 7.5 ARS install. We quickly ran into Oracle lockouts. Changing the ARAdmin password to the same value as the development server was using fixed the problem. So somehow I missed at least one reference to the production database in the database. (Fortunately for me, the server name change is a one letter change: 'p' for production becomes 't' for test'. The names are the same length.) Does anyone have a list of where to look so I am sure I get all of the instances found in the Oracle database? Thank you, Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Moving databases and switching server names within
Thorin, If you are talking about server names in the definitions, there is a easier way out.. Take an XML definition file and look for the tag Server-Name This tag will have the offending value so you can do a simple search and replace for what you want to do. And then reimport the def file.. Joe From: Marty.Thorin thorin.ma...@we-energies.com To: arslist@ARSLIST.ORG Sent: Tuesday, May 26, 2009 5:29:50 PM Subject: Moving databases and switching server names within ** Good afternoon: I need to copy a fully loaded Remedy 7.5 server and its database to another machine. Copying and updating the Linux files is easy. I just copy then hunt and replace every instance of the old server's name with the new server name. I thought the Oracle 10g database would be just as easy. (All tablespaces keep the their same name so it is ARSystem everywhere. I will be changing the database server's name.) Last time I brought up Remedy then went to the Admin Console and updated the e-mail engine. I am hesitant to do this because this did not catch all of the instances of the old name. Our 7.1 servers were a mess. We first built the production server with the development database. Then I cloned this to create the development server attached to the production database. Then we fixed it so production server with production database and development server with development database. We started over for our 7.5 installs. I just finished doing the 7.5 production server with its 7.5 production database. The older 7.1 development server is still running. Because of a bug, you must use the default password for ARAdmin when doing a 7.5 ARS install. We quickly ran into Oracle lockouts. Changing the ARAdmin password to the same value as the development server was using fixed the problem. So somehow I missed at least one reference to the production database in the database. (Fortunately for me, the server name change is a one letter change: 'p' for production becomes 't' for test'. The names are the same length.) Does anyone have a list of where to look so I am sure I get all of the instances found in the Oracle database? Thank you, Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
