Oracle Database - 12c Installation on Windows 64 bit

About

Installation of Oracle Database 12c (12.1.0.1.0) on Windows.

You can download the oracle software from OTN or better the latest patch from Oracle Company - My Oracle Support (MOS).

Prerequisites

Hardware

  • Disk space: Typical Install Type total: 10 GB
  • Physical memory (RAM): 2 GB minimum

Software

setx ORACLE_HOSTNAME %COMPUTERNAME%
SUCCESS: Specified value was saved.
::Restart the shell 
echo %ORACLE_HOSTNAME%
HI-LAPTOP-NGD
  • Verify that the system drive on your computer has default share configured on it with net use:
net use \\%COMPUTERNAME%\c$
Local name
Remote name       \\HI-LAPTOP-NGD\c$
Resource type     Disk
Status            Disconnected
# Opens           0
# Connections     1
The command completed successfully.

Steps

  • Configure Security Updates: Pass
  • Software Updates: Provides you Mos Id
  • Installation Options: Create and Configure a database
  • System Class: Server Class (because I want to be able to choose all options)
  • Grid Installation Options: Single Instance Database Installation
  • Install Type: Advanced Install
  • Product Languages: English
  • Database Edition: Enterprise Edition
  • Oracle Home User Selection: Windows Built-in Account. This account is used for running the Windows services for the Oracle home.
  • Installation Location: (Default)
  • Configuration Type: General Purpose (It could be Data Warehousing)
  • Database Identifier:
    • Global Database Name: orcl.HotITem.local
    • Oracle System Identifier (Sid): orcl

  • Configurations Options:
    • Enable Automatic Memory Management
    • Characters Set: UTF-8
    • Create Database with Sample Schemas
  • Database Storage: File System: C:\app\gerard\oradata
  • Management Options: No Cloud Control
  • Recovery Options: No Recovery
  • Schema Passwords: The same: manager1
  • Summary: Response File: dbrspwindows12c.zip
  • Database Configuration Assistant:

  • Finish

Post Task

Trigger

The pdb's are standard not opened (but mounted).

CREATE OR REPLACE TRIGGER open_pdbs AFTER STARTUP ON DATABASE 
BEGIN 
   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 
END open_pdbs;
/

Script

Appendix

Users created during the installation

  • SYSTEM
  • SYS
  • LBACSYS
  • OUTLN
  • FLOWS_FILES
  • DVF
  • MDSYS
  • ORDSYS
  • DBSNMP
  • WMSYS
  • APEX_040200
  • APPQOSSYS
  • GSMADMIN_INTERNAL
  • ORDDATA
  • CTXSYS
  • ANONYMOUS
  • XDB
  • ORDPLUGINS
  • DVSYS
  • SI_INFORMTN_SCHEMA
  • OLAPSYS
  • ORACLE_OCM
  • SYSKM
  • GSMCATUSER
  • MDDATA
  • SYSBACKUP
  • DIP
  • SYSDG
  • APEX_PUBLIC_USER
  • SPATIAL_CSW_ADMIN_USR
  • SPATIAL_WFS_ADMIN_USR
  • GSMUSER
  • AUDSYS

Support

A database instance with the specified identifier already exists

After suppression of an old database software, you may still get this errors:

Oracle system identifier (SID):[INS-35075] A database instance with the specified identifier already exists.

Steps:

Bad Language on Em

Enterprise Manager uses the local en-us and not us. Be sure that this local is on the top if you want to see Em in English.

Documentation Reference


Powered by ComboStrap