Oracle 12C 建立使用者串連pdb

標籤：

測試環境：C:\ora12c\product\12.1.0\dbhome_1\BIN>sqlplus.exe /nologSQL*Plus: Release 12.1.0.1.0 Production on 星期二 9月 20 03:50:23 2016Copyright (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 NOSQL>SQL> alter session set container=polestar1;會話已更改。SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         3 POLESTAR1                      READ WRITE NOSQL> 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/[email protected]:1523/POLESTAR1SQL*Plus: Release 12.1.0.1.0 Production on 星期二 9月 20 02:48:14 2016Copyright (c) 1982, 2013, Oracle.  All rights reserved.串連到:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         3 POLESTAR1                      READ WRITE NOSQL> exit

 

Oracle 12C 建立使用者串連pdb