URGENT - CONNECTIVITY PROBLEM

[uparna]

Hi ,
My office here has around 150 machines on an isolated LAN , whereas the other 1500 machines are on a common lan. I have setup an Oracle 8.1.7.0.0 database on WIN NT ( for Office Automation purposes) in the common lan. The PCs in the isolated LAN cannot access this server , and hence i had requested the Network administrator of that LAN to please open the 1521 port in his firewall. This resulted in the port being opened. Here comes the problem : i am able to TNSPING sucecssfully from tha machines in the isolated lan to this server , but am ot able to connect to the server through the client - it gives the TNS12535 - TNS Operation Timed out error. I have subsequently set the connect_timeout parameter to 10,50,60,300 and finally 0 in the listener of the server , but of no avail. I have also installed the 8.1.7.1.1 and the 8.1.7.1.5 patches on the database server , again of no avail ---------------------- I have used only the 1521 port in the listener.....my understanding is that since Oracle Listens on port 1521 , it even responds to requests from that port itself. Am i right?
any solutions in sight? PLEASE help me ,.......... i promise to pray for you if you do... !!! Regards,
S. Jayaram Uparna .

If the need arises,you are welcome to mail me at oracguru@yahoo.com .

 

[JJSmith]

If you are going through a Firewall, and your server platforms are NT, then you must ensure that you set up a SQL*Net/Net8 Proxy, such as Net8 Connection Manager,
if none is provided by the Firewall vendor.
The reason is that, even though the port is open, the TCP layer will REDIRECT the port to another port.
This is due to Winsock2 workings under Microsoft.

 

[uparna]

Thx JJSmith , I have already managed to solve the problem.. !! Here is the text that helped me - i have got the thread contents by mail and so am pasting them below for the benefit of others:
************************************************************
ORA-12535: TNSperation timed out - SQL*Net / Oracle 8i
When trying to connect past a LinkSys router firewall remotely, SQL*Net fails with the
following message:
ERROR:
ORA-12535: TNSperation timed out

(this may also be diagnosed as ORA-12560: TNSrotocol adapter error)
The sqlnet.log file contains the following:

Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RROAD.COM)(PORT=1521))(CONNECT_DATA=
(SERVICE_NAME=SAMPLE.DELL180)(CID=(PROGRAM=C:\ORACLE\ORA81\BIN\SQLPLUSW.EXE)
(HOST=TECRA)(USER=bcarter))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
Time: 16-DEC-2001 10:57:56
Tracing to file: C:\WINDOWS\Desktop\cli.trc
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNSperation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0

The sqlnet.ora file was modified to include TRACE_LEVEL_CLIENT = 16 as follows:

# SQLNET.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
TRACE_LEVEL_CLIENT = 16

The resulting cli.trc file contained the following packet dump containing an ip
address which is hidden behind the firewall and inaccessible to the remote computer
running SQL*Net:
nsprecv: 65 bytes from transport
nsprecv: tlen=65, plen=65, type=5
nsprecv: packet dump
nsprecv: 00 41 00 00 05 00 00 00 |.A......|
nsprecv: 00 37 28 41 44 44 52 45 |.7(ADDRE|
nsprecv: 53 53 3D 28 50 52 4F 54 |SS=(PROT|
nsprecv: 4F 43 4F 4C 3D 74 63 70 |OCOL=tcp|
nsprecv: 29 28 48 4F 53 54 3D 31 |)(HOST=1|
nsprecv: 39 32 2E 31 36 38 2E 31 |92.168.1|
nsprecv: 2E 31 30 32 29 28 50 4F |.102)(PO|
nsprecv: 52 54 3D 34 34 39 38 29 |RT=4498)|
nsprecv: 29 00 00 00 00 00 00 00 |).......|
nsprecv: normal exit

Here are some more excerpts from the cli.trc file showing the inaccessible ip address
and the resulting error diagnosis:

nttbnd2addr: entry
nttbnd2addr: port resolved to 4498
nttbnd2addr: using host IP address: 192.168.1.102
nttbnd2addr: exit
...
ntt2err: entry
ntt2err: soc 144 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
...
nscall: error exit
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12535
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 505
nioqper: nt (2) err code: 60
nioqper: nt OS err code: 0
niomapnserror: entry
niqme: entry
niqme: reporting NS-12535 error as ORA-12535
niqme: exit
niomapnserror: returning error 12535
niomapnserror: exit
niotns: Couldn't connect, returning 12535
niotns: exit

Solution: Add "USE_SHARED_SOCKET"="TRUE" to the Windows NT registry on the
server as follows, and restart the database and listener services on the server:

REGEDIT
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"USE_SHARED_SOCKET"="TRUE"


************************************************************
Regards,
S. Jayaram Uparna