Hi Matthias,
we've done this just a couple of days before:
The Job was migrating a middlerange HTMLDB - Instance from 9.2.0.7 to
10g. 9 Tablespaces, about 20 Apps, Datavolume nearby 4 G,
charactersetconversion included.
The old one was running on SUSE 8.2 PRO , the new one hides in a SLES9 SP3.
Here's a short description what to do:
- you can lift up the existing htmldb 2.0
- after doing this, export the existing workspaces with workspace export
assistant. ( this has to be done, otherwise you won't get stable
security for your applications )
- export each application because their logic does not reside in the
user-scheme
- create the necessary tablespaces w datafiles on 10g-instance ( named
FlOWS_XXXX )
- install the fresh apex 2.2 on the 10g( neither using sysaux I've
choosen a tablespace apex/apex-Files for it)
- import the workspaces with workspaces import assistant
- import each application from its sqlfile, one by one ( use sqlplus
commandline as FLOWS_020200 for doing this )
* after this your security mechanism is working and your application
logic is working
- now you can do exp/imp on the schemas from the old to the 10g.
* this will bring in your data and business-logic towards your application.
We did not notice any issues after that kind of upgrade.
You'll get further compentent hints on forums.oracle.com , lookin in the
Application express-forum.
Regards Franz
franzlangner_at_gmx.de
boogab00_at_yahoo.com schrieb:
> Matthias Hoys wrote:
>> Guys (and girls if there are any),
>>
>> I'm preparing for the migration of an Oracle 9i database with HTMLDB 2.0
>> running on AIX to a new Oracle 10g server with APEX 2.2 running on RHEL 4.0.
>> I'm not sure what's the best way to migrate/upgrade the HTMLDB applications.
>> Should I export the HTMLDB schemas from Oracle 9i, import them into the 10g
>> and then upgrade to APEX 2.2 ? Or should I upgrade the 9i first to APEX 2.2
>> and then export/import the schemas ? What about the Apache configuration ?
>>
>> Has anyone done this kind of migration before ? Any known issues after the
>> upgrade to APEX 2.2 ?
>>
>>
>> Thanks
>> Matthias
>
> I think I would go ahead and create the new APEX 2.2, linux enviroment
> and then export/import you're HTMLDB stuff.
>
Received on Mon Sep 18 2006 - 02:40:21 CDT