Create database手工建库

通过create database命令手工建库

name	value
db_name	orcl
character set	al32utf8
cdb	true
omf	true

创建数据库参数文件

配置参数文件

vi initorcl.ora
db_name=orcl
sga_target=1g
pga_aggregate_target=200m
db_create_file_dest=/u01/app/oracle/oradata
db_recovery_file_dest=/u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size=10g
enable_pluggable_database=true

创建spfile

startup nomount
create spfile from pfile;
shutdown immediate
startup nomount

通过create database创建数据库

create database orcl
user sys identified by oracle
user system identified by oracle
character set al32utf8
national character set al16utf16
extent management local
default tablespace users
default temporary tablespace temp
undo tablespace undotbs1
enable pluggable database;

运行脚本

@?/rdbms/admin/catcdb.sql