Centos 7.4 安装Oracle 12c
Oracle 12c下载地址： https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
1.检查先决条件
[root@k8s03 ~]# cat /proc/version
Linux version 3.10.0-693.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC) ) #1 SMP Tue Aug 22 21:09:27 UTC 2017
[root@k8s03 ~]# uname -r
3.10.0-693.el7.x86_64
[root@k8s03 ~]# free -m
total used free shared buff/cache available
Mem: 2831 419 1994 8 417 2214
Swap: 0 0 0
[root@k8s03 ~]# grep -i selinux= /etc/sysconfig/selinux
# SELINUX= can take one of these three values:
SELINUX=disabled
[root@k8s03 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
[root@k8s03 ~]# ping baidu.com
PING baidu.com (220.181.38.148) 56(84) bytes of data.
64 bytes from 220.181.38.148 (220.181.38.148): icmp_seq=1 ttl=128 time=24.7 ms
64 bytes from 220.181.38.148 (220.181.38.148): icmp_seq=2 ttl=128 time=26.5 ms
^C
--- baidu.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1000ms
rtt min/avg/max/mdev = 24.725/25.624/26.524/0.913 ms
[root@k8s03 ~]#
2.安装依赖包
[root@k8s03 ~]# yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 elfutils-libelf-devel gcc gcc-c++ glibc*.i686 glibc glibc-devel glibc-devel*.i686 ksh libgcc*.i686 libgcc libstdc++ libstdc++*.i686 libstdc++
-devel libstdc++-devel*.i686 libaio libaio*.i686 libaio-devel libaio-devel*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686 libXp xhost unzip zip libXtst libXp*.i686 libXt*.i686 xterm xdpyinfo smartmontools-* readline-devel*
[root@k8s03 ~]#
3.修改内核参数
[root@k8s03 ~]# vim /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.file-max = 6815744
fs.aio-max-nr = 1048576
[root@k8s03 ~]# sysctl -p
[root@k8s03 ~]# 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
oracle hard stack 10240
[root@k8s03 ~]# vim /etc/pam.d/login
session required pam_limits.so
[root@k8s03 ~]#
4.创建用户和添加环境变量
[root@k8s03 ~]# groupadd oinstall
[root@k8s03 ~]# groupadd dba
[root@k8s03 ~]# useradd -g oinstall -G dba oracle
[root@k8s03 ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password fails the dictionary check - it is based on a dictionary word
Retype new password:
passwd: all authentication tokens updated successfully.
[root@k8s03 ~]# mkdir /u01/app/oracle/product/11.2.0.1/db_1 -p
[root@k8s03 ~]# chown -R oracle:oinstall /u01/
[root@k8s03 ~]# vim /etc/profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.1/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
[root@k8s03 ~]# . /etc/profile
5.在windows机器安装Xmanager - Passive（图形化界面）
6.在linux使用Xmanager - Passive图形化界面[root@k8s03 ~]# xhost +
xhost: unable to open display ""
[root@k8s03 ~]# su - oracle
[oracle@k8s03 ~]$ export DISPLAY=windows机器IP地址:0.0
[oracle@k8s03 ~]$ unzip linuxx64_12201_database.zip
[oracle@k8s03 ~]$ cd database/
[oracle@k8s03 database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 18045 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3071 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-11-30_04-09-35PM. Please wait ...[oracle@k8s03 database]$
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@k8s03 ~]# sh /u01/app/oracle/product/11.2.0.1/db_1/root.sh
Performing root user operation. The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.1/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] : Oracle Trace File Analyzer (TFA - User Mode) is available at :
/u01/app/oracle/product/11.2.0.1/db_1/suptools/tfa/release/tfa_home/bin/tfactl OR Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script :
/u01/app/oracle/product/11.2.0.1/db_1/suptools/tfa/release/tfa_home/install/roottfa.sh [root@k8s03 ~]#
7.下载安装rlwrap历史记录工具
[root@k8s03 ~]# wget https://github.com/hanslub42/rlwrap/releases/download/v0.43/rlwrap-0.43.tar.gz
[root@k8s03 ~]# tar xvf rlwrap-0.43.tar.gz
[root@k8s03 ~]# cd rlwrap-0.43
[root@k8s03 rlwrap-0.43]# ./configure
[root@k8s03 rlwrap-0.43]# make check
[root@k8s03 rlwrap-0.43]# make install
[root@k8s03 rlwrap-0.43]# vim /home/oracle/.bash_profile
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman
[root@k8s03 rlwrap-0.43]# su - oracle
Last login: Sat Nov 30 16:07:06 CST 2019 on pts/0
[oracle@k8s03 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 1 14:37:18 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from dual;
D
-
X
SQL> select * from dual; --按向上方向键就可以看到历史命令
8.开机自启动
[root@k8s03 ~]$ vim /etc/oratab
orcl:/u01/app/oracle/product/11.2.0.1/db_1:Y --最后的N改写Y
[root@k8s03 ~]# chmod 755 /etc/rc.d/rc.local
[root@k8s03 ~]$ vim /etc/rc.d/rc.local
su oracle -lc "/u01/app/oracle/product/11.2.0.1/db_1/bin/lsnrctl start"
su oracle -lc /u01/app/oracle/product/11.2.0.1/db_1/bin/dbstart
[root@k8s03 ~]# reboot
