3 Installing the Software

3.1 Recommended Pre-installation Tasks

If you plan to install Oracle HTML DB, Oracle recommends that you complete the following steps before beginning the installation:

1. Shut down any existing Oracle Database instances, as well Oracle-related processes.

   Shut down any existing Oracle Database instances with normal or immediate priority, except for the database where you plan to install the Oracle HTML DB schemas. On Real Application Clusters (RAC) systems, shut down all instances on each node.

   If Automatic Storage Management (ASM) is running, shut down all databases that use ASM except for the database where you will install Oracle HTML DB, then shut down the ASM instance.

   You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to shut down Oracle Database and ASM instances. Names of Oracle databases are preceded with OracleService. The Oracle ASM service is named OracleASMService+ASM. In addition, shut down the OracleCSService service, which ASM uses. Right-click the name of the service and from the menu, choose Stop.

2. Back up the Oracle Database installation.

   Oracle recommends that you create a backup of the current installation of Oracle Database installation before you install Oracle HTML DB. You can use Oracle Database Recovery Manager, which is included the Oracle Database installation, to perform the backup.

   See Also:

   Oracle Database Backup and Recovery Basics

3. Start the Oracle Database instance that contains the target database.

   After backing up the system, you must start the Oracle instance that contains the target Oracle database. Do not start other processes such as the listener or Oracle HTTP Server. However, if you are performing a remote installation, make sure the database listener for the remote database has started. To start the database instance or listener, you can use the Windows Services utility.

   Note:

   If you are connecting to a remote database, then start the listener.

3.2 Installing the Oracle HTML DB Software

To install Oracle HTML DB release 2.0 you must download and unzip the file htmldb_2.0.zip on a computer where you can connect to the target database using SQL*Plus as the SYS user.

To install Oracle HTML DB release 2.0:

1. Download the file htmldb_2.0.zip.

2. Unzip htmldb_2.0.zip as follows, preserving directory names:

   • UNIX and Linux: unzip htmldb_2.0.zip

   • Windows: Double click the file htmldb_2.0.zip in Windows Explorer

3. Change your working directory to htmldb.

4. Start SQL*Plus and connect the database where Oracle HTML DB is installed as SYS or SYSTEM, for example:

   c:\> sqlplus sys/SYS_password as sysdba
   
   

5. Run htmldbins.sql passing the following six arguments in the order shown:

   @htmldbins password tablespace_htmldb tablespace_files tablespace_temp images connect
   
   

   Where:

   • password is the password for the Oracle HTML DB administrator account, the HTML DB schema owner, and the HTML DB files schema owner.

     The HTML DB schema owner is the user or schema into which Oracle HTML DB database objects will be installed. The HTML DB files schema owner is the user or schema where uploaded files are maintained in Oracle HTML DB.

   • tablespace_htmldb is the name of tablespace for the Oracle HTML DB application user.

   • tablespace_files is the name of tablespace for the Oracle HTML DB files user.

   • tablespace_temp is the name of the temporary tablespace.

   • images is the virtual directory for Oracle HTML DB images. To support future Oracle HTML DB upgrades, define the virtual image directory as /i/.

   • connect is the Oracle Net connect string to the database. If this is a local install, use none or NONE.

     The following examples demonstrate running htmldbins.sql and passing these arguments when the target database is Oracle Database 10g release 1 (10.1):

     Local installation:

     sqlplus "sys/syspass as sysdba" @htmldbins password SYSAUX SYSAUX TEMP /i/ none
     
     

     Using a connect string:

     sqlplus "sys/syspass@10g as sysdba" @htmldbins password SYSAUX SYSAUX TEMP /i/ 10g