Oracle8i Cache Concepts and Administration Guide Release 1.0 A83544-02 |
|
This chapter describes error logging, cautions against certain actions, describes some problems you may encounter in your Oracle8i Cache environment and solutions to those problems, and notes restrictions to the software.
To help you troubleshoot problems in your environment, Oracle8i Cache writes error messages to a log file or an event viewer.
By default, on UNIX, the file specification of the log file is:
$ORACLE_HOME/admin/icache/bdump/wtcme.log
On Windows NT, Oracle8i Cache writes error messages to the Event Viewer. From the Windows NT Start menu, select Programs -> Administrative Tools -> Event Viewer. From the Log menu of the Event Viewer, choose Application. Then, select events named OracleWtcIcache.sid, where sid is the Oracle system identifier (SID) of the cache.
If error messages cannot be written to the event log, errors are written to the log file:
ORACLE_HOME\admin\icache\bdump\wtcme.log
Note that the contents of the log file are always written using the UTF8 character set. If the log file contains non-ASCII characters, you may need to use a text viewer that can display characters in the UTF8 character set.
You can change the level of errors written to the log file and, on UNIX, the name and location of the log file. To make these changes, modify the parameters in the file wtcme.ora
or specify a parameter to the wtcme
command.
The file wtcme.ora
is located in the following directory:
The following table describes the parameters that are specified in the wtcme.ora file:
Parameter | Description |
---|---|
authenticationserver |
The tnsname of the origin database. Do not use the command line or edit the file to change this parameter. The tnsname is set during installation. |
port |
The port number of the listener for Oracle8i Cache. The listener establishes a communication path between Oracle8i Cache on the middle tier and Cache Manager on the client tier. Do not use the command line or edit the file to change this parameter. The port number is set during installation or by using the Configuration Assistant as described in "Using the Configuration Assistant to Reconfigure a Cache". By default, the port number is 51719. |
logfile |
The full file specification for the log file. By default, the value is set to the following: |
loglevel |
The level of error messages written to the log file wtcme.log or to the Windows NT Event Viewer. Valid values are:
|
The following shows the command that specifies a log level of debug:
wtcme loglevel=debug
The following describes some important information:
ORACACHE
is created.
ORACACHE$n
In the format, n represents an integer between 1 and 1000.
Do not delete these users from the origin database or change their passwords.
Do not modify or delete these objects.
To use Oracle8i Cache, Oracle8i Cache, the Oracle8i Cache management engine, Oracle Data Gatherer, and TNS Listener must be started.
To use Cache Manager to manage your caches, the Oracle8i Cache management engine must be started. When the management engine is not started on a middle-tier node, Cache Manager cannot access the cache. Cache Manager displays the General page for that cache as dimmed.
If Oracle Data Gatherer and TNS Listener are not started, you will not be able to use Oracle8i Cache or some functionality of the product.
On UNIX systems, if you followed the procedures for automating startup and shutdown in the installation guide, Oracle8i Cache (as well as the Oracle8i Cache management engine, Oracle Data Gatherer, and TNS Listener) is started when your system starts.
On Windows NT systems, Oracle8i Cache, the Oracle8i Cache management engine, and TNS Listener are services that are started automatically when your system starts.
On UNIX, if Oracle8i Cache is stopped, you can restart it, the Oracle8i Cache management engine, Oracle Data Gatherer, and TNS Listener by executing the cachstrt
script, which is located in the $ORACLE_HOME/bin directory. Use the following command:
cachstrt
On UNIX, to stop Oracle8i Cache and the TNS Listener, execute the cachshut
script, which is located in the $ORACLE_HOME/bin directory:
cachshut
To execute these commands, you must be logged in as the user under which Oracle8i Cache was installed.
On Windows NT, if Oracle8i Cache is stopped, you can restart it by starting the service:
On Windows NT, you must start the Oracle8i Cache management engine separately:
To start the Data Gatherer and the TNS Listener, see the following sections.
Oracle Data Gatherer, which manages the collection of statistics for use by Oracle Enterprise Manager components such as DBA Studio, must be started on the middle-tier machine. If it is not, you may receive the following error when you click on the Performance Monitor tab for a cache:
Cannot connect to Data Gatherer for cache. Some performance charts will not be available.
On UNIX, use the following command to start Oracle Data Gatherer:
vppcntl -start
On Windows NT, take these steps to start Oracle Data Gatherer:
TNS Listener must be started on the middle-tier node. If it is not, queries are routed to the origin database.
Note that the listener on the middle-tier node is configured to listen for IPC protocol connection requests. The IPC protocol is used by applications that reside on the same node as the listener to communicate with a cache.
On UNIX, use the following command to start the listener:
lsnrctl start listener
On Windows NT, take these steps to start the listener:
Oracle8i Cache uses threads to monitor and maintain statistics about the behavior of the cache. As a result, if an application already uses OCI in threaded mode, you do not need to make any changes to the application. If the application is a single-threaded application, you must relink the application using the multithreaded mode.
For example, on UNIX, you use the -lthread
option in the link line.
On Windows NT, you link with the msvcrt.lib library.
If the application is not linked in multithreaded mode, Oracle8i Cache may not execute properly and may return errors, such as the following error:
Failed: Register Aggregate Stats Queue
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|