Remote acces problem

From: Radim Friedel <friedel.radim_at_vagonka.cz>
Date: Mon, 17 Feb 2003 11:17:42 +0100
Message-ID: <b2qcrq$utn$1@server4.gts.cz>

Hello

NT 4 server,Oracle 8

1 physical NIC and 2 IP on it

internet->firewall->public ip//NT 4\\local ip<-local user

Local users can use oracle DB without any problem Remote user do see the listener, but they canŧt connect to the DB.

I donīt know how to configure listener.

Should I specify both IPs in listener.ora like this?

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 212.80.76.3)(PORT = 1521))
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )

    )
  )

Could be both IPīs on the same port?

How to modify the tnsnames.ora? I do use two SIDīs.

TEST =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = TEST)
    )
  )

TEST2 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 212.80.76.3)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = TEST)
    )
  )

Iīm new to the oracle.
Somwhere I saw info that I need to use Connection manager which I donīt have configured yet.

Thank you forward for any information about this problem.

Best regards

Radim Received on Mon Feb 17 2003 - 04:17:42 CST