My prod is a 7.5 p3 so I installed to 7.5p3 on my dev environment. Then my Oracle dba's refreshed my dev database from production and reset the aradmin password (I'm not allowed to have that password in production). Prod and dev now have the same binaries, schema and data including all customized forms and workflow. I do have to modify some AIE forms to make sure that the jobs point to the correct box (backup_flags and exchange). From that point I have a mirror of production and can run my 7.6.03 upgrade path.
As far as what a database refresh is... well I'm not positive if that is a normal Oracle process or just some words that our company uses. When I had control of my own MSSQL boxes I could do the same thing by just restoring a backup of production over a dev database that was built out to the same version a prod. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of NormD Sent: Wednesday, January 05, 2011 10:22 AM To: [email protected] Subject: Re: ARS 75p4 to 7.603 upgrade problem What exactly did your DBA do? It sounds like they did a drop and import of prod data which is what I did or did they do something else? Doing this does not update the db schema tables with the new changes introduced by the 7.6 schema changes. In essense you would be running a 7.6 executables against a 7.5 schema db. Once your dba's did their thing, did you resinstall 7.6 overtop of itself to do a db "upgrade" ? -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/ARS-75p4-to-7-603 -upgrade-problem-tp5892010p5892459.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
