Question, was your 9i database upgraded from older version of Oracle? One thing that you may miss out are some of the new data types that have been introduced over the years.
It has been a while since I worked with Oracle but I remember one upgrade, by creating a fresh install of ARS 6.3 and migrating defs from the old system that was build on 4.x (not sure what version of Oracle it started on), some of the fields converted to to newer data types. Sorry I don't remember the specifics. Maybe one of them was CLOBs because we were able to do wild card searches on the work log field on the new system. Jason On Wed, Feb 27, 2008 at 5:11 AM, Tadeu Augusto Dutra Pinto < [EMAIL PROTECTED]> wrote: > Hi Mário, > > We're finalizing our migration process .. > At the moment, we tested only on Test Server ... > We're migrating from [[ ARS 5.3, Oracle 9i, AIX 5.2 ]] to [[ ARS 7.0.01, > Oracle 10g, AIX 5.3 ]] > > Firstly: we're separating our system... DB, OS and ARS (each one in each > server) > > - Our first step was to create a new filesystem for new AIX 5.3 Server; > - Second, we export only database filesystem from the old server to our > new server (this new server is only for database); > - Then, we did a copy of our database to our new server, and after, e did > a restore at database... > - Next Step: Install/config of ARS version 7.0.01 on its new server... > - So, we import our def files that were updated; > - Configuration of DNS, instance, etc... > > > P.S.: you'll need to config var Lang to correct problems with special > characters (i.e. "ã, í, ç" becomes "?") > > Then finally, "test" very well these.... > > We executed many test cases on our homologation/test server... > > > Att, > > Tadeu Augusto Dutra Pinto > ----------------------------------------------------------------- > IT Web Services ATM > Cinq Technologies > http://www.cinq.com.br > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Fone: 41 3018-2833 - Cinq > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Fone: 41 2107-5736 - HSBC Outsourcing > ----------------------------------------------------------------- > Confiabilidade, Inovação e Qualidade em T.I. > > ________________________________ > > De: Action Request System discussion list(ARSList) em nome de Mario > Roberto Porto Fº > Enviada: ter 26/2/2008 19:54 > Para: [email protected] > Assunto: Migration from ARS 5.1.2 to 7.1 > > > > ** > Hi All, > > Is there anyone in the list who have migrated ARS from 5.1.2 directly to > 7.1 ? > I'd like to know if anybody faced any situation that requeries more > atention or effort. > > In addition, i need to decide the best migration mode. i personally prefer > the UPDATE > mode using ar system installer. We did that when we migrated 4.5 to 5.1.2and > it was OK. > > The problem now envolves the migration of the OS ( AIX 4.3 to 5.2 ). Next, > the > script we are planning to do > 1 - Copy ar system filesystem from AIX 4.3 to an AIX 5.2 machine > 2 - Start ARS 5.1.2 on this new machine ( Is this really works ? ) > 3 - Run installer on UPDATE mode > > Scenario > From > ARS 5.1.2 Patch 1389 > AIX 4.3 , Oracle 9i > To > ARS 7.1 > AIX 5.2, Oracle 10 > > > Thanks > > Mário Roberto Porto Filho > Analista de Tecnologia da Informação > Tecnologia Bancária S/A > (11) 4196-7883 > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
