Oracle 12c CDB/PDB Initial Setup..Or..”Let’s ROLL!”

Installing the oracle 12c software is fairly straightforward *ahem*. But some small things did change..Of course when installed, one wants to dive in as soon as possible, like I do..but somehow I keep being sidetracked with searching on: “How does this work?” and “How was that again?”..

This post is a summary of steps where most of these issues are addressed, saving Googling until memorized.. 😉

Privileges

After creating a user (“testUser”), and be able to actually DO something with the schema:

SQL> grant resource to testUser;

In order to prevent the pesky: ORA-01950: no privileges on tablespace 'XXXX'

SQL> ALTER USER testUser QUOTA UNLIMITED ON USERS;

PDB admin

Listing the plug-able databases in the container db, and see if they are ready to roll..

COLUMN pdb_name FORMAT A20

SELECT pdb_name, status
FROM   dba_pdbs
ORDER BY pdb_name;

SELECT name, open_mode
FROM   v$pdbs
ORDER BY name;

— Starting all the PDB’s at once:

SQL> alter pluggable database all open;

– Switching from Container to Pluggable database (e.g.: pdb1):

SQL> alter session set container=pdb1;
SQL> sho con_name;
CON_NAME 
----------
PDB1

To ease the administraton/frustration: add this parameter to the listener.ora file:

USE_SID_AS_SERVICE_LISTENER=on

This way , one can connect to a 12c database without configuring all the connectors to use a service name..

Advertisements

About GemsOfProgramming

Beeing a previously enthusiastic Java programmer, I rolled into the Oracle Database Administration world. It turned out I got a knack for this, and since approx. 2000 I'm a full time DBA. My experiences touches lot of Oracle products like Forms and Reports 9/10, JDAPI, Application Server, Weblogic Fusion and of course: Oracle Enterprise Databases, JavaFX, Swing and other Java components.
This entry was posted in 12c, Databases. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

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