I have Oracle8i installed on my Unix box and I have created a new database. I can connect to my db via Net8 from windows using the IP address, but can not connect from sqlplus or the Oracle loging window. I can also connect to my database using this connect string within unix: SQL>connect gilles/gilles@rich. However, I dont know how to connect from my windows desktop Oracle application. How does one do it?
192.168.00.00.rich or hostame.rich or yet something else? The former two options do not work.
It sounds like you don't have an entry for your instance in tnsnames.ora on your windows box.
Open the file tnsnames.ora (usually in C:\oracle\ora81\network\admin) and make sure an entry is their for the instance. If not, copy and paste one of the existing and modify the various params. It's fairly self explanatory.