Oracle 12C 建立使用者連線pdb

測試環境：

 

C:\ora12c\product\12.1.0\dbhome_1\BIN>sqlplus.exe /nolog

SQL*Plus: Release 12.1.0.1.0 Production on 星期二 9月 20 03:50:23 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn /as sysdba

已連線。

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 POLESTAR1                      READ WRITE NO

         4 POLESTAR2                      READ WRITE NO

SQL>

SQL> alter session set container=polestar1;

 

會話已更改。

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         3 POLESTAR1                      READ WRITE NO

SQL>

SQL> create user polestar identified by polestar;

 

User created.

 

SQL> grant dba to polestar;

 

配置監聽listener檔案：

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1523))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))

    )

  )

 

SID_LIST_LISTENER=

(SID_LIST=

  (SID_DESC =

  (GLOBAL_DBNAME = orcl12c)   #CDB資訊

  (SID_NAME = orcl12c)

  )

 

  (SID_DESC =

  (GLOBAL_DBNAME = polestar1) #PDB資訊

  (SID_NAME = orcl12c)

  )

)

 

 

 

用建立使用者連線pdb資料庫

C:\ora12c\product\12.1.0\dbhome_1\BIN>sqlplus polestar/polestar@192.168.0.100:1523/POLESTAR1

 

SQL*Plus: Release 12.1.0.1.0 Production on 星期二 9月 20 02:48:14 2016

 

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 

連線到:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

ions

 

SQL> show pdbs;

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         3 POLESTAR1                      READ WRITE NO

SQL> exit