Overview Few actions will have a greater impact on the stability of your database than a sound software installation. We want to install software to meet these criteria:
* Secure. * Standardized. * Able to store a daunting amount of data. * Able to manage connections effectively. * Scalable.
This calls for markedly different mentality than installing home PC software.
If the installation of Oracle in your environment is not standardized, then it will be harder to duplicate success, and harder for new DBAs to get up to speed. The same is true with any piece of Enterprise software.
Modify the OS Kernel to Support Oracle Add the following settings to the to your /etc/system file. The system must be rebooted before these settings will take effect. The below works in Solaris versions 8, 9 and 10. See your UNIX System Administrator as required.
set noexec_user_stack=1 set semsys:seminfo_semmni=300 set semsys:seminfo_semmns=1024 set semsys:seminfo_semmsl=300 set semsys:seminfo_semvmx=32767 set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=300 set shmsys:shminfo_shmseg=20
The default kernel values for the Solaris 10 operating system now account for many of the traditional ones that used to be required. Any entries regarding shared memory or semaphores (shm & sem) in /etc/system will be ignored if prctl is used. Furthermore, the following parameters have been removed in Solaris 10. If these parameters are included in the /etc/system file on a Solaris 10 system, they will be ignored: