Oracle Database 12c Tutorials 1: How to install Oracle Database 12c on windows 7 By Manish Sharma

Oracle Database 12c Tutorials 1: How to install Oracle Database 12c on windows 7 By Manish Sharma


What’s up internet?
I am Manish from RebellionRider.com and today’s video is about how to install Oracle Database
12c on Windows 7 64 bit. Unfortunately Oracle database 12c is not yet available for 32 bit
windows environment. Also, if we talk about windows environment then Oracle database 12c
only supports Windows 7, Windows 8, windows server 2008, windows server 2008 R2 and windows
server 2012. You can follow the same steps for the installation on either of these versions.
Plus it’s highly recommended to have at-least 2 GB of main memory and 10GB of free disk
space along with the updated version of JDK which you can freely download from the Oracle
website. Before starting let me tell you first, that
I am going to install oracle database 12c on Windows 7 professional 64 bit machine.
The same steps can be followed for the versions that I mentioned just now.
So let’s start. First we need to download the Oracle Database
12c Setup files, for that, head over to www.oracle.com. Here on this website hover your cursor over
this Download menu and then choose this Oracle database link under the database section.
Doing so will take you to the Oracle Database Download page
On this page, you have to accept the OTN license agreement. After that come to this Oracle
database 12c release-1 section. Here as you can see we have two versions of Oracle 12c
namely – the Enterprise Edition and the standard, standard-1 and Enterprise edition. You can
download either of them according to your need. I will download this second version
which is standard, standard-1 and Enterprise edition.
And as I am going to install the Oracle Database 12c on windows 7 64 bit thus I will go with
the first link. Now we have to download these two files. You can either download them directly
from here or you can click this “See All” link. I will go with the latter option.
After Clicking the See All link you will be on this Oracle Database 12c R1 download webpage.
Here again first accept the OTN license agreement. And then download these 2 files.
To start the download you need to sign in on oracle website for that you need to have
a valid account here. If you have any then just fill the username and password and hit
the sign in button this will start the download. Otherwise you can create an account for free.
Just to save the time I have already downloaded both the files.
Now I will make a folder by the name of Oracle 12c and then I will move these freshly downloaded
files in that folder. Ok done let’s go to this folder.
Now as you can see both the files are compressed as zip so first we need to un-compress them
and extract content of these files. First I will un-compress our first folder.
It’s done. Now I will rename it from Database to Database 1
Again I will un-compress and extract the content of 2nd folder. Here we are now, and I will
rename this one from Database to Database-2. Now we have to go to the directory database-2
and then go to this folder Stage and then Components. Here you have to copy all these
5 folders After doing so, come to our base Directory
which is Oracle 12c. Now here this time open the directory Database-1 and then Stage and
then components and here paste those 5 folders which we copied from database-2 directory.
With this we are done with all the pre-installation process of Oracle Database-12c and we are
all set to start the installation. So come to directory Database-1 and here right click
this setup.exe file and choose run as administrator. This will start the OUI.
Step1: configure security updates. If you wish to have all the security notifications
on your email then you can provide your email address here otherwise hit next. Avoid this
warning it’s just saying that you haven’t provided the email address. Hit yes and move
ahead. Step2: Software updates. If you have Oracle
support credentials then you fill here and download the update or if you already have
downloaded the update then chose this 2nd option. Since in our case we just downloaded
the fresh and updated version of Oracle 12c hence just select the Skip Update option and
hit next. Step3: Installation option. Here we have 3
options: 1. Create and configure a database
2. Install database software only or 3. Upgrade an existing database
If you already have a database and want to upgrade that with Oracle Database 12c then
go with the 3rd option or if you just want to install the oracle software and don’t
want to create any database then go with the 2nd option. Otherwise if you want to create
and configure database along with installing all database software then choose 1st one,
as I am going to do here. So I am going to select the first option which is already selected
now Hit next and move to next step. Step4: System Class. Here you have 2 options
Desktop class and Server class. See if your system is capable for handling the load of
server class services then go with Server class or if you are installing Oracle Database
12c on your desktop or laptop then go with the Desktop class. I will choose the desktop
class. Which is already selected now hit next and move ahead.
Step5: Oracle Home user selection. Till the now the installation was pretty similar to
that of oracle 11g or 10g but here we have a different step. Now with Oracle database
12c you can create an Oracle home user at the time of installation. This user will be
responsible for running all Oracle home windows services. Note that, this user is associated
with an Oracle Home and cannot be changed to a different user after the installation.
Here we have 3 options; with the first option you can use any existing windows user. But
this user must be a standard windows user or say limited windows user and not the administrative
one. If you choose the second option then Oracle
will create a new standard windows user for you and then will assign this user as an Oracle
home user. And if you will chose the 3rd option then
oracle OUI will use Windows Built-in Account as the oracle home user.
Here I will choose the 2nd option and will create a new limited or say standard user
for my oracle home. I will name my user as RebellionRider- You
can give whatever name you want and I will set the password as “oracle”. Make sure
to note down this information somewhere safely because it will be required later to administer
or manage database services Hit next and move ahead
Step6: Typical Installation. This window will show you all the important configuration settings
of your Oracle Database 12c. Such as Oracle Base, that indicates the location of Base
directory for your oracle software which will serve as a top level directory.
Next we have Software Location which is very well known by the name db_home directory.
This directory will indicate the location where you can find all the binaries of your
oracle database. Next is Database file location. This field
can be used to set the location where all the important files like control files, Data
files and Redo logs will be saved by Oracle. Next we have database edition, here you can
choose what edition of oracle database 12c you want to install. I will let it be on the
default one which is Enterprise edition. Next is character set. Using this option you
can tell your database which method do you want it to use for saving the character data
into the database. You have 2 options you can choose either of them. I will leave it
on default. Then we have Global database name using this
field you can set the global name for your database this will also serve as the SID of
your database. Let it be on ORCL, You can give any name of your choice here.
In the next 2 fields you have to set the administrative password. This password will be used as the
password for privileged user such as Sys and System. For this demonstration I will set
my password as oracle only Make sure to note down global database name
and password safely. Next we have a checkbox saying create as container
database. Let it be checked. This option will create a database as container database that
can support maximum up to 252 pluggable databases. Next is pluggable database name. Here you
have to specify a unique name for your pluggable database. For this demonstration I will let
it be on default which is “pdborcl”, but if you want you can change it.
Before moving ahead I just want to make a small change in the directory path I just
want to add OracleDB12c directory here as a base directory. Its just to make directory
structure more specific in the system. It’s purely an individual choice if you want to
change it then its ok otherwise let it be on the default one
Ok then Click next and move ahead Avoid this warning; it says that the password
which I have given is not according to the oracle standard. Just hit yes here.
Step7: Next window will check for the entire Necessary prerequisite for oracle database
12c installation. If there is any error it will show you here. But fortunately we don’t
have any errors and are good to go. Next just hit the Install button. This will
start the installation of Oracle database 12c.
Just to save the time I am fast forwarding this process.
Here is our DBCA window. This utility will create and configure the database on your
system. This process is also time taking so again I am fast forwarding it.
Ok password management; Here on this window of DBCA you can configure and unlock the sample
accounts if you want. You can click this password management button which will open up a password
management window for you. Here just select the account which you want
to unlock and then uncheck the corresponding column to that account and provide the password.
For example let’s say I want to unlock the “Anonymous” account. For that I will first
uncheck this column and then I will write my password here in new password column and
then enter the same in confirm password column. Then just hit OK
Again avoid this warning, this warning is just saying that the password which we just
enter is not upto the oracle password standard. Just hit yes and move ahead
We are back on our DBCA window here as you can see we have all the necessary configuration
displayed such as Global Name of database, SID of database and the URL of enterprise
manager. I would suggest you to save this URL.
Here just hit Ok. Your installation is successful. You are free to close this window for that
just click close. Hope this video will help you in installing
oracle database 12c on you system. That’s it for today.
Please hit the thumbs up button if you liked this video, you can also comment and share
this tutorial with all your friends on your social networking.
And don’t forget to subscribe to my channel. Will see you soon till then take care
This is Manish from rebellionrider.com

