This appendix contains the following information on troubleshooting:
Before you try any of the troubleshooting steps in this appendix, do the following:
Check Chapter 2, "Oracle Database Companion CD Requirements" to make sure that the system meets the requirements and that you have completed all of the preinstallation tasks.
Read the release notes for the product on your platform before installing it. The release notes are available on the Oracle Database installation media. You can find the latest version of the release notes on the Oracle Technology Network Web site:
http://www.oracle.com/technology/index.html
This section covers the following topics:
Oracle Universal Installer creates the DRIVE_LETTER
:
\ORACLE_BASE\ORACLE_HOME
\Inventory\logs
directory the first time it runs to record an inventory of products that it installs on your system as well as other installation information.
The log file is named installActions
date_time
.log
, where date_time
is the date and time of the installation. For example, installActions2004-055-14_09-00-56-am.log
.
You can also view a list of installed components by clicking Installed Products on any window of Oracle Universal Installer.
Note:
Do not delete or manually alter theInventory
directory or its contents. Doing so can prevent Oracle Universal Installer from locating products that you install on your system.
The installActions
date_time
.log
file contains a log of actions executed during the installation process. This file also records any link errors during installation. Do not delete or alter the installActions
date_time
.log
file.
After you install Oracle HTML DB, Oracle Universal Installer 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 necessarily mean that your installation failed. Acceptable errors are noted as such in the log file.
Stop the Oracle HTTP Server as described in the "Starting, Stopping, or Restarting Oracle HTTP Server".
Proceed to the following sections to complete the process:
If an installation fails, you must remove files that Oracle Universal Installer created during the attempted installation and remove the Oracle home directory. Perform the following steps to remove the files:
Insert Oracle Database installation media and navigate to the companion
directory. Alternatively, navigate to the directory where you downloaded or copied the installation files. Then double-click setup.exe
to start Oracle Universal Installer.
Click Deinstall Products on the Welcome window or Installed Products available on any Oracle Universal Installer window. The Inventory window appears, listing installed products.
Select the products that you want to remove and click Remove.
Note:
If you have more than one installation on the system, products installed in other Oracle homes appear in the Inventory window. If you select products from other Oracle homes, they are deinstalled.If you installed Oracle HTTP Server, manually remove the Oracle HTTP Server Oracle home directory used in the failed installation.
If you installed Oracle HTML DB, follow the steps in the next section.
In a successful Oracle HTML DB 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.
However, if the installation fails, in addition to using Oracle Universal Installer to remove the Oracle HTML DB components, you need to drop either one or two database schemas depending upon the installation type before retrying the installation.
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:
If you altered your images directory, you need to point the text alias /i/
back to images directory for 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
, for example:
c:\> sqlplus sys/SYS_password as sysdba
Execute the following:
SQL> ALTER SESSION SET CURRENT_SCHEMA = FLOWS_010600; SQL> exec FLOWS_010600.wwv_flow_upgrade.switch_schemas ('FLOWS_010600','FLOWS_010600');
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;
To determine whether a silent or nonintereactive installation succeeds or fails, check the silentInstallActions
date_time
.log
file, located in the DRIVE_LETTER
:\Program Files\Oracle\Inventory\logs
directory.
A silent installation fails if:
You do not specify a response file.
You specify an incorrect or incomplete response file.
For example, a common problem is that while all the product-specific data is filled out correctly, the staging area location may be incorrect. If this is the case, check the FROM_LOCATION
variable and make sure that it points to the products.xml
file in the installation media. In the installation media, this products.xml
is in companion\stage
.
Oracle Universal Installer encounters an error, such as insufficient disk space.
Oracle Universal Installer or a configuration assistant validates the response file at runtime. If the validation fails, the installation or configuration process ends. Oracle Universal Installer treats values for parameters that are of the wrong context, format, or type as if no value was specified in the file.
See Also:
"Reviewing a Log of an Installation Session" for information on interactive installation log filesIf the images in Oracle HTML DB do not display correctly, Oracle HTML DB may be having a problem locating the directory where these images are stored. The directory location for the images is stored in an alias in the marvel.conf
file. To address this problem:
Open the marvel.conf
file, located in ORACLE_BASE
\
ORACLE_HOME
\Apache\modplsql\conf
, in a text editor.
Look for an alias to the images
directory, which appears similar to the following:
Alias /i/ C:/oracle/product/10.2.0/db_HTMLDB/htmldb/images
Check for the following problems:
If the /i/
alias appears more than once, rename the first instance of /i/
to a different alias name. Alternatively, copy the images from the ORACLE_BASE
\
ORACLE_HOME
\htmldb\images
directory to the directory defined by the first /i/
alias.
If the /i/
alias points to an incorrect directory, correct the directory path.
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