Posted on January 20, 2016
Tom Blakeley, Performance Architects
At Performance Architects, we have a lovely sandbox environment where many of us work on pilot programs, demos, and code snippets. It’s a nice central server that we all share access to, with plenty of horsepower and space (to blow things up). Recently, we went on a journey to revamp our installs on this server, including moving from Oracle Database 11g to Oracle Database 12c, upgrading Oracle EPM (Hyperion) to 18.104.22.168, and moving Oracle Business Intelligence to 12c. As I sat down to do the Oracle 12c install I thought it might be a good idea to throw together a simple guide – so here you go! FYI: This install is for Microsoft Windows x64 (Windows Server 2008R2).
Downloading the Assemblies:
- Obviously the first step is to locate and download the 12c assemblies/installers from Oracle. To begin, navigate to the following site: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index-092322.html
- We are installing on Microsoft Windows x64, so I’ll be downloading both File 1 and File 2. I’ve gone ahead and confirmed my Oracle credentials, and downloaded the two files to a DB12C Installers directory. This will serve as the home for my download files, and eventually the Installer I will unpack from these downloads.
- With the downloads complete, it is now time to begin the unzipping process.
- First thing to do is create a folder to house the Installer. As shown below, I’ve created a folder called “12C_Installer”.
- Next, I’ll unzip both of the Oracle assemblies into this 12C_Installer directory. I’m using 7-zip as my utility, as I find it to be quick at this. I’ll unzip the first file into 12C_Installer, and then the second into the subfolder I just created – winx64_12102_database_1of2.
- Once the files are unzipped the installation folder should resemble the below screenshot.
- With the files successfully unzipped I’ll navigate into the “winx64_12102_database_1of2” folder, down to the database folder.
- Once here, I’ll right click and run “setup.exe” as an Administrator. The 12C Installer should launch.
- From here we can begin the Oracle 12C Installation.
- First, I’ll go ahead and uncheck the tick box next to “I wish to receive security updates via My Oracle Support.” as I’ll prefer to do so manually. Then I’ll click Next. Note: Confirm the warning message.
- Here we are presented with a variety of installation options. I am going to create and configure a database. I’ll leave this checked, and click “Next.”
- On the next screen I’ve selected to perform a “Server Class” installation, as this yields the most configuration options.
- I am going to be performing a “Single Instance database installation” of Oracle Database 12C, so I’ll just go ahead and select the first option. Then I’ll click “Next.”
- I am going to perform an “Advanced Install” as I want to be able to make a few changes to passwords, and review my character sets.
- I am going to take the “Default Language” selection.
- I am going to be performing an “Enterprise Edition” installation.
- On the next screen I’ve chosen to use the built-in account as opposed to a separate user. I’ll be managing the services with the admin level account. I’ll also confirm that I do want to use a built in account.
- On the next screen I’ve specified my installation directory. Here I am going to install into a new folder called “oracle_12c_db”, clearly denoting where it is located.
- I am doing to perform a “General Purpose/Transaction Processing Database” install, as the database is likely going to have a mix of everything installed.
- Now I’ll give my database a name. Shown below is the default name provided by the installer. I’m also going to included the “Container” database, introduced as part of the 12c release.
- Next I’ll allocate an appropriate amount of memory for the database.
- I’m also going to select the “Unicode” character set on the “Character sets” tab.
- I’m not including the Sample schemas.
- I’ll go ahead and choose to use “File system” as my storage location.
- I won’t be using Oracle’s “Enterprise Manager Cloud Control” for this database install.
- At this point I could elect to create an “Enable Recovery” area for my database. I am choosing not to.
- From here I’ll go ahead and specify the schema passwords I want to use.
- Once those passwords are specified, the installer will perform some prerequisite checks.
- After the checks are performed, I have a chance to review my install. After I’ve reviewed my setup, I’ll save off the response file for record keeping.
- Now the install begins! You will likely see the database configuration window pop up towards the end of the install. Good time to get a cup of coffee and relax.
- Once the install is complete, you’ll have a working instance of Oracle Database 12c!
- You should now be able to access your install via SQL Developer, or Toad for Oracle.
The Oracle 12c installation and configuration is really straightforward. I hope this helps you get started!
Still stuck on install or want additional help with Oracle applications or databases? Send us a note at email@example.com or leave us a note in the comments below, and we’ll be sure to respond.
© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.