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

"ORA-12541: TNS:no listener" error

I installed Oracle 8.1.7 on a local Windows XP machine. I have no problem using SQL*Plus by scott/tiger/no Home String. However, if I log in using the username/password/Home String which was created when the database is created, i.e., system/manager/HomeXP, it gives an "ORA-12541: TNS:no listener" error. The service 'OracleOraHome81TNSListener' on my local Windows XP is running OK.
Use system/manager and leave the connect string the same as you did when logging in with scott/tiger. The listener error is because the TNS alias that you're using (looks like you're calling it "Home String" -- whatever that is) doesn't reference the listener that you're running. Is there a network interface on your PC? If not, then you'll probably need to set the environment variable ORACLE_SID to connect.

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