The Oracle XE tab enables you to modify the configuration settings specific to Oracle XE database engine.
The Oracle XE tab
Oracle XE is supported on the following platforms:
Windows XP Professional
Windows 2000
Windows Server 2003 and Windows Server 2003 R2
32 Bit Windows Vista (Vista Business, Ultimate and Enterprise Editions)
Before you start the redistribution of the Oracle XE engine you must register on the Oracle web site:
http://www.oracle.com/technology/products/database/xe/index.html
You can download a preconfigured package for Oracle XE support in the Add-On Packages topic.
The fields in http.ini specific to the
Oracle XE section are shown below:
[OracleXE] ; Install Oracle XE Engine settings Install=1
InstallDir=##DWEBPRO_SYSTEMDRIVE##\oraclexe SYSPassword=oraclexe
InstallerScript=##DWEBPRO_PATH##\engine\oraclexe\OracleXE-Install.iss
InstallerCommand="##DWEBPRO_PATH##\engine\oraclexe\OracleXEUniv.exe" /s /f1"##DWEBPRO_ORACLEXE_INSTALLERSCRIPT##" /f2"##DWEBPRO_TEMP##\setup.log" LazyErrorHandling=1 ; Network settings TNSPort=1521
MTSPort=2030
HTTPPort=8088
FindFreePort=1
; Restore settings ShowRestoreCommands=0 RestoreCommand.0="##DWEBPRO_ORACLEXE_HOME##\bin\imp.exe" system/oraclexe file="##DWEBPRO_PATH##\engine\oraclexe\sample.dmp" full=yes
Install Oracle XE Engine settings
Install Oracle XE Engine
Install
Install Oracle XE Engine specifies whether Oracle XE is
installed upon start up of DWebPro. The install process is executed only once.
Accepted values: 0, 1
Install Dir
InstallDir
Install Dir specifies the destination folder into which DWebPro will install Oracle XE. This value will be saved in the
DWEBPRO_ORACLEXE_INSTALLDIR internal constant and it will be used during the parsing of the InstallerScript file. Accepted values: string
System Password
SYSPassword
System Password specifies the password of the system user of the Oracle XE engine. This value will be saved in the
DWEBPRO_ORACLEXE_SYSPASSWORD internal constant and it will be used during the parsing of the InstallerScript file. Accepted values: string
Installer Script
InstallerScript
Installer Script specifies the path of the Oracle XE install script. This value will be copied into a temporary folder, parsed agains the DWebPro internal constants and then used to start the Oracle XE installer. The value of the installer script path will be saved in the
DWEBPRO_ORACLEXE_INSTALLERSCRIPT internal constant.Accepted values: string
Installer Command
InstallerCommand
Installer Command specifies the path of the Oracle XE install script. This value will be copied into a temporary folder, parsed agains the DWebPro internal constants and then used to start the Oracle XE installer. The value of the installer script path will be saved in the
DWEBPRO_ORACLEXE_INSTALLERSCRIPT internal constant.Accepted values: string
Network settings
MTS Port
MTSPort
MTS Port specifies the port on which the Oracle MTS service will listen on. This value will be saved in the
DWEBPRO_ORACLEXE_MTS_PORT internal constant and it will be used during the parsing of the InstallerScript file. Accepted values: integer
TNS Port
TNSPort
TNS Port specifies the port on which the Oracle TNS service will listen on. This value will be saved in the
DWEBPRO_ORACLEXE_TNS_PORT internal constant and it will be used during the parsing of the InstallerScript file. Accepted values: integer
HTTP Port
HTTPPort
HTTP Port specifies the port on which the Oracle MTS service will listen on. This value will be saved in the
DWEBPRO_ORACLEXE_HTTP_PORT internal constant and it will be used during the parsing of the InstallerScript file. Accepted values: integer
Find Free Port
FindFreePort
Find Free Port specifies whether DWebPro
should search for a free port for the MTS, TNS and HTTP Oracle services.
Accepted values: 0, 1
Restore settings
Show Restore Commands
ShowRestoreCommands
Show Restore Commands specifies if DWebPro has to show the restore commands execution to the user or not.
Accepted values: 0, 1
Restore Commands
RestoreCommand.X
Restore Command specifies the commands that DWebPro will execute to restore your databases into the new Oracle XE instance. You must insert one command per row. In the
http.ini file, each command will be saved in a field named RestoreCommand.X where the X will be a number >= 0 in concecutive order (i.e. RestoreCommand.0, RestoreCommand.1, RestoreCommand.2 and so on).Accepted values: string