Oracle connection

From: <mateev_at_geocities.com>
Date: Tue, 13 Apr 1999 06:15:05 GMT
Message-ID: <7eund4$8bu$1@nnrp1.dejanews.com>

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 Tue Apr 13 1999 - 01:15:05 CDT