1.下载介质
数据库链接:https://pan.baidu.com/s/1RAbcipAiiWGDdDcCNAIjfw
提取码:9nzy
系统链接:https://pan.baidu.com/s/1uMudv5ghT1KdDB-0xpM3fQ
提取码:72i2
rpm链接:https://pan.baidu.com/s/1GgwXbGtoqTkhBocPru1cfA
提取码:5wxp
客户端链接:https://pan.baidu.com/s/1-KVEk0Ee6yQ0lXRfSLryWA
提取码:6np2
2.虚拟机安装(内存8G以上)
2.1 选择英文
2.2 时间和日期,设置成上海,语言支持选择中文--中文简体
2.3 INSTALLATION SOURCE 选择下图的"Auto-detected installation media"
2.4 SOFTWARE SELECTION 按照下图选择“Server with GUI” 勾选图中的8个选项
选择minimal安装的需要手动安装
yum -y groupinstall "Server with GUI"
yum -y groupinstall "Compatibility Libraries"
yum -y groupinstall "Development Tools"
yum -y groupinstall "Security Tools"
yum -y groupinstall "Smart Card Support"
2.5 INSTALLATION DESTINATION选择创建自定义分区(swap跟内存保持一致)
2.6 SECURITY POLICY 选择OFF,KDUMP选择不启用
3.配置本地yum源
3.1 创建挂载目录
mkdir -p /media/cdrom
3.2 上传rhel-server-7.6-x86_64-dvd.iso到opt目录下
3.3 挂载对应系统版本的iso光盘镜像文件
mount -o loop -t iso9660 /opt/rhel-server-7.6-x86_64-dvd.iso /media/cdrom
3.4 配置yum文件如下
vi /etc/yum.repos.d/rhel-source.repo
[ISO]
name=iso
baseurl=file:///media/cdrom/
enabled=1
gpgcheck=0
4.安装需要的软件包
yum install -y binutils.x86_64 compat-libcap1.x86_64 compat-libstdc++-33.i686 compat-libstdc++-33.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.x86_64 glibc.i686 glibc-devel.x86_64 glibc-devel.i686 ksh.x86_64 libgcc.x86_64 libgcc.i686 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libaio.x86_64 libaio.i686 libaio-devel.i686 libaio-devel.x86_64 libXext.x86_64 libXext.i686 libXtst.x86_64 libXtst.i686 libX11.x86_64 libX11.i686 libXau.x86_64 libXau.i686 libxcb.x86_64 libxcb.i686 libXi.x86_64 libXi.i686 make.x86_64 sysstat.x86_64 vnc vnc-server xdpyinfo xorg-x11-xauth xorg-x11-fonts-* xorg-x11-font-utils xorg-x11-fonts-Type1 xclock
将compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm上传至/media/cdrom/Packages目录下并安装
cd /media/cdrom/Packages && rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
5.调整系统参数
systemctl stop firewalld
systemctl disable firewalld
设置selinux为disabled
vi /etc/sysctl.conf
# Oracle database 12c
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 6442450944
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
kernel.panic_on_oops = 1
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 = 1048586
vi /etc/security/limits.conf
# Oracle database 12c
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
vi /etc/pam.d/login
# Oracle database 12c
session required pam_limits.so
重启生效
6.创建oracle安装目录并重新挂载最大磁盘
mkdir -p /u01/app/
umount -l /home
mount /dev/mapper/rhel-home /u01/app/
修改开机自挂载目录
vi /etc/fstab
7.创建oracle用户并赋予权限
groupadd -g 501 oinstall
groupadd -g 502 dba
useradd -u 502 -g oinstall -G dba oracle
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app
8.上传oracle压缩包到/u01/目录下
9.oracle用户环境变量
oracle 用户下vi编辑vi ~/.bash_profile
,添加以下内容:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export ORACLE_SID=oemrepo
export PATH=$ORACLE_HOME/bin:$PATH
10.解压软件并使用xshell调用图形安装软件(用oracle用户单独打开,不要切换用户)
cd /u01/app/
unzip /u01/linuxamd64_12102_database_1of2.zip && unzip /u01/linuxamd64_12102_database_2of2.zip
运行runInstaller
[oracle@OMR ~]$ cd /u01/app/database/
[oracle@OMR database]$ ls
install response rpm runInstaller sshsetup stage welcome.html
[oracle@OMR database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 24063 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2015 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
选择只安装软件:
确认最终安装信息无误:
按要求root用户执行脚本:
完成安装:
至此,Oracle 12.1.0.2 软件的安装已经完成
11.开启监听服务
netca
lsnrctl start
12.创建数据库
dbca
解锁SCOTT用户,设置新密码
重启reboot
13.启动数据库
cp /u01/app/oracle/admin/orcl/pfile/init.ora.1125202111612 /u01/app/oracle/product/12.1.0/dbhome_1/dbs/initoemrepo.ora
sqlplus /nolog
connect /as sysdba
startup
14.客户端连接
navicat 连接
配置工具-选项-OCI环境
PLSQL连接
配置会话-首选项-oracle
C:\Download\PLSQL Developer-64\instantclient_12_2
C:\Download\PLSQL Developer-64\instantclient_12_2\oci.dll