cbeech1980
asked on
Remote connection over Oracle over wireless adapter?
Hi all,
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.....
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(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!
Thanks,
Chris
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.....
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(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!
Thanks,
Chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Really a network issue. There's something else blocking it.
On the database server from a command prompt post the results of: lsnrctl status
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Turn off the firewall on your computer.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\CBeech>telnet 192.168.1.103 1521
Connecting To 192.168.1.103...Could not open connection to the host, on port 152
1: Connect failed