I would first suggest that you choose a supported configuration for Oracle. Oracle 8i is not certified to run on Win XP. The first server release certified for XP was 9.0.1. Check the certification matrix on Metalink to be sure.
If you continue to have problems with a supported, certified configuration, then I'd suggest recreating the database using the database configuration assistant.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.