If you're can get away with leaving the tns connection name intact then it will be transparent to the remedy server.
There are multiple possible locations for the tnsnames file, so you'll want to test connectivity with a client tool like SQLPlus under the same environment that Remedy is being started under. SQLDeveloper maintains it's own connections and bypasses the tnsnames, so I wouldn't use that to test. The location of TNSNames has a couple of default locations and can be changed with an environment variable. If you have to change the name of the database, but the Remedy application server itself will maintain the same name, then updating the connection info in ars.conf will be necessary. Assuming no database level integration points exist, that's all you'll need. Thanks, Steve On Tue, Mar 19, 2013 at 8:50 AM, Hennigan, Sandra <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 > "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"
