Skip Headers
Oracle® HTML DB Installation Guide
Release 2.0

Part Number B16375-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

A Oracle HTML DB Troubleshooting

This appendix contains information on troubleshooting.

This chapter contains these topics:

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:

  1. 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".)

  2. Execute the following command in SQL*Plus:

    1. 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
      
      
    2. 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');
      
      
    3. 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:

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

  2. 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:

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

  2. 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:

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:

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

See Also:

Oracle HTTP Server mod_plsql User's Guide for information on overriding the CGI environment variables and "Oracle Text Requirement"