How to Configure Ephemeral Ports for Oracle 11gR2 on Solaris 11
# /usr/sbin/ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port 32768 65535 # ipadm show-prop tcp PROTO PROPERTY PERM CURRENT PERSISTENT DEFAULT POSSIBLE tcp cong_default rw newreno -- newreno newreno,cubic, highspeed,vegas tcp cong_enabled rw newreno,cubic, newreno,cubic, newreno newreno,cubic, highspeed, highspeed, highspeed,vegas vegas vegas tcp ecn rw passive -- passive never,passive, active tcp extra_priv_ports rw 2049,4045 -- 2049,4045 1-65535 tcp largest_anon_port rw 65535 -- 65535 32768-65535 tcp max_buf rw 1048576 -- 1048576 128000-1073741824 tcp recv_buf rw 128000 -- 128000 2048-1048576 tcp sack rw active -- active never,passive, active tcp send_buf rw 49152 -- 49152 4096-1048576 tcp smallest_anon_port rw 32768 -- 32768 1024-65535 tcp smallest_nonpriv_port rw 1024 -- 1024 1024-32768 root@CSOPORAADM2:~# ipadm show-prop udp PROTO PROPERTY PERM CURRENT PERSISTENT DEFAULT POSSIBLE udp extra_priv_ports rw 2049,4045 -- 2049,4045 1-65535 udp largest_anon_port rw 65535 -- 65535 32768-65535 udp max_buf rw 2097152 -- 2097152 65536-1073741824 udp recv_buf rw 57344 -- 57344 128-2097152 udp send_buf rw 57344 -- 57344 1024-2097152 udp smallest_anon_port rw 32768 -- 32768 1024-65535 udp smallest_nonpriv_port rw 1024 -- 1024 1024-32768
Using IPADM set-prop command, set the property for ephemral ports
# ipadm set-prop -p smallest_anon_port=9000 tcp # ipadm set-prop -p smallest_anon_port=9000 udp # ipadm set-prop -p largest_anon_port=65500 tcp # ipadm set-prop -p largest_anon_port=65500 udp
Configuration is permanent.
# init 6 # /usr/sbin/ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port 9000 65500
What is the reason of modifying this parameter?, how does it affect the database?
It is required, under Oracle’s documentation.
https://docs.oracle.com/cd/E11882_01/install.112/e48357/pre_install.htm#SSDBI1150