Thank you for your response! ARS services were stopped. DBA copied/moved database. Upon completion of move, the client TNSNames.ora was modifed to reflect the db change then ARS services started. It was scary how easy the process ended up being (probably due to a good on site Oracle DBA) The DBAis going to list the steps he took - if I get a copy, I will post it.
Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, Lj Sent: Tuesday, March 19, 2013 12:14 PM To: [email protected] 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 <[email protected]<mailto:[email protected]>> 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"
