Re: Oracle Firewall issue - PLEASE HELP

"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

Three comments:
1 it is USE_SHARED_SOCKETS
Your trace clearly shows sqlnet didn't pick up the registry var 2 you are using Milnet /fake IP-addresses, they are not supposed to work outside your domain
3 I guess internal is still a reserved word, and creating a database 'internal' looks like just askign for trouble.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 02 2001 - 13:41:55 CDT