Installing the Oracle Database (Basic Install)

In this post, I am going to cover the simplest of Oracle software installations. A single instance Oracle installation on a file system. The first step is to download the Oracle software installation files. The oracle database software can be downloaded from here: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html. Or, if you have an Oracle CSI and appropriate licensing you can download the latest patchset from My Oracle Support (MOS).

For this installation, we are using file system, so we need the first two files, linuxamd64_12c_database_1of2.zip and linuxamd64_12c_database_2of2.zip. Files 3 and 4 are required if you plan to user ASM, or are installing oracle Grid Infrastructure (GI).

1. Download the files to your database server. I will be using a virtual server that was set up using the methodology described here: https://dbakerber.wordpress.com/2015/09/23/installing-oracle-software-part-1-prerequisites/.

2. Unzip the database files. This will create a directory named ‘database’ under your current directory..

3. Start the installer:

cd database

./runInstaller

Uncheck the box about security updates, if you are already signed up it will just add to your volume of emails, which you probably don’t want.

clip_image002

Then assure Oracle that you really do know what you are doing.

clip_image004

On the next screen, choose what you consider appropriate. For this example, we will go ahead and create and configure a starter database.

clip_image006

Next, choose server class, even if installing on a desktop class vm. The server class option gives more flexibility in installation options.

clip_image008

On the next screen choose advanced install. Once again, this gives us more installation options.

clip_image010

Next choose the appropriate language. This is a US English blog, so that is what we choose.

clip_image012

Next, choose the appropriate edition. The particular download we are using only has enterprise edition, but a full download from otn.oracle.com will have both Enterprise and Standard Edition. For details about the advantages of each, I recommend a contact other than Oracle corp. Oracle will of course recommend the most costly option of Enterprise Edition. One possible source of information is the consulting firm House of Brick Technologies (http://houseofbrick.com/) , though as a consulting firm they do charge for their time. They can discuss the advantages of various Oracle editions, as well as virtualization of your database load.

clip_image014

I normally install in the default directory structure, /u01. Obviously this can change with your preference and company policies. But for this example, we will take the default file system.

clip_image016

On the next screen, also take the default.

clip_image018

Next, choose your database type. This screen will not appear if you did not choose to create a database earlier.

clip_image020

We are not going to choose the default oracle database name. This is one of those well known items that can lead to security holes.

clip_image022

We are going to name our instance dbatest. We will not create it as a container database, you can change this later if you want.

clip_image024

In the next screen, you choose the memory footprint. Note that by default, this installation will use Automatic Shared Memory Management (ASMM), not Automatic Memory Management (AMM). There is substantial ongoing debate among DBA’s on which method is better. If at some point you may want to use hugepages, you must use ASMM. Otherwise, the general opinion among DBA’s is to use ASMM. ASMM generally gives a little more control of memory usage, and most DBA’s prefer to use it.

clip_image026

Click on the character set tab to choose the character set. I generally prefer to use the Unicode character set, AL32UTF8.

clip_image028

Since this is a training exercise, choose the install sample schemas option on the sample schemas tab.

clip_image030

Next, choose the location of the oracle database files. I normally use ASM, but for this example we are using file system, so the default file location is fine. Change it if you require.

clip_image032

On the next screen, if you choose to register the database with OEM Cloud Control, click on the box. If you don’t want to register, or have no idea what it is, leave the box unchecked.

clip_image034

On the next screen, enable recovery if you choose. I am going to go ahead and enable recovery, and choose a location, since I may want to use this instance when I discuss recovery in a later blog, however, generally we don’t bother with recovery on test instances.

clip_image036

clip_image038

On the password screen, it is generally easiest to choose a single password for all schemas, then change them individually per your company’s standards.

clip_image040

Use the default groups. Changing these can sometimes cause problems.

clip_image042

The installer will next verify that the installation requirements have been met, and come up with a summary screens.

clip_image044

I am going to save a response file here, because I plan to do another blog topic on silent installation at a later date.

clip_image046

After clicking ‘install’, the installation commences.

clip_image048

After installation is complete, the prompt to run the root scripts will come up. If you have the appropriate access, run these scripts as the root user, otherwise you will need to have a system administrator or other person with root access run it.

clip_image050

After running the root scripts, click continue, and then the database configuration assistant will start running to create the database that you defined earlier.

clip_image052

After software installation and database creation is completed, a screen will pop up with the database information, including the database express URL.

clip_image054

Save the URL for the em database express, and click ok.

clip_image056

Then click on close.

At this point, your database is up and ready to use.

For an easy to use hypertext management front end, oracle supplies the database express, whose URL you coped earlier, htttps://oel64node.localdomain:5500/em, in my example.

Navigate to the database express URL using your web browser of choice.

clip_image058

If you are new to oracle, I suggest that you explore this page to familiarize yourself with the oracle database.

clip_image060

This then is the easiest and most basic method of installing the Oracle database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: