Re: Oracle Firewall issue - PLEASE HELP

I have expereinced this situation.
Try to setup cman to eliminate random port redirection.

hth,
Winner H. Manurung

Chad <chadscc_at_hotmail.com> wrote in message news:87feb722.0108020759.76a293de_at_posting.google.com...
> 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 Fri Aug 03 2001 - 04:07:46 CDT