How to install Oracle Database 12C

Oracle continues to ease our customers’ efforts to standardize, consolidate, and automate database services on the cloud. What started more than a decade ago with pioneering features like Oracle Real Application Clusters and Oracle Automatic Storage Management now continues with Oracle Multitenant, which enables IT to tap fully into the benefits of the cloud, including resource sharing, management flexibility, and cost savings.

Pluggable databases

Consolidation is an important business strategy to reduce the costs of infrastructure and operational expenses. In many production database servers, a big portion of CPU cycles go unused. By consolidating many databases into fewer database servers, both the hardware and operational staff can be more effectively utilized.

But database consolidation is easier said than done. Critical issues such as database workload characteristics, the ability to maintain performance service levels, and point-in-time recovery needs of different databases must be considered during consolidation efforts. Ideally, consolidation would not only reduce the need to purchase and allocate less physical CPU, RAM, and I/O (because physical servers are underutilized), but would also reduce actual resource consumption (because multiple instances share some overhead). However, in the past, we’ve seen that co-locating databases physically in the same server does not reduce overall resource usage.

Oracle’s new pluggable database feature reduces the risk of consolidation because the DBA can easily plug or unplug an existing database to or from a container database. There is no need to change any code in the application. When the user connects to a plugged database, the database environment looks exactly as if the user had connected to a traditional database.

Further, pluggable databases do lower resource consumption. Memory and processes are owned by the container database and shared by all pluggable databases, improving resource usage overall. It is also easy to unplug a database and convert the pluggable database to a traditional database if required. In addition, you can back up and recover pluggable databases independently of the container database; you can also perform a point-in-time recovery of a pluggable database. Further, Resource Manager can be used to control resources consumed by a pluggable database.

In short, database consolidation can be done much more effectively with pluggable databases than ever before. Finally, we have a true cloud database.

Optimizer features

Version 12c introduces a few useful SQL Optimizer features, and most of these are automatically enabled.

Although Optimizer has matured over the years, it is still not uncommon for Optimizer to choose an inefficient execution plan due to incorrect cardinality estimates, invalid statistics, or even stale statistics. This can have dire results. A SQL statement estimated to run for a few seconds might take hours to execute if the chosen execution plan is not optimal.

How to install Oracle Database 12C

Step 1 – Run “Setup.exe”, It will start Oracle Universal Installer and it will check monitor.

Oracle Database 12C Setup

Step 2 – Select Installation Type, as per your requirement select the type of installation. If you are confuse with the selection read the brief installation guide.

Oracle Database Installation Type

 

Step 3 – Download Software Update.

Select one of the option from given options. Software update consist of recommended updates to the installer system requirement checks, PatchSet Updates (PSUs), and other recommended patches.

Oracle Database 12C Software Update

Step 4 – Select Product Language

Oracle Database 12C Product Language

 

Step 5 – Specify Oracle Home User

Use Windows Built-in Account or specify a standard Windows User Account (not an Administrator account) to install and configure the Oracle Home. This account is used for running the Windows services for the Oracle Home. Do not log in using this account to perform administrative tasks.

Use Existing Windows User

The account can be a Windows Local User, Windows Domain User or Windows Managed Services Account (MSA). You must provide a user name and password for a Windows Local or Domain User. For MSA account, which is a managed domain account, you only need to provide the user name.

For an Oracle RAC Database and Oracle Grid Infrastructure installation, you can only use a Windows Domain User Account.

Create New Windows User

Provide the user name and password for the Windows Local User that you want Oracle Universal Installer to create. Confirm the password. The new user that is created is denied interactive logon privileges to the Windows computer. However, a Windows administrator can manage this account like any other Windows account.

Use Windows Built-in Account

No user name or password is required. Oracle creates Windows Services using Windows Built-in Accounts (LocalSystem or LocalService).

For Database Server installations, Oracle recommends that you use a standard Windows User Account (instead of a Windows Built-in Account) as the Oracle Home User for enhanced security.

Oracle Database 12C Home User Selection

Step 6 – Specify Installation Location

Oracle Database 12C Install Location

Step 7 – Perform Prerequisites Checks

Verify that the target environment meets minimum installation and configuration requirements for products you have selected.

Oracle Database 12C Prerequisite Check

 

Step 8 – Summary

Oracle Database 12C Install Summary

 

Step 9 – Install Product

Oracle Database 12C Product Installation

 

Oracle Database 12c Product Installation 2

 

Step 10 – Installation Finish

Oracle Database 12C Install Completed

 

After Installation

Now, Open Run “SQL Developer”, you will have the following screens. Now you are done with everything. Now you are ready for development.

Oracle SQL Developer

 

Oracle SQL Developer Main Screen

Spread the love...Share on FacebookShare on Google+Pin on PinterestShare on RedditTweet about this on TwitterEmail this to someone