Re: Oracle connection

Georgy

You are encountering problems with NT using a dedicated socket for TCP/IP connection. This is resolved by adding the reg key USE_SHARED_SOCKET=TRUE under you ORACLE key (v8, might work with v7). As a proof if you check the active sockets on your internal network using sql*plus the will be connected to 192.168.0.1, BUT the port# will not be 1521.

tnsping only checks if the listener is listening, and therefore doesn't require a dedicated socket to be spawned.

If you can't go to Oracle8, then it might be worth installing the Net8 listener to solve your requirements.

Chris.

mateev_at_geocities.com wrote:
>
> 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 - 10:45:59 CDT