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

Unable to connect to 9i on Windows 98

I installed a fresh copy of Oracle 9i on Windows 98. After the install, when I log in to SQL*Plus I get the following error: "ORA-12560: TNS: protocol adapter error." And I can't connect.

I installed a fresh copy of Oracle 9i on Windows 98. After the install, when I log in to SQL*Plus I get the following error: "ORA-12560: TNS: protocol adapter error." And I can't connect. I'm using user ID "Scott" and password "Tiger." Could you please help solve this problem?
First of all, it appears that 9i is not certified to run on Windows 98, so even if you get past this error, you may encounter others because of this. To view the certification matrix, click here.

Second, with respect to the ORA-12560 error, here are some potential causes:

  • Verify that the instance has started and that the database is open.
  • Ensure that the ORACLE_SID is properly set in the registry.
  • Verify that the SID does not contain a non-alphanumeric character.

If the problem is still not resolved after checking the above, it could be that the database was not created successfully. Review the alert log for any errors.

This was last published in November 2005

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