Oracle 19C部署(不推荐生产使用)

Oracle 19C部署

1、下载地址

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html 下载oracle-database-ee-19c-1.0-1.x86_64.rpm

2、preinstall下载

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html 下载oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm

3、准备工作

# 创建安装目录
mkdir -p /opt/oracle

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

# 查看是否安装成功
id oracle

# 设置密码
passwd oracle

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

4、安装

# 安装Oralce 19C，时间比较久
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm

# 配置自己的实例
cd /etc/sysconfig/
cp oracledb_ORCLCDB-19c.conf oracledb_实例名称-19c.conf
cd /etc/init.d/
cp oracledb_ORCLCDB-19c oracledb_实例名称-19c

# 修改初始化实例文件
vi oracledb_实例名称-19c

%s/ORCLCDB/实例名称/g
%s/ORCLPDB1/实例名称pdb/g
%s/AL32UTF8/ZHS16GBK/g
%s/=true/=false/g

# 初始化安装，时间比较久
/etc/init.d/oracledb_实例名称-19c configure

# 查看是否启动成功
ps -ef | grep smon

5、配置环境变量

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=实例名称" >> ~/.bash_profile
echo "export ORACLE_SID=实例名称" >> ~/.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

6、创建表空间和用户，并授予用户权限

# 登录dba账号
sqlplus "/as sysdba"

# 设置表空间大小
create tablespace GRP logging datafile '/opt/oracle/oradata/实例名称/grp.dbf' size 100m autoextend on next 100m maxsize unlimited extent management local;

# 创建用户
create user youname identified by youpassword;

# 授权
grant dba,connect,resource,create view to youname;
grant create session to youname;
grant select any table to youname;
grant update any table to youname;
grant insert any table to youname;
grant delete any table to youname;

7、Oracle常用命令

# 启动Oracle
/etc/init.d/oracledb_qfeng-19c start

# 启动数据库，启动监听
sqlplus "/as sysdba"
startup;
exit;
lsnrctl start

# 停止数据库，停止监听
sqlplus "/as sysdba"
shutdown immediate;
exit;
lsnrctl stop

8、日志路径

/opt/oracle/cfgtoollogs/dbca/kuantuo/实例名称.log

9、数据库卸载

su - oracle
cd $ORACLE_HOME/bin
./dbca
cd $ORACLE_HOME/bin
./netca

10、plsql下载地址

https://www.allroundautomations.com/

instantclient：https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html