Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » I'm Back - brain picking time once again
I'm Back - brain picking time once again [message #590175] Mon, 15 July 2013 12:12 Go to next message
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 #590179 is a reply to message #590175] Mon, 15 July 2013 13:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when localhost is used, then no remote client can ever connect to this system/db/listener
localhost only ever uses 127.0.0.1; which is a non-routable IP#
Re: I'm Back - brain picking time once again [message #590183 is a reply to message #590179] Mon, 15 July 2013 14:14 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
There must be a way to allow connection from somewhere on the network other than locally. Maybe there's a script that needs to be edited? Otherwise, what's the point of having a database you can't connect to remotely?
Re: I'm Back - brain picking time once again [message #590184 is a reply to message #590183] Mon, 15 July 2013 14:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>There must be a way to allow connection from somewhere on the network other than locally.
Yes, don't use localhost.
Any DB Server should have a static & routeable IP# assigned to it.
Re: I'm Back - brain picking time once again [message #590187 is a reply to message #590184] Mon, 15 July 2013 14:34 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Right! The host computer does have an IP assigned to it: 192.168.2.16

So, I should be able to connect using: http://192.168.2.16:8080/apex

That should work, but it doesn't.

[Updated on: Mon, 15 July 2013 14:41]

Report message to a moderator

Re: I'm Back - brain picking time once again [message #590191 is a reply to message #590187] Mon, 15 July 2013 14:38 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you ping 192.168.2.16?
Re: I'm Back - brain picking time once again [message #590193 is a reply to message #590191] Mon, 15 July 2013 14:43 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Yes, I can ping 192.168.2.16

C:\Users\Alan>ping 192.168.2.16

Pinging 192.168.2.16 with 32 bytes of data:
Reply from 192.168.2.16: bytes=32 time<1ms TTL=128
Reply from 192.168.2.16: bytes=32 time<1ms TTL=128
Reply from 192.168.2.16: bytes=32 time<1ms TTL=128
Reply from 192.168.2.16: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.2.16:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Re: I'm Back - brain picking time once again [message #590194 is a reply to message #590193] Mon, 15 July 2013 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
open Command Window then issue following OS commands below

lsnrctl status
lsnrctl service

Copy the results from above then PASTE all back here
Re: I'm Back - brain picking time once again [message #590196 is a reply to message #590194] Mon, 15 July 2013 15:02 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
You want me to run these commands on my computer or the computer that is hosting Oracle?
Re: I'm Back - brain picking time once again [message #590198 is a reply to message #590196] Mon, 15 July 2013 15:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>or the computer that is hosting Oracle?
run them on the DB Server system
Re: I'm Back - brain picking time once again [message #590203 is a reply to message #590198] Mon, 15 July 2013 15:14 Go to previous messageGo to next message
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 #590206 is a reply to message #590203] Mon, 15 July 2013 15:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Shiers-PC)(PORT=1521)))

what IP# is associated with Shiers-PC?
Re: I'm Back - brain picking time once again [message #590207 is a reply to message #590206] Mon, 15 July 2013 15:43 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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).
Re: I'm Back - brain picking time once again [message #590211 is a reply to message #590209] Mon, 15 July 2013 16:51 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
C:\Users\Alan>telnet 192.168.2.16 8080
Connecting To 192.168.2.16...Could not open connection to the host, on port 8080
: Connect failed

Ok. so now we're back to the firewall thing. I am able to get into the firewall on the computer running Oracle. Is there something specific you want me to look for in there?

I'll have to continue this conversation tomorrow. I'm out for the rest of the day. I'll be in touch tomorrow.
Re: I'm Back - brain picking time once again [message #590267 is a reply to message #590209] Tue, 16 July 2013 08:21 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Ok guys,

I'm back. What's the next step? How do we figure out what's blocking the connection from my computer to the host computer running Oracle?

Alan
Re: I'm Back - brain picking time once again [message #590270 is a reply to message #590267] Tue, 16 July 2013 08:40 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
PACKET SNIFF using wireshark or similar utility
Previous Topic: can't connect to apex homepage
Next Topic: Deleting a record
Goto Forum:
  


Current Time: Thu Mar 28 14:38:23 CDT 2024