Connect to a PDB of Oracle12c

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
リリース: 2016-06-07 15:32:19
オリジナル
1063 人が閲覧しました

Story about CDB and PDB Oracle12c has a new feature and definition of CDB and PDB. If you first use 12c you will get confused like me. So that is necessary to know some basic definitions before you start. Oracle's official document is alwa

Story about CDB and PDB

Oracle12c has a new feature and definition of CDB and PDB. If you first use 12c you will get confused like me. So that is necessary to know some basic definitions before you start. Oracle's official document is always the best material.

What is CBD and PDB and why introduce them?


Login a CBD

[oracle@ol65 ~]$ <strong>sqlplus /nolog</strong>

SQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 27 23:07:56 2014

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

SQL> conn sys@orcl as sysdba
Enter password: 
Connected.
SQL> sho con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> 
ログイン後にコピー
** sho con_name - show current container name. Root container is always called CDB#ROOT.

How many PDBs in your root container now?

SQL> sho pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDBORCL			  MOUNTED
SQL> 
ログイン後にコピー


** PDB$SEED is a seed PDB, as its name Oracle12c will take is
    Default status of a new PDB is mounted. It's not running, you have to 'open' it before you start using it.


Open a PDB

You must have sysdba privilege.

SQL> alter pluggable database PDBORCL open;

Pluggable database altered.

SQL> sho pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 PDBORCL			  READ WRITE NO
SQL> 
ログイン後にコピー

Login a PDB

SQL> sho con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=PDBORCL;

Session altered.

SQL> sho con_name

CON_NAME
------------------------------
PDBORCL
SQL> 
ログイン後にコピー
Now you login a PDB. Now you can create a new user as you operate a Oracle DB before 12c. This user is not common user. It's a user for this PDB. You also can understand PDB as a general DB of the version before 12c.


Login Root Container again and Stop a PDB

SQL> conn sys as sysdba
Enter password: 
Connected.
SQL> alter pluggable database PDBORCL close immediate;

Pluggable database altered.

SQL> 
ログイン後にコピー

Register a Entry of a PDB

Edit config file /$ORACLE_HOME/network/admin/tnsnames.ora.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.localdomain)
    )
  )

PDBORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl.localdomain)
    )
  )
ログイン後にコピー

Save and quit. Go to open this PDB again. Now you can access PDBORCL by service name.

[oracle@ol65 admin]$ sqlplus sys@pdborcl as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 28 00:08:52 2014

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

Enter password: 

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> 
ログイン後にコピー
And the most importance is that now you are able to remotely connect this PDB!

Connect to a PDB of Oracle12c

Now you application can use this DB as well.


関連ラベル:
このウェブサイトの声明
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。
人気のチュートリアル
詳細>
最新のダウンロード
詳細>
ウェブエフェクト
公式サイト
サイト素材
フロントエンドテンプレート