F Troubleshooting

This appendix describes solutions to common problems that you might encounter when installing Oracle Portal, Forms, Reports and Discoverer. It contains the following sections:

F.1 General Troubleshooting Tips

If you encounter an error during installation:

F.2 Installation and Configuration Log Files

This section contains information about the log files that are created when running the Oracle Portal, Forms, Reports and Discoverer installar and the Configuration Wizard. Log files contain information that can help you troubleshoot problems with your installation or configuration.

F.2.1 Installation Log Files

The installer writes logs files to the Oracle_Inventory_Location/log (on UNIX operating systems) or Oracle_Inventory_Location\logs (on Windows operating systems) directory. On UNIX systems, if you do not know the location of your Oracle Inventory directory, you can find it in the oraInst.loc file in the following directories (default locations):

  • Linux: /etc/oraInst.loc

  • HP-UX and Solaris: /var/opt/oracle/oraInst.loc

On Windows systems, the default location for the inventory directory is C:\Program Files\Oracle\Inventory\logs.

The following install log files are written to the log directory:

  • installdate-time-stamp.log

    This is the main log ifle.

  • installdate-time-stamp.out

    This log file contains the output and error streams during the installation.

  • installActionsdate-time-stamp.log

    This file is used by tbe installer GUI to keep track of internal information.

  • installProfiledate-time-stamp.log

    This log file contains the overall statistics like time taken to complete the installation, as well as configuration, memory and CPU details.

  • oraInstalldate-time-stamp.log

    This log file contains the output stream of the copy session.

If you start the installer with the -printtime parameter, the timeTakendate-time-stamp.log and timedate-time-stamp.log files are created in the same directory:

  • timeTakendate-time-stamp.log

    This file contains information for the amout of time taken to move between screens (applicable for GUI installations only).

  • timedate-time-stamp.log

    This file contains time information for the copy session.

If you start the installer with the -printmemory parameter, the memorydate-time-stamp.log file is created. This file contains memory usage information for the copy session.

F.2.2 Configuration Log Files

To create a log file of your configuration session, start the Configuration Wizard with the -log option, as shown below:

On UNIX operating systems:

% ./config.sh -log=log_filename

On Windows operating systems:

G:\ config.cmd -log=log_filename

If you specify an absolute path with your log_filename then your log file will be created there. If you only specify a file name with no path, then the log files are created in the ORACLE_HOME/common/bin (on UNIX operating systems) or ORACLE_HOME\common\bin (on Windows operating systems) directory.

F.3 Granting Access to rwbuilder

A user who installed the Oracle Reports components can access them, by default. If you want to allow other users to run rwbuilder:

  1. Change the permissions of the following files.

    On Linux x86 operating systems:

    chmod 750 ORACLE_HOME/bin
    chmod 750 ORACLE_HOME/bin/rwbuilder
    chmod 750 COMMON_COMPONENTS_HOME/modules/oracle.dms_11.1.1/*.jar
    chmod 750 COMMON_COMPONENTS_HOME/modules/oracle.odl_11.1.1/*.jar
    chmod 750 ORACLE_INSTANCE
    chmod 750 ORACLE_INSTANCE/bin
    chmod 750 ORACLE_INSTANCE/config
    chmod 750 ORACLE_INSTANCE/config/reports
    chmod 750 ORACLE_INSTANCE/config/reports/bin
    chmod 750 ORACLE_INSTANCE/config/reports/bin/*
    chmod 750 ORACLE_INSTANCE/config/FRComponent
    chmod 750 ORACLE_INSTANCE/config/ReportsToolsComponent
    chmod 750 ORACLE_INSTANCE/config/ReportsToolsComponent/ReportsTools
    chmod 750 ORACLE_INSTANCE/config/ReportsToolsComponent/ReportsTools/*
    chmod 770 ORACLE_INSTANCE/config/ReportsToolsComponent/ReportsTools/rwbuilder.conf
    chmod 750 ORACLE_INSTANCE/reports
    chmod 750 ORACLE_INSTANCE/reports/reports_install.properties
    chmod 750 DOMAIN_HOME/servers/WLS_REPORTS/tmp/_WL_user/
    chmod 770 DOMAIN_HOME/servers/WLS_REPORTS/tmp/_WL_user/reports_version/
    chmod 770 DOMAIN_HOME/servers/WLS_REPORTS/tmp/_WL_user/reports_version/<random_name>/war
    chmod 750 directory_mentioned_in_REPORTS_TMP
    

    On Windows operating systems, right-click on the folder, select Properties, then modify the security settings as necessary.

  2. Change the location of the log files so that users will have both read and write access. Modify the PATH property of the runtime_trace_handler and zrcclient_trace_handler parameters in the ORACLE_INSTANCE/config/ReportsToolsComponent/ReportsTools/logging.xml (on Linux x86 operating systems) or ORACLE_INSTANCE\config\ReportsToolsComponent\ReportsTools\logging.xml (on Windows operating systems) file.

F.4 Errors Accessing the Discoverer Plus and Discoverer Viewer URLs

During the configuration process, if the database that contains the prefix_DISCOVERER schema is shut down between the "Create ASInstance" and "Deploy Discoverer" steps, the configuration process will be completed successfully despite the database being down. However, you will not be able to access the Discoverer Plus and Discoverer Viewer URLs.

The following errors can be found in the log file:

connection error.  
- error while creating the session, check for other errors.
- oracle.discoiv.connections.ConnectionStoreException:
@ weblogic.common.resourcepool.ResourceDisabledException: Pool
@ staeb57.us.oracle.com_db4405.us.oracle.com_SPS3NT_DISCOVERER_PS is
disabled,
cannot allocate resources to applications.. 

In this situation, you should do the following:

  1. Start the database.

  2. Restart the Oracle Discoverer instance.

  3. Restart the WLS_DISCO Managed Server.

  4. Restart the Administration Server.

F.5 Need More Help?

If this appendix does not solve the problem you encountered, try these other sources:

If you do not find a solution for your problem, open a service request.