A Oracle HTML DB Troubleshooting

This appendix contains information on troubleshooting.

This chapter contains these topics:

Reviewing a Log of an Installation Session
Cleaning Up After a Failed Installation
Images Displaying Incorrectly in Oracle HTML DB
Online Help Not Working

A.1 Reviewing a Log of an Installation Session

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_020000 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.

A.2 Cleaning Up After a Failed Installation

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_020000 schema.

To reinstall, you need to drop either one or two database schemas depending upon the installation type.

A.2.1 After a Failed Upgrade Installation

In the case of a failed upgrade installation, you need to revert Oracle HTML DB to to a previous release (either release 1.5 or release 1.6) and then remove the schemas associated with release 2.0.

A.2.1.1 Reverting to Previous Release

To revert a previous Oracle HTML DB release:

If you altered your images directory, you need to point the text alias /i/ back to images directory for release 1.5. (See "Copying the Images Directory When Upgrading".)

Execute the following command in SQL*Plus:

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
```

To revert to Oracle HTML DB release 1.5, execute the following:

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_010500;
exec flows_010500.wwv_flow_upgrade.switch_schemas
('FLOWS_020000','FLOWS_010500');

To revert to Oracle HTML DB release 1.6, execute the following:

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_010600;
exec flows_010600.wwv_flow_upgrade.switch_schemas
('FLOWS_020000','FLOWS_010600');

To remove the release 2.0 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_020000 CASCADE;
```

A.2.2 After a Failed New Installation

To remove schemas after a failed new installation:

Start SQL*Plus and connect the database where Oracle HTML DB is installed as SYS or SYSTEM.

Execute the following commands:

drop user FLOWS_020000 cascade;
drop user FLOWS_FILES cascade;

A.3 Images Displaying Incorrectly in Oracle HTML DB

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 definition 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.

A.4 Online Help Not Working

If users are accessing Oracle HTML DB through a Virtual Host, the online help will not work. Consider the following example:

The hostname of the Oracle HTTP Server where the Oracle HTML DB DAD resides is internal.server.com and the port is 7777.
Users access Oracle HTML DB through a Virtual Host. In their Web browsers, users see external.server.com and the port 80.

In this example, Oracle HTML DB online help will not work if the users cannot access internal.server.com. To resolve this issue, add the following lines to the Oracle HTML DB Database Access Descriptor (DAD) to override the CGI environment variables SERVER_NAME and SERVER_PORT:

PlsqlCGIEnvironmentList SERVER_NAME=external.server.com
PlsqlCGIEnvironmentList SERVER_PORT=80