oracle12c安装文档

官方文档
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/managing-a-multitenant-environment.html#GUID-93F1E584-D309-4301-82E0-AD0E60D4977C

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ladbi/installing-the-oracle-preinstallation-rpm-with-uln-support.html#GUID-AF94713E-97AF-4F20-8DBC-36BC383D0301

wget http://yum.oracle.com/public-yum-ol7.repo

wget http://yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

yum install oracle-database-server-12cR2-preinstall.x86_64 --nogpgcheck

https://www.howtoforge.com/tutorial/how-to-install-oracle-database-12c-on-centos-7/
[root&＃64;bogon ~]# systemctl stop firewalld
[root&＃64;bogon ~]# systemctl disable firewalld
[root&＃64;bogon ~]# systemctl status firewalld

[root&＃64;linux01 ~]#vi /etc/selinux/config   #This file controls the state of SELinux on the system.
# SELINUX&＃61; can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX&＃61;disabled
# SELINUXTYPE&＃61; can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.

12c安装

1. 
yum -y install binutils elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c&＃43;&＃43; glibc glibc-common glibc-devel kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc&＃43;&＃43; libstdc&＃43;&＃43;-devel make numactl-devel sysstat unixODBC unixODBC-devel pdksh compat-libcap1 libXext* libXtst* libX11* libXau* libxcb* libXi* nscd* libXp*  xorg*  xterm*  unzip* readline* compat*

yum install libXext.i686 -y 

yum install zlib-devel.i686 -y
2. 创建必要?户&＃xff1a;
groupadd -g 54321 oinstall 
groupadd -g 54322 dba 
groupadd -g 54323 oper 
useradd -u 54321 -g oinstall -G dba,oper oracle
3.修改密码
passwd  oracle
4.关闭防?墙
[root&＃64;bogon ~]# systemctl stop firewalld
[root&＃64;bogon ~]# systemctl disable firewalld
[root&＃64;bogon ~]# systemctl status firewalld
5.创建?录
mkdir -p /u01/app/oracle/product/12.2.0.1/db_1 
chown -R oracle:oinstall /u01 
chmod -R 775 /u01
6. oracle 用户下
编辑环境变量
[oracle&＃64;localhost ~]$ vi .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH&＃61;$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export TMP&＃61;/tmp
export TMPDIR&＃61;\$TMP
export ORACLE_HOSTNAME&＃61;vdedu   
export ORACLE_UNQNAME&＃61;cdb1
export ORACLE_BASE&＃61;/u01/app/oracle
export ORACLE_HOME&＃61;$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID&＃61;vdedu
export PATH&＃61;/usr/sbin:/usr/local/bin:$PATH
export PATH&＃61;$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH&＃61;\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH&＃61;\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
export NLS_LANG&＃61;AMERICAN_AMERICA.ZHS16GBK

root用户
7. 编辑/etc/hosts [root&＃64;bogon ~]# vi /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.80.157 vdedu
~
8. 下载oracle12c安装包
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html?ssSourceSiteId&＃61;otncn
传到虚拟机/u01  下
9. oracle用户下解压 linuxx64_12201_database.zip
[oracle&＃64;localhost u01]$ unzip linuxx64_12201_database.zip
10.准备安装   
su - oracle
export DISPLAY&＃61;:0.0
xhost &＃43; 
11.   [oracle&＃64;localhost database]$ cd /u01/database
[oracle&＃64;localhost database]$ ./runInstaller
12.   配置监听netca
13.  dbca 创建数据库

cd $ORACLE_HOME/network/admin

cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER &＃61;
  (DESCRIPTION_LIST &＃61;
    (DESCRIPTION &＃61;
      (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; vdedu)(PORT &＃61; 1521))
      (ADDRESS &＃61; (PROTOCOL &＃61; IPC)(KEY &＃61; EXTPROC1521))
    )
  )

cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_VDEDU &＃61;
  (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; vdedu)(PORT &＃61; 1521))

VDEDU &＃61;
  (DESCRIPTION &＃61;
    (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; vdedu)(PORT &＃61; 1521))
    (CONNECT_DATA &＃61;
      (SERVER &＃61; DEDICATED)
      (SERVICE_NAME &＃61; vdedu)
    )
  )

PDB &＃61;
  (DESCRIPTION &＃61;
    (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; vdedu)(PORT &＃61; 1521))
    (CONNECT_DATA &＃61;
      (SERVER &＃61; DEDICATED)
      (SERVICE_NAME &＃61; vdedu)
    )
  )

show con_name;查看当前
show pdbs; 容器个数
desc v$containers;
启动PDB
alter pluggable database  pdb open;
alter pluggable database  pdb close immediate;
进入pdb
alter session set container&＃61;pdb;
sqlplus sys/oracle&＃64;PDB as sysdba;
cdb/ 下只能创建comm user
create user c##us identified by oracle;
pdb  普通用户 
create user n identified by o;
监听注册
conn / as sysdba
show parameter common_
alter  system set loca_listener&＃61;&＃39; &＃39;;
创建表空间
select file_name, tablespace_name from dba_data_files; 
create tablespace tbs01 datafile &＃39;/u01/....../tabs0101.dbf&＃39;  size 10M autoextend on extent management local autoallocate;
create tablespace temp tempfile &＃39;/u01/app/oracle/oradata/VDEDU/temp01.dbf&＃39; size 100m autoextend on;
create tablespace add tempfile &＃39;<路径和文件名>&＃39; size <文件名> [autoextend on];