海外吃瓜大揭秘,欧美人与禽XOXO牲伦交,东京热黄色软件下载指南,a网站在线看

Oracle 19c-手工建庫.pdf

布衣

1880

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墨值下載

文檔被以下合輯收錄

特色一级强游戏,海奥华预言免费阅读,51漫画兑换码,美女裸体无遮挡永久免费观看网站,lubuntu线路检测入口

文檔被以下合輯收錄

評論