This chapter describes how to install Oracle HTML DB release 2.0.
This chapter contains these topics:
If you plan to install Oracle HTML DB, Oracle recommends that you complete the following steps before beginning the installation:
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.
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 |
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.
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.
See Also: Oracle Database PL/SQL User's Guide and Reference for more information about SQL*Plus |
To install Oracle HTML DB release 2.0:
Download the file htmldb_2.0.zip
.
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
Change your working directory to htmldb
.
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
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