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.