Home » Technology » Oracle Databases » Learn Oracle - Download and Install, Part 2

Learn Oracle - Download and Install, Part 2

© Lewis R Cunningham

This continues Installing an Oracle 10g Database. I have posted a word document, http://www.suite101.com/files/topics/196... , with screen. You can print that file and compare your screens with mine to help you follow along.

In the last article, the last step had you run the Oracle setup program. If you haven't done that, do it now. Below are the screens you will see and my recommendations for you. You should follow along screen by screen.

Welcome Screen

This screen is just Oracle's way of saying howdy. You can click on installed products to see if you have any oracle products installed already. Otherwise, just click on Next.

Specify File Locations

You can change these if you want to, but I would recommend leaving them as is so that later we'll be on the same page.

The fields on this screen are:

• Source Name: This is where the install is coming from. You should see your extract home followed by \stage\products.xml
• Destination Name: You may install different Oracle products to different Oracle Homes. The name you enter here will be the Oracle 10g Home name for this install.
• Source Path: When I talk about go to your Oracle home, this is the directory I mean. This directory is the root for your Oracle 10g database.

After making any changes, press Next.

Select Installation Type

I recommend accepting the default of Enterprise Server. The differences between the three types, excluding Custom, are minimal from our perspective. However, in the future, if you want to take advantage of a particular feature that is only available in the Enterprise version, you might as well install it now.

Press Next.

Select Database Configuration

We want a general-purpose database. We'll be testing many features of the database. Accept the default of Create a Database and General Purpose.

A transaction-processing database is optimized for small, fast transactions and a datawarehouse is optimized for large amounts of storage.

Specify Database Configuration Options

The Global Database Name is the name you will use to access your new database. When you connect to the database, you will give it a login ID, password and SID. The first two fields on this screen are the name and SID. You can name your Global Name differently than your SID but right now, I would not recommend that. I've named both db1. If you name yours db1, it may be less confusing for you later on when I refer to my database by name.

I also changed the Database Character set to English US7ASCII, but you can set this to your preferred language.