# bauler - upgrade for APEX patch on XE

bauler is a utility to upgrade APEX on an XE database. The reason this is needed is that Oracle provides patch sets for APEX but only for paying customers. Seeing as though both Oracle XE and APEX are free, it makes sense you would need a method to upgrade to the latest version (which is currently difficult without the patch sets).

A way around this is to backup all workspaces, remove APEX and then re-install everything.

The backup functionality is provided through way of a Java program provided within the APEX installation files. Assuming you unzipped APEX installation files to `$ORACLE_HOME/apex`, you can initiate a workspace export with:

```
export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc5.jar:${ORACLE_HOME}/apex/utilities/
java oracle.apex.APEXExport -db localhost:1521:XE -user system -password oracle -expWorkspace
```

It is worth reading the full documentation to see what options are available, which can be found at: `$ORACLE_HOME/apex/utilities/readme.txt`

This should only be used for minor updates - major updates should be installed with a full installation.

Usage:

```
./upgrade.sh /path/to/apex/install/files host port sid system_password sys_password
```

Current caveats:

* This should be run from the server apex is installed on - so that images can be updated
* Users against the internal workspace will be lost
* instance configuration not backed up/restored

# bauler - upgrade for APEX patch on XE

bauler is a utility to upgrade APEX on an XE database. The reason this is needed is that Oracle provides patch sets for APEX but only for paying customers. Seeing as though both Oracle XE and APEX are free, it makes sense you would need a method to upgrade to the latest version (which is currently difficult without the patch sets).

A way around this is to backup all workspaces, remove APEX and then re-install everything.

The backup functionality is provided through way of a Java program provided within the APEX installation files. Assuming you unzipped APEX installation files to `$ORACLE_HOME/apex`, you can initiate a workspace export with:

```
export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc5.jar:${ORACLE_HOME}/apex/utilities/
java oracle.apex.APEXExport -db localhost:1521:XE -user system -password oracle -expWorkspace
```

It is worth reading the full documentation to see what options are available, which can be found at: `$ORACLE_HOME/apex/utilities/readme.txt`

This should only be used for minor updates - major updates should be installed with a full installation.

Usage:

```
./daxul.sh /path/to/apex/install/files host port sid system_password sys_password
```

Current caveats:

* This should be run from the server apex is installed on - so that images can be updated
* Users against the internal workspace will be lost
* instance configuration not backed up/restored

Update example on how to call
Update example on how to call
