Re: Moving ARS 6.3 -> ARS 7.5
Migrator is going to be a haphazard approach as you will run into issues if there are conflicts on things like the user/group forms, some objects doesn't migrate (core fields on display only forms), plus it will take a long time to move things in that way. The best approach, in my experiences, is: 1. export the db from the old production system 2. import the db to the new db instance 3. Install ARS 7.5 on the new arserver and point it at the new db server; the installer should take care of the rest. This approach will take care of altering all the things in the db that are needed to run the newer version of ars, all your data will be there, and it will take much less time and be less problematic than going through the Remedy api. Some other things to check/consider when upgrading: - the character set of the new oracle instance; make sure you use what Remedy supports if youcheck plan on running in unicode (AL32UTF8). Many shops use other character sets (e.g., UTF8). - Make sure you install the 64-bit Oracle client Axton Grams On Fri, Sep 11, 2009 at 11:50 AM, Brittain, Mark wrote: > After thinking about this some more, I have one question. What if the new box > has a different name? > > When we move to the new production box, this will likely not be an issue > because we will keep the same name. But while we are testing our process with > 2 development boxes they will have to have different names so they can both > be on the network. > > Of course if I could use Migrator then it would not be an issue. However it > makes no sense for me to pay a lot of money for something I will use for 30 > days. > > Thanks > Mark > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W > Sent: Thursday, September 10, 2009 10:59 AM > To: arslist@ARSLIST.ORG > Subject: Re: Moving ARS 6.3 -> ARS 7.5 > > Are you sticking with the same applications in Remedy? > > If so I would recommend building the new box, installing Oracle, copying the > data from Oracle 9 (I think the Oracle utility is called Data Pump or > something like that), and installing ARS 7.5 as an upgrade. > > Using the Oracle utility will also copy things like your Procedures/Functions > and dbLinks to the new database. > > The DBAs here used the utility when we moved our databases from a Sun RISC > cluster w/Oracle 9i to a Sun x86 cluster w/Oracle 10g with no problems. > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark > Sent: Thursday, September 10, 2009 9:12 AM > To: arslist@ARSLIST.ORG > Subject: Moving ARS 6.3 -> ARS 7.5 > > ** > HI All, > > I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 > Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, > install ARS 7.5 and the move the data over to the new server. > > Has anyone done this before? Any suggestions on the best way to move the > data? Is there a better way? > > Thanks > Mark Brittain > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that is > privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > 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"
Re: Moving ARS 6.3 -> ARS 7.5
After thinking about this some more, I have one question. What if the new box has a different name? When we move to the new production box, this will likely not be an issue because we will keep the same name. But while we are testing our process with 2 development boxes they will have to have different names so they can both be on the network. Of course if I could use Migrator then it would not be an issue. However it makes no sense for me to pay a lot of money for something I will use for 30 days. Thanks Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, September 10, 2009 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Moving ARS 6.3 -> ARS 7.5 Are you sticking with the same applications in Remedy? If so I would recommend building the new box, installing Oracle, copying the data from Oracle 9 (I think the Oracle utility is called Data Pump or something like that), and installing ARS 7.5 as an upgrade. Using the Oracle utility will also copy things like your Procedures/Functions and dbLinks to the new database. The DBAs here used the utility when we moved our databases from a Sun RISC cluster w/Oracle 9i to a Sun x86 cluster w/Oracle 10g with no problems. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, September 10, 2009 9:12 AM To: arslist@ARSLIST.ORG Subject: Moving ARS 6.3 -> ARS 7.5 ** HI All, I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, install ARS 7.5 and the move the data over to the new server. Has anyone done this before? Any suggestions on the best way to move the data? Is there a better way? Thanks Mark Brittain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Moving ARS 6.3 -> ARS 7.5
Hi Brittain,my fast procedure is: 1) Stop Remedy service in the old server 2) export file dump from the old server launch exp utility user=aradmin 3) in the new server connect with system user --create tablespace arsystem create tablespace arsystem datafile 'arsys1.dat' size 500M autoextend on; --create aradmin user create user aradmin identified by ar#admin# default tablespace arsystem; grant connect, resource,dba to aradmin; from a command windows: imp system/manager file=c:\temp\exp_ars.dmp log=c:\temp\exp_ars.log fromuser=aradmin touser=aradmin feedback=1 4) upgrade remedy version to 7.5 version 5) TEST, TEST, TEST. Ciao Mauro 2009/9/10 Brittain, Mark > ** HI All, > > I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 > Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, > install ARS 7.5 and the move the data over to the new server. > > Has anyone done this before? Any suggestions on the best way to more the > data? Is there a better way? > > Thanks > Mark Brittain > > > * * > This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that > is privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited. > _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"
Re: Moving ARS 6.3 -> ARS 7.5
Fred, Everything here is customized out of the box. No modules such as ITSM. The approach you described makes a lot of sense. Thanks Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, September 10, 2009 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Moving ARS 6.3 -> ARS 7.5 Are you sticking with the same applications in Remedy? If so I would recommend building the new box, installing Oracle, copying the data from Oracle 9 (I think the Oracle utility is called Data Pump or something like that), and installing ARS 7.5 as an upgrade. Using the Oracle utility will also copy things like your Procedures/Functions and dbLinks to the new database. The DBAs here used the utility when we moved our databases from a Sun RISC cluster w/Oracle 9i to a Sun x86 cluster w/Oracle 10g with no problems. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, September 10, 2009 9:12 AM To: arslist@ARSLIST.ORG Subject: Moving ARS 6.3 -> ARS 7.5 ** HI All, I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, install ARS 7.5 and the move the data over to the new server. Has anyone done this before? Any suggestions on the best way to move the data? Is there a better way? Thanks Mark Brittain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Moving ARS 6.3 -> ARS 7.5
Are you sticking with the same applications in Remedy? If so I would recommend building the new box, installing Oracle, copying the data from Oracle 9 (I think the Oracle utility is called Data Pump or something like that), and installing ARS 7.5 as an upgrade. Using the Oracle utility will also copy things like your Procedures/Functions and dbLinks to the new database. The DBAs here used the utility when we moved our databases from a Sun RISC cluster w/Oracle 9i to a Sun x86 cluster w/Oracle 10g with no problems. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Thursday, September 10, 2009 9:12 AM To: arslist@ARSLIST.ORG Subject: Moving ARS 6.3 -> ARS 7.5 ** HI All, I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, install ARS 7.5 and the move the data over to the new server. Has anyone done this before? Any suggestions on the best way to move the data? Is there a better way? Thanks Mark Brittain ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Moving ARS 6.3 -> ARS 7.5
HI All, I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, install ARS 7.5 and the move the data over to the new server. Has anyone done this before? Any suggestions on the best way to more the data? Is there a better way? Thanks Mark Brittain This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"