How To Install Oracle Database 12c on Windows 10 Professional 64 bit Manish Sharma

How To Install Oracle Database 12c on Windows 10 Professional 64 bit Manish Sharma


What’s up Internet? I am Manish from RebellionRider.com.
Today in this video we are going to learn how to install oracle database 12c on windows
10 professional 64 bit. Unfortunately oracle 12c is not available for 32bit architecture
operating system so if you are using one of them then I am really sorry.
If you are using any version other than Windows 10 Professional then also don’t worry you
can still follow this tutorial as steps for installing oracle database 12c are the same.
That being said let’s jump straight to the tutorial and learn how to install oracle database
12c on windows 10 pro 64 bit. In order to install the oracle 12c we have
to download the software which you can do by visiting the oracle website.
Go to the oracle.com and choose Download from the menu and then select Oracle Database after
that you will be here on the download page. First accept the license agreement. And come
to this oracle database 12c release 1 section. Here as you can see all the available edition
of oracle 12c is listed. Choose the one which best suits your needs. For this demonstration
I will choose the oracle database 12c Standard, Standard1 and Enterprise edition.
I will download the files from the first option which is Microsoft windows 64 bit as I am
installing the software on windows 10 professional 64 bit. We have to download these two files
and you can download these files either directly clicking on their name or by selecting See
All Link. I will choose the latter option. Once you click that See All link. You will
be here on Oracle database 12c download page. Here again accept the OTN License agreement.
And download these 2 files from the Oracle Database 12c Release 1.
To download these files you will need to sign in to the oracle website. If you have a valid
account on this site then it’s well and good otherwise you can register yourself here
and create an account which is completely free of cost.
After filling the username and password, as soon as you hit the sign in the file will
start downloading automatically. To save the time I have already downloaded these files.
Here are they. As you can see the content of both these files
are compressed and zipped thus we need to first extract their content. Let’s start
with the first file. Here we are now let’s rename this extracted
folder from Database to Database 1. Let’s do the same with our second file. Ok again
let’s rename this folder from Database to Database 2.
Next go to folder database 2 and then go to this folder Stage then go to the directory
components. And copy all the directories from this components’ folder.
Press control A to select all and now copy them.
Now we have to come back to our folder database 1 and here it is. Inside this you have folder
Stage, go to it and then go to the folder Components and here paste all those files
which we copied earlier. That’s it. Now we are all set to start the
setup and install the oracle database 12c on our windows 10. So let’s come to our
folder database 1 where we have our set up file.
Here it is. Right click the setup file and choose run
as administrator. Accept the warning and this will start your Oracle Universal Installer.
1st Screen On the first screen you need to provide your
email address if you want to receive all the notifications and news alerts from oracle.
If you do not want it then simply leave these fields empty and move to next. Accept this
warning as it’s just reminding you that you didn’t provide the email id. Avoid it
and move ahead. 2nd Screen
On this step you have options for installing updates to oracle database 12c if you have
oracle database credentials then choose the first option fill up the login form and download
the updates. Or if you already have downloaded the updates on your system then choose the
2nd option specify the file location and install the updates. 3rd option will let you proceed
ahead without installing any updates. This is the one that we are going to do now as
we just downloaded fresh and updated copy of oracle 12c software.
3rd Screen On the next screen you will be presented with
3 different installation options. You can choose any of them according to your needs.
In my case I want to install Oracle server software and want to create a database also.
Thus I will choose the first option. If you choose the second option then only
oracle server will be installed and no database will be created. You can create a database
after the installation of oracle server using DBCA. If you want to do that then I have a
video tutorial on how to create database using DBCA just for you. Link is in the description.
You can go with the 3rd option if you want to perform the upgrade of the database and
software. But I will choose the first option and will
hit next and move ahead. 4th Screen
In this step you have to choose between Server Class and Desktop class. If you are installing
this oracle database 12c on your laptop or desktop then go with the first option which
is desktop class. If you are installing this oracle 12c on a server which is capable enough
to handle the load of all the server components and processes then choose the 2nd option which
is Server class. In my case I am installing Oracle database
12c on a windows 10 professional which is installed on my laptop thus I will choose
the first option and hit next. 5th Screen
Till now the installation was pretty similar to the installation of oracle 10g and 11g
but here we have a different step. In this step we need to select or create a windows
user account for oracle database 12c. This account must be standard or say limited account
not the administrative one. As you can see we are provided with 3 options. 1st option
will let us use existing windows standard user if you have any. Using 2nd option we
can create a standard windows user which will be later assigned as oracle home. 3rd option
will help us in choosing oracle home from the windows built in default users.
I will go with the 2nd option and create a windows standard user and use it as my oracle
home. I will name my oracle home user as rebellionrider and will give it a valid password. You can
name your windows user whatever you want. Hit next and move to the next step.
6th Screen Here in this step you can configure the basic
settings of your database for example using first 3 text fields you can set the oracle
base location. Software location which will be your Oracle Home and database file location
which will be the location where oracle server will store all your important files such as
data files, control files and redo logs. Be careful while setting them. I am good with
default locations thus won’t change them. Using database edition drop down list you
can choose which database version you want to install. In my case it’s the enterprise
edition. Next is character set. Let it be set on default
as I am good with it but if you want you can change it.
Next field is global database name which will be the name of your database also server as
your database SID. You will need this while making connection with your database using
tools such as SQL Developer. By default it is set as ORCL. If you want
you can change it and give any other name but make sure to remember it. I suggest you
to write it down somewhere as your Database SID.
In the next two fields you have to give the password. This will be the password of your
administrative users such as sys or system. Ok be careful here, write it down somewhere
or remember it. This will be the password for your sys user or system user. Let’s
fill it up Make sure to check the create as container
database checkbox. This option creates our 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 am good
with the default name which is PDBORCL. So let’s hit next
Don’t worry about this warning – it is just saying that the password which we just
entered is not as per the oracle password standard. You can read this warning. Click
yes and move ahead. 7th Screen
Now OUI will check for the prerequisites such as hardware compatibility. If everything goes
well then we will be good to install it. If there is any error then OUI will show you
here. Fortunately no errors! Now hit Install. Doing so will start the installation.
This installation might take some time depending on your hardware.
Don’t go anywhere, there is one more important step left in the installation.
I don’t want to waste your time thus I will fast forward this process.
Here we are the last step where we will unlock the users. Click this password management
button. Now here in this password management window we have all the users which are by
default locked. You can unlock any of them. For example I want to unlock this user with
name Anonymous. For that I will uncheck the box which is in front of its name and give
it a valid password. Click ok now. Avoid this warning again as it’s reminding you that
the password is not up to the oracle standards. Just hit yes and move ahead. We are back again
on our DBCA windows. Here you can see all the important information regarding our oracle
database such as Global database name, SID of our database, location of the parameter
files and the link for our enterprise manager. I would suggest you to save this link somewhere.
Click ok and this installation is successfully done. Click close to close OUI.
That’s all we have to do to install oracle database 12c on windows 10 professional 64
bit. I have done a few videos on oracle database 12c explaining how to unlock HR sample Schema,
How to install sample users or schemas in oracle 12c and how to connect pluggable database
with SQL Developer using TNS services as well as how to uninstall oracle 12c. You can check
all these tutorial links in the description below.
If you like this video then please give it a thumbs up and share it with your friends
on your social media. You can tell me how you liked this video by leaving a comment
down below and tweet me @RebellionRider. Thanks for watching. I will be back soon with
another tutorial till then take care. This is Manish from RebellionRider.

