Oracle Firewall issue - PLEASE HELP

I am pulling my hair out here...I have Oracle 8.1.7 running on a Windows 2000 Server...we are using port forwarding technology through a service provider...this essentially acts as a firewall. Port 1521 is open to a specific IP Address...but net8 acces was not possible because of the way the db redirects the port. I have done Oracle's fix - which is to add "USE+SHARED_SOCKET = TRUE" to the registry.

Now I cannot even connect locally, I get - ORA-12537: TNS:connection closed when I try to connect locally or when some tries to connect using SQL+ from outside our domain. I'm getting this in the listener log:

(CONNECT_DATA=(SERVICE_NAME=internal.cima.com)(CID=(PROGRAM=C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=GATTACA)(USER=Administrator)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.3.230)(PORT=2319)) * establish * internal.cima.com * 0

The DB name is INTERNAL - and the server is "bigbird." Any ideas? Thanks in advance!

Chad Smith
(404) 406-7128

csmith_at_cimaconsulting.com Received on Thu Aug 02 2001 - 10:59:04 CDT