Judging by the second error you've described (SID already exists) I would say that the TNS protocol error is due to a problem with your database, especially if you've tried to re-create the same database a number of times. You likely don't have a database successfully created which would explain why you can't connect as SCOTT. I would recommend deleting the database files that currently exist for this database, as well as deleting the service, then try creating the database again using the DBCA (Database Configuration Assistant). If you've successfully removed all the components of the database before attempting to create it again, the DBCA should guide you through the process of creating your database.
For additional information on creating an Oracle 9.2 database on Windows XP, review the Oracle9i Database Administrator's Guide Release 2 (9.2) for Windows, which can be found on the Oracle Technology Web site (OTN) here.
This guide provides step-by-step instructions on how to create a database via the DBCA, or manually via scripts if you prefer.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.