Re: Listener configuration

tomunio wrote:
> Hi
> I've two oracle 9i databases (prod and test) on two separate hosts -
> host1 (192.168.1.6), host2 (192.168.1.4 and external_IP).
> One of them (host2) has got an access to the Internet. How should I
> configure the listener on host2 so that I could connect from the
> Internet to the database on host1 (it has no access to the Internet).
> Thx in advance
>
> [oracle_at_host2 admin]$ cat listener.ora
> # LISTENER.ORA Network Configuration File:
> /opt/ora9/product/9.2/network/admin/listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
> 192.168.1.4)(PORT = 1521))
> )
> SID_LIST_LISTENER =(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = TEST)
> (ORACLE_HOME = /opt/ora9/product/9.2) (SID_NAME = US2)))
>
> [oracle_at_host2 admin]$ cat tnsnames.ora
> ####################################
> # TNSNAMES.ORA Configuration
> File:/opt/ora9/product/9.2/network/admin/tnsnames.ora
> # Generated by Oracle Enterprise Manager V2
> # Date..........: Thu Aug 19 14:06:35 CEST 2004
> ####################################
>
> PROD.domain =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.6)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = US2)(SERVER = DEDICATED))
> )
>
> TEST.domain =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = external_IP)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = US2)(SERVER = DEDICATED))
> )
>

If you need to connect to the database on HOST1 from the Internet, then that server needs to be on the Internet.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown