Re: Accessing an Oracle DB through a SOHO hub based ADSL network.

From: Jake <me_at_heyjay.com>
Date: Sun, 8 Sep 2002 22:09:10 -0500
Message-ID: <alh3a7$lc0$1@bob.news.rcn.net>

You sure look at your listener is listening of 1523. Look at the listener.ora file
make sure the port your tnsnames.ora on your external machine and your listener.ora agree
wire it like:

DSL Line

       |
       |
------------------
|(xxx.xx.xxx.xxx)|
|     Win2k      |

|(192.168.1.254) |

       |
      HUB
       |
------------------

| (192.168.1.10) |
| DB Server |

4) Then must do port forwarding (how you do this in MS land is beyond me). But you must port forward the port that your listener is listening upon to the internal box. That is xxx.xxx.xxx.xxx:1521 -> 192.168.1.10

"arb" <brasiera_at_bigpond.net.au> wrote in message news:9sSe9.9959$_l1.24521_at_news-server.bigpond.net.au...
>
> Hi... I am hoping you can help!
>
> I have a Win XP Pro PC set-up as an ADSL server.
>
> On my LAN (Using a simple NetGear DS 104 HUB i.e. no router) I have a Win
2k
> PC with an Oracle server (linstening on Port 1523).
>
> Win XP ICS is configured and working fine (So therefor NAT is working!).
>
> I would like to allow an external PC the ability to access my Win 2K Pro
PC
> and Oracle DB... but they cannot see it.
>
> How is it possible that an external PC can access a PC on a network that
is
> not the owner of the dynamic IP supplied by the ADSL service?
>
> I can assume that I possibly need to do a port redirection...
> - I have gone to Network Connections >> (Telstra ADSL WAN Miniport PPPoE)
> Properties >> Advanced > Settings
> - Added a service for 192.168.0.2 (the IP Address of the Win 2K Oracle DB
> PC) and set the External Port number to be '1523' and the Internal Port
> Number to '1523'... (As per the attached .jpg file).
>
> You will see from the TNSNAMES.ORA file that if the external PC inserts
the
> dynamic IP of my ADSL server PC at port 1523.. then it 'should' redirect
to
> the Win 2K machine. But this does not seem to be happening?!?!?!
>
> However when trying to log on from an external machine I get the
following:
>
> ORA-12500: TNS:listener failed to start a dedicated server process
>
>
> Details:
> oci.dll found
> 2) Oracle Home Key is SOFTWARE\ORACLE\HOME0
> Looking for TNS_ADMIN environmental variable
> TNS_ADMIN environmental variable doesnt exist,
> looking for TNS_ADMIN reg key using home key: >SOFTWARE\ORACLE\HOME0<
> TNS_ADMIN does not exist in SOFTWARE\ORACLE\HOME0
> looking for TNS_ADMIN reg key in \Oracle: >SOFTWARE\ORACLE\HOME0<
> Looking for OracleHomeKey\ORACLE_HOME
> Oracle Path is now e:\oracle\ora81\Network\Admin
> Looking for e:\oracle\ora81\Network\Admin\tnsnames.ora
> tnsnames.ora found
> tnsnames entry: EP
> tnsnames entry: INST1_HTTP
> tnsnames entry: EXTPROC_CONNECTION_DATA
> tnsnames.ora found
> tnsnames entry: EP
> tnsnames entry: INST1_HTTP
> tnsnames entry: EXTPROC_CONNECTION_DATA
>
>
> Please help! You help would be extremely appreciated.. I have looked
> through every resource link listed from your WWW pages and Whirlpools..
and
> tried a number of other news groups (noone can tell me any more than what
I
> already know).
>
> In case it helps I have provided an ipconfig /all for the Win XP ADSL PC
and
> the Win 2K Oracle PC...
>
> Win XP ADSL PC
> ==============
> Windows IP Configuration
>
> Host Name . . . . . . . . . . . . : ep-01
> Primary Dns Suffix . . . . . . . :
> Node Type . . . . . . . . . . . . : Unknown
> IP Routing Enabled. . . . . . . . : Yes
> WINS Proxy Enabled. . . . . . . . : No
> DNS Suffix Search List. . . . . . : vic.bigpond.net.au
>
> Ethernet adapter Local Area Connection 3:
>
> Connection-specific DNS Suffix . :
> Description . . . . . . . . . . . : SMC EZ Connect USB/Ethernet
> Series C
> onverter
> Physical Address. . . . . . . . . : 00-04-E2-08-9B-9F
> Dhcp Enabled. . . . . . . . . . . : No
> IP Address. . . . . . . . . . . . : 10.0.0.1
> Subnet Mask . . . . . . . . . . . : 255.0.0.0
> Default Gateway . . . . . . . . . :
>
> Ethernet adapter Local Area Connection:
>
> Connection-specific DNS Suffix . :
> Description . . . . . . . . . . . : 3Com EtherLink 10/100 PCI For
> Comple
> te PC Management NIC (3C905C-TX)
> Physical Address. . . . . . . . . : 00-50-DA-61-0D-78
> Dhcp Enabled. . . . . . . . . . . : No
> IP Address. . . . . . . . . . . . : 192.168.0.1
> Subnet Mask . . . . . . . . . . . : 255.255.255.0
> Default Gateway . . . . . . . . . :
>
> PPP adapter Telstra ADSL:
>
> Connection-specific DNS Suffix . :
> Description . . . . . . . . . . . : WAN (PPP/SLIP) Interface
> Physical Address. . . . . . . . . : 00-53-45-00-00-00
> Dhcp Enabled. . . . . . . . . . . : No
> IP Address. . . . . . . . . . . . : 203.51.63.139
> Subnet Mask . . . . . . . . . . . : 255.255.255.255
> Default Gateway . . . . . . . . . : 203.51.63.139
> DNS Servers . . . . . . . . . . . : 61.9.192.14
> 61.9.192.15
> NetBIOS over Tcpip. . . . . . . . : Disabled
>
>
> WIN 2K (ORacle PC)
> ==================
> Windows 2000 IP Configuration
>
> Host Name . . . . . . . . . . . . : D4RYM41S
> Primary DNS Suffix . . . . . . . :
> Node Type . . . . . . . . . . . . : Mixed
>
> IP Routing Enabled. . . . . . . . : No
>
> WINS Proxy Enabled. . . . . . . . : No
>
> DNS Suffix Search List. . . . . . : vic.bigpond.net.au
>
> Ethernet adapter Local Area Connection:
>
>
>
> Connection-specific DNS Suffix . :
> Description . . . . . . . . . . . : 3Com 10/100 Mini PCI Ethernet
> Adapter
> Physical Address. . . . . . . . . : 00-04-76-48-6E-7E
>
> DHCP Enabled. . . . . . . . . . . : No
>
> IP Address. . . . . . . . . . . . : 192.168.0.2
>
> Subnet Mask . . . . . . . . . . . : 255.255.255.0
>
> Default Gateway . . . . . . . . . : 192.168.0.1
>
> DNS Servers . . . . . . . . . . . : 192.168.0.1
>
>
>
> With Kind Regards,
>
>
>
Received on Sun Sep 08 2002 - 22:09:10 CDT