Tuesday, 3 March 2015

Installing Oracle Database 10g or latest versions on Windows

How we can install Oracle database on  Microsoft Windows 7 or Windows 8.
How to install oracle 10 g or higher version (Express Edition) database Package in windows 7.It provides SQL* PLUS development tool , Interface for running SQL commands easily  and developing databases for the organisation.

You can download free oracle 10g database or higher version just by a single signup.

  1. We will install from the downloaded version. From the directory where the DVD files were unzipped, double-clicksetup.exe.Oracle 10g can be downloaded from only file sharing sites because Oracle provides only latest versions of oracle database software at no extra cost.just register on oracle and you will get the links for downloading Oracle Software.           Note:for all the Oracle versions,installation procedure remain same.no need to worry about                            the installation.
  2.  The Oracle Universal Installer starts..........................................                                    Windows 7 or 8,automatically changes the recommended setting in your system and changes the appearance of your windows 7 to basic theme . A message may appear on the task bar while installation.                                             
  3.  You will perform a basic installation with a starter database.
  4.  Enter “orcl ” for the Global Database Name and “admin” for the Database Password and Confirm Password. Then click Next.                                                                                            
  5. The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported errors  by clicking the checkbox against each warning error (warnings are OK) before continuing. When the check successfully completes (with or without warnings), click Next.                                                       

  6. If you received any warnings, you can proceed. Click Yes.                                                                         
  7. Review the Summary window to verify what is to be installed. Then, click Install.                                
  8. The progress window appears on the screen,showing the progress of installation on your system.                                                                                                            
  9. Progress windows will automatically closed and the Configuration Assistants window appears.                                                                                     

  10. Your database is now being created as per the setting imposed at the begining.                                                                                                    
  11. When the database has been created, you can unlock the users you want to use. Click Password Management.                                                                                                                                     
  12. Unlock SHOE and HR users by clicking on the check mark in the Lock Account? column. Enter the same name as the user in the New Password and Confirm Password fields. For example, to unlock SH user, enter SHin the New Password and Confirm Password fields. Then, click OK.                 
  13. Click OK again.                                                                                                                                      
  14. Click Exit                                                                                                                                            
  15. Click Yes to confirm exit.                                                                                                                          
  16. To run SQL *PLUS ,Click Start Button on the Taskbar.You will find Oracle Database in  All Programs ,then go to Application Development Folder to find SQL*PLUS  .Open SQL*PLus by single click.NowEnter the Username "orcl"  and Password "admin".Host String will left blank and click Ok.You will get message "Connected to Oracle "  successfully and a prompt appears SQL>.
  17. Now you can execute SQL Commands or queries easily . Enjoy!!!!!!.... :-)                                          Watch  Oracle Installation video for more help. 
  18. https://www.youtube.com/watch?feature=player_embedded&v=xJLDXDOxtwA                                                                                                                                                 
  19. Thank you and have a nice day.Don't forget to subcribe my channel.