Thank you everyone that replied. I'll let you know the results.
- Scary in the simplicity. There are many more steps when moving a SQL db including changing ownership of the db. Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Tuesday, March 19, 2013 12:14 PM To: arslist@ARSLIST.ORG Subject: Re: Relocate Oracle database to a different server ** Sandra, Due to the fact that the TNSNames.ora file is the clients connection to the DB, yes, changing that will re-point your Remedy instance to the new db On Tue, Mar 19, 2013 at 9:50 AM, Hennigan, Sandra <sandra.henni...@usdoj.gov<mailto:sandra.henni...@usdoj.gov>> wrote: All, I just found out that the Oracle database instance to which I installed full ITSM 8.1 is in Test; the servers are in production. The db needs to be moved to production. Windows 2008 R2 Oracle 11g ARS & full ITSM suite 8.1 The Oracle DBA will handle the copy of the database from test to production. This article on BMC Communities seems to address my needs - Aug 17, 2012 12:22 AM Making ARS point to a Database Server that is installed on a different machine Hi, I have ARS & Database (Oracle) installed on the same machine. However, as per business requirements ARS & Database need to be there on different machines. Assume that we have installed Oracle on a different machine, replicated it with the original database. Can anyone provide me with the Checklist that gives an exact idea about what changes need to be taken care of at Remedy end? I need the exact details (changes in the config files, etc) to implement the same. I would be more than satisfied if anyone could provide me with a detailed checklist as an attached file. Thanks ! Correct Answer by Pankaj Jadhav on Aug 21, 2012 11:08 PM Hi Friends, Actually we made no changes to the config file. We made no change at Remedy end as the new database was made as a clone of the original database. Even the "Oracle-Two-Task" parameter was kept untouched in the config file as the connection string was kept the same as that was before. Appropriate changes were made in "tnsnames.ora" file by the DBA, and this was enough. Is it really that simple for me, the Remedy developer > I stop ARS, DBA relocates the database & updates the tnsnames.ora, I start ARS? Does the Oracle DBA know which tnsnames.ora file to change? Any "Got-yous" to prepare for? Precautions? Assistance is appreciated. Thank you! Sandra Hennigan Remedy Developer _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"