Solaris - Oracle 11g install (Ephemeral Ports)

The DBAs were uprading from 10g to 11g - they found an issue where 11g complains about the TCP and UDP port settings. Some how this escaped the QA testing prior to Oracle releasing the version (I've been informed that Oracle weren't looking at fixing the issue at present - luckily we don't pay a vast amount of money for Oracle licensing..... Oh, wait. We do!!).

Error message:

11.2.0.2 Installer (OUI) requires anon_port parameters to be set [ID 1266293.1]

Temporary fix which applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2 and later
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

Run the following:

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

Verify change:

# ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port
# ndd /dev/udp udp_smallest_anon_port udp_largest_anon_port

NOTE: Changes will not be kept once rebooted - for more permanence.....

1. Create Startup script (SXXname).

# touch /etc/init.d/SXXname

2. Edit the permissions on the file

# chmod 755 SXXname

3. Confirm permissions

# ls -al

4. Create link from /etc/init.d to /etc/rc3.d

# ln -s /etc/init.d/SXXname /etc/rc3.d/SXXname

Startup script contents:

Name: SxxOracle11g

Content:

#!/usr/bin/ksh
ndd -set /dev/udp udp_smallest_anon_port 9000
ndd -set /dev/udp udp_largest_anon_port 65500
ndd -set /dev/tcp tcp_smallest_anon_port 9000
ndd -set /dev/tcp tcp_largest_anon_port 65500