G
Troubleshooting

This appendix describes how to troubleshoot problems with Oracle8.

Specific topics discussed are:

• Database Connection Issues
• Operating System Permission Issues
• Using Oracle Trace
• Contacting Oracle Worldwide Customer Support

Database Connection Issues

The table below lists and provides answers to common Oracle8 database connection issues:

If You Receive This Error...	Do the Following...
TNS-12203 TNS: unable to connect to destination	Ensure your OracleServiceORCL and OracleTNSListener80 services are started.
ORA-12547 TNS: lost contact	Ensure your OracleServiceORCL and OracleTNSListener80 services are started. You receive this error if you attempt to use any of the Oracle8 Utilities, such as Server Manager.

Operating System Permission Issues

The permission problem (OS 5 or 3) is typically caused by inadequate configuration of the NTFS permissions. By default, the Oracle8 database service runs using the SYSTEM account instead of a named Windows NT user such as Administrator. In File Manager or Windows NT Explorer, you must grant Full Control on the ORACLE_HOME directory and all of its subdirectories to the SYSTEM user. The SYSTEM user has the full name The operating system and has an icon of a computer chip. For this and other Windows NT problems, consult your Windows NT documentation or contact your Windows NT System Administrator.

After correcting the problem, you must delete any files that were created as a result of partial completion of the CREATE DATABASE command. The files to delete are the:

• Control files (specified in the initialization parameter file)
• Online redo log files (specified in the CREATE DATABASE statement)
• Data file(s)

Then, run the CREATE DATABASE script again in Server Manager.

Using Oracle Trace

Oracle Trace is a general-purpose data collection tool that is part of the Oracle Enterprise Manager Performance Pack (not contained on this CD-ROM disc). Oracle Trace collects data from Oracle applications and databases. This data can include:

• performance statistics
• diagnostics data
• system resource usage
• business transaction details

This data can be:

• formatted into a report for your review
• input to the Oracle Expert tool of Oracle Enterprise Manager, an expert system that applies rules to this data and provides suggestions for optimizing your application or database.

For information on starting and using Oracle Trace, see Oracle Enterprise Manager Oracle Trace User's Guide

Contacting Oracle Worldwide Customer Support

How to Contact Oracle Worldwide Customer Support

Oracle Worldwide Customer Support can be contacted as follows:

Location	Contact
United States of America	Telephone (1) (415) 506-1500
Europe	Telephone (1) (44) (1344) 860-160
Outside the United States of America and Europe	Your Oracle sales representative
Worldwide	Visit: Oracle Worldwide Customer Support

For further information on how to contact Oracle Worldwide Customer Support, refer to the included Customer Support Information Booklet.

Before You Call for Assistance

Before calling for assistance, have the following information available:

• Your CPU Support Identification (CSI) number
• Oracle Product Registration Number
• Oracle product name and version number
• Make and model of your computer
• Available memory and disk space of your computer
• Operating system vendor, name and version number, if applicable
• Network operating system vendor, name and version number, if applicable
• Any Oracle error numbers and error message text

---