{"id":13330,"date":"2019-10-31T11:14:26","date_gmt":"2019-10-31T11:14:26","guid":{"rendered":"https:\/\/dbtut.com\/?p=13330"},"modified":"2020-10-02T08:30:18","modified_gmt":"2020-10-02T08:30:18","slug":"how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/","title":{"rendered":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c"},"content":{"rendered":"

Connect to Root Container<\/h1>\n

The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be established using OS authentication on the database server.<\/p>\n

[oracle@oradb ~]$ sql \/ as sysdba\n\nSQLcl: Release 12.2.0.1.0 RC on Sat Dec 15 15:11:41 2018\n\nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\n\nSQL> set sqlformat ansiconsole\nSQL> show con_name\nCON_NAME\n------------------------------\nCDB$ROOT<\/pre>\n
Find Service Names<\/h1>\n
We can find service names from the V$SERVICES view.<\/p>\n
SQL> select NAME,PDB,CON_ID from v$services;\nNAME                                       PDB       CON_ID\nORCL.svcsubnetad3.svcvcn.oraclevcn.com     CDB$ROOT  1\nORCL.svcsubnetad3.svcvcn.oraclevcn.comXDB  CDB$ROOT  1\nSYS$BACKGROUND                             CDB$ROOT  1\nSYS$USERS                                  CDB$ROOT  1\npdb1.svcsubnetad3.svcvcn.oraclevcn.com     PDB1      3<\/pre>\n
It is also possible to find service names with the lsnrctl tool.<\/p>\n
[oracle@oradb ~]$ lsnrctl status\n\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-DEC-2018 15:14:24\n\nCopyright (c) 1991, 2016, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORADB.svcsubnetad3.svcvcn.oraclevcn.com)(PORT=1521)))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production\nStart Date                12-DEC-2018 19:17:31\nUptime                    2 days 19 hr. 56 min. 53 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/listener.ora\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/ORADB\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb.svcsubnetad3.svcvcn.oraclevcn.com)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oradb.svcsubnetad3.svcvcn.oraclevcn.com)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/admin\/ORCL\/xdb_wallet))(Presentation=HTTP)(Session=RAW))\nServices Summary...\nService \"7cd91ac74a8a1f40e0530320000a2fa7.svcsubnetad3.svcvcn.oraclevcn.com\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\nService \"ORCL.svcsubnetad3.svcvcn.oraclevcn.com\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\nService \"ORCL.svcsubnetad3.svcvcn.oraclevcn.comXDB\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\nService \"pdb1.svcsubnetad3.svcvcn.oraclevcn.com\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\nThe command completed successfully\n\n\n[oracle@oradb ~]$ lsnrctl service\n\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-DEC-2018 15:14:44\n\nCopyright (c) 1991, 2016, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORADB.svcsubnetad3.svcvcn.oraclevcn.com)(PORT=1521)))\nServices Summary...\nService \"7cd91ac74a8a1f40e0530320000a2fa7.svcsubnetad3.svcvcn.oraclevcn.com\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\n    Handler(s):\n      \"DEDICATED\" established:2 refused:0 state:ready\n         LOCAL SERVER\nService \"ORCL.svcsubnetad3.svcvcn.oraclevcn.com\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\n    Handler(s):\n      \"DEDICATED\" established:2 refused:0 state:ready\n         LOCAL SERVER\nService \"ORCL.svcsubnetad3.svcvcn.oraclevcn.comXDB\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\n    Handler(s):\n      \"D000\" established:0 refused:0 current:0 max:1022 state:ready\n         DISPATCHER <machine: oradb, pid: 12265>\n         (ADDRESS=(PROTOCOL=tcp)(HOST=oradb.svcsubnetad3.svcvcn.oraclevcn.com)(PORT=23026))\nService \"pdb1.svcsubnetad3.svcvcn.oraclevcn.com\" has 1 instance(s).\n  Instance \"ORCL\", status READY, has 1 handler(s) for this service...\n    Handler(s):\n      \"DEDICATED\" established:2 refused:0 state:ready\n         LOCAL SERVER\nThe command completed successfully<\/pre>\n\n
Connect To Pluggable Database with Easy Connect Method<\/h1>\n
After specifying the service names, we can connect with the easy connect method as follows.<\/p>\n
oradb.svcsubnetad3.svcvcn.oraclevcn.com -> hostname<\/p>\n
pdb1.svcsubnetad3.svcvcn.oraclevcn.com\u00a0 \u00a0-> pdb1 pluggable database service name<\/p>\n
[oracle@oradb ~]$ sqlplus ahmet\/ahmet@oradb.svcsubnetad3.svcvcn.oraclevcn.com:1521\/pdb1.svcsubnetad3.svcvcn.oraclevcn.com\n\nSQL*Plus: Release 12.2.0.1.0 Production on Sat Dec 15 15:17:55 2018\n\nCopyright (c) 1982, 2016, Oracle.  All rights reserved.\n\nLast Successful login time: Sat Dec 15 2018 10:40:22 +00:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL> show con_name\n\nCON_NAME\n------------------------------\nPDB1<\/pre>\n
Connect To Pluggable Database with Naming Method<\/h1>\n
We can connect with Naming method as follows. First we need to make sure that the TNS name exists in $ORACLE_HOME\/network\/admin\/tnsnames.ora and that it is correct.<\/p>\n
TNS information in the tnsnames.ora file:<\/h3>\n
PDB1 =\n(DESCRIPTION =\n(ADDRESS = (PROTOCOL = TCP)(HOST = ORADB.svcsubnetad3.svcvcn.oraclevcn.com)(PORT = 1521))\n(CONNECT_DATA =\n(SERVER = DEDICATED)\n(SERVICE_NAME = pdb1.svcsubnetad3.svcvcn.oraclevcn.com)\n)\n)<\/pre>\n
Naming Method<\/h3>\n
[oracle@oradb admin]$ sqlplus ahmet\/ahmet@PDB1\n\nSQL*Plus: Release 12.2.0.1.0 Production on Sat Dec 15 15:21:00 2018\n\nCopyright (c) 1982, 2016, Oracle.  All rights reserved.\n\nLast Successful login time: Sat Dec 15 2018 15:17:55 +00:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL> show con_name\n\nCON_NAME\n------------------------------\nPDB1<\/pre>\n\n
Connect To Pluggable Database From Root Container<\/h1>\n
After connecting to the root container (CDB$ROOT), it is possible to switch to the corresponding pluggable databases via the alter session command or to the root container from pluggable databases.<\/p>\n
[oracle@oradb admin]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 12.2.0.1.0 Production on Sat Dec 15 15:22:43 2018\n\nCopyright (c) 1982, 2016, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL> show con_name\n\nCON_NAME\n------------------------------\nCDB$ROOT\nSQL>\nSQL>\nSQL>\nSQL> select name from v$pdbs;\n\nNAME\n--------------------------------------------------------------------------------\nPDB$SEED\nPDB1\n\nSQL>\nSQL>\nSQL> alter session set container=PDB1;\n\nSession altered.\n\nSQL> show con_name\n\nCON_NAME\n------------------------------\nPDB1\nSQL>\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         3 PDB1                           READ WRITE NO\nSQL>\nSQL>\nSQL> alter session set container=CDB$ROOT;\n\nSession altered.\n\nSQL>  show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ WRITE NO\nSQL> show con_name\n\nCON_NAME\n------------------------------\nCDB$ROOT\n\nSQL> select sys_context('USERENV','CON_NAME') from dual;\n\nSYS_CONTEXT('USERENV','CON_NAME')\n--------------------------------------------------------------------------------\nCDB$ROOT<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be established using OS authentication on the database server. [oracle@oradb ~]$ sql \/ as sysdba SQLcl: Release 12.2.0.1.0 RC on Sat Dec 15 15:11:41 2018 Copyright (c) 1982, 2018, Oracle. All …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":13331,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[5064,5048,5046,5049,5070,5071,5065,5053,5045,5047,5051,5066,5050,5080,5076,5075,5052,5067,5062,5063,5057,5058,5054,5078,5079,5077,5055,5074,5072,5069,5068,5061,5082,5081,5056,5073,5060,5059],"class_list":["post-13330","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-cdbroot","tag-connect-cdb","tag-connect-oracle-container-database","tag-connect-pluggable-database","tag-connect-to-a-pdb-in-sql-plus","tag-connect-to-a-pdb-in-sqlplus","tag-connect-to-cdbroot","tag-connect-to-container","tag-connect-to-container-database-cdb","tag-connect-to-oracle-cdb","tag-connect-to-oracle-pluggable-database","tag-connect-to-oracle-pluggable-database-from-root-container","tag-connect-to-pluggable-database","tag-connect-to-pluggable-database-from-root-container","tag-connect-to-pluggable-database-with-easy-connect-method","tag-connect-to-pluggable-database-with-naming-method","tag-connect-to-root-container","tag-connect-to-root-container-from-oracle-pluggable-database","tag-connect-to-root-container-with-easy-connect-method","tag-connect-to-root-container-with-naming-method","tag-easy-connect","tag-easy-connect-in-oracle","tag-find-available-service-names-in-the-database","tag-find-database-service-names","tag-find-pluggable-database-service-names","tag-find-service-names","tag-find-service-names-in-the-database","tag-how-do-i-find-my-pdb","tag-how-does-sql-developer-connect-to-pdb-database","tag-how-to-connect-to-cdb-in-oracle","tag-how-to-connect-to-pluggable-databases-in-oracle","tag-naming-method","tag-switch-pluggable-database-from-container","tag-switch-root-container-from-pluggable-database","tag-vservices","tag-what-is-cdb-root","tag-what-is-easy-connect","tag-what-is-easy-connect-in-oracle"],"aioseo_notices":[],"yoast_head":"\nHow To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-31T11:14:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-02T08:30:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png\" \/>\n\t<meta property=\"og:image:width\" content=\"761\" \/>\n\t<meta property=\"og:image:height\" content=\"449\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c\",\"datePublished\":\"2019-10-31T11:14:26+00:00\",\"dateModified\":\"2020-10-02T08:30:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\"},\"wordCount\":206,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png\",\"keywords\":[\"CDB$ROOT\",\"Connect CDB\",\"Connect Oracle Container database\",\"Connect pluggable database\",\"Connect to a pdb in SQL Plus\",\"Connect to a pdb in SQLPlus\",\"Connect To CDB$ROOT\",\"Connect to Container\",\"Connect to Container database (CDB)\",\"Connect to ORACLE CDB\",\"Connect to oracle pluggable database\",\"Connect To Oracle Pluggable Database From Root Container\",\"Connect to pluggable database\",\"Connect To Pluggable Database From Root Container\",\"Connect To Pluggable Database with Easy Connect Method\",\"Connect To Pluggable Database with Naming Method\",\"Connect to Root Container\",\"Connect To Root Container From Oracle Pluggable Database\",\"Connect To Root Container with Easy Connect Method\",\"Connect To Root Container with Naming Method\",\"Easy Connect\",\"Easy Connect in Oracle\",\"find available service names in the database\",\"Find Database Service Names\",\"Find Pluggable Database Service Names\",\"Find Service Names\",\"Find Service Names in the Database\",\"How do I find my PDB?\",\"How does SQL Developer connect to PDB database?\",\"How to connect to cdb in Oracle\",\"How to connect to pluggable databases in Oracle\",\"Naming Method\",\"switch pluggable database from container\",\"switch root container from pluggable database\",\"V$SERVICES\",\"What is CDB root?\",\"What is Easy Connect\",\"What is Easy Connect in Oracle\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\",\"name\":\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png\",\"datePublished\":\"2019-10-31T11:14:26+00:00\",\"dateModified\":\"2020-10-02T08:30:18+00:00\",\"description\":\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png\",\"width\":761,\"height\":449},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c - Database Tutorials","description":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/","og_locale":"en_US","og_type":"article","og_title":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c - Database Tutorials","og_description":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c","og_url":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/","og_site_name":"Database Tutorials","article_published_time":"2019-10-31T11:14:26+00:00","article_modified_time":"2020-10-02T08:30:18+00:00","og_image":[{"width":761,"height":449,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c","datePublished":"2019-10-31T11:14:26+00:00","dateModified":"2020-10-02T08:30:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/"},"wordCount":206,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png","keywords":["CDB$ROOT","Connect CDB","Connect Oracle Container database","Connect pluggable database","Connect to a pdb in SQL Plus","Connect to a pdb in SQLPlus","Connect To CDB$ROOT","Connect to Container","Connect to Container database (CDB)","Connect to ORACLE CDB","Connect to oracle pluggable database","Connect To Oracle Pluggable Database From Root Container","Connect to pluggable database","Connect To Pluggable Database From Root Container","Connect To Pluggable Database with Easy Connect Method","Connect To Pluggable Database with Naming Method","Connect to Root Container","Connect To Root Container From Oracle Pluggable Database","Connect To Root Container with Easy Connect Method","Connect To Root Container with Naming Method","Easy Connect","Easy Connect in Oracle","find available service names in the database","Find Database Service Names","Find Pluggable Database Service Names","Find Service Names","Find Service Names in the Database","How do I find my PDB?","How does SQL Developer connect to PDB database?","How to connect to cdb in Oracle","How to connect to pluggable databases in Oracle","Naming Method","switch pluggable database from container","switch root container from pluggable database","V$SERVICES","What is CDB root?","What is Easy Connect","What is Easy Connect in Oracle"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/","url":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/","name":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png","datePublished":"2019-10-31T11:14:26+00:00","dateModified":"2020-10-02T08:30:18+00:00","description":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-23.png","width":761,"height":449},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/31\/how-to-connect-to-container-database-cdb-and-pluggable-databases-pdb-in-oracle-12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13330"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13330\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13331"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}