OraFAQ Forum: Networking and Gateways » Oracle redirect to high ports

Home » RDBMS Server » Networking and Gateways » Oracle redirect to high ports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle redirect to high ports [message #170014]

Mon, 01 May 2006 13:31

MeganP
Messages: 15
Registered: March 2005

Junior Member

All,
Greetings! In DEV environment, DB server is able to communicate with Web server (DMZ) thru standard port (1521).

In PROD environment, the request is getting dropped and is being requested to use random high port numbers (3053, in the following case). I was just wondering what could have caused PROD DB server to look / request for high ports. I am not really sure whether both configuration setups are exactly identical (But same oracle versions 9i). I would really appreciate your help in this regard.

Please see the firewall log for your reference.

Development:
===========
Number: 1853460
Date: 11Apr2006
Time: 15:45:05
Product: VPN-1 & FireWall-1
Interface: eth3c0
Origin: mobinet1
Type: Log
Action: Accept
Protocol: tcp
Service: sql_tcp_1521 (1521)
Source: ABC52006
Destination: ABC51002
Rule: 124
Source Port: 4054

Production:
==========
Number: 1812002
Date: 11Apr2006
Time: 15:22:22
Product: VPN-1 & FireWall-1
Interface: eth3c0
Origin: mobinet1
Type: Log
Action: Accept
Protocol: tcp
Service: sql_tcp_1521 (1521)
Source: ABC52003
Destination: ABC51001
Rule: 124
Source Port: 2949
Source Port: 2949

Number: 1812006
Date: 11Apr2006
Time: 15:22:22
Product: VPN-1 & FireWall-1
Interface: eth3c0
Origin: mobinet1
Type: Log
Action: Drop
Protocol: tcp
Service: 3053
Source: ABC52003
Destination: ABC51001
Rule: 127
Source Port: 2950

Thanks!

[Updated on: Mon, 01 May 2006 13:32]

Report message to a moderator

Re: Oracle redirect to high ports [message #170052 is a reply to message #170014]

Mon, 01 May 2006 21:57

networker
Messages: 5
Registered: April 2006

Junior Member

Have you configured USE_SHARED_SOCKET=TRUE on the DEV but not the production setup ?

This will force all packets to use the same port (1521) and not the random high port.

Report message to a moderator

Re: Oracle redirect to high ports [message #170224 is a reply to message #170052]

Tue, 02 May 2006 14:40

MeganP
Messages: 15
Registered: March 2005

Junior Member

I have just checked the registry and couldn't find USE_SHARED_SOCKET on either servers. Do you guys think of any other reason?

It appears that DBA has installed Oracle 10g on both the servers, 9i being the primary database. Does 10g configuration cause any of these issues?

Thanks.

Report message to a moderator

Previous Topic:	TNS-12541: TNS:no listener
Next Topic:	TNS:protocol adapter error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 09:36:59 CST 2024