RSS

Tag Archives: Oracle 12c

Installation of Oracle 12c on Oracle Enterprise Linux 7

Last updated on December 15th, 2014 at 04:44 am

Dear Friends,
I had installed Oracle 12c database on Oracle Enterprise Linux 7 yesterday. I am sharing my steps which I had taken for installation. Hope you find this helpful.

Step 1: Download the OEL7 ISO for 64 bit from Oracle Edelivery (V46135-01.iso and V46138-01.iso)

Step 2: Open Virtual Box and Create New Virtual Machine choosing the OS option as Other Linux -> Oracle 64-bit.

Step 3: Point the CD/DVD to the ISO image downloaded from Edelivery site

Step 4: Change the boot sequence to CD/DVD, Hard Disk

Step 5: Create a shared folder with auto mount and read only option and point it to the setup location on the host machine.

Step 6: Start the Virtual Machine and follow the steps.

Step 7: Install Additional Guest Image – This will enable to access the shared folder on host machine.

Step 8: Install the RPM mentioned in the appendix section of this article.

Step 9: Copy the Oracle 12c database setup from the shared folder on host to the /u01 directory.

Step 10: Refer my previous blog post on installation steps here.

Installation Steps in OEL7

Installation Steps in OEL7

 

Login Screen in OEL7

Login Screen in OEL7

 

OEM Database Express 12c - Login Screen

OEM Database Express 12c – Login Screen

 

OEM Database Express 12c - Performance Hub

OEM Database Express 12c – Performance Hub

Some Points to remember:

1. Installation Guide by Tim Hall is available here – This contains tips to troubleshoot certain installation errors.

2. Useful article on OTN can be found here.

3. Installation Guide at Oracle Docs which I found useful is here

Appendix:

Download the rpm for oracle-rdbms-server-12cR1-preinstall-1.0-1.el7.x86_64.rpm from here

Download adobe flash player for Firefox browser, this will be required for the Oracle EM Database Express 12c. (flash-plugin-11.2.202.411-release.x86_64.rpm)

 
Leave a comment

Posted by on November 15, 2014 in DBA, Oracle

 

Tags: , , ,

10 Features in Oracle 12c for Developers

Last updated on November 26th, 2014 at 07:07 am

Dear All,
After a long break and holiday season, today I tried my hands on some new features in Oracle 12c for developers.
There has been flood of articles, blog posts, seminars, webinars, conference presentations, videos on Oracle 12c since its launch, which is making wave in the cyber world. Over the years I have learnt to overcome this overwhelming phenomenon in my own way.  The idea is to create my own list of favorite features in new release of Oracle Database and post it 🙂

But all that remained enigma until I tried some of the features today. I have narrowed down my list to 10 features for developers in Oracle 12c.

DH-082013-1.png-550x0

Source: ToadWorld – Oracle 12c understanding the version number

Did you know that Oracle release version number says a lot about the Oracle Database Product you are working on? There is a one article on understanding Oracle version numbers by Dan Hotka. In case you are interested you can access it on ToadWorld website here.

The presentation content for my Top 10 Features in Oracle 12c for Developers can be found here.

You can download the – setup script and demo script available on my website.

I would like to end this post by sharing a wonderful interactive guide on Oracle 12c. The interactive guide is available on Oracle website here.

Hope you find the content useful and it gives you head start to latest release of Oracle 12c.

Cheers!
Vijay Mahawar

 
Leave a comment

Posted by on February 1, 2014 in DBA, Oracle, PL/SQL

 

Tags: , , , , , , , ,

Steps for Installing RAC with ASM on Oracle Database 12c

Last updated on January 17th, 2016 at 06:56 am

Hi Friends,

In  continuation to my previous posts on Workshop on RAC and ASM and 12c New Feature Pluggable Database. Today I am posting the installation steps for RAC with ASM on the latest Oracle Database 12c release, which I managed to install on my laptop.

Disclaimer: Please consider this as only checklist and steps and not a end-to-end installation guide to install RAC with ASM on Oracle Database 12c.

Following is the list of steps which I had performed for my installation:

1. Download Oracle VM VirtualBox from here.
2. Download Oracle Enterprise Linux 6 from Edelivery

EDelivery-Oracle-12c-Database-Grid-

EDelivery-Oracle-12c-Database-Grid-

