Skip to main content

Oracle Database 11.2.0.2 tcp_ and udp_ New kernel parameters for Sun Solaris 10

There are some new kernel parameters needs to be configured in order to Install new patch set for 11gR2 (11.2.0.2)

Error message while running Installer:




PRVF-7543 : OS Kernel parameter “tcp_smallest_anon_port” does not have proper value on node “solaris1″ [Expected = "9000" ; Found = "32768"]
PRVF-7543 : OS Kernel parameter “tcp_largest_anon_port” does not have proper value on node “solaris1″ [Expected = "65500" ; Found = "65535"]
PRVF-7543 : OS Kernel parameter “udp_smallest_anon_port” does not have proper value on node “solaris1″ [Expected = "9000" ; Found = "32768"]
PRVF-7543 : OS Kernel parameter “udp_largest_anon_port” does not have proper value on node “solaris1″ [Expected = "65500" ; Found = "65535"]




The following are the list of parameters:

1) tcp_smallest_anon_port

2) tcp_largest_anon_port

3) udp_smallest_anon_port

4) udp_largest_anon_port

When i was trying to Install this new patchset, the result for pre-requisite check was failed because of these newly introduces kernel parameters.

These kernel parameters was not updated in Installation and upgrade guide for solaris at the time when i was installing:


http://download.oracle.com/docs/cd/E11882_01/install.112/e17755/toc.htm#BABGADGE


Setting these kernel parameters:

1) To view the current value of these parameters, login as root user:




bash-3.00# ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port
9000

65500
bash-3.00#

bash-3.00# ndd /dev/udp udp_smallest_anon_port udp_largest_anon_port
9000

65500
bash-3.00#




The kernel parameters as expected by the Installer:

kernel parameter preset val expected

tcp_smallest_anon_port -- 32768 --> 9000

tcp_largest_anon_port -- 65535 --> 65500

udp_smallest_anon_port -- 32768 --> 9000

udp_largest_anon_port -- 65535 --> 65500

update these kernel parameters using following parameters:




bash-3.00# ndd -set /dev/tcp tcp_largest_anon_port 65535
bash-3.00# ndd -set /dev/udp udp_smallest_anon_port 9000
bash-3.00# ndd -set /dev/udp udp_largest_anon_port 65500
bash-3.00# ndd -set /dev/tcp tcp_smallest_anon_port 9000
bash-3.00# ndd -set /dev/tcp tcp_largest_anon_port 65500



Then verify the settings using:




bash-3.00# ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port

bash-3.00# ndd /dev/udp udp_smallest_anon_port udp_largest_anon_port



After setting these kernel parameters the pre-requisite check was successfull and Installation completed without any issue.

Happy reading.

Comments

Anonymous said…
While the setup may finish successfully should these settings be persisted across reboots?
Syed Zaheer said…
If you want to keep these settings permanent then keep it in a System startup scripts.
Anonymous said…
Excellent Syed.. indeed very helpful. Do you think having these ndd values NOT persistend across reboots create problems later on or is it sufficient to have them set just for installation?
Anonymous said…
The settings are not there to allow the install to complete, you can safely ignore them and the install will complete fine. The kernel settings are there to support the intended requirements of the database under heavy load. Your default settings may be fine for this but Oracle is now recommending a greater port range.
Anonymous said…
Thank you for the userfull info, it solved my 2 days pending work
Thrissukaran said…
1. As the root user, use a text editor to edit the /etc/inittab file and add the following statement before the line which executes sys.startd:

tm::sysinit:/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 32776 > /dev/console
2. Save the changes and close the file.
3. Reboot the server for these settings to take effect.

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment

Oracle Applications R12.2 Installation on Linux using virtual box

Oracle E-Business suite R12.2 is released a month ago. I received too many requests from my followers to demonstrate this Installation. This is a step by step detailed article for Installing Oracle E-business suite R12,2 on Oracle Enterprise Linux 5.7 (64-bit). I've used oracle virtual box for Installing Linux. Note:  This Installation is demonstrated on virtual machine with 8GB RAM and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this .  My Virtual Machine configuration: CPU    = 1 core RAM   = 8 GB HDD   =  380 GB Software's Required: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 5.7 (64-bit) 3) Oracle E-Business suite R12.2 for LinuxX86-64-bit Installation Steps: Hardware requirements Create virtual machine and Install operating system Operating System pre-requisites Prepare Stage Area Install Oracle EBS R12.2 software Verify Installation 1. Hardware Requirement