Troubleshooting Tips

At this point, you should have a good idea whether Oracle XE is working properly. If you are having problems starting Oracle XE, connecting to Oracle with SQL*Plus, or viewing the Database Home Page, the tips in this section should help.

Confirm Existence of Oracle XE Software and Database

To check the status of the Oracle XE software and database installation, complete the following steps.

1. Choose Start | [All] Programs | Accessories | Windows Explorer.

2. Use Windows Explorer to confirm that ORACLE_BASE exists (e.g., C:\oraclexe) with the subdirectories app and oradata.

3. Use Windows Explorer to confirm that ORACLE_HOME exists (e.g., C:\oraclexe\app\oracle\product\10.2.0\server) along with a long list of subdirectories ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.