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 SH, OE 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.

Monday, 2 February 2015

Speed Up Your Computer- Quick and easy

  Make your slower computer machine to run faster,preventing system crashes and free up the hard disk space with some essential computer tricks for speeding up your computer.
First of all,
#We will have to remove all the temporary files from your computer.As we know that these temporary files are created with every operation carried out  by the system and remain intact in the storage  after completion of task .hence slower down the performance of system.these files should be deleted from the memory.
here is method for deleting such files easily.
Trick:1
->Go to Run (Window Key + R)
->Type %temp% and Press Enter.

#Booting is the major issue when large number of programs are installed in the computer system.some programs may be queue with the booting programs while windows startup.these programs have the greater  impact over the booting time of system.Computer may take much more time to load all necessary programs as well as unwanted programs like Adobe Update,IDM Update,any software update etc in memory to start your computer
So, we have to  remove such programs which are not required while starting up of windows and improve the startup time and performance too.
Trick:2
->  in search box,type System Configuration
->Go to  Startup Tab,Uncheck unwanted programs of your computer and click Apply  and OK.
Warning :Don't uncheck any of the windows programs.otherwise System can't boot up next time.

#Use Disk cleanup Utility to remove unwanted files,Thumbnails,Temporary internet files etc from your system.

#Un-install the rarely used or unnecessary programs from your computer using computer control panel.

#Also ,change the graphics setting like windows themes,Screensavers etc .Don't install the theme outside the Microsoft store.these theme may have viruses or any suspicious programs,may cause malfunctioning.
 
#Always use geniuen operating system and good antivirus programs like Quickheal to protect your system from scam and viruses.
All these tricks are well explained in this video.if you like it please share.
Subscribe to my blog and youtube channel.
Thanks.
Author: Sandeep Kaundal