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

Change host name

[root@oracledb ~]# sed -i "s/HOSTNAME=localhost.localdomain/HOSTNAME=oracledb/" /etc/sysconfig/network

[root@oracledb ~]# hostname oracledb

Add hostname and IP mapping records

[root@oracledb ~]# vi /etc/hosts

192.168.1.160 oracledb

[root@oracledb ~]# ping oracledb

Close Selinux

[root@oracledb ~]# sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config

[root@oracledb ~]# setenforce 0

turn off the firewall

[root@oracledb ~]# chkconfig iptables off

[root@oracledb ~]# service iptables stop

Install dependency packages

[root@oracledb ~]# yum -y install gcc gcc-c++ make binutilscompat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-commonglibc-devel libaio libaio-devel libgcclibstdc++ libstdc++-devel unixODBC unixODBC-devel

create users and groups

[root@oracledb ~]# groupadd oinstall

[root@oracledb ~]# groupadd dba

[root@oracledb ~]# useradd -g oinstall -G dba oracle

[root@oracledb ~]# passwd oracle

Modify kernel parameters

[root@oracledb ~]# vi /etc/sysctl.conf #Add to end of file

net.ipv4.ip_local_port_range= 9000 65500

fs.file-max = 6815744

kernel.shmall = 10523004

kernel.shmmax = 6465333657

kernel.shmmni = 4096

kernel.sem = 250 32000 100128

net.core.rmem_default=262144

net.core.wmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_max=1048576

fs.aio-max-nr = 1048576

[root@oracledb ~]# sysctl -p

[root@oracledb ~]# sysctl -a

Modify oracle installation user resource limits

[root@oracledb ~]# vim /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

[root@oracledb ~]# vi /etc/pam.d/login

session required pam_namespace.so #Add pam_limits.so below

session required pam_limits.so

Create directory to change permissions

[root@oracledb ~]# mkdir -p /u01

[root@oracledb ~]# chown -R oracle:oinstall /u01

[root@oracledb ~]# chmod -R 775 /u01

Enable all users to access graphical desktops

[root@oracledb ~]# xhost +

Set oracle environment variables

[root@oracledb ~]# su - oracle #Switch to oracle user

[oracle@oracledb ~]$ vim ~/.bash_profile

export ORACLE_BASE=/u01/oracle

export ORACLE_SID=orcl

export ORACLE_HOME=/u01/oracle/product/11.2.0/dbhome_1

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PATH=$PATH:$HOME/bin:/u01/oracle/product/11.2.0/dbhome_1/bin

oracle@oracledb ~]$ source .bash_profile #Effective immediately

Install Oralce

1 Unzip orcale to root/Documents/123 directory

[oralce@oracledb 123]$ ./ database/runInstaller

Modify/etc/oratab to change N to Y to allow dbstart to start the database

[root@oracledb /]# vim /etc/oratab

Modify/etc/rc.local to start Oracle

[root@oracledb /]# vim /etc/rc.local

su - oracle -c 'lsnrctl start'

su - oracle -c 'dbstart'

su - oracle -c 'emctl start dbconsole'

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.