Daniel Ostrander

Related Posts

57 thoughts on “Oracle Database 12c Tutorials 1: How to install Oracle Database 12c on windows 7 By Manish Sharma

  1. Manish Sharma says:

    A fitting ending to a great year with this latest video depicting a proper step by step installation of #OracleDatabase12c.

    Tags: #Oracle #Oracle12c #OracleDatabase #RebellionRider

  2. Computer Science says:

    awesome manish

    – via YtPak(.com)

  3. Hoe Keat Neoh says:

    ERROR "AddInstallUser ToGroupException_desc" how to fix???
    only 3 option there: "Abort", "Retry", "Continue"

    If i press abort, it will stop there on 66%
    if i press retry, the text box prompt out again and again
    i never try continue before

  4. Dharma Teja says:

    Thanks Manish.
    I had little knowledge on oracle  and i have seen many videos on youtube your videos are simply exact to the point and the best and Thank your for sharing your knowledge with us .

  5. Sreenivasa Pendlimari says:

    Nice video to watch. Very fast and quick

  6. Santhosh Kumar says:

    No words to say…Its just Excellent and simply super. Nice presentation.

    Thanks.

  7. Alvaro Parra says:

    wow dude you speak really fast and clear.

  8. Rajesh Goyal says:

    Great learning thanks!

  9. ShinyArjun Singh says:

    wow..

  10. RockstahRolln says:

    This is terrific! I subbed 🙂

  11. rEoOo says:

    Great Video , Thanks a lot

  12. Manvitha V says:

    Hi Mr. Manish
    your video was very nice.
    I have a doubt in this.
    What if we select windows built-in account in Oracle home user selection?
    what would be username and password for this?

    Thanks

  13. nirjhor khan says:

    Thanks Buddy
    you helped me a lot
    those who installed oracle 11g before and then uninstalled it from control panel
    and then again tried to reinstall it
    they must face some kinds of problems
    so they have to install 12c with this video. It really works.Have patience

  14. subodh pawar says:

    Software installation was successful. But some configuration assistants failed, were cancelled or skipped.

  15. Joe Smith says:

    You rawk!

  16. Ishaq Naseri says:

    How we can connect php to oracle 11g database?
    #help me sir

  17. Imran siddique says:

    Hi Sir,Great explanation very positive tutorial thats great learning and knowledge sharing..

  18. Charles Barnett says:

    Manish – I installed exactly like the video instructed me to.. I created several users and logins but none of them are working except the Anonymous user that I modified when the user/login table was displayed during installation. Do you have any suggestions on how to access the other users? I have the logins. I have a project that needs to be completed in a timely fashion and I can't get any of it done because the Anonymous user that was created does not have the correct permissions. Is there any way to modify these permissions in the current state that I am in (no admin privileges)? Thanks

  19. Dheeraj Kumar says:

    Nice Video, Sir Make a more videos for beginners like us………………………………………….

  20. Soul J. Miralles says:

    please help! when i started to install setup.exe and while OUI just check the temp location. it gives me a message "CreateFile() error 32 when trying set file time". What is this?
    Also give me a message "INS-30131" after i continue the first step.

  21. Marek Dobrodinsky says:

    Great job!

  22. Saikat Samadder says:

    how to use 'scott' user in this version? & how to use it using browser?

  23. Saikat Samadder says:

    Sir,
    I just forgot to save the url of oracle 12c after installation. How to get that link again? please help me sir.

    thank you.

  24. Arun Correa says:

    Very Informative. Thanks Manish

  25. srherry says:

    Thank you helped me lot .

  26. manali jain says:

    Helped me 🙂
    thanks

  27. Aparna Das says:

    what is the EM Express url? What can we use it for?

  28. Ashikul Abir says:

    which JDK file should download,please mention.

  29. saurabh tandon says:

    How to login into pluggable database …? I mean is there any default user for PDBs.

  30. Ezad Khan says:

    Hi Manish, Hope this finds you well !
    Could you advise how can i install 12C on 32bit Windows 7 professional
    Regards,

  31. Krishnan Aishwarya says:

    Nice tutorials a great work done by you . Please also upload all tutorials of oracle 12c

  32. R_shree Star says:

    Hi Manish Sir,
    My friend suggested to watch videos on SQL.
    There are also video's for Plsql, I would like to see Video's on Oracle 11g Admin 1 & 2. You are explaining very well All basic & deeply explained. Sir please upload video's. I have mailed you same before 6 month ago… plz plz plz Sir, Many online trainees also thinking same…

  33. dinesh yalagandula says:

    hi manish sharm
    while iam installing oracle 12c on oracle database configuration assistance i have this error msg please solve this

    Error while executing "D:oracle 12cappappleproduct12.1.0dbhome_1rdbmsadmindbmssml.sql".
    refer to "D:oracle 12cappapplecfgtoollogsdbcaorcldbmssml0.log" for more details.
    error in process: "D:oracle 12cappappleproduct12.1.0dbhome_1perlbinperl.exe

    i tried two times but its failed..

  34. Chirag Shah says:

    Can I install Oracle Database 12c Release 2 on my Window 10 Machine

  35. Amit Gautam says:

    hi can I have ur contact number

  36. Indian Muslim to Jihadi niklaa says:

    Nice Speach ….. Cool …. You Are good going ….  Fast teacher .!

  37. Indian Muslim to Jihadi niklaa says:

    but it gives Proxy Setting ?? Have you any idea …. Why this is giving ?? and what to do ….

  38. k shanmugasundaram says:

    sir I need your help ins-20802 Oracle database configuration assistant failed.The error message is case-The plugin failed the perform method
    how to fix the bug

  39. Johnny Phan says:

    nice video thank you my friend… Can I install database 11g and 12c in the same windows 7?

  40. Johnny Phan says:

    Hello Manis, Can you make a video on How to install Oracle Database 12c on Linux, Please?

  41. Samuel Maina says:

    nice stuff

  42. juvvigunta narasimha theja says:

    Quick and crisp. exactly what needed. Please make more!! 🙂

  43. Mohammad Haque says:

    Hi Manish, can you tell me why my 12cr2 installation failing for setting up PATH (Environment variable PATH set failed and it error says it is not fixable) Thanks.

  44. gaurav panwar says:

    I am failing to install oracle 12c on windows 7. firstly when i downloaded 12c it doesnot show me two options of db as it shows in your video. it shows me only one ,and when i downloaded it and extract it then while installation it stuck on 7th step. it shows error in database configuration assistant. my database configuration assistant window doesn't open. what should i do? please tell me.

  45. Prabath Shanaka Gurusinghe says:

    Fast and Clear. Excellent Tutorial. Thank you so much.

  46. sebas says:

    Excelent thanks, voice little accelerated some times.

  47. FARIA REHMAN says:

    there visiting on website not getting this database option need your help?

  48. leo gwangwadza says:

    i am getting an error when installing i have deleted the resigtries and tried to reinstall 5 times but getting an error.

    error while executing "C:apporacleproduct12.1.0dbhome_1RDBMSADMINdbmssml.sql". Refer to "C:apporacle product12.1.0dbhome_1dbmssml 0.log" for more details. Error in process "C:apporacleproduct12.1.0dbhome_1pearlbinpearl.exe"

  49. Awdhesh Ravi says:

    hey dude, I'm using oracle 12 c ..but i want to know username only ..i know password but i forgot username..tell me process plz

  50. DON'T VISIT THIS CHANNEL says:

    Can i install oracle 12 c on window 10

  51. Code Tourist says:

    Can we install Oarcel 12C in external hard disk and use it

  52. TAMIRU DEJENE says:

    super helpful! blessings,

  53. Orlando Rutaquio says:

    Thank you very much for your very interesting oracle 12c database tutorials.

  54. Ranjith Paruchuri says:

    hi i want to create a new user for oracle. it giving an error message as invalid common user or role name. could clarify it?

  55. Christian Martin says:

    Hello Manish, I have been using Oracle for 12c for the last 3 month and all over sudden I am getting this critical error message when attempting to log into Enterprise Manager " Fail to parse data returned by server“ I have never seen this error before and every attempt at finding a solution has been unsuccessful. I am rather a newbie in the world of Oracle DB. your help will be very much appreciated, So far i am able to connect to the database with SQL Developer, but when EM is giving me the critical error message

  56. imtiaj fahim says:

    Thank you,bro

  57. Niranjan Vunnam says:

    after installation can we delete unzipped database 2 folder

Leave a Reply

Your email address will not be published. Required fields are marked *