Danny Hutson

100 thoughts on “How To Install Oracle Database 12c on Windows 10 Professional 64 bit Manish Sharma

  1. after setting oracle _sid and oracle_home i typed sqlplus /nolog
    but im not able to connect im getting "sqlplus is not recoqnised as an internal or external command,operable files,batch"
    what should i do??
    please help me out quickly!!

  2. When extracting the zip files your don't need to rename the extracted directories – the 2nd extract will automatically install into the correct directory tree structure on the original extract folder.

  3. Hi, Is anyone else getting an Error during the DB clone portion of the install? Specifically an ORA-01503: CREATE CONTROLFILE FAIL error regarding the SYSAUX01.DBF failing to open and an unable to read the header block to file error? I'm new to Oracle and I did some googling but havent found a solution to this error yet. Any help would be appreciated!

  4. The tutoring video is very easy to follow. I'm a novice in Oracle and never installed any Oracle before, just finished installation of Oracle 12c successfully without any errors. Thank you very much.

  5. Hello Mr. Manish, At the end of my installation I have an error: INS-20802: Oracle Net configuration Assistant failed error … Please I need your help. thank you

  6. hi manish sharma i have problem to run sql plus is not connecting user id and password invalid give me solution

  7. hello sir ,when i have install oracle 12c in windows 10 , and my pc is 64 bit when i have run 64bit setup file then this is it can show error this type"CreateFile() error 32 when trying set file time" please help me sir

  8. why i canot access to hr schemea from this database
    why everytime i want access to hr schema , make confg ,untill to connect hr schemea
    ????
    i can found way to make hr schemea always open

  9. Aloha Manish,
    I'm stuck at 66% installation process 'Copy Files' with the error message 'Failed to create 'my user name' Oracle Home User'. I pressed 'Retry' a few times and no progress. I've canceled the installation waiting for your input…

  10. Facing issue while installing Oracle 12c database in my windows 10 64 bit Enterprise.
    Setup is automatic closing while run the setup of orale 12c

  11. Hello Manish, Great video! I noticed that there is only one database folder upon unzipping the two downloaded original folders. No need to merge the components contents anymore. This may have been fixed by Oracle.

  12. In the password management window do we need to give the password? because i just want to unlock the account but not to change any password

  13. Mine is getting stuck at 70 percent on Saving Inventory. Nobody seems to have this issue. what is happening?

  14. Hi, am getting an error "AddInstallUserToGroupException_desc" while installing 12c on windows 8.1 Home edition. Please help

  15. I have got errors create control file failed and unable to read the header block of file . Please help

  16. hello sir there is problem when installing oracle12c , when installing it will stuck on last step at 91% database configured, sir please make a video how to get it's solution, or tell me how to reslove this ,if possible then mail me at [email protected]

  17. on the register page they want job details and that is the mandatory field…if one is not a job person than what to do?

  18. Hi Manish. Thank you very much for the video. I got a problem on installing Oracle database 12c to WIndows10 following this video.
    At the prerequisite check process, an error called "Environment variable "PATH" " occurred. The description says "This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. (more details)". However, the length of my system path is just around 300 letters, not so long. Even if I shorten more around 200, it did not work. Could you tell me how to solve it?

  19. Dear Manish,
    your video is amazing, but I do have a question though, what really happens if you uncheck the option of creating a container, does it completely act like previous versions of oracle databases such as 10 and 11, or what really happens when that option is un-checked? please it is important to tell us what happens….
    your sincere effort is greatly appreciated and you are the type who deserves full support all the time.
    thanks for everything.

  20. Thank you. Your demo is fantastic. Unfortunately, I am having the same issue when hitting the database configuration assistant. During the cloning of my database, the assistant errors with the following:
    ORA-01503: CREATE CONTROL FILE failed
    ORA-01565: error in identifying file'D:APP<my db>ORADATA<first half of db name>SYSAUX01.DBF'

    There are additional errors but I have stopped with the above. My database name is <4 characters.4 characters>. It seems that the second part has been cut off when creating files. Can you confirm this may be the case before I move ahead to uninstall this again and start over, using a database name with no '.'?

  21. By mistkly I am cancelling the installation in 88 Percentage ,so I try to reinstall the Oracle 12c but in installation typical installation error is found ,so please say how to solve this problem

  22. Hi Manish
    Thanks for the video.
    But when i am installing 12c it is hanging at some point i.e., at 70% and it is not throwing any error.
    Please can you assist.

  23. Hi Manish,I'm facing issue while installing at some point of time @91% even I waited more than 5 hours because at @70% it taken more than one hour.Could you please suggest me, do I miss anything or should I need do anything for this to complete.
    Thanks in Advance!
    Br,
    Swapna

  24. HI Manish, by seeing you video i have successfully installed oracle 11g release 2 and i have created a table in oracle database too. But the problem is when i try to connect to Oracle through a Python program i am facing the below error.

    cx_Oracle.DatabaseError: DPI-1047: 32-bit Oracle Client library cannot be loaded: "C:appSaiproduct11.2.0dbhome_1binoci.dll is not the correct architecture". See https://oracle.github.io/odpi/doc/installation.html#windows for help

    plz let me know hot to fix this. I am literally breaking my head on this, i spent lots of time googling it but no answer.

  25. Thanks a bunch I installed it successfully following ur steps…..Issue next is how to make a connection to database…..Any lesson on this pls?

  26. how i connect with SQL developer tool with 12c DB …….my 12c oracle DB path same as your D:drive……now please help me how i connect with SQL developer tool

  27. Great Vid !

    Manish – I have release 2, but i dont get the Database Configuration Assistant at the end. So I dont get password management and I cant setup the user accounts during installation.

    I cant seem to find a resource to do this otherwise – please advise 🙂

  28. Hi Manish, Thanks for the detailed illustration. My oracle Installation errors out during the DBCA process. I have followed all the steps as illustrated however not sure what is causing to fail. Not sure if this is something to do with the Permissions on my C Drive ?
    ORA-01994: GRANT failed: Password file Missing or Disabled.

    OS: – Windows 10 Pro on Mac book Pro
    Oracle:- 12.1/12.2 64 Bit Enterprise Edition

    Any help or guidance will be helpful.

  29. setup is stuck at 87%
    i did not last step pop up to unlock the user

    the detail log shows
    Starting 'Prepare for configuration steps'
    Starting 'Prepare for configuration steps'
    Completed 'Prepare for configuration steps'
    Starting 'Oracle Net Configuration Assistant'
    Completed 'Oracle Net Configuration Assistant'
    Starting 'Oracle Database Configuration Assistant'

    from last 1 hour ,any idea what can be done???

  30. Hi Manish, for my case I followed your procedure of how you copy and paste the component files from database 2 to component files from database 1 file but the installation setup wizard cannot even start. I don't know why.

  31. Hi Manish. Thank you very much for the video. I got a problem on installing Oracle database 12c to WIndows10 following this video.

  32. Hey, when I reach step 5, setting up locations and ssid : orcl and setting password
    After that when I click on next it a progress bar shows up, and it continues up till checking environmental path and suddenly the setup is closed, so nothing is installed
    Can u help with a solution for this?

  33. Thank you .very educative and practical.i have struggle to install this several times to no avail.it was so easy following you

  34. I followed the steps in this video to install the database but when i try to set up the connection on SQL developer, I keep getting an error telling me the username and password is incorrect when it isn't as I'd literally just set it up… confused

  35. Hey I did the same but when i am executing the setup.exe its just shows that black window and after that nothing happens

Leave a Reply

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