Q
Problem solve Get help with specific problems with your technologies, process and projects.

Unable to enter database with scott/tiger

I have a problem with installing Oracle9i on Windows XP. When I give username and password as scott and tiger, I cannot enter the database. I get a "TNS PROTOCOL" error. Even while installing, it says SID already exists.

I have a problem with installing Oracle9i on Windows XP. When I give username and password as scott and tiger, I cannot enter the database. I get a "TNS PROTOCOL" error. What is the password for Oracle9i for Windows XP? Actually even while installing, it says SID already exists. (Since I have insatlled it more than once!) Please help me. Thanks in advance.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close