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))
> )
Received on Wed Aug 16 2006 - 06:03:47 CDT
