Oracle12c日常維護(hù)

1.啟動(dòng)CDB和PDB數(shù)據(jù)庫(kù)

創(chuàng)新互聯(lián)成都網(wǎng)站建設(shè)定制網(wǎng)站制作，是成都網(wǎng)站營(yíng)銷公司,為社區(qū)文化墻提供網(wǎng)站建設(shè)服務(wù),有成熟的網(wǎng)站定制合作流程，提供網(wǎng)站定制設(shè)計(jì)服務(wù)：原型圖制作、網(wǎng)站創(chuàng)意設(shè)計(jì)、前端HTML5制作、后臺(tái)程序開(kāi)發(fā)等。成都網(wǎng)站維護(hù)熱線：18982081108

SQL> select con_id,dbid,name,open_mode from v$pdbs;

CON_ID DBID NAME OPEN_MODE

---------- ---------- ------------------------------ ----------

2 1226396669 PDB$SEED READ ONLY

3 411454583 DB12CCD MOUNTED

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> select con_id,dbid,name,open_mode from v$pdbs;

CON_ID DBID NAME OPEN_MODE

---------- ---------- ------------------------------ ----------

2 1226396669 PDB$SEED READ ONLY

3 411454583 DB12CCD READ WRITE

2.創(chuàng)建PDB數(shù)據(jù)庫(kù)

SQL> select name,cdb from v$database;

NAME CDB

--------- ---

DB12C YES

SQL> select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs;

PDB_ID PDB_NAME DBID STATUS CREATION_SCN

---------- -------------------- ---------- --------- ------------

3 DB12CCD 411454583 NORMAL 1744330

2 PDB$SEED 1226396669 NORMAL 1594399

SQL> create pluggable database test admin user test identified by test file_name_convert=('/u01/app/oracle/oradata/cdb/pdbseed/','/u01/app/oracle/oradata/cdb/test/');

Pluggable database created.

create pluggable database test1 admin user test1 identified by test1 file_name_convert=('/u01/app/oracle/oradata/cdb/test/','/u01/app/oracle/oradata/cdb/test1/');

3.建立連接

--進(jìn)入cdb

sqlplus / as sysdba

sqlplus sys/sys@192.168.10.32:1521/cdb as sysdba

--進(jìn)入pdb

3.1)通過(guò)tns方式用創(chuàng)建的admin user登錄

[oracle@ora12cA ~]$ sqlplus sys/oracle@192.168.10.32:1521/test as sysdba

SQL> show con_name

CON_NAME

------------------------------

TEST

--查看admin user擁有的權(quán)限

SQL> select * from session_privs;

PRIVILEGE

----------------------------------------

SET CONTAINER

CREATE PLUGGABLE DATABASE

CREATE SESSION

3.2)通過(guò)set container來(lái)連接pdb

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB MOUNTED

4 TEST READ WRITE NO

SQL> alter session set container=test;

Session altered.

SQL> show con_name

CON_NAME

------------------------------

TEST

4.打開(kāi)和關(guān)閉pdb

SQL>alter pluggable database all close immediate;

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB MOUNTED

4 TEST MOUNTED

--打開(kāi)單個(gè)pdb

SQL> alter pluggable database pdb open;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST MOUNTED

--打開(kāi)所有pdb

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST READ WRITE NO

--關(guān)閉所有pdb

SQL> alter pluggable database all close immediate;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB MOUNTED

4 TEST

5.創(chuàng)建用戶。

1).概述

在cdb默認(rèn)是container=all,在cdb中只能創(chuàng)建全局用戶;

在pdb默認(rèn)是container=current,在pdb只能創(chuàng)建本地用戶。

http://dovelauren.blog.51cto.com/9876026/1719310

如果在cdb中創(chuàng)建用戶會(huì)在cdb和所有的pdb中創(chuàng)建該用戶,但是pdb中的全局用戶需要另外授權(quán)才能夠在pdb中訪問(wèn))。

2).創(chuàng)建全局用戶

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL> create user c##t identified by t;

User created.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 PDB1 READ WRITE NO

3).創(chuàng)建本地用戶

SQL> alter session set container=pdb1;

Session altered.

SQL> create user t identified by t;

User created.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

4 PDB1 READ WRITE NO

6.用戶授權(quán)

用戶授權(quán)默認(rèn)情況下是只會(huì)給當(dāng)前container,在cdb中也可以指定container=all,對(duì)所有open的pdb且存在該用戶都進(jìn)行授權(quán)

Connected.

SQL> grant connect,resource to c##t;

Grant succeeded.

SQL> grant connect,resource to c##t container=all;

Grant succeeded.

7.修改參數(shù)

在cdb中修改,pdb會(huì)繼承進(jìn)去;如果在pdb中修改會(huì)覆蓋pdb從cdb中繼承的參數(shù)含義

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL> show parameter open_cursors

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

open_cursors integer 300

SQL> alter system set open_cursors=500;

System altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 PDB1 READ WRITE NO

SQL> alter session set container=pdb1;

Session altered.

SQL> show parameter open_cursors

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

open_cursors integer 500

SQL> alter system set open_cursors=100;

System altered.

SQL> show parameter open_cursors

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

open_cursors integer 100

SQL> show con_name

CON_NAME

------------------------------

PDB1

SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> show parameter open_cursors

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

open_cursors integer 500

本文標(biāo)題：Oracle12c日常維護(hù)
鏈接分享：http://muchs.cn/article24/pgodce.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供企業(yè)網(wǎng)站制作、營(yíng)銷型網(wǎng)站建設(shè)、網(wǎng)站營(yíng)銷、軟件開(kāi)發(fā)、網(wǎng)站改版、App開(kāi)發(fā)

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容