Thursday, April 24, 2008

Developing own program using Oracle XE and APEX

Steve Hall method:
1) Fresh install of Oracle XE to default location on new machine,
2) Run backup.bat script on my development machine (ApEx 3.1, my app etc),
3) Copied these files / folders from the development machine to the new installation :
flash_recovery_area\XE\AUTOBACKUP\*
flash_recovery_area\XE\BACKUPSET\*
product\10.2.0\server\database\SPFILE2INIT.ORA
4) Run the restore.bat script on the target machine.
Voila! ApEx 3.1 and my app on the target machine. It needs more testing and automating but it certainly seems to work 'in the lab'.

Suggestion: You can try the COMPRESS option in backup.

Andre method:
Basically the steps are as follows.

1. Create your schema.
2. Create a workspace using that schema.
3. Create your underlying db objects.
4. Import the application into the workspace.

This is pretty basic and there may be some other steps required to complete the job, such as importing images and workspace users but overall, once you do it once, its not that hard.

1 comment:

tscottt said...

I've tried the first method a few times on an important database of mine I'm trying to migrate to a new machine. So far, no luck. RMAN refuses to cooperate:

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=432 devtype=DISK

recovery area destination: /usr/lib/oracle/xe/app/oracle/flash_recovery_area
database name (or database unique name) used for search: XE
channel ORA_DISK_1: no autobackups found in the recovery area
autobackup search outside recovery area not attempted because DBID was not set


I'll take a new backup and see if that works.