Legacy

Oracle 11g (11.2.0.x) Database Installation

Overview

What follows is the most common way to install Oracle 11g for enterprise environments. Ideally you only want to install what will actually be used. This streamlines routine Oracle patches and makes your databases more secure. Removing unused components at a later date usually requires running scripts and various manual actions. Also, the removal of some components may require downtime.

Prerequisites

Download the Oracle Database installation files matching your OS. To download 11.2.0.3 you may need to do via the patchset (10404530).

For Windows it is ideal to run the setup as THE local Administrator account from 11g onwards. Not an Administrator "equivalent" account or Domain Administrator account. Create initial directories (c:\app, c:\oradata etc.) and set required OS privileges.

Procedure

1. Configure Security Updates
   Email: {DBA Email Address}
      If behind a secure network blocked to the Internet:
         [ ] I wish to receive security updates via My Oracle support.
         [x] I want to remain uninformed...
2. Download Software Updates
   If behind a firewall or in a secure area choose:
   (x) Skip software updates
3. Installation Option
   (x) Install database software only       
4. Grid Installation Options
   (x) Single instance database installation
5. Product Languages
   Selected Languages: {English} (use default)
6. Database Edition
   (x) Enterprise Edition 
   Deselect any unused components from [Select Options].
   Commonly selected:
      [x] Oracle Partitioning
      [x] Oracle Database Extensions for .NET
7. Installation Location
   Oracle Base:  C:\app\oracle
   Software Location:  C:\app\oracle\product\11.2.0.3\dbhome_1
8. Prerequisites Checks
   ...
9. Summary
   After reviewing select: Install

   Product installation runs...

10. Finish
    If successful you will see: The installation of Oracle Database was successful.
    Select: Close.

11. Apply the latest CPU patch if applicable.

Post Installation

For all that follows it is highly recommended that you set the Oracle environment at this time. If you are upgrading from an earlier version to 11g 11.2.0.3 don't set these until your maintenance window to perform the upgrade so as not to affect your production database.

Set Oracle Environment Variables

 ORACLE_BASE = C:\app\oracle
 ORACLE_HOME = C:\app\oracle\product\11.2.0.3\dbhome_1
 ORACLE_SID  = MyDB

Set Global Profile for SQLPlus

Edit $ORACLE_HOME/sqlplus/admin/glogin.sql to set common values.

SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER> "
SET LINESIZE 240
SET PAGESIZE 9999

Copy Standard Support Files to Server

Scripts
Tools (7zip/gzip, FireFox, Notepad++, Splinterware, SQLDev etc.)

Troubleshooting

If you have issues during the install you can run it in debug mode and review the log file. Example: setup.exe -debug -loglevel finest

The logs will be in: C:\Program Files\Oracle\Inventory\logs

Windows Environments

Create Shortcuts for SQLPlus

%ORACLE_HOME%\bin\sqlplus sys/Password as sysdba       <== Direct DB Connection
%ORACLE_HOME%\bin\sqlplus sys/Password@DB01 as sysdba  <== Connection via Listener

Set Oracle SQLPATH in Registry

Using regedit:

 Navigate to Oracle:  HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_Ora11g_home1
 Set value for entry: SQLPATH
 Example value:       C:\app\scripts\sql;

Set Windows Firewalls

Windows OS firewalls can interfere with Oracle connections to the database. You can disable them using the following:

 OS> netsh advfirewall set domainprofile  state off
 OS> netsh advfirewall set privateprofile state off
 OS> netsh advfirewall set publicprofile  state off

Set Windows OS DBA Users

Add any Windows users that will need to interact with the database to the local ORA_DBA group. For Windows 2008:

 My Computer -> Manage -> Configuration -> Local Users and Groups -> Groups (Add)

Set Windows Pagefile

Oracle performs better on Windows systems when the pagefile (virtual OS RAM) does not keep resizing. To achieve this set the Windows pagefile minimum and maximum size to the same value. Generally RAM x 1.5 is a good starting place. If this is not set as indicated you will probably get ORA-00445 errors and corresponding loss of service in time.

Write-Caching Policy

On some Windows 200n servers if write-cache buffer flushing is on for a disk(s) I/O performance will be abominable for the given disk(s)! To fix this enable "Turn off Windows write-cache buffer flushing on the device".

   Device Manager -> Disk drives -> 
   <Manufacturer_DriveType> Disk Device -> 
   Right-click Properties -> Policies tab
      [x] Turn off Windows write-cache buffer flushing on the device

Deinstallation

cd <ORACLE_HOME to Deinstall>\deinstall
OS> deinstall.bat
- If using the separate deinstall files.
  OS> deinstall -home <FullPathOfOracleHomeToDeinstall>
Follow the prompts to remove Oracle from system.

Example Session Prompts:

Specify all Single Instance listeners that are to be de-configured [LISTENER]:
Specify the list of database names that are configured in this Oracle home [DB1]:
Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]:
Specify the diagnostic destination location of the database [C:\app\oracle\diag\rdbms\db1]:
Specify the storage type used by the Database ASM|FS []: FS
Specify the list of directories ...[ ]:
Specify the fast recovery area location... [ ]:
Specify the database spfile location [ ]:

Do you want to continue (y - yes, n - no)? [n]: y

Process runs...

Output at end of process looks similar to this:

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################

############# ORACLE DEINSTALL & DECONFIG TOOL END #############

        1 dir(s) moved.
        1 dir(s) moved.

Post Deinstall Actions

Delete any physical directories not needed.
Ensure all services gone (should be).
Ensure all registry values gone (should be).

<- Legacy