Aug
10
This is a list of the parameters and configuration settings you should first check when installing the oracle database into a personal/sandbox environments, I made a note of them to allow me to verify them quickly without going through all the documentation for every install. This assumes you will not use ASM on your new instance.
All these commands assume you are logged in to your system as root.
1. Verify your system has at least 1 GB of RAM
grep MemTotal /proc/meminfo
2. Verify the required Libraries (x86_64)
SUSE Linux Enterprise Server 11The following packages (or later versions) must be installed:
binutils-2.20.0-0.7.9 (s390x)
gcc-4.3-62.198 (s390x)
gcc-c++-4.3-62.198 (s390x)
glibc-2.11.1-0.17.4 (s390x)
glibc-32bit-2.11.1-0.17.4 (s390x)
glibc-devel-2.11.1-0.17.4 (s390x)
glibc-devel-32bit-2.11.1-0.17.4 (s390x)
kshlibaio-0.3.109-0.1.46 (s390x)
libaio-32bit-0.3.109-0.1.46 (s390x)
libaio-devel-0.3.109-0.1.46 (s390x)
libaio-devel-32bit-0.3.109-0.1.46 (s390x)
libstdc++43-4.3.4_20091019-0.7.35 (s390x)
libstdc++43-32bit-4.3.4_20091019-0.7.35 (s390x)
libstdc++43-devel-4.3.4_20091019-0.7.35 (s390x)
libstdc++43-devel-32bit-4.3.4_20091019-0.7.35 (s390x)
libgcc43-4.3.4_20091019-0.7.35
make-3.81
sysstat-8.1.5-7.9.56 (s390x)
unixODBC-2.2.12 or later
unixODBC-devel-2.2.12 or later
unixODBC-32bit-2.2.12 (32 bit) or later
3. Ensure that resource limits are set appropriately by editing the /etc/security/limits.conf file to include the configuration described below:
oracle soft nproc 2047oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
4. Configure kernel parameters on the /etc/sysctl.conf as follows:
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
5. On SUSE Enterprise Linux use the command below:
/sbin/chkconfig boot.sysctl on
6. Create O/S groups:
#create the OSDBA group
/usr/sbin/groupadd -g 502 dba
#create the OSOPER group
/usr/sbin/groupadd -g 504 oper
#create the Oracle Installer Group
/usr/sbin/groupadd -g 507 oinstall
7. Create the Oracle software owner user:
/usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
8. Create the ORACLE_BASE directory
cd /u01
mkdir app
cd app
mkdir oracle
chown oracle:oinstall oracle
9. Add the ORACLE_BASE and other configuration to the oracle user’s profile
su – oracle
echo “export ORACLE_BASE=/u01/app/oracle” >> /home/oracle/.profileecho “export DISPLAY=localhost:0.0″ >> /home/oracle/.profile
exit chmod -R 775 /u01/app/oracle
10. Create directories for database files and the recovery area:
su – oracle
mkdir $ORACLE_BASE/oradata
mkdir $ORACLE_BASE/recovery_area
11. Verify TMP space and configure a new directory if necessary:
df -h /tmp
if the space in the current TMP directory is not sufficient:
mkdir /u01/tmp
chmod a+wr /u01/tmp
echo “export TMP=/u01/tmp” >> /home/oracle/.profile
echo “export TMPDIR=/u01/tmp” >> /home/oracle/.profile
12. Close your root session and login to the system as oracle to execute the following commands before you begin your installation:
xhost +localhost
unset ORACLE_HOME
unset TNS_ADMIN
