Tag Archives: database 12c

Open and Migrate Microsoft Access in Oracle SQL Developer 4

For many people getting start with databases revolve around using Microsoft Access (MS Access). MS Access is an entry level “database” (if you can call it a database) that Microsoft has been putting out for years. Often people want to move older MS Access “databases” into enterprise databases as they become reliant on the information […]

Tuning with ASH Analytics in #em12c

Performance tuning of the Oracle Database has always been a great thing to learn and a valuable skill for any database administer.  In a previous post, I talked about how to use the Active Workload Repository (AWR) and Active Session History (ASH) to performance turn a database.  In this post, I want to take a […]

SPFILE for a CDB vs. a PDB

Recently, I have had conversations with users about Oracle Database 12c.  One question that often comes up is, how does the database manage the parameters between a container database (CDB) and a pluggable database (PDB)?  In order to answer this question, I had to work with my pluggable database setup in a test environment.  Before […]

Installing Oracle Golden Gate 12c (12.1.2) along side Oracle Database 12c (12.1.0.1)

With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore.  One new feature is the new way of installing Oracle Golden Gate.  In the past, the installation was simple.  Just copy the zip/tar file to the directory you want to install it in and unzip/untar […]

Oracle Golden Gate 12c (12.1.2) released – Finally!!!!

Back in June, Oracle released Oracle Database 12c and everyone went nuts trying to download and start documenting the many new features.  One of the items within the 12c (database) release that I was curious about was how is Oracle Golden Gate going to work with multi-tenant databases.  As I was testing I noticed that […]

Change COMMON_USER prefix – 12c Edition

Earlier I wrote a post on the difference between COMMON_USERS and LOCAL_USERS within the Oracle Database 12c architecture.  I mentioned in that post that the COMMON_USER had to be configured with a C## or c## to identify the user as a common user.  This got me to thinking, what if I wanted to use a […]