文章目录
建用户,组,目录,权限
创建用户和组
有两个组,oinstall是主组,dba是附组
[root@test ~]# groupadd oinstall [root@test ~]# groupadd dba [root@test ~]# useradd oracle -g oinstall -G dba [root@test ~]# passwd oracle Changing password for user oracle. New password: oracle BAD PASSWORD: The password is shorter than 8 characters Retype new password: oracle passwd: all authentication tokens updated successfully.
创建oracle安装目录
[root@test ~]# mkdir -p /u01/oracle
[root@test ~]# chown -R oracle:oinstall /u01
[root@test ~]# chmod -R 775 /u01/oracle
设置系统参数
[root@test ~]# vi /etc/sysctl.conf
文件中加入下列行
multi-user.target
systemctl set-default graphical.target
systemctl set-default multi-user.target
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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
运行下列命令使修改的核心参数立即生效
[root@test ~]# sysctl -p
设置Shell Limits(系统资源限制),提高软件的运行效率
[root@test ~]# vi /etc/security/limits.conf
文件中加入下列
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
在/etc/pam.d/login文件中加入下列行,如果里面没有的话
[root@test ~]# vi /etc/pam.d/login
session required /lib/security/pam_limits.so
session required pam_limits.so
在/etc/profile后加入以下语句
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
在/home/oracle/.bash_profile中删掉原来的最下面三行,然后加添下面的oracle环境变量
# add for oracle11g
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=prod
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
NLS_LANG="simplified chinese"_china.AL32UTF8
export NLS_LANG
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF'
export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
使用yum工具安装需要的包,按照联机文档要求去检查
rpm -qa binutils
rpm -qa compat-libstdc
rpm -qa elfutils-libelf
rpm -qa elfutils-libelf-devel
rpm -qa elfutils-libelf-devel-static
rpm -qa glibc-common
rpm -qa glibc-devel
rpm -qa glibc-headers
rpm -qa gcc*
rpm -qa kernel-headers
rpm -qa ksh
rpm -qa libaio-devel
rpm -qa libgcc
rpm -qa libgomp
rpm -qa libstdc++
rpm -qa libstdc++-devel
rpm -qa make
rpm -qa sysstat
上传Oracle安装介质
[root@test ~]# mkdir /soft
[root@test soft]# ll
total 2487320
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_1of7.zip
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_2of7.zip
[root@test soft]# rpm -ivh rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# ll -a
total 2487320
drwxr-xr-x 3 root root 164 Mar 10 12:37 .
dr-xr-xr-x. 19 root root 247 Mar 10 12:25 ..
drwxr-xr-x 7 root root 136 Aug 27 2013 database
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
安装Oracle软件
将运行模式改为图像化界面
[root@test database]# su - oracle
上一次登录:三 3月 11 14:06:47 CST 2020pts/1 上
[oracle@test ~]$ vncserver
[root@test ~]# vi /etc/sysctl.conf 文件中加入下列行 multi-user.target systemctl set-default graphical.target systemctl set-default multi-user.target fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 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 运行下列命令使修改的核心参数立即生效 [root@test ~]# sysctl -p
设置Shell Limits(系统资源限制),提高软件的运行效率
[root@test ~]# vi /etc/security/limits.conf
文件中加入下列
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
在/etc/pam.d/login文件中加入下列行,如果里面没有的话
[root@test ~]# vi /etc/pam.d/login
session required /lib/security/pam_limits.so
session required pam_limits.so
在/etc/profile后加入以下语句
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
在/home/oracle/.bash_profile中删掉原来的最下面三行,然后加添下面的oracle环境变量
# add for oracle11g
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=prod
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
NLS_LANG="simplified chinese"_china.AL32UTF8
export NLS_LANG
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF'
export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
使用yum工具安装需要的包,按照联机文档要求去检查
rpm -qa binutils
rpm -qa compat-libstdc
rpm -qa elfutils-libelf
rpm -qa elfutils-libelf-devel
rpm -qa elfutils-libelf-devel-static
rpm -qa glibc-common
rpm -qa glibc-devel
rpm -qa glibc-headers
rpm -qa gcc*
rpm -qa kernel-headers
rpm -qa ksh
rpm -qa libaio-devel
rpm -qa libgcc
rpm -qa libgomp
rpm -qa libstdc++
rpm -qa libstdc++-devel
rpm -qa make
rpm -qa sysstat
上传Oracle安装介质
[root@test ~]# mkdir /soft
[root@test soft]# ll
total 2487320
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_1of7.zip
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_2of7.zip
[root@test soft]# rpm -ivh rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# ll -a
total 2487320
drwxr-xr-x 3 root root 164 Mar 10 12:37 .
dr-xr-xr-x. 19 root root 247 Mar 10 12:25 ..
drwxr-xr-x 7 root root 136 Aug 27 2013 database
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
安装Oracle软件
将运行模式改为图像化界面
[root@test database]# su - oracle
上一次登录:三 3月 11 14:06:47 CST 2020pts/1 上
[oracle@test ~]$ vncserver
[root@test ~]# vi /etc/pam.d/login session required /lib/security/pam_limits.so session required pam_limits.so
在/etc/profile后加入以下语句
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
在/home/oracle/.bash_profile中删掉原来的最下面三行,然后加添下面的oracle环境变量
# add for oracle11g
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=prod
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
NLS_LANG="simplified chinese"_china.AL32UTF8
export NLS_LANG
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF'
export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
使用yum工具安装需要的包,按照联机文档要求去检查
rpm -qa binutils
rpm -qa compat-libstdc
rpm -qa elfutils-libelf
rpm -qa elfutils-libelf-devel
rpm -qa elfutils-libelf-devel-static
rpm -qa glibc-common
rpm -qa glibc-devel
rpm -qa glibc-headers
rpm -qa gcc*
rpm -qa kernel-headers
rpm -qa ksh
rpm -qa libaio-devel
rpm -qa libgcc
rpm -qa libgomp
rpm -qa libstdc++
rpm -qa libstdc++-devel
rpm -qa make
rpm -qa sysstat
上传Oracle安装介质
[root@test ~]# mkdir /soft
[root@test soft]# ll
total 2487320
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_1of7.zip
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_2of7.zip
[root@test soft]# rpm -ivh rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# ll -a
total 2487320
drwxr-xr-x 3 root root 164 Mar 10 12:37 .
dr-xr-xr-x. 19 root root 247 Mar 10 12:25 ..
drwxr-xr-x 7 root root 136 Aug 27 2013 database
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
安装Oracle软件
将运行模式改为图像化界面
[root@test database]# su - oracle
上一次登录:三 3月 11 14:06:47 CST 2020pts/1 上
[oracle@test ~]$ vncserver
# add for oracle11g ORACLE_BASE=/u01 ORACLE_HOME=$ORACLE_BASE/oracle ORACLE_SID=prod PATH=$ORACLE_HOME/bin:$PATH export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' NLS_LANG="simplified chinese"_china.AL32UTF8 export NLS_LANG export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF' export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
使用yum工具安装需要的包,按照联机文档要求去检查
rpm -qa binutils
rpm -qa compat-libstdc
rpm -qa elfutils-libelf
rpm -qa elfutils-libelf-devel
rpm -qa elfutils-libelf-devel-static
rpm -qa glibc-common
rpm -qa glibc-devel
rpm -qa glibc-headers
rpm -qa gcc*
rpm -qa kernel-headers
rpm -qa ksh
rpm -qa libaio-devel
rpm -qa libgcc
rpm -qa libgomp
rpm -qa libstdc++
rpm -qa libstdc++-devel
rpm -qa make
rpm -qa sysstat
上传Oracle安装介质
[root@test ~]# mkdir /soft
[root@test soft]# ll
total 2487320
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_1of7.zip
[root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_2of7.zip
[root@test soft]# rpm -ivh rlwrap-0.43-2.el7.x86_64.rpm
[root@test soft]# ll -a
total 2487320
drwxr-xr-x 3 root root 164 Mar 10 12:37 .
dr-xr-xr-x. 19 root root 247 Mar 10 12:25 ..
drwxr-xr-x 7 root root 136 Aug 27 2013 database
-rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
安装Oracle软件
将运行模式改为图像化界面
[root@test database]# su - oracle
上一次登录:三 3月 11 14:06:47 CST 2020pts/1 上
[oracle@test ~]$ vncserver
[root@test ~]# mkdir /soft [root@test soft]# ll total 2487320 -rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip -rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip -rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm [root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_1of7.zip [root@test soft]# unzip oracle.p13390677_112040_Linux-x86-64_2of7.zip [root@test soft]# rpm -ivh rlwrap-0.43-2.el7.x86_64.rpm [root@test soft]# ll -a total 2487320 drwxr-xr-x 3 root root 164 Mar 10 12:37 . dr-xr-xr-x. 19 root root 247 Mar 10 12:25 .. drwxr-xr-x 7 root root 136 Aug 27 2013 database -rw-r--r-- 1 root root 1395582860 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_1of7.zip -rw-r--r-- 1 root root 1151304589 Mar 10 12:36 oracle.p13390677_112040_Linux-x86-64_2of7.zip -rw-r--r-- 1 root root 121910 Mar 10 12:36 rlwrap-0.43-2.el7.x86_64.rpm
安装Oracle软件
将运行模式改为图像化界面
[root@test database]# su - oracle
上一次登录:三 3月 11 14:06:47 CST 2020pts/1 上
[oracle@test ~]$ vncserver
[root@test database]# su - oracle 上一次登录:三 3月 11 14:06:47 CST 2020pts/1 上 [oracle@test ~]$ vncserver
./runInstaller -jreLoc /etc/alternatives/jre_1.8.0
如图取消订阅,接下来会有提示框,点yes
取消升级,下一步
选择只安装database
安装单实例
第一个企业版安装,下一步
显示的路径应该与配置好的环境变量一样不能直接建在oracle下
我在这里不可以next,必须安装pdksh,但是pdksh又有依赖,所以我强制安装
[root@test ~]# rpm -ivh pdksh-5.2.14-30.x86_64.rpm 警告:pdksh-5.2.14-30.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 73307de6: NOKEY 错误:依赖检测失败: pdksh 与 (已安裝) ksh-20120801-140.el7_7.x86_64 冲突 [root@test ~]# rpm -e ksh-20120801 [root@test ~]# rpm -i --force --nodeps pdksh-5.2.14-30.x86_64.rpm 警告:pdksh-5.2.14-30.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 73307de6: NOKEY [root@test ~]#
按顺序用root用户执行两个脚本,点ok