Listener configuration

From: tomunio <tomunio_at_wp.pl>
Date: 16 Aug 2006 03:42:57 -0700
Message-ID: <1155724977.474624.179590@i3g2000cwc.googlegroups.com>

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 - 05:42:57 CDT