2 Oracle HTML DB Installation Requirements

This chapter describes the requirements for installing Oracle HTML DB, release 2.0.

This chapter contains these topics:

Oracle Database Requirement
Oracle HTTP Server Requirement
Disk Space Requirement
Oracle XML DB Requirement
Oracle Text Requirement
Browser Requirement

2.1 Oracle Database Requirement

Oracle HTML DB version 2.0 requires an Oracle database that is release 9.2.0.3 or higher.

2.1.1 Checking the shared_pool_size of the Target Database

Oracle HTML DB requires the shared_pool_size of the target database to be at least 100 MB.

To check the shared_pool_size of the target database:

Start the database:
```
SQL> STARTUP
```
If necessary, enter the following command to determine whether the system uses an initialization parameter file (initsid.ora) or a server parameter file (spfiledbname.ora):
```
SQL> SHOW PARAMETER PFILE;
```
This command displays the name and location of the server parameter file or the initialization parameter file.
Determine the current values of the shared_pool_size parameter:
```
SQL> SHOW PARAMETER SHARED_POOL_SIZE
```
If the system is using a server parameter file, set the value of the SHARED_POOL_SIZE initialization parameter to at least 100 MB:
```
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;
```
If the system uses an initialization parameter file, change the values of the SHARED_POOL_SIZE parameter to at least 100 MB in the initialization parameter file (initsid.ora).
Shut down the database:
```
SQL> SHUTDOWN
```
Restart the database:
```
SQL> STARTUP
```

2.2 Oracle HTTP Server Requirement

Oracle HTML DB must have access to Oracle HTTP Server and mod_plsql in order to run. The following products include the versions of HTTP Server and mod_plsql that meet this requirement:

Oracle 9i Database release 2 (9.2) or higher
Oracle 9i Application Server release 1 (1.0.2.2) or higher

2.3 Disk Space Requirement

Verify that the file system that contains the Oracle home directory contains at least 460 MB of free disk space for the installation. The system drive disk space requirement is 100 MB.

The disk space requirements are as follows:

Software files in the Oracle home: 459 MB
c:\Program Files\Oracle directory: 0.5 MB
TEMP directory: 110 MB

2.4 Oracle XML DB Requirement

Oracle XML DB must be installed in the Oracle database that you want to use. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

2.5 Oracle Text Requirement

Oracle Text must be installed so that you can use the searchable online help in Oracle HTML DB. By default, Oracle Text is installed as part of Oracle Database.

In addition, make sure that the default language preferences for Oracle Text have been installed. To install the Oracle Text default language, log into the Oracle database where you plan to install Oracle HTML DB and run the appropriate drdeflang.sql script, which by default is located in ORACLE_BASE\ORACLE_HOME\ctx\admin\defaults. For example, to run the language preferences script for US English, drdefus.sql:

c:\> sqlplus sys/SYS_password as sysdba
SQL> @c:\oracle\product\10.2.0\db_1\ctx\admin\defaults\drdefus.sql

2.6 Browser Requirement

To view or develop Oracle HTML DB applications, Web browsers must support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:

Microsoft Internet Explorer 6.0 or higher (Windows only)
Netscape Communicator 7.0 or higher
Mozilla 1.2 or higher
Firefox 1.0 or higher