Saturday, July 06, 2013

Oracle Database 12c - notes 1

I now have a functional Oracle Database 12c Lab environment which consists of a bunch of x86_64 computers networked together.  (And some that are still pending, for the RAC exercise.)

Configuration:

SAN:
  1x AMD-based homegrown computer running OpenFiler 2.99 as iSCSI server

Monitoring and Support (licenses includes with Database):
  1x Oracle Linux 5u6 for OEM 12c Cloud Control
   - DB 11gR2
   - OEM 12.1.0.3
   - Cloud Control agent pushed to all machines BEFORE any additional s/w set up

  1x Oracle Linux 5u8 for Oracle Internet Directory
  - DB 11gR2,
  - RCU 11.1.1.7.0
  - WebLogic Server 10.3.6
  - Oracle Identity Management Suite 11.1.1.7.0 selected for OID
  - all targets displaying on Cloud Control

Test Machine 1
  - Oracle Linux 5u8, 48GB RAM
  - Standalone Grid installed for ASM
  - ASM 12.1.0.1
  - 1x DB 12.1.0.1 EE Container using ASM with 1 Pluggable DB 
  - 1x DB 12.1.0.1 EE Container using File System with 1 Pluggable DB
  - all targets displaying on Cloud Control

Test Machine 2
  - Oracle Linux 5u8, 4GB RAM
  - 1x DB 12.1.0.1 EE Container using File System with 1 Pluggable DB
  - all targets displaying on Cloud Control and EM Express

Test Machine 3
  - Oracle Linux 6u3, 4GB RAM
  - 1x DB 12.1.0.1 SE Container using File System with 1 Pluggable DB
  - 1x DB 12.1.0.1 EE non-Container using File System
  - all targets displaying on Cloud Control and EM Express

(Still to come:
   Test machine 4 will host GSM.
   Test machines 5-7 will have OVM and RAC 12c.
)

Results:

     84 Targets in OEM Cloud Control, all showing Green!

Initial Notes: 
  1. I needed to upgrade to OEM 12c Cloud Control 12.1.0.3 as 12.1.0.2 did not have the plugins to monitor Database 12c (production release). 
  2. Standard Edition supports 1 (one) pluggable database, if you chose the container architecture.
  3. Selecting both Cloud Control AND EM-Express during DBCA screws up EM-Express
    1. You need to install using EM-Express ONLY and discover manually with CC later.
  4. Separation of duty configuration works - almost correctly.

No comments: