ORACLE through INTERNET

From: <mateev_at_geocities.com>
Date: 1999/04/09
Message-ID: <7eksgf$d7u$1_at_nnrp1.dejanews.com>#1/1

I work with ORACLE 7.3.2 server, instaled on NT 4. The server have

two lan cards. The first card is conected to internal network

(IP=192.168.0.1). The other card is conected to INTERNET through
modem (IP=212.62.112.181). I can connect from internal network, but I cannot connect from INTERNET. I use TCP/IP.

I can connect from INTERNET only with TNSPING. I recieve message "ERROR: ORA-12203: TNS:unable to connect to destination" if I try to connect with SQL PLUS.

I send a part of listener tracing file: ...
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)
(Ho st=212.62.112.181)(Port=1521))) port resolved to 1521 looking up IP addr

for host: 212.62.112.181 opening transport... No PROTOCOL.ORA file is found 
^^^^^^^^^^^^ Validnode Table IN use; err 0x0 getting sockname transport is

open global context check-in (to slot 4) complete completing partial addr:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)
(Ho st=212.62.112.181)(Port=1521)))Listening on:
(ADDRESS=(PROTOCOL=tcp)(DEV=140)(HOST=212.62.112.181)(PORT=1521)) ...

I have writed file PROTOCOL.ORA in <ORAHOME>\network\admin directory, but it seems ORACLE doesn't read it.

Can anyone help me?

Georgy Mateev
mateev_at_geocities.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 09 1999 - 00:00:00 CEST