12c Database installation.

Hi Guys,

As everybody knows that Oracle is working hard on cloud computing and after 12c EM, 12c Weblogic…Here is 12c Database and FMW. In this post we will explore 12c Database installation process and top 12 features.

1. I am jumping straight to installation process, reason I think everybody knows about O.S. level setting.

2. Launch the Installer

 

Important points:

  1. You can copy the files location from installer for example you need to execute the scripts as root user , just select the location from installer and ctrl +c and simple click on linux server. It will past it.
  2. You can create container database during installation.
  3. You can register database with EM 12 C during installation.
  4. During database creation process you can see the ‘Activity log’ and ‘Alert log’.

I don’t want email notification.

It is not software update.

 

I want to create and configure oracle database.

Server class

Single instance.

Let’s explore advance installation.

I selected UK English also.

EE

You can choose the right home base and home.

Location of inventory directory.

Select the type of database you want to create.

Make a note there are 3 tabs in this screen.

 

Top 12 features of database 12c.

1.            Pluggable database is a neat feature. Basically, you create a container database (CDB) that contains all of the oracle level data and data dictionary. You then create pluggable databases (PDB) that contain user data and the user portion of the data dictionary. Since the PDB files contain everything about the user data, you can unplug a PDB from a CDB and plug it into a different CDB and be up in seconds. All that needs to happen is a quick data dictionary update in the CDB.

2.            Duplicate Indexes – Create duplicate indexes on the same set of columns. In 11.2 and below, if you try to create an index using the same columns, in the same order, as an existing index, you get an error. In some cases, you might want two different types of index on the same data (such as in a data warehouse where you might want a bitmap index on the leading edge of a set of columns that exists in a BTree index).

3.            Implicit Result Sets – create a procedure, open a ref cursor, return the results. No types, not muss, no mess. Streamlined data access (kind of a catch up to other databases).

4.            PL/SQL Unit Security – A role can now be granted to a code unit. That means you can determine at a very fine grain, who can access a sepcific unit of code.

5.            MapReduce in the Database  – MapReduce can be run from PL/SQL directly in the database. I don’t have much more info than that.

6.            Interval-Ref Partitions – Can now create a ref partition (to relate several tables with the same partitions) as a sub-partition to the interval type. Ease of use feature.

7.            SQL WITH Clause Enhancement – I want to see some examples of this one. In 12c, you can declare PL/SQL functions in the WITH Clause of a select statement.

8.            Catch up with MySQL – Some catch up features: INDENTITY columns (auto-sequence on a PK), can now use a sequence as a DEFAULT column value, (there’s another that I cannot remember right now).

9.            32k VARCHAR2 Support – Yes, 32k varchar2 in the database. Stored like a CLOB.

10.          Yeah – Booleans in SQL (sort of)  – You can use booleans values in dynamic PL/SQL. Still no booleans as database types.

11.  Execute SQL from RMAN, refresh single datafile to and from standby.

12. Rolling forward synchronization of standby.

July 15, 2017 · Sanjay · No Comments
Posted in: 9. DB 12c

Leave a Reply

You must be logged in to post a comment.