SEO

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

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.

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@gmx.de


boogab00@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.
>

"Franz Langner" <franzlangner@gmx.de> wrote in message
news:eelih4$6um$1@newsreader2.netcologne.de...
>
> 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@gmx.de
>

Thanks a lot for the feedback, appreciated !!

Cheers
Matthias