Connect to a PDB of Oracle12c
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 ~]$ sqlplus /nolog 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>
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!
Now you application can use this DB as well.
上一篇: PHP/MySQL三日通-第一天(一)
下一篇: 怎么安装pear工具包
推荐阅读
-
Connect to a PDB of Oracle12c
-
Can t connect to MySQL server 常见问题解决办法
-
php 不能连接数据库 php error Can't connect to local_MySQL
-
PHP中$link=mysql_connect("localhost""root""");解决思路
-
php mysql操作mysql_connect连接数据库实例详解
-
PHP下使用mysqli的函数连接mysql出现warning: mysqli::real_connect(): (hy000/1040): ...
-
MYSQL拒绝访问报错not allowed to connect
-
Kafka Connect 博客分类: kafka KafkaKafka Connect
-
Kafka Connect 博客分类: kafka KafkaKafka Connect
-
: Can’t connect to local mysql server through socket ‘/tmp/mysql.sock’ 博客分类: linux mysqlsockhostlinux