DB12c DBCA – Create a Pluggable Database
With the release of Oracle Database 12c, there is a lot of excitement and thoughts about multi-tenant databases. This basically means that we can run more database while achieving a smaller foot print on servers and within the infrastructure. This concept of multi-tenant databases is actually going to make it cool again to be a DBA. Instead of fighting for resources to house multiple database; we can now use existing servers within the infrastructure and still provide the support organizations are looking for.
In this blog post, I want to show you how easy it is to create a pluggable database from the Database Configuration Assistant (DBCA). This is one of the many ways, Oracle has provided to end users for creating pluggable databases quickly and effortlessly.
As with any database install we need to have the binaries install before we can use DBCA. Once the binaries are installed, we should have created a container database (CDB). The container database is going to be where we create our pluggable database. My environment for testing this is as follows:
Oracle Enterprise Linux 6.4 (V33411-01.iso) Oracle Database 12c Enterprise Edition (12.1.0.1) Oracle_Home is set to /oracle/app/product/12.1.0.1/dbhome_1
In short, I have a pretty generic environment set up.
Lets start the DBCA and create our pluggable database.
I always set my Oracle environment before I start to interact with Oracle tools.
[oracle@oel ~]$ . oraenv ORACLE_SID = [oracle] ? ora12c The Oracle base has been set to /oracle/app [oracle@oel ~]$ env | grep ORA ORACLE_SID=ora12c ORACLE_BASE=/oracle/app ORACLE_HOME=/oracle/app/product/12.1.0.1/dbhome_1
This actually makes it easier to start the DBCA because I don’t need to specify the path to the file since it is already setup in my environment.
Starting the DBCA is easy and will bring use to the first screen. You will notice that Oracle has added a new option called “Manage Pluggable Databases“. This is the path that the DBCA will use to manage, create, delete and alter any pluggable databases that are associated with the container database.
[oracle@oel dbhome_1]$ dbca & [1] 8853
Step two, we have multiple options to use for the pluggable database(s). Since we are focusing on creating a pluggable database, select the “Create Pluggable Database” option.
Step three, we can choose what container database we would like to create the pluggable database in. For the purpose of this example, I’m creating the pluggable in the “ora12c” container database.
Step four, we can create a new pluggable database. We can also create a pluggable form a PDB archive or from an RMAN supported PDB file set. Again, we are just creating so lets stick with the default option.
Step five, we have to name our PDB, identify what type of storage we are using and setup an initial PDB Admin user. As a general rule, it is good to come up with a naming scheme for PDBs. I tend to use pdb<name> format, just so I can keep track of what is PDB versus non-PDB. For storage of a PDB, I’m using my file system for storage; however, you can also select an ASM instance to use.
Step six, is our review screen. Review what you have selected and make sure it will create the PDB where you are expecting it to be created.
Step seven, is the progress screen.
When the pluggable database is created and successful, the DBCA will let you know.
After closing DBCA, how can we tell if the pluggable database is created and running? Pluggable databases are contained within a container database. This means that we cannot use normal avenues of looking up a database process (ps -ef | grep -i peon). Actually, one of the easiest way to see if the pluggable is running is to check the listener status. The new pluggable database will automatically register with the listener upon creation.
[oracle@oel dbhome_1]$ lsnrctl status | grep -i pdbtest Service "pdbtest.acme.com" has 1 instance(s).
Well, hope you see how easy it is to create a pluggable database from one of the tools that Oracle provides.
Enjoy!
twitter: @curtisbl294
blog: http://dbasolved.com
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
025 for ERK1 CHOL EECP group vs CHOL group; P 0 priligy sg One study revealed a high concordance between the AdnaTest BreastCancer and the CellSearch system in the detection of two or more CTCs without evaluating the prognostic relevance 38
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me. https://www.binance.com/ar/register?ref=V2H9AFPY
Informative, pretty much as I had come to expect from this site.
I think you have observed some very interesting details , thankyou for the post.
Excellent beat ! I wish to apprentice while you amend your web site, how can i subscribe for a blog site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear idea
Imagine that you are already as part of your student days to weeks in addition to breast implants in destin florida continue to an individual can’t look for a night out. And even wondering an individual for just a time is usually a misery for yourself. In other words, you get the idea challenging to be able to approach adult females as well as lacks self-assurance around by yourself.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.