| I'm Back - brain picking time once again [message #590175] |
Mon, 15 July 2013 12:12  |
 |
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
|
Junior Member |
|
|
Hi Guys,
Thought I'd start off fresh with a new discussion. When last we spoke, I was having issues with connecting to Oracle through the browser: http://localhost:8080/apex.
These issues were so difficult and frustrating to rectify I decided to uninstall Oracle Express from my computer and today decided to install it on a different computer on the network.
This time, I have some success. On that new "host" computer I am able to connect via SQL Developer and the browser using URL: http://localhost:8080/apex
So far so good. Now, I wanted to see if I could connect from my original computer, this time using the IP address that points to the host computer: http://192.168.2.16:8080/apex
This is the response:
The connection has timed out
The server at 192.168.2.16 is taking too long to respond.
I'm thinking this is more of a Windows network configuration thing. Obviously, if I go to the host computer I'm able to connect locally, but something is preventing me from connecting from anywhere on the network. Are you able to assist on troubleshooting this? Fortunately, on the host computer I do finally have access to the Firewall. The thing is, I don't want to muck around in there without some instruction because I don't know what I'm doing in there. I'm running Windows 7 on both computers.
Alan
[Updated on: Mon, 15 July 2013 12:25] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: I'm Back - brain picking time once again [message #590203 is a reply to message #590198] |
Mon, 15 July 2013 15:14  |
|
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
|
Junior Member |
|
|
Here ya go:
C:\Users\Owner>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 15-JUL-2013 17:10
:48
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 15-JUL-2013 16:33:17
Uptime 0 days 0 hr. 37 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\Shiers-PC\listener
\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Shiers-PC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Shiers-PC)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Users\Owner>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 15-JUL-2013 17:11
:35
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:6 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: SHIERS-PC, pid: 2416>
(ADDRESS=(PROTOCOL=tcp)(HOST=Shiers-PC)(PORT=49159))
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
|
|
|
|
|
|
| Re: I'm Back - brain picking time once again [message #590207 is a reply to message #590206] |
Mon, 15 July 2013 15:43 |
|
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
|
Junior Member |
|
|
It's: 192.168.2.16
Here is what IPCONFIG returns:
C:\Users\Owner>ipconfig
Windows IP Configuration
Wireless LAN adapter Wireless Network Connection 2:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Wireless LAN adapter Wireless Network Connection:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . : backbench.nedtek.local
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::a018:2712:1627:c1a0%10
IPv4 Address. . . . . . . . . . . : 192.168.2.16
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.2.1
Tunnel adapter Local Area Connection* 12:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Tunnel adapter isatap.backbench.nedtek.local:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Tunnel adapter isatap.{6FD9DA3A-D9A6-4CF1-983B-407515B3FD92}:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Tunnel adapter Local Area Connection* 11:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Tunnel adapter isatap.{D9C6F5C4-4CBD-4F70-8F15-0F6ED9C0AF68}:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
[Updated on: Mon, 15 July 2013 16:30] Report message to a moderator |
|
|
|
| Re: I'm Back - brain picking time once again [message #590209 is a reply to message #590207] |
Mon, 15 July 2013 16:35 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Hi, man. Run the telnet test! On the old PC,
telnet 192.168.2.16 8080
and if you don't get through to the blinking cursor, you have a networking problem - possibly firewall related. Remember that ping doesn't test tcp connectivity, only IP (or something like that).
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
