Oracle12c Database Installation steps

[Brindavan_M]

Oracle12c Installation step on Linux

Summary:-

This document contains the steps that how to do the oracle12c Database installations steps on Linux.

Database: Oracle12c

OS Level    : Red Hat Linux 6

Author: Brindavan Mookaiah

Designation: SAP BASIS Consultant

Note: The steps are only suitable for NON SAP Oracle

Pre Installation Steps:-

   Step 1)

1. Download the software 12c http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=oc...

Step 2) Hardware requirements:

1. If Large-scale installation need to be use multicore processors with High availability.

      2. Recommended minimum RAM needed for Oracle is 2GB or more.

      3. Swap must be enabled double the size of RAM.

    Step 3) Disc Space & system meets

1. Disk space must be more than 8GB,

2. /tmp directory must have free space more than 1GB for error free installation.
3. Both x86_64 and i686 packages are required for installation.
4. Screen resolution must be more than 1024×768 resolution.

Introduction:-

The current version of oracle is 12c (C stands for Cloud) with cloud features. Oracle Database 12c makes the process far faster and simpler, enabling the high density of schema-based consolidation—without requiring changes to existing applications. To make this possible, a single, multitenant container database can now host many "pluggable" databases.

Step 1

    1. Login into OS with user “root”.

    2. Update /etc/hosts file with fully qualified name of server

[root@<hostname>]# cat /etc/hosts

   3. Check the Linux kernal version.

   [root@<hostname>]# uname -a

  4.  OS Packages (RPMs) requirements:

  5. Use  “oracle-rdbms-server-12cR1-preinstall” package to automatically install all required RPMs using “yum” OS utility.

   # cd /etc/yum.repos.d

  # wget https://public-yum.oracle.com/public-yum-ol6.repo

  # yum install oracle-rdbms-server-12cR1-preinstall -y

  6. Create Oracle user & Group base on your requirements

  7. Stet the value current ulimits in followings "/etc/profile"

  8 . Set the enviorment variable like below for example:

 

9.  Install the database (Note : You need X-manager or anyother tool to execute GUI to install Oracle DB)

[oracle@<hostname>]# cd /software/database

[oracle@<hostname>]# ls

[oracle@<hostname>]# ./runInstaller

It will ask the E-mail ID to registred to send oracle updates. If you don't want to  registre then just select the option skip  and continue.

Click "Next"

Select any of installation options, and click Next.

1) Here we select “Install database software only”.This option only installs the database binaries.

2) To configure the database, you must run Oracle Database Configuration Assistant after the software installation.

3) To upgrade 11G to 12C then select upgrade option

Then click " Next"

.

Here we select option "Single instance database installation".( This option installs the database software and the listener) and then click "Next"

Select the language and  then Click " Next "

You can select the Edition as per the requirement, Here we have select Enterprise Edition, and then click " Next"

The Oracle base path appears by default. You can change this path based on your requirement.

Specify Oracle Base, Software Location, and then click "Next".

The operating system groups are selected by default. You can also manually select the groups and select "Next".

. You should fix all issues before proceed to Next if you found any system requirements to install database mets.

If everything find then Click " Next".

Click " Install"

Run the "root.sh script" and then click "Ok".

[root@<hostname>]# cd /u01/app/oracle/product/12.1.0/db_1

[root@<hostname>]# sh root.sh

Performing root user operation for Oracle 12c

The following environment variables are set as:

ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.

Oracle12c database install sucessfully.

After Software installation and then create database using "DBCA"

Creating Oracle Database 12c (Container & Pluggable)

For beginners, default is good, but here we use advanced option to learn more.

Specify Container & Pluggable database name and then click " Next".

Click " Finish"

Click " Next"

Select what type of database you want to create (OLTP, Warehouse, General, or Custom). You can view detailed featured for all types by clicking “Show Details” button. Once selected, click “Next”.

Enter the Global database name and then click " Next"

Select the required Option and then click " Next" ( Here we have selected " Datbase Express"

Enter rhe password and then Click " Next"

Click " Next"

Select location of datafiles, Storage File System, Fast Recover Area as previously known as FLASHBACK and size. You can also enable archiving here and can setup Multiplex (multiple duplicate locations) for REDO & Control files.

You can select Database Vault & Label Security features here as per your requirement.

You can select the memory and click " Next".

Then check the sizing & character stets and then click " Next"

Dedicated Server Mode is most commonly used, but you can select “Shared Server Mode”

Select the Create " Database " and then click " Next"

The Next screen Summary and then click " Next"

Creating Oracle Database 12c (Container & Pluggable)

Once Complete, it will prompt you for “Password Management” of default accounts Note the URL: https://hostname:5500/em for managing database.

Give the URL in IE with user " system and password.

Oracle web login page

Oracle database home

Oracle Memory Management

Oracle Tablespace

Oracle Performance Hub

All the performance,backup, configuration can be see in web.