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] > 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 > "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"
