RHEL7.5oracle12c单机安装

环境:

RHEL7.5

IP地址: 192.168.95.200/24 网络设置host-only

使用Xshell或Putty、SecureCRT等软件远程连接到RHEL7.5的服务器上.

1) 修改hosts file文件

[root@12c ~]# hostnamectl

Static hostname: 12c.oracle.com

[root@12c ~]# ip addr show ens33

2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000

link/ether 00:0c:29:1b:8d:48 brd ff:ff:ff:ff:ff:ff

inet 192.168.95.200/24

[root@12c ~]# vim /etc/hosts

192.168.95.200 12c.oracle.com 12c ###添加记录

为了后面使用yum安装对应软件包,在本地做一个yum仓库

创建挂载点

[root@12c ~]# mkdir /mnt/rhel7

[root@12c ~]# vim /etc/fstab

/dev/cdrom /mnt/rhel7 iso9660 defaults 0 0

[root@12c ~]# vim /etc/yum.repos.d/rhel7.repo

[RHEL7_Repos]

name=RHEL7

baseurl=file:///mnt/rhel7

enabled=1

gpgcheck=0

[root@12c ~]# yum clean all

[root@12c ~]# yum repolist all

[root@12c ~]# yum makecache

2) manual Setup

[root@12c ~]# vim /etc/sysctl.d/12c-oracle.conf

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

[root@12c ~]# /sbin/sysctl -p

[root@12c ~]# vim /etc/security/limits.d/12c-oracle.conf

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

oracle hard memlock 134217728

oracle soft memlock 134217728

3) 使用yum安装需要的软件包

4) 创建组用户等信息

[root@12c ~]# groupadd -g 54321 oinstall

[root@12c ~]# groupadd -g 54322 dba

[root@12c ~]# groupadd -g 54323 oper

[root@12c ~]# useradd -u 54321 -g oinstall -G dba,oper oracle

[root@12c ~]# echo "oracle" | passwd --stdin oracle

[root@12c ~]# grep oracle /etc/passwd

oracle:x:54321:54321::/home/oracle:/bin/bash

5) 设置SELinux 防火墙

[root@12c ~]# setenforce 0

[root@12c ~]# vim /etc/selinux/config

#SELINUX=enforcing

SELINUX=permissive

[root@12c ~]# systemctl is-active firewalld.service

[root@12c ~]# systemctl stop firewalld.service

[root@12c ~]# systemctl disable firewalld.service

active

7) 使用oracle上传的Oracle软件包并解压

[root@12c ~]# su - oracle

使用xshell自带的zmoden上传软件包到RHEL7.5的oracle用户的目录下

[oracle@12c ~]$ unzip linuxx64_12201_database.zip

8) 使用oracle修改.bash_profile文件

[oracle@12c ~]$ ll /home/oracle/.bash_profile

-rw-r--r--. 1 oracle oinstall 193 Sep 26 2017 /home/oracle/.bash_profile

[oracle@12c ~]$ vim /home/oracle/.bash_profile

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1

PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin

[oracle@12c ~]$ source /home/oracle/.bash_profile

[oracle@12c ~]$ echo $ORACLE_SID

orcl

[oracle@12c ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/12.2.0.1/db_1

9) 使用Oracle用户 OUI方式

[oracle@12c ~]$cd database

[oracle@12c database]$ ./runInstaller

[oracle@12c orcl]$ which sqlplus

/u01/app/oracle/product/12.2.0.1/db_1/bin/sqlplus

[oracle@12c orcl]$ sqlplus / as sysdba

SQL Developer、Sqlplus 、plsql developer、toad等等

需要启动实例

SQL> startup

查看Oracle的监听命令

[oracle@12c sqldeveloper]$ which lsnrctl

/u01/app/oracle/product/12.2.0.1/db_1/bin/lsnrctl

[oracle@12c sqldeveloper]$ lsnrctl status

[oracle@12c db_1]$ cd $ORACLE_HOME/network/admin

[oracle@12c admin]$ pwd

/u01/app/oracle/product/12.2.0.1/db_1/network/admin

[oracle@12c admin]$ ls

listener.ora samples shrept.lst sqlnet.ora tnsnames.ora

[oracle@12c admin]$ lsnrctl start

[oracle@12c admin]$ lsnrctl status

[oracle@12c admin]$ sqlplus / as sysdba

SQL> shutdown immediate;

SQL> startup

[oracle@12c admin]$ echo $ORACLE_SID

orcl

Human Resource (HR) Schema

user and schema

SQL> desc dba_users

解决Oracle目前环境不支持上下方向键

使用root用户

[root@12c ~]# ls rlwrap-0.41.tar.gz

rlwrap-0.41.tar.gz

[root@12c ~]# file rlwrap-0.41.tar.gz

rlwrap-0.41.tar.gz: gzip compressed data, from Unix, last modified: Mon May 19 02:46:08 2014, max compression

[root@12c ~]# tar xvf rlwrap-0.41.tar.gz

[root@12c ~]# cd rlwrap-0.41/

[root@12c rlwrap-0.41]# ./configure

[root@12c rlwrap-0.41]# make && make install

SQL> col username format a10

SQL> col account_status format a20

SQL> ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY hr;

做一个决定，并不难，难的是付诸行动，并且坚持到底。