This appendix contains information on troubleshooting.
This chapter contains these topics:
The htmldbins.sql script creates a log file in the htmldb directory using the naming convention installYYYY-MM-DD_HH24-MI-SS.log. In a successful installation, the log file contains the following text:
Thank you for installing Oracle HTML DB. Oracle HTML DB is installed in the FLOWS_010600 schema.
If the log file contains a few errors, it does not mean that your installation failed. Note that acceptable errors are noted as such in the log file.
In a successful installation the following banner displays at the end of the installation:
Thank you for installing Oracle HTML DB. Oracle HTML DB is installed in the FLOWS_010600 schema.
To reinstall, you need to drop either one or two database schemas depending upon the installation type.
In the case of a failed upgrade installation, you should first revert Oracle HTML DB to release 1.5 and then remove the schemas associated with release 1.6.
To revert Oracle HTML DB to release 1.5:
Execute the following command in SQL*Plus:
Start SQL*Plus and connect the database where Oracle HTML DB is installed as SYS or SYSTEM.
Execute the following:
ALTER SESSION SET CURRENT_SCHEMA = FLOWS_010500;
exec flows_010500.wwv_flow_upgrade.switch_schemas
('FLOWS_010600','FLOWS_010500');
To remove the release 1.6 schema:
Start SQL*Plus and connect the database where Oracle HTML DB is installed as SYS or SYSTEM.
Execute the following commands:
DROP user FLOWS_010600 CASCADE;
In "Configuring Oracle HTTP Server in a New Installation", you added an alias entry that points to the file system path where you copied the images directory. If images in Oracle HTML DB do not display correctly, you may have more than one defintion of the /i/ alias. To address this issue:
If possible, rename the first instance of /i/ to a different alias name.
Alternatively, copy the images from the ORACLE_BASE\ORACLE_HOME\marvel\images directory to the directory defined by the first /i/ alias.