介绍
Oracle数据库是甲骨文公司的一款关系数据库管理系统。
环境
Oracle Linux 6.5_64 Mini Desktop
Oracle版本为112040_Linux-x86-64
硬件信息:CPU1核心 内存8G 磁盘40G
准备
系统安装参考Oracle Linux 6系统安装
开始部署
1.网卡设置
# vi /etc/sysconfig/network-scripts/ifcfg-eth0ONBOOT=yesNM_CONTROLLED=yesBOOTPROTO=staticIPADDR=192.168.100.203NETMASK=255.255.255.0GATEWAY=192.168.100.1DNS1=114.114.114.114:wq重启网卡#service network restart
2.安装工具
yum install zip unzip –y
3.设置hosts
#删除原内容,添加以下内容#vi /etc/hosts127.0.0.1 localhost oracle.localdomain oracle::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
4.修改环境变量
#vi 1.sh#!/bin/bash#Purpose:Create 6 groups named 'oinstall','dba','asmadmin','asmdba','asmoper','oper', plus 2 users named 'oracle','grid'.#Also setting the Environment#variable for oracle user.#variable for grid user.#Usage:Log on as the superuser('root'),and then execute the command:#./1preusers.sh#Author:Asher Huang echo "Now create 6 groups named 'oinstall','dba','asmadmin','asmdba','asmoper','oper'"echo "Plus 2 users named 'oracle','grid',Also setting the Environment"groupadd -g 1000 oinstallgroupadd -g 1300 dbagroupadd -g 1301 operuseradd -u 1101 -g oinstall -G dba,oper -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracleecho "oracle" | passwd --stdin oracleecho 'export PS1="`/bin/hostname -s`-> "'>> /home/oracle/.bash_profileecho "export TMP=/tmp">> /home/oracle/.bash_profile echo 'export TMPDIR=$TMP'>>/home/oracle/.bash_profileecho "export ORACLE_HOSTNAME=oracle.localdomain">> /home/oracle/.bash_profileecho "export ORACLE_SID=devdb1">> /home/oracle/.bash_profileecho "export ORACLE_BASE=/main/app/oracle">> /home/oracle/.bash_profileecho 'export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1'>> /home/oracle/.bash_profileecho "export ORACLE_UNQNAME=devdb">> /home/oracle/.bash_profileecho 'export TNS_ADMIN=$ORACLE_HOME/network/admin' >> /home/oracle/.bash_profileecho "export ORACLE_TERM=xterm">> /home/oracle/.bash_profileecho 'export PATH=/usr/sbin:$PATH'>> /home/oracle/.bash_profileecho 'export PATH=$ORACLE_HOME/bin:$PATH'>> /home/oracle/.bash_profileecho 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib'>> /home/oracle/.bash_profileecho 'export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib'>> /home/oracle/.bash_profileecho "export EDITOR=vi" >> /home/oracle/.bash_profileecho "export LANG=en_US" >> /home/oracle/.bash_profileecho "export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK" >> /home/oracle/.bash_profileecho "export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'" >> /home/oracle/.bash_profileecho "umask 022">> /home/oracle/.bash_profilemkdir -p /main/app/oraclechown -R oracle:oinstall /mainchmod -R 775 /maincp /etc/security/limits.conf /etc/security/limits.conf.bakecho "oracle soft nproc 2047" >>/etc/security/limits.confecho "oracle hard nproc 16384" >>/etc/security/limits.confecho "oracle soft nofile 1024" >>/etc/security/limits.confecho "oracle hard nofile 65536" >>/etc/security/limits.confecho "grid soft nproc 2047" >>/etc/security/limits.confecho "grid hard nproc 16384" >>/etc/security/limits.confecho "grid soft nofile 1024" >>/etc/security/limits.confecho "grid hard nofile 65536" >>/etc/security/limits.confcp /etc/pam.d/login /etc/pam.d/login.bak echo "session required /lib/security/pam_limits.so" >>/etc/pam.d/loginecho "session required pam_limits.so" >>/etc/pam.d/login echo "Now modify the /etc/profile,but with a backup named /etc/profile.bak"cp /etc/profile /etc/profile.bakecho 'if [ $USER = "oracle" ]||[ $USER = "grid" ]; then' >> /etc/profileecho 'if [ $SHELL = "/bin/ksh" ]; then' >> /etc/profileecho 'ulimit -p 16384' >> /etc/profileecho 'ulimit -n 65536' >> /etc/profileecho 'else' >> /etc/profileecho 'ulimit -u 16384 -n 65536' >> /etc/profileecho 'fi' >> /etc/profileecho 'fi' >> /etc/profileecho "Now modify the /etc/sysctl.conf,but with a backup named /etc/sysctl.bak"cp /etc/sysctl.conf /etc/sysctl.conf.bakecho "fs.aio-max-nr = 1048576" >> /etc/sysctl.confecho "fs.file-max = 6815744" >> /etc/sysctl.confecho "kernel.shmall = 2097152" >> /etc/sysctl.confecho "kernel.shmmax = 4186771456" >> /etc/sysctl.confecho "kernel.shmmni = 4096" >> /etc/sysctl.confecho "kernel.sem = 250 32000 100 128" >> /etc/sysctl.confecho "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.confecho "net.core.rmem_default = 262144" >> /etc/sysctl.confecho "net.core.rmem_max = 4194304" >> /etc/sysctl.confecho "net.core.wmem_default = 262144" >> /etc/sysctl.confecho "net.core.wmem_max = 1048586" >> /etc/sysctl.confecho "net.ipv4.tcp_wmem = 262144 262144 262144" >> /etc/sysctl.confecho "net.ipv4.tcp_rmem = 4194304 4194304 4194304" >> /etc/sysctl.confecho "Modifing the /etc/sysctl.conf has been succeed."echo "Now make the changes take effect....."sysctl -p[root@oracle ~]# sh 1.sh[root@oracle ~]# vi /home/oracle/.bash_profile把export ORACLE_SID=devdb1改成export ORACLE_SID=devdb
5.安装依赖包
下载依赖包(依赖包放置在/home/oracle/rpm下)
compat-libcap1-1.10-1.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/compat-libcap1-1.10-1.x86_64.rpm)
compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm)
gcc-c++-4.4.7-4.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/gcc-c++-4.4.7-4.el6.x86_64.rpm)
ksh-20120801-10.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/ksh-20120801-10.el6.x86_64.rpm)
libaio-0.3.107-10.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/libaio-0.3.107-10.el6.x86_64.rpm)
libaio-devel-0.3.107-10.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/libaio-devel-0.3.107-10.el6.x86_64.rpm)
libstdc++-devel-4.4.7-4.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/libstdc++-devel-4.4.7-4.el6.x86_64.rpm)
sysstat-9.0.4-22.el6.x86_64.rpm(http://image.wohenniucha.com/upload/2018/06/sysstat-9.0.4-22.el6.x86_64.rpm)
[root@oracle rpm]# rpm -ivh *
6.关闭selinux
vi /etc/selinux/config修改SELINUX=enforcing为SELINUX=disabled然后执行setenforce 0 生效
7.安装Oracle
进入系统
![b4580cbacd8b719d9df6dc272d5103bf.png](https://i-blog.csdnimg.cn/blog_migrate/a71f4bb00390233a18cec52dac8d3a11.jpeg)
#把p13390677_112040_Linux-x86-64_1of7.zip和p13390677_112040_Linux-x86-64_2of7.zip软件上传至/home/oracle/下#解压运行oracle-> unzip p13390677_112040_Linux-x86-64_1of7.zip && unzip p13390677_112040_Linux-x86-64_2of7.zip
![4131d80856e69bb27f5820d4e62fbbc3.png](https://i-blog.csdnimg.cn/blog_migrate/6e4753285a443c0af77e3d97e431393e.jpeg)
若是在root下切换到oralce时,在物理机上测试安装时提示check if the display variable is set此步需要在root下执行:xhost + 建议直接以oralce用户登录执行一下命令
打开oracle的安装界面
去掉勾选,点next,选择yes:
![1b6b1fa3c50c5f46ea48806ad1d5b568.png](https://i-blog.csdnimg.cn/blog_migrate/3183ad455129508d69a54dd5ea332028.jpeg)
![39ad651c6cb964ac97a73fa0ef311cdd.png](https://i-blog.csdnimg.cn/blog_migrate/e1540475314437e405e4f3530162426b.jpeg)
![7e5e6a8a311074110d7322b4d325bde6.png](https://i-blog.csdnimg.cn/blog_migrate/45348ceee099fc6b0897d787336af62b.jpeg)
![f4b4bb0901e07a494957b82fc63729b6.png](https://i-blog.csdnimg.cn/blog_migrate/0e42cd680389974ff50c6a4ed676079b.jpeg)
![606077457127cd463fa8f666f81699d4.png](https://i-blog.csdnimg.cn/blog_migrate/039fa86c7da7bf5e8bb78158cfe5a66e.jpeg)
![756c4694b61695138430a3737db552cf.png](https://i-blog.csdnimg.cn/blog_migrate/789e3228adb0ecb487d65876345e5a34.jpeg)
![cc01e5d6e40bdb0aa30d6bb86ba9f605.png](https://i-blog.csdnimg.cn/blog_migrate/c1136a43b17bfc8bf18cf90505202cc5.jpeg)
![7245debb033aefbc7165478156e51b0e.png](https://i-blog.csdnimg.cn/blog_migrate/94ce6cd54d0195c24ed9fa93cb4c3caa.jpeg)
![794b070322e505bfbde80e0088c2848e.png](https://i-blog.csdnimg.cn/blog_migrate/b778051770085048b4952ed4238c67a4.jpeg)
![cb962acdc88c1486dc27666401be795c.png](https://i-blog.csdnimg.cn/blog_migrate/0659b75490ccd29d13a23484f05ab5f4.jpeg)
![179b17702c93cada8a2ea977358ddf21.png](https://i-blog.csdnimg.cn/blog_migrate/e5a2e6ed52a100b99c5e36c373a8959a.jpeg)
根据提示在root用户下执行脚本命令
![ab463a003aa2e82d0df87d71e97f2555.png](https://i-blog.csdnimg.cn/blog_migrate/386d5d8e9010e06f41c21b5c0320d05e.jpeg)
![acded27b1b81644d73a1f1fd3044b6d6.png](https://i-blog.csdnimg.cn/blog_migrate/8255c42a04680c07cff4c8508a735f6c.jpeg)
![984d19ed87bdfc514ec28cccbf67b623.png](https://i-blog.csdnimg.cn/blog_migrate/44f98cc04d48cd05e4e4092597491cd3.jpeg)
建立监听
![13558bbcb800322ea51159f53e6b572d.png](https://i-blog.csdnimg.cn/blog_migrate/353a402bb69574cdf6456f58cce5a02f.jpeg)
弹出建立监听界面,一直下一步到结束Finish
建库
![fee30d27b8a43dd6cde4df1effce57e1.png](https://i-blog.csdnimg.cn/blog_migrate/53aa600cd2ffa561f071391ba12e9d90.jpeg)
![14cf5011db68b493513f082aeb0d9944.png](https://i-blog.csdnimg.cn/blog_migrate/08a26d1041f1e60384eab74eafccc662.jpeg)
![2feb911466cbe4f4071862d639dea2eb.png](https://i-blog.csdnimg.cn/blog_migrate/9cae0e86502e4d57bdec979413fdae4d.jpeg)
![4c850e34e8f45a9b17f30176140bb05f.png](https://i-blog.csdnimg.cn/blog_migrate/3739b38415d131d5fdd29f6958b1734b.jpeg)
![57ab43ba9b0db085f77fc6937724ebdc.png](https://i-blog.csdnimg.cn/blog_migrate/67154b3b9711f403879591a2540221e0.jpeg)
![9388809c33074802b379301d9e8ecada.png](https://i-blog.csdnimg.cn/blog_migrate/0dffc32b14e7e3833db04647aee17960.jpeg)
此处密码不能设置特殊符号,否则建库会出错
![c9a294d506fc4f1538cc879865f4688b.png](https://i-blog.csdnimg.cn/blog_migrate/1afdd71671e74c079141cf69fc68c5ec.jpeg)
![8fba8f2a451b912b6933543a850b4843.png](https://i-blog.csdnimg.cn/blog_migrate/a98fa7c7dd6c393a6a8faa6cf933332d.jpeg)
![d13afe0b678ff5878b7d05a5c272be3b.png](https://i-blog.csdnimg.cn/blog_migrate/c2a2c81746a4114cad507ab5a53f155b.jpeg)
![23baca9f449b37a5edea4bcd08dc3ebf.png](https://i-blog.csdnimg.cn/blog_migrate/46911b4f7470087d40a8f59a5d8ab62b.jpeg)
![7ab8f2682b0fd868700591921f88dfc0.png](https://i-blog.csdnimg.cn/blog_migrate/df3e8098d8f02fc06bc34a03ae9a9531.jpeg)
![fb4e6d31551524c2b2a044f7c2b0a521.png](https://i-blog.csdnimg.cn/blog_migrate/494a957abfe7926e3b98aa7ae8e28ca5.jpeg)
![b7c13efe6dd9b64894ebca6667705a49.png](https://i-blog.csdnimg.cn/blog_migrate/a981d5f8e62290b67b70b2e9dae12e5b.jpeg)
![00b93952b283f9f76c36ce27eea3d83d.png](https://i-blog.csdnimg.cn/blog_migrate/e1e3749d8c42ec338de824b3f15ea5af.jpeg)
![c9c0a2c92291193f3d32cb525a2191bc.png](https://i-blog.csdnimg.cn/blog_migrate/0b222a7c8082dcccb77dc95f4b5451a1.jpeg)
8.设置lsnrctl与db开机自动启动
#修改/etc/oratab文件# vi /etc/oratab 找到devdb:/main/app/oracle/product/11.2.0/db_1:N这一行,把N改成Ydevdb:/main/app/oracle/product/11.2.0/db_1:Y#修改/etc/rc.local# vi /etc/rc.local #添加下面两行su - oracle -c 'lsnrctl start'su - oracle -c 'dbstart'#开放防火墙端口vi /etc/sysconfig/iptables在:OUTPUT ACCEPT [0:0]行下输入-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT#然后重启iptablesservice iptables restart