Q

"TNS:Could not resolve Service name" error

I've installed Oracle9i in Windows XP, and when I try to connect through SQL*Plus it gives me an error: "TNS:Could not resolve Service name." I connected using scott and tiger. I even tried through svrmgrl in the command prompt. There I get a different error.

I've installed Oracle9i in Windows XP, and when I try to connect through SQL*Plus it gives me an error: "TNS:Could not resolve Service name." I connected using scott and tiger. I even tried through svrmgrl in the command prompt. There it gives me the error as "Message 4505 not found; No message file for product=RDBMS, Facility=MGR. ORA-12560:TNS:Protocol Adapter Error." Please help.

This message indicates that the ORACLE_HOME environment variable is either set incorrectly in the registry or in...

the environment (Control Panel -> System -> Environment).

You could try removing the ORACLE_HOME environment variable from Control Panel -> System -> Environment. Alternatively, ensure that ORACLE_HOME is set to the correct destination in the registry (in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<x> where <x> is the unique identifier of the ORACLE_HOME).

This was last published in January 2006

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close