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_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.
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.
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.
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;
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.
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
See Also: Oracle HTTP Server mod_plsql User's Guide for information on overriding the CGI environment variables and "Oracle Text Requirement" |