S.T.E.M. Cell™

Dateline – Philadelphia, PA   11-Aug-2013  

The last week my STEM mind was turned towards working with Oracle’s new database, version 12c. The ‘c’ of 12c is for CLOUD.  Downloading Oracle 12c was a job encompassing two ZIP files totaling 2.6 GB (gigabytes).

The Install was a bit different, but in just two attempts I was able to install the software and took defaults to create a default database. As it turned out that database was a Container DB. It was named ORCL (same as in past releases). What was different was that since it was a Container DB, it had a Pluggable DB (PDBORCL) and a Pluggable Seed DB (PDB$SEED).

See my blog post of 12-August-2013 for a fuller description.

How do you use a Container DB? It is quite a paradigm shift, that is sure to confuse long time DBAs.

-- connect to the container database

connect / as sysdba

select name from V$ACTIVE_SERVICES;

...

pdb1.home

orclXDB

orcl.home

SYS$BACKGROUND

SYS$USERS

show CON_NAME
NAME
--------
CBD$ROOT

-- connect to pluggable database, PDBORCL
connect /@localhost:1521/pdb1.home as sysdba
Connected.
show CON_NAME
NAME
--------
PDB1

This was good but I wanted to connect with the much easier syntax:
conn /@PDB1 as sysdba

To do this, I needed to edit the tnsnames.ora file. After editing (I duplicated the entry for ORCL) to create a service name PDB1 my file looked like:

TNSNAMES_4PDBs

Notice that the service name (pdb1.home) matches the active_service name from the

V$ACTIVE_SERVICES table ! The next time you enter Sql*Plus (or whatever developer tool you use), you will now be able to connect as:

CONNECT user/password@PDB1

And you will be connected to the pluggable database, PDB1  (inside the Container DB, ORCL). Your application need not know it is a pluggable database or a part of a Container DB. Your DBAs will need to know about this distinction, but your developers do not need to know anything different.

NEXT:  Common User vs Local User

————

Dateline – Philadelphia, PA  – 05-May-2013 ●

A couple of years ago, I heard President Obama use the acronym STEM in a speech. Stanczyk has always been interested in science & mathematics and  through a funny quirk in my education I took a computer science course in high school. Thereafter, a life of engineering emphasizing computer software engineering & Very Large DataBases (VLDBs) ensued. So with my life, I have embraced, Science, Technology, Engineering & Mathematics (STEM).

About a year ago I got an idea, ‘S.T.E.M. Cell™’ which I will more fully develop. But I first wanted to trademark the name while I develop the concept. Hence the ‘™’ sprinkled about this page. I wanted to write more upon the STEM topics, so I added this page, as an offshoot of my blog about a topic I love, but not the central purpose of my blog — still a passion non-the-less.

Where did STEM, the acronym originate? I cannot find an earlier reference to STEM before Representative Vernon Ehlers  (R-MI)in his 2010 article (Reflecting On STEM Education) from The Hill. In that article he references STEM as a 2005 bipartisan committee taking the forward looking view to fund Education in these fields. He also indicates that STEM evolved from the earlier use of the discordant sounding acronym, SMET (pre-2000, but actual year, not specified).

As befits a jester’s ruminations, it is a play on the words (and concepts) of a stem cell that can evolve into more specialized purposes. That is my page’s meme  and I am sticking to it. I hope others will too.

Tell Me Your Thoughts ...

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 370 other followers

%d bloggers like this: