oracle 19c-m6米乐安卓版下载

m6米乐安卓版下载-米乐app官网下载

oracle 19c-手工建库.pdf

布衣

566

2页

9次

2021-09-13

10墨值下载

一、启动实例:

1.设置：

exportoracle_sid=cdb1

2.创建口令文件（注意这里的口令文件名是有要求的，不能随便起）

1orapwdfile=$oracle_home/dbs/orapwcdb1password=oracle

3.设置：initcdb1.ora:

1‐setcontrol_filestocdbcontrolfilenames。

2‐setdb_nametoacdbname.

3‐setenable_pluggable_databasetotrue.

1vim/u01/oracle/19.2.0/product/dbs/initcdb1.ora

*.audit_file_dest='/u01/oracle/admin/cdb2/adump'

*.audit_trail='db'

*.compatible='19.0.0'

*.control_files='/u01/oradata/cdb2/control01.ctl','/u01/oradata/cdb2/control02.ctl'

*.db_block_size=8192

*.db_name='cdb2'

*.diagnostic_dest='/u01/oracle'

*.dispatchers='(protocol=tcp) (service=twocdbxdb)'

*.enable_pluggable_database=true

*.local_listener='listener_cdb2'

*.nls_language='american'

*.nls_territory='america'

*.open_cursors=300

*.pga_aggregate_target=782m

*.processes=1280

*.remote_login_passwordfile='exclusive'

*.sga_target=2346m

*.undo_tablespace='undotbs1'

4.启动nomount状态：

1sql>startupnomount;

5.生成spfile文件：

1sql>createspfilefrompfile;

2sql>shutdownimmediate;

3sql>startupnomount;

二、创建数据库

1cdb$root根容器：container

2pdb$seed种子容器:pluggabledatabase

1sql>createdatabasecdb2

2usersysidentifiedbyp1

3usersystemidentifiedbyp2

4logfilegroup1('/u01/oradata/cdb2/redo1/redo1a.log','/u01/oradata/cdb

2/redo2/redo1b.log')size100m,

5group2('/u01/oradata/cdb2/redo1/redo2a.log','/u01/oradata/cdb2/redo2/r

edo2b.log')size100m

6charactersetal32utf8national

7charactersetal16utf16

8extentmanagementlocaldatafile'/u01/oradata/cdb2/system01.dbf'size3

25mreuse

9sysauxdatafile'/u01/oradata/cdb2/sysaux01.dbf'size325mreuse

10defaulttablespaceusersdatafile'/u01/oradata/cdb2/susers01.dbf'size

100mreuseautoextendonmaxsizeunlimited

11defaulttemporarytablespacetempts1

12tempfile'/u01/oradata/cdb2/temp01.dbf'size20mreuse

13undotablespaceundotbs1

14datafile'/u01/oradata/cdb2/undotbs01.dbf'size200mreuse

15enablepluggabledatabase

16seedfile_name_convert=('/u01/oradata/cdb2','/u01/oradata/cdb2/seed');

17sql>showpdbs;

18con_idcon_nameopenmoderestricted

19‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐

202pdb$seedreadonlyno

21sql>selectopen_modefromv$database;

22open_mode

23‐‐‐‐‐‐‐‐‐‐

24readwrite

三、运行后续脚本：

1.创建数据字典：

1sql>@?/rdbms/admin/catalog

2.创建pl/sql运行环境

1sql>@?/rdbms/admin/catproc

2sql>selectpdb_id,pdb_name,statusfromcdb_pdbs;

3pdb_idpdb_namestatus

4‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐

52pdb$seednormal

3.创建scott用户

1sql>@?/rdbms/admin/utlsampl

2sql>sqlplusscott/tiger

of 2

10墨值下载

关注

oracle 19c-m6米乐安卓版下载

评论