So_keepalive Post: 302206872

Sponsored Content

Operating Systems AIX So_keepalive Post 302206872 by amiri2000 on Wednesday 18th of June 2008 02:37:47 PM

06-18-2008

Registered User

So_keepalive

Hi,

TCP/IP connection timeout issue:
Here is the scenario:
1) WLS Server1 (from Machine 1) is creating a conn pool to Oracle RAC node1 (on Machine 2) and node2 (Machine 3).
When we do the Oracle node panic shutdown of node1, we noticed failover is happening successfully, but with few stuck threads. After analyzing the stack trace, we noticed that there is still a socket open from Machine1 to node1 (macihne2 ) as ESTABLISHED state though node1 is dead.

When we contacted serveral teams, someone recommended SO_KEEPALIVE needs to be enabled. Any suggestions how to enable SO_KEEPALIVE flag to true? Here are the current TCP settings for Mahine 1:

Versions: AIX 5.3, WLS9.2, Oracle 10g Thin.
TCP/IP settings: no -a |grep tcp:
tcp_bad_port_limit = 0
tcp_ecn = 0
tcp_ephemeral_high = 65535
tcp_ephemeral_low = 32768
tcp_finwait2 = 1200
tcp_icmpsecure = 0
tcp_init_window = 0
tcp_inpcb_hashtab_siz = 24499
tcp_keepcnt = 8
tcp_keepidle = 600
tcp_keepinit = 150
tcp_keepintvl = 150
tcp_limited_transmit = 1
tcp_low_rto = 0
tcp_maxburst = 0
tcp_mssdflt = 1460
tcp_nagle_limit = 65535
tcp_nagleoverride = 0
tcp_ndebug = 100
tcp_newreno = 1
tcp_nodelayack = 0
tcp_pmtu_discover = 1
tcp_recvspace = 262144
tcp_sendspace = 262144
tcp_tcpsecure = 0
tcp_timewait = 1
tcp_ttl = 60
tcprexmtthresh = 3

thanks in advance for your advises.
regards,
Amir

amiri2000

View Public Profile for amiri2000

Find all posts by amiri2000

LEARN ABOUT PHP

oci_server_version

OCI_SERVER_VERSION(3)													     OCI_SERVER_VERSION(3)

oci_server_version - Returns the Oracle Database version

SYNOPSIS

       string oci_server_version (resource  $connection)

DESCRIPTION

	Returns a string with the Oracle Database version and available options

PARAMETERS

	      o $connection
		-

RETURN VALUES

	Returns the version information as a string or FALSE on error.

EXAMPLES

       Example #1

	      oci_server_version(3) example

	      <?php

	      $conn = oci_connect("hr", "hrpwd", "localhost/XE");
	      echo "Server Version: " . oci_server_version($conn);

	      // Displays:
	      // Server Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
	      // With the Partitioning, OLAP, Data Mining and Real Application Testing option

	      oci_close($conn);

	      ?>

NOTES

       Note

	       In  PHP	versions  before 5.0.0 you must use ociserverversion(3) instead. This old name still can be used. However it is deprecated
	      and not recommended.

SEE ALSO

       oci_client_version(3).

PHP Documentation Group 												     OCI_SERVER_VERSION(3)