Linux安装Oracle 19c

Linux安装Oracle 19c

概述

一、准备工作

1、关闭系统防火墙

systemctl stop firewalld
syustemctl disable firewalld
systemctl status firewalld.service

2、关闭selinux

vim /etc/selinux/config
SELINUX=disabled

3、准备安装oracle安装所需依赖*(需要的联系)*

rpm -ivh  *.rpm  --force --nodeps

4、安装oracle-database-preinstall

rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

二、安装Oracle 19c

1、安装

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

2、初始化Oracle数据库

/etc/init.d/oracledb_ORCLCDB-19c configure

3、修改Oracle密码 非必须 输入并确认密码

passwd oracle

4、修改配置文件

vi /etc/profile
#在最后追加
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin
export ORACLE_SID=ORCLCDB
export NLS_LANG="AMERICAN_AMERICA.UTF8"
#使环境变量生效
source /etc/profile

5、登录

切换到oracle用户执行数据库操作
su oracle
sqlplus / as sysdba
根据自己需求修改密码:
alter user system identified by 123456;
alter user sys identified by 123456;
alter user sysdba identified by 123456;

6、查看PDB

show pdbs;
#需要在CDB
#rpm方式安装自动会创建一个PDB数据库：ORCLPDB1，如不需要，可将其删除
ALTER PLUGGABLE DATABASE ORCLPDB1 CLOSE;
DROP PLUGGABLE DATABASE ORCLPDB1 including datafiles;

7、使用system 在navcat连接oracle

CREATE PLUGGABLE DATABASE orcl ADMIN USER orcl IDENTIFIED BY oracle
STORAGE (MAXSIZE UNLIMITED)
DEFAULT TABLESPACE orcl
DATAFILE '/opt/oracle/oradata/ORCLCDB/orcl/orcl.dbf' SIZE 100M AUTOEXTEND ON
PATH_PREFIX = '/opt/oracle/oradata/ORCLCDB/orcl/'
FILE_NAME_CONVERT = ('/opt/oracle/oradata/ORCLCDB/pdbseed', '/opt/oracle/oradata/ORCLCDB/orcl');

8、启动ORCL

ALTER PLUGGABLE DATABASE ORCL OPEN;

9、在Navicat中执行 创建触发器，实现Oracle启动后自动打开PDB

CREATE TRIGGER open_ORCL
AFTER STARTUP ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ORCL OPEN';
END open_ORCL;
/

如果已经有了 更新操作命令如下

CREATE OR REPLACE TRIGGER open_ORCL
AFTER STARTUP ON DATABASE
BEGIN
   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ORCL OPEN';
END open_ORCL;
/

10、#切换回CDB容器

alter session set container=CDB$ROOT;

11、创建表临时空间和表空间

#创建临时表空间
CREATE TEMPORARY TABLESPACE BYQJKGL_TEMP TEMPFILE '/opt/oracle/oradata/ORCLCDB/byqjkgl_temp.dbf' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 20480 M EXTENT MANAGEMENT LOCAL;
#创建表空间
CREATE TABLESPACE BYQJKGL_DATA LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/byqjkgl_data.dbf' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 20480 M EXTENT MANAGEMENT LOCAL;

12、创建公共用户

#创建用户
CREATE USER "BYQJKGL" IDENTIFIED BY "123456" DEFAULT TABLESPACE "BYQJKGL_DATA" TEMPORARY TABLESPACE "BYQJKGL_TEMP";
# 使用自定义表空间oracle19c创建【公共用户】必须已C##或者c##
CREATE USER "C##BYQJKGL_USER" IDENTIFIED BY "123456" DEFAULT TABLESPACE "BYQJKGL_DATA" TEMPORARY TABLESPACE "BYQJKGL_TEMP";
# 使用默认表空间
CREATE USER "TEST_USER" IDENTIFIED BY "123456";
#用户授权
GRANT "CONNECT", "DBA", "RESOURCE" TO "C##BYQJKGL_USER";
#删除用户
drop user "TEST_USER" cascade;

13、创建PDB用户

alter session set container=ORCL;
#创建临时表空间
CREATE TEMPORARY TABLESPACE BYQSFYZ_TEMP TEMPFILE '/opt/oracle/oradata/ORCLCDB/orcl/byqsfyz_temp.dbf' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 20480 M EXTENT MANAGEMENT LOCAL;
#创建表空间
CREATE TABLESPACE BYQSFYZ_DATA LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/orcl/byqsfyz_data.dbf' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 20480 M EXTENT MANAGEMENT LOCAL;
#创建用户
CREATE USER "BYQSFYZ" IDENTIFIED BY "BYQSFYZ123456" DEFAULT TABLESPACE "BYQSFYZ_DATA" TEMPORARY TABLESPACE "BYQSFYZ_TEMP";
#用户授权
GRANT "CONNECT",  "RESOURCE" TO "BYQSFYZ";
#删除用户
drop user "BYQSFYZ" cascade;