Another USE_SHARED_SOCKET problem - please help
652844Jul 31 2008 — edited Jul 31 2008In our company we work with an Oracle 9i Database on a Windows XP SP2 PC.
The Listener listen on port 1521 like listener.ora below shows.
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.22)(PORT = 1521))
)
)
)
This works fine inside the LAN. Now we want to access this database from the internet over a SSH tunnel through a firewall (TnsPing succeed). I read about the occuring problem that the database will communicate with the client over an "random" socket number and also about the option to let the database communicate with the client over over the shared listener socket (USE_SHARED_SOCKET).
So I set the values the windows registry in paths: HKLM/Software/Oracle and HKLM:Software/Oracle/Home<#> on server machine (values set to TRUE). Second value I set because after reboot database server the database used still random socket numbers. But this second configuration still won't work.
The connect try is logged with this line in listener.log file:
31-JUL-2008 08:48:45 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ourDB)(CID=(PROGRAM=xxx)(HOST=client)(USER=user))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.26)(PORT=33482)) * establish * ourDB * 0
The I read that the USE_SHARED_SOCKET parameter also can set as an environment variable. But with this change there are no changes.
summing up:
- using putty to create a SSH connection (with port forwarding: local:10000 -> server:1521) to connect database from internet
- tnsping succeed
- USE_SHARED_SOCKET is set to True three times (2x registry, 1x environment)
- connect to database fails
- listener.log indicates that database still try to connect through random port
Can anyone help me to configurate the database so that it communicates with the client over shared socket 1521?
Please help me.
regards,
Jan