day03-VMvare中在CentOS7安装oracle

-----oracle 12c-----------

到oracle官网下载12c


database服务器端的两个文件:

linuxamd64_12102_database_1of2.zip

linuxamd64_12102_database_2of2.zip

database的client的一个文件：


32位 oracle 11g client  windows版本

centos 7

oracle 12c


1.


添加用户及相关目录
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle

变更oracle12c介质的所有者

授权
chown -R oracle:oinstall /tmp

切换到oracle用户
su oracle 

到tmp文件夹下，对上传的两个oracle文件解压
unzip linuxamd64_12102_database_1of2.zip 
unzip linuxamd64_12102_database_2of2.zip
解压之后生产一个database文件夹
可以将上面两个删除

2.

---创建安装oracle安装目录
root用户操作：
mkdir -p /u01/app/oracle/product/12.1.0/dbhome_1
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01
chmod -R 777 /u01

3.
系统依赖包的安装 验证
root账户
root /  目录均可

yum -y install binutils
yum -y install compat-libcap  
yum -y install gcc-  
yum -y install gcc-c++-
yum -y install glib2-devel 
yum -y install glibc  
yum -y install ksh  
yum -y install libaio
yum -y install libaio-devel
yum -y install libgcc- 
yum -y install libstdc++-
yum -y install libstdc++-devel
yum -y install libX11
yum -y install libXau
yum -y install libxcb
yum -y install libXext
yum -y install libXtst 
yum -y install make
yum -y install sysstat
yum -y install compat-libstdc++
yum -y install libstdc++
yum -y install compat-c++
yum -y install compat-libcap
yum -y install gcc-c++
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install xterm
yum -y install elfutils-libelf
yum -y install libaio-devel
yum -y install libgcc
yum -y install pdksh
yum -y install compat-libstdc++




------------------------
-----------------------



-------------------------------

4.修改linux 核心配置文件

root账户

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 


执行下边命令生效上述

sysctl -p






5.


--修改系统限制
vi /etc/security/limits.conf


oracle              soft    nproc   2047  
oracle              hard    nproc   16384  
oracle              soft    nofile  1024  
oracle              hard    nofile  65536  


6.


---


vi /etc/pam.d/login


session    required     /lib/security/pam_limits.so  
session    required     pam_limits.so  


7.


 vi /etc/profile
 在done与unset中间加入

if [ $USER = "oracle" ]; then  
        if [ $SHELL = "/bin/ksh" ]; then  
              ulimit -p 16384  
              ulimit -n 65536  
        else  
              ulimit -u 16384 -n 65536  
        fi  
fi  


8.
切换用户

su oracle


vi ~/.bash_profile

export PATH上面添加
  
ORACLE_BASE=/u01/app/oracle  
ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
ORACLE_SID=test  
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin  
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib  
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH  



--以oracle用户本身来执行下边的命令生效

source ~/.bash_profile

 
 
9.


//上面若已经授权就不需要 chown -R oracle:oinstall /tmp/database




--------------
su root

export DISPLAY=:0.0

xhost +

su oracle


cd /tmp/database


./runInstaller.sh

---------


root用户运行脚本
		/u01/app/oraInventory/orainstRoot.sh
		/....



10.


--创建数据库
dbca 

如果找不到，切换到oracle用户
source ~/.bash_profile


--创建监听器
netca





11.

export LANG=""






---------