I have run into situations on SQL Server where the ARAdmin account was either not brought over, or was no longer the default database owner, but never on Oracle. It could be that the Oracle admins were just better at making sure everything was the same, or it could be that it's transparent.
The account not present is apparent right out of the gate and easy to resolve. The account not being the default dbo seems to be fairly transparent to Remedy, but it makes it so you have to refer to the fully qualified object names. (arsystem.aradmin.TXXX instead of just TXXX). Not a difficult problem to resolve really, but kind of a pain in the neck. Also... I did have one customer years and years ago who's indexes disappeared at one point. Not sure why or how that occurred, but the unexpected always happens at the worst possible time. You'll want to do some basic sanity checks/regression testing and run through simple operations like creating a form, changing indexes, adding/deleting entries and then deleting that form. On Tue, Mar 19, 2013 at 9:43 AM, Hennigan, Sandra <[email protected] > wrote: > ** > > 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: > [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]> 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"**** > > ** ** > > _ARSlist: "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"
