I'm playing with WAS 7 and clustering and have installed Oracle 11GR2 on my laptop that normally serves as a media PC in my lounge.
Everything is installed and working although I can't seem to connect to Oracle from my other machines. I have disabled all firewalls and still no joy.
I can SQL+ to it locally but when I try and access with SQLDeveloper I get "IO Exception : The network adapter could not establish the connection".
My Oracle PC is connected to the network via its wireless connection and I have updated the listener.ora file to include this line.....
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.103)(PORT = 1521))
...the change here is localhost for the the IP address of the wireless adapter.
I'm running short of ideas here!