3. Download Oracle 12c Database for Linux 64 bit (2 Parts – size ) from Edelivery (highlighted in above image)
4. Download Oracle 12c Database Grid for Linux 64 bit (2 Parts – size ) from Edelivery (highlighted in above image)
5. Install VM Virtual Box and OEL 6 on VM Virtual Box.
VirtualBox Guest Additions Package can be installed from this location. Post installation it will prompt you to install the extension package which can be downloaded from here.
6. OEL6 comes with pre-installed oracle users and oinstall users. Ensure that you select the package oracle-rdbms-server-11gR2-preinstall available under system tools. More information on this is available here.
7. At this point, its better if you take the snapshot of your virtual machine. This would help you to avoid repeating the previous steps incase of any issues.
8. Setup the .bash_profile, grid_env and db_env in oracle user home directory.
9. Setup the public ip address, vip address, private address and scan address in the /etc/hosts file.
10. Create directory for oracle database and inventory.
11. Copy the Oracle Software and Grid Software to the path you had mentioned in the .bash_profile.
12. Go to the Grid/rpm directory and install rpm cvuqdisk-1.0.9-1.rpm.
13. Create ASM disks and make it shareable. Login as root  partition the disks created under /dev using fdisk command.
14. Install oracleasmlib-2.0.4-1.el6.x86_64.rpm. Use the oracleasm command to createdisks for asm using the disks created in step 12.
15. Clone the Virtual Machine for second node. Ensure that firewall on both the machine are disabled.
16. Configure the second node for Network (for public address and vip address)
17. Setup the SSH password less connectivity to avoid the user equivalence error.
18. Copy the Oracle 12c database files in the inventory location (under /u01)
19. Install the Grid (from /u01/grid/runInstall)
20. This will invoke Installer for Oracle Grid Infrastructure. The wizard includes 13 steps. Including mainly cluster configuration and Creation of ASM Disk Groups.
21. Now, the system is ready to install the Oracle 12c Database (goto /u01/database and run ./runInstaller)
22. At this point, its better if you take the snapshot of your virtual machine again. This would help you to avoid repeating the previous steps in case of any issues.
23. The above command will launch the Oracle Database 12c Release 1 Installer, which is again a 13 steps.
24. Login into the sqlplus and confirm the installation. As shown in below screenshot:
OEL6-12c-DB-RAC1

Some Errors which I came across while installing RAC with ASM:

1. OEL6 by default gets installed without desktop and GUI. Default package installation of OEL6 does not include desktop GUI installation. This was resolved by clicking on custom option and selecting the desktop view. (You can also choose either gnome or kde)
2. User Equivalence Error.  This was resolved by setting the SSH connectivity and disabling the firewall.
3. Network ethernet settings post clone were not set up properly this led to error while setting up the cluster settings at the time of GRID installation.
4. I missed out step to install cvuqdisk-1.0.9-1.rpm.
5. ASM location was not showing during the GRID installation. This was due to the missing oracleasm rpm.
6. First installation failed because of shortage of disk space. Only 25GB of disk space which was allocated. This was resolved by allocating 35GB to the virtual disk. In addition to this I had allocated 5GB to each ASM disks. Making the total space for the installation for 1 rac node 50GB and if I include the clone node the total installation used up 85GB. Since ASM disks were shared between the nodes.
7. During the Database installation. Database was showing as ‘orcl.localdomain’ by default. This had to be changed to RAC as configured in the .bash_profile file.

Hope you find this steps and content useful for installing RAC on Oracle 12c with ASM. Please feel free to leave your comments.

Happy ‘RAC’ ing 🙂
Cheers!
Vijay

Visit Vijay’s Oracle photo gallery here and know more about him here

 
Leave a comment

Posted by on August 28, 2013 in DBA, Oracle

 

Tags: , , , , , , , , ,

Oracle Database 12c: New Feature – Pluggable Databases

Last updated on November 26th, 2014 at 07:07 am

The much anticipated 12c version of Database was made available for download on 25th June 2013 on OTN here. The most important new feature in this latest release is the Pluggable Databases.

This will give a big boost and strong hold to Oracle in the Cloud technology and rightly ‘c’ in ’12c’ stands for cloud.

I have tried to depict this new feature of Pluggable Database in 12c using below image.

Pluggable Databases in Oracle 12c

Pluggable Databases in Oracle 12c

Hope my analogy to explain all important new feature of Pluggable Database is useful.to all my readers.

Cheers!
Vijay

 
Leave a comment

Posted by on July 7, 2013 in DBA, Oracle

 

Tags: , , , , , ,

 
snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake