From: "arb" Newsgroups: comp.databases.oracle.server References: <9sSe9.9959$_l1.24521@news-server.bigpond.net.au> Subject: Re: Accessing an Oracle DB through a SOHO hub based ADSL network. Lines: 222 X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Mon, 09 Sep 2002 06:09:18 GMT NNTP-Posting-Host: 203.51.57.188 X-Complaints-To: news@bigpond.net.au X-Trace: news-server.bigpond.net.au 1031551758 203.51.57.188 (Mon, 09 Sep 2002 16:09:18 EST) NNTP-Posting-Date: Mon, 09 Sep 2002 16:09:18 EST Organization: BigPond Internet Services (http://www.bigpond.net.au) Thanks for the reply Jake... Referring to your points... 1. Yes I checked several times! 2. yep! 3. My config is exactly as your ANSI diagram! 4. Port forwasrding was achieved as per the Win XP screenshot in my initial post. Unfortunately I get a 'ORA-12541: TNS:no listener' error! I am positive the listener is correctly configured cause I can log into the database from 'inside' my Lan! I am hoping I am missing something else.. so any ideas!?!?!? Alex. "Jake" wrote in message news:alh3a7$lc0$1@bob.news.rcn.net... > 1) You sure look at your listener is listening of 1523. Look at the > listener.ora file > > 2) make sure the port your tnsnames.ora on your external machine and your > listener.ora agree > > 3) 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" wrote in message > news:9sSe9.9959$_l1.24521@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, > > > > > > > >