使用SQL语句create database手工创建ORACLE19c数据库

郑全

手工创建数据库CDBDEV 过程

1.创建参数
cp $ORACLE_HOME/dbs/init.ora $ORACLE_HOME/dbs/initCDBDEV.ora

vim $ORACLE_HOME/dbs/initCDBDEV.ora

db_name='CDBDEV'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/CDBDEV/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=CDBDEVXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = ('/u01/app/oracle/oradata/control01.ctl', '/u01/app/oracle/fast_recovery_area/control02.ctl')
compatible ='19.16.0'

db_create_file_dest='/u01/app/oracle/oradata'
enable_pluggable_database=true

2.建立对应的目录
mkdir -p /u01/app/oracle/admin/CDBDEV/adump
mkdir -p /u01/app/oracle/fast_recovery_area
mkdir -p /u01/app/oracle/oradata

3.创建创建数据库的脚本
mkdir /home/oracle/labs

cd /home/oracle/labs
vim CrCDBDEV.sql

create database cdbdev
user sys identified by sztech_4U
user system identified by sztech_4U
extent management local
default temporary tablespace temp
default tablespace users
undo tablespace undotbs1
enable pluggable database;

4.设置环境变量
export ORACLE_SID=CDBDEV

5.启动实例
sqlplus /nolog
conn / as sysdba
startup nomount;

6.执行创建数据库脚本
sql>@/home/oracle/labs/CrCDBDEV.sql

7.执行创建数据字典脚本

sql>@?/rdbms/admin/catalog.sql
sql>@?/rdbms/admin/catproc.sql

8.添加环境参数
cat "CDBDEV:/u01/app/oracle/product/19.16.0/db_1:N"  >> /etc/oratab


9.增加em express
sql>select dbms_xdb_config.gethttpsport() from dual;

sql>execute dbms_xdb_config.sethttpsport;

到此，手工创建数据库就完成了。