说明
之前安装的Docker 版本有一些性能问题待处理,索性安装一版非docker版本的,仅供参考。
关闭防火墙
systemctl stop firewalld
安装依赖
yum -y update
安装依赖:
yum install -y compat-libcap1 compat-libstdc++-33 gcc-c++ ksh libaio-devel libstdc++-devel elfutils-libelf-devel fontconfig-devel libXrender-devel libXtst
检查依赖:
rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" bc binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat elfutils-libelf elfutils-libelf-devel fontconfig-devel libxcb smartmontools libX11 libXau libXtst libXrender libXrender-deve
下载地址:
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
下载
需要下载 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
下载地址:https://download.csdn.net/download/lulongji2035/15647846
安装oracle-database-preinstall
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
下载Oracle 19c
可以选择官网下载或者我的百度硬盘。
官网地址:
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
百度硬盘:
链接: https://pan.baidu.com/s/1BrEcHB_Mmxt9BJ-hyUT_wQ 密码: a137
安装Oracle 19c
yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
初始化Oracle数据库:
/etc/init.d/oracledb_ORCLCDB-19c configure
初始化Oracle数据库:
/etc/init.d/oracledb_ORCLCDB-19c configure
等待.......时间较长。。。
预计40分钟左右。。。
......
......
......
数据库创建完成。有关详细信息, 请查看以下位置的日志文件:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB。
数据库信息:
全局数据库名:ORCLCDB
系统标识符 (SID):ORCLCDB
有关详细信息, 请参阅日志文件 "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log"。Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
配置环境变量:
vim /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
配置账户:
su - oracle
sqlplus sys/dwh
as
sysdba;
select
name
,cdb
from
v$
database
;
col pdb_name
for
a30
select
pdb_id,pdb_name,dbid,status,creation_scn
from
dba_pdbs;
创建使用者为newfs
切换模式
alter
session
set
container=ORCLPDB1;
查看
show con_name;
创建用户并授权
create
user
newfs identified
by
123456
default
tablespace users
temporary
tablespace
temp
;
grant
create
user
,
drop
user
,
alter
user
,
create
any
view
,
connect
,resource,dba,
create
session,
create
any
sequence
to
newfs;
创建成功 账户
地址:192.168.183.240
端口:1521
服务名:ORCLPDB1
用户名:newfs
密码:123456