z-notes

ORACLE LINUX 7.7 安装 ORACLE-19C

1.项目需求

某业务系统最近上线，需要快速搭建一套ORACLE19C数据库环境用于前期测试。

要求：
操作系统：ORACLE LINUX 7.7 X86_64
数据库版本：ORACLE19C版本+传统架构
创建数据库：ITPUXDB
字符集：ZHS16GBK
数据块大小：8K

1.下载ORACLE-19C的RPM包

ORACLE-19C下载地址：

#哪个网址可以用哪个
ORACLE-19C下载地址：
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c
https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

ORACLE-12C下载地址（不用于这个项目）：
https://www.oracle.com/technetwork/cn/database/bi-datawarehousing/downloads/index.html

2.配置hosts,关闭防火墙,selinux

echo "192.168.248.52 fgedu52" >> /etc/hosts
systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld

vim /etc/selinux/config
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:

3.配置yum环境

mkdir /mnt/linux
mount /dev/cdrom /mnt/linux
cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/
echo "[EL]" >> /etc/yum.repos.d/itpux.repo
echo "name=Linux 7.x DVD" >> /etc/yum.repos.d/itpux.repo
echo "baseurl=file:///mnt/linux" >> /etc/yum.repos.d/itpux.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/itpux.repo
echo "enabled=1" >> /etc/yum.repos.d/itpux.repo
cat /etc/yum.repos.d/itpux.repo

4.安装ORACLE-19c

#准备安装目录

mkdir /opt/oracle

#准备预先安装的包

#下载preinstall包
/cd /mnt/hgfs/oracle soft
wget http://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

#安装preinstall包
rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

#根据提示安装依赖
yum install -y ksh libaio-devel

#oracle Database 19c的preinstall包（通常称为Oracle-database-preinstall-19c）的主要作用是为安装Oracle Database 19c做准备工作，确保所有必要的依赖项和配置已经就绪，从而简化安装过程并减少安装过程中可能出现的问题‌。

#创建用户和组
groupadd oinstall
useradd oracle
passwd oracle
P@ssword

#授权
chown -R oracle:oinstall /opt/oracle
chmod -R 775 /opt/oracle

#安装
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm

#复制专用得配置的文件
cd /etc/sysconfig/
cp oracledb_ORCLCDB-19c.conf oracledb_itpuxdb-19c.conf

#查看配置文件
more oracledb_itpuxdb-19c.conf 

#This is a configuration file to setup the Oracle Database. 
#It is used when running '/etc/init.d/oracledb_ORCLCDB configure'.
#Please use this file to modify the default listener port and the
#Oracle data location.

# LISTENER_PORT: Database listener
LISTENER_PORT=1521               #监听端口

# ORACLE_DATA_LOCATION: Database oradata location
ORACLE_DATA_LOCATION=/opt/oracle/oradata   #安装目录

# EM_EXPRESS_PORT: Oracle EM Express listener
EM_EXPRESS_PORT=5500                #EM管理器的端口

#修改启动文件
cd /etc/init.d/
cp oracledb_ORCLCDB-19c oracledb_itpuxdb-19c 

vim oracledb_itpuxdb-19c
:%s/ORCLCDB/itpuxdb/g
:%s/ORCLPDB1/itpuxdb/g
29 export CHARSET=ZHS16GBK
33 export CREATE_AS_CDB=false

#创建数据库
/etc/init.d/oracledb_itpuxdb-19c configure
#创建完成后的信息
全局数据库名:itpuxdb
系统标识符 (SID):itpuxdb

#查看数据库实例
ps -ef | grep smon
oracle   11416     1  0 16:36 ?        00:00:00 ora_smon_itpuxdb

#配置环境变量
su - oracle
echo "export LANG=en_US" >> ~/.bash_profile
echo "export ORACLE_BASE=/opt/oracle" >> ~/.bash_profile
echo "export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1" >> ~/.bash_profile
echo "export ORACLE_UNQNAME=itpuxdb" >> ~/.bash_profile
echo "export ORACLE_SID=itpuxdb" >> ~/.bash_profile
echo "export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG" >> ~/.bash_profile
echo "export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin" >> ~/.bash_profile
source ~/.bash_profile
env |grep ORACLE

#关于oracle的启停
/etc/init.d/oracledb_itpuxdb-19c
Usage: /etc/init.d/oracledb_itpuxdb-19c {start|stop|restart|configure|delete}

#启动之后可以查看监听状态
su - oracle
lsnrctl status

#进入oralce查看是否能正常运行
su - oracle
sqlplus "/as sysdba"
select instance_name,status from v$instance;