Oracle 19c-手工建库.pdf

布衣

1005

2页

9次

2021-09-13

10墨值下载

一、启动实例:

1.设置：

exportORACLE_SID=CDB1

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

1 orapwd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.

1 vim/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状态：

1 SQL>startupnomount;

5.生成spfile文件：

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

2 SQL>shutdownimmediate;

3 SQL>startupnomount;

二、创建数据库

1 CDB$ROOT根容器：container

2 PDB$SEED种子容器:pluggabledatabase

1 SQL>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');

17 SQL>showpdbs;

18 CON_IDCON_NAMEOPENMODERESTRICTED

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

20 2PDB$SEEDREADONLYNO

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

22 OPEN_MODE

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

24 READWRITE

三、运行后续脚本：

1.创建数据字典：

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

2.创建PL/SQL运行环境

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

2 SQL>SELECTPDB_ID,PDB_NAME,STATUSFROMCDB_PDBS;

3 PDB_IDPDB_NAMESTATUS

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

5 2PDB$SEEDNORMAL

3.创建SCOTT用户

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

2 SQL>sqlplusscott/tiger

of 2

10墨值下载

关注

评论