centos7.4安装Oracle11g

Love The Way You Lie 2023-06-14 05:28 28阅读 0赞

系统要求1.5G内存，硬盘20G  
1.关闭防火墙  
systemctl stop firewalld  
禁止开机启动  
systemctl disable firewalld  
2.关闭selinux  
setenforce 0  
编辑conf文件永久关闭  
![关闭selinux][selinux]  
3.创建安装Oracle的用户和用户组  
groupadd oinstall  
groupadd dba  
useradd -g oinstall -G dba -m oracle  
为Oracle用户创建密码  
passwd oracle  
4.创建安装目录  
mkdir -p /data/oracle  
mkdir -p /data/oraInventory  
mkdir -p /data/database/  
<将Oracle安装文件解压到/data/database目录下  
将目录权限授予Oracle用户及oinstall组  
chown -R oracle:oinstall /data/  
5.修改Oracle用户限制  
编辑/etc/security/limits.conf 文件，添加如下内容  
oracle soft nproc 2047  
oracle hard nproc 16384  
oracle soft nofile 1024  
oracle soft nofile 65536  
编辑/etc/pam.d/login文件，添加如下内容  
session required /lib64/security/pam\_limits.so  
session required pam\_limits.so  
6.安装依赖包  
yum -y install binutils compat-libstdc+±33 elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc+±devel make ksh sysstat unixODBC unixODBC-devel  
7.修改内核参数/etc/sysctl.conf添加如下内容  
net.ipv4.icmp\_echo\_ignore\_broadcasts = 1  
net.ipv4.conf.all.rp\_filter = 1  
fs.file-max = 6815744  
fs.aio-max-nr = 1048576  
kernel.shmall = 2097152  
kernel.shmmax = 2147483648   
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  
注意红色字体部分根据自己的主机去调整  
8.配置用户环境变量  
vi /home/oracle/.bash\_profile  
export ORACLE\_BASE=/data/oracle \#oracle数据库安装目录  
export ORACLE\_HOME=$ORACLE\_BASE/product/11.2.0/db\_1 \#oracle数据库路径  
export ORACLE\_SID=orcl \#oracle启动数据库实例名  
export ORACLE\_TERM=xterm \#xterm窗口模式安装  
export PATH=$ORACLE\_HOME/bin:/usr/sbin:$PATH \#添加系统环境变量  
export LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:/lib/:/usr/lib \#添加系统环境变量  
export LANG=C \#防止安装过程出现乱码  
export NLS\_LANG=AMERICAN\_AMERICA.ZHS16GBK \#设置Oracle客户端字符集，必须与Oracle安装时设置的字符集保持一致  
保存后执行source /home/oracle/.bash\_profile使配置文件生效  
8.安装vnc服务端  
请先确定系统已安装了GNOME Desktop  
yum -y install tigervnc-server  
9.切换到Oracle用户下设置vnc登录密码  
\[root@192 ~\]\# su - oracle  
\[oracle@192 ~\]$ vncpasswd  
Password:  
Verify:  
Would you like to enter a view-only password (y/n)? n  
启动vnc服务  
\[oracle@192 ~\]$ vncserver :1

Warning: 192.168.254.130:1 is taken because of /tmp/.X11-unix/X1  
Remove this file if there is no X server 192.168.254.130:1  
A VNC server is already running as :1

Warning: 192.168.254.130:1 is taken because of /tmp/.X11-unix/X1  
Remove this file if there is no X server 192.168.254.130:1  
xauth: file /home/oracle/.Xauthority does not exist

New ‘192.168.254.130:2 (oracle)’ desktop is 192.168.254.130:2

Creating default startup script /home/oracle/.vnc/xstartup  
Creating default config /home/oracle/.vnc/config  
Starting applications specified in /home/oracle/.vnc/xstartup  
Log file is /home/oracle/.vnc/192.168.254.130:2.log  
这里提示192.168.254.130:1被占用，系统自动为我们分配192.168.254.130:2  
使用客户端登录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70]  
输入刚才设置的密码  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 1]  
10.进入/data/database目录执行安装![在这里插入图片描述][20191118205415135.png]  
11.不接受安全更新  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 2]  
12.只安装数据库软件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 3]  
13.非集群模式，默认下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 4]  
14.默认下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 5]  
15.默认企业版，下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 6]  
16.这里显示的是刚才设置的目录，点击下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 7]  
17.默认下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 8]  
18.默认下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 9]  
19.如果提示系统参数问题，点击fix&Check Again  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 10]  
按照提示执行脚本  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 11]  
20.检查下插件是否安装上了  
对于pdksh不用管，只需要安装行ksh就可以了  
21.检查无问题执行忽略，进行下一步安装  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 12]  
报错一：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 13]  
解决方法：  
1.确认电脑上又没有安装 glibc-static软件，没有则安装上  
rpm -qa|grep glibc-static  
2.编辑/data/oracle/product/11.2.0/db\_1/ctx/lib/ins\_ctx.mk文件，在如下位置添加红色方框标记部分，然后点击retry  
![在这里插入图片描述][20191121202058249.png]  
报错二  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 14]  
解决方法：编辑/data/oracle/product/11.2.0/db\_1/sysman/lib/ins\_emagent.mk文件  
添加如下红色方框标识的部分，然后点击retry  
![在这里插入图片描述][20191121203251378.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 15]  
按照要求执行上面的脚本  
执行完后，数据库软件就安装完了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 16]  
数据软件安装完后还需要安装监听和实例，然后数据库才可以使用。

[selinux]: https://img-blog.csdnimg.cn/20191118200040805.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191118205039819.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191118205120649.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[20191118205415135.png]: https://img-blog.csdnimg.cn/20191118205415135.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191118205742591.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191118205830342.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191118205942487.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20191118210034687.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20191118210112151.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20191118210154119.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20191118210230922.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20191118210311748.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20191118211707373.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/20191118211852479.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20191118214433601.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20191120220044799.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[20191121202058249.png]: https://img-blog.csdnimg.cn/20191121202058249.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20191121202324887.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[20191121203251378.png]: https://img-blog.csdnimg.cn/20191121203251378.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/20191121204121897.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/20191121204309961.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1MTExMWh1YW4=,size_16,color_FFFFFF,t_70