Installing Oracle DataBase Server 12.1 on Windows 2008 Server

This document describes one of the ways to install an Oracle database on Microsoft Windows 2008 Server.

It should be used if you are just starting to learn the basics of Oracle database administration. If you need to use it in a production environment, you must ensure backup, multiplexing of critical database files, and properly configure system parameters.

If you find errors, inaccuracies, typos, or know better methods, write to the chat or email.

Documentation:

• Official Documentation
  

Distributions:

• Database Distributions and Additional Software
  

Before Installation:

• Before Installation

Creating a VirtualBox Virtual Machine for Installing Oracle Database on Windows 2008 Server:

• Creating a VirtualBox Virtual Machine for Installing Oracle Database on Windows 2008 Server

Database Installation:

• Installing Oracle DBMS (DataBase SoftWare)
• Creating Remote Server Connection Service (Listener)
• Creating a Database Instance

After Installation:

• After Installation

Ensuring Additional Fault Tolerance and Reliability:

• Setting FAST RECOVERY AREA Parameters
• Creating a Backup of the Created Database (Cold Backup)
• Multiplexing Controlfiles
• Multiplexing Redologs
• Enable ARCHIVELOG Mode
• Multiplexing Archivelogs
• Changing Data File Location
• Extending Tablespaces (Creating Additional Files for Tablespaces)
• Enable FLASH BACK Mode
• Final Backup (Hot Backup)

Connect to the Database from a Client Computer:

• Installing Oracle Client 12C (32 bit) on Windows 7 (64 bit) (64-bit client does not work with programs like PL/SQL Developer)