Oracle® Fail Safe Concepts and Administration Guide
Release 3.3.3 for Windows
Part No. B12070-01
This appendix discusses the following topics:
Reporting a Problem
Finding Your Version Information
Tracing Oracle Fail Safe Problems
Locating Trace and Alert Files
The hardware, operating system, and release number of the operating system on which the Oracle software is running
The complete release number of the Oracle and other product software
All Oracle programs (with release numbers) in use when the error occurred
If you encountered one or more error codes or messages, the exact code numbers and message texts, in the order that they were displayed
The problem severity, according to the following codes:
Your personal and company information:
Company Oracle Support ID Number
In some cases, Oracle Support Services will request a trace file.
See Section B.3 for information about using the trace function to log error output to a file.
You can find the version of software that you are running in the Oracle Fail Safe Manager help menu. Choose Help, then About Oracle Fail Safe Manager.
Tracing is available to help you track, report, and examine errors that you receive in Oracle Fail Safe by dumping information about the errors to a log file.
You enable tracing on a per-node basis.
Follow these steps to enable tracing and set tracing flags on the cluster server nodes:
Run the Windows registry editor.
Select the following from the Registry tree:
HKEY_LOCAL_MACHINE, then SOFTWARE, then ORACLE, then FailSafe, and finally, Tracing
From the Registry Editor menu bar, select Edit, then Add Value to open the Add String dialog box.
In the Value Name field, enter an Oracle Services for MSCS value from Table B-1.
In the Data Type field, enter REG_SZ.
Click OK to open the String Editor dialog box.
In the String field, enter one or more of the Oracle Services for MSCS strings shown in Table B-1. Separate multiple entries with commas.
Repeat steps 3 through 7 to set additional Oracle Services for MSCS trace flags.
Using MSCS Cluster Administrator, shut down Oracle Services for MSCS.
In the Windows control panel, select Services and stop the Oracle Services for MSCS on each cluster node.
Repeat these steps on each cluster node to ensure that tracing is enabled across the cluster.
|FSR_TRACE_OUTPUT||A path and file name||Specifies the path and file name for the file to which you want tracing information about the Oracle Fail Safe resource DLL to be written. For example:
|FSS_TRACE_OUTPUT||A path and file name||
Specifies the path and file name for the file to which you want tracing information about the Oracle Services for MSCS to be written. For example:
|FSS_TRACE_FLAGS||CLUSTER_MGR||Logs information about calls made to the cluster management software.|
|CR_DBRES||Logs information when you create database resources during the Add Resource to Group Wizard.|
|CR_SAMPLE||Captures tracing information about the Create Sample Database operation, including a start and stop entry for each step (with a time stamp).|
|DB_RES||Logs information when the Oracle Fail Safe resource DLL accesses a database.|
|DEL_SAMPLE||Logs information about the Delete Sample Database operation, similar to the CR_SAMPLE operation.|
|GR_VERIFY||Logs information about the Verify Group operation.|
Enables local tracing, which specifies that trace output for a given cluster node be written to the FSS_TRACE_OUTPUT file for that node. If this flag is not specified, then trace output for all cluster nodes is written to the FSS_TRACE_OUTPUT file on the node where Oracle Services for MSCS is running (the node where the Cluster Group resides).
You must specify one or more additional FSS_TRACE_FLAG strings to specify the type of information that you want to have traced. If you specify only the LOCAL_TRACE string, then no trace output is produced.
|SQLNET||Generates detailed internal information related to the Oracle Net configuration done by Oracle Services for MSCS. Information is logged whenever an operation is performed that requires a change to the Oracle Net configuration. This includes creating and deleting a sample database, or adding and removing a database from a group.|
|VERIFY_DB||Logs information about the Verify Standalone Database operation.|
If you use a cluster disk, trace and alert files contain complete information about the operation. However, information about the node hosting the database is not recorded. The cluster disk used for these files should be one of the disks used for the archive log files or the database data files (where Create Sample Database places them, for example); otherwise, they will not be added to the group.
If you use a private disk, trace and alert files each contain node-specific information about the operation. However, you might need to view files from each cluster node together to obtain complete chronological information if the database has failed over or been moved. Use a path name that is valid on each node so that data can be written to these files correctly. Files on private disks are never added to a group.