Oracle 10g Tutorial Part 1

This tutorial is the beginning of my Oracle tutorial series. You first need to install Oracle on your computer. These instructions are for Windows.

This is a tutorial to get you familiar with Oracle and its related technologies. Oracle is widely used for Enterprise applications.

You should download Oracle from this site: http://www.oracle.com/technology/software/products/database/index.html.

I am using Windows Vista for this tutorial so you should download the Oracle Database 10g release 2(10.2.0.3/10.2.0.4) for Microsoft Windows Vista and Windows 2008. If you are using another operating system, then download the version that applies to you.

You will need to accept the license agreement. Download the complete zip files (10203 vista w2k8 86 production db.zip)

You will need to have a username and password to create an account before downloading the software.

After you unzip the folder, execute the setup.exe file.

When the installation runs, you will see radio buttons for basic installation, or advanced installation. I would keep it set as basic installation. You will then need to enter a database password. I will call my password admin and the global database name will be called orcl.

Press next from the product-specific prerequisite check if you do not receive any errors.

Press Install when you reach the summary.

After the installation is completed, change the passwords for Sys, System, and Scott and unlock them. You do this by selecting the password management button.

I am going to change all the passwords to admin since this is a test environment.

press okay and exit to complete the installation.

You should reboot your computer for the changes to take effect.

To test your installation, go to start->programs->Oracle_OraDb10g_Home1->Application Development->SQL Plus

Input Scott as the userid and the password which, in my case, is admin. The host string you will leave blank. That would be used if you are connecting to a database that isn't on your local machine.

You should now be in the Oracle SQL*Plus console.

Go To Part 2