Shulou(Shulou.com)06/01 Report--

1. Create a user

Groupadd oinstall

Groupadd dba

Useradd-m-g oinstall-G dba oracle

Passwd oracle

2. Create a directory

Mkdir-p / u01/app/oracle

Mkdir-p / u01/app/oraInventory

Chown-R oracle.oinstall / u01/app

Chmod 777 / u01/app

3. Modify the file / etc/security/limits.conf and add the following:

# / etc/security/limits.conf

# for oracle

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

Oracle hard stack 32768

4. Check to confirm whether the following rpm package is installed. If not, install the following rpm package in time.

Binutils-2.19

Gcc-4.3

Gcc-32bit-4.3

Gcc-c++-4.3

Glibc-2.9

Glibc-32bit-2.9

Glibc-devel-2.9

Glibc-devel-32bit-2.9

Ksh-93t

Libaio-0.3.104

Libaio-32bit-0.3.104

Libaio-devel-0.3.104

Libaio-devel-32bit-0.3.104

Libstdc++33-3.3.3

Libstdc++33-32bit-3.3.3

Libstdc++43-4.3.3mm 20081022

Libstdc++43-32bit-4.3.3_20081022

Libstdc++43-devel-4.3.3_20081022

Libstdc++43-devel-32bit-4.3.3_20081022

Libgcc43-4.3.3mm 20081022

Libstdc++-devel-4.3

Make-3.81

Sysstat-8.1.5

UnixODBC-2.2.12 or later

UnixODBC-devel-2.2.12 or later

UnixODBC-32bit-2.2.12 (32-bit) or later

5. Modify kernel parameters

Vi / etc/sysctl.conf

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

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 = 1048576

Vm.hugetlb_shm_group=oinstall 's id # # has one more parameter setting than Red Hat.

Execute after modification is saved

/ sbin/chkconfig boot.sysctl on

/ sbin/sysctl-p

Note: if the parameter value in the sysctl.conf file is greater than the specified value, then the configuration file parameter value shall prevail.

6. Modify the oracle user bash_profile file and add the following

Vi .profile

Export TMP=/tmp

Export TMPDIR=$TMP

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

Export ORACLE_SID=ORACLE

Export ORACLE_TERM=xterm

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Export PATH=$ORACLE_HOME/bin:$PATH

ExportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; umask 022

7. Install database software.

8. Create a database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.