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:
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.
Then assure Oracle that you really do know what you are doing.
On the next screen, choose what you consider appropriate. For this example, we will go ahead and create and configure a starter database.
Next, choose server class, even if installing on a desktop class vm. The server class option gives more flexibility in installation options.
On the next screen choose advanced install. Once again, this gives us more installation options.
Next choose the appropriate language. This is a US English blog, so that is what we choose.
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.
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.
On the next screen, also take the default.
Next, choose your database type. This screen will not appear if you did not choose to create a database earlier.
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.
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.
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.
Click on the character set tab to choose the character set. I generally prefer to use the Unicode character set, AL32UTF8.
Since this is a training exercise, choose the install sample schemas option on the sample schemas tab.
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.
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.
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.
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.
Use the default groups. Changing these can sometimes cause problems.
The installer will next verify that the installation requirements have been met, and come up with a summary screens.
I am going to save a response file here, because I plan to do another blog topic on silent installation at a later date.
After clicking ‘install’, the installation commences.
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.
After running the root scripts, click continue, and then the database configuration assistant will start running to create the database that you defined earlier.
After software installation and database creation is completed, a screen will pop up with the database information, including the database express URL.
Save the URL for the em database express, and click ok.
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.
If you are new to oracle, I suggest that you explore this page to familiarize yourself with the oracle database.
This then is the easiest and most basic method of installing the Oracle database.