2016-09-07 0 Planning

Overview

The purpose of CLIFTON is to have development tools using a Oracle client connecting to a remote database server.

I am proposing to install the following software:

• Oracle Enterprise Linux 7
• Oracle RDBMS 12.1 client
• JDeveloper
• cx_Oracle package for Python

References

• Oracle Database Client Installation Guide, 12c Release 1 (12.1) for Linux
  • 2 Oracle Database Client Preinstallation Tasks
    • 2.2 Configuring Servers for Oracle Database
      • 2.2.2 General Server Minimum Requirements
      • 2.2.3 Server Storage Minimum Requirements
        • 2.2.3.1 Disk Space Requirements for Linux x86-64
        • 2.2.3.3 Disk Space Requirements for the Temporary Directory
      • 2.2.4 Server Memory Minimum Requirements
      • 2.2.5 Hardware Requirements for SQL Developer
• Oracle® Fusion Middleware Installing Oracle JDeveloper 12.1.3
  • 1 Preparing to Install Oracle JDeveloper
    • 1.5 Verifying Your System Requirements for Installing Oracle JDeveloper
• Oracle® Fusion Middleware System Requirements and Specifications
  • Oracle® Fusion Middleware System Requirements and Specifications 12c (12.1.3)
    • 5 Product-Specific Memory and Disk Space Requirements
      • Section 5.7, "Oracle JDeveloper Requirements"
        • Section 5.7.2, "Oracle JDeveloper Requirements on Linux Operating Systems"
• Oracle® Linux Installation Guide for Release 7
• Oracle® Linux Release Notes for Oracle Linux 7
  • 1.1 System Requirements
• Welcome to cx_Oracle's documentation!

Planning

Overview

What resources I am mainly concerned with at this stage are:

• Number of CPUs
• Minimum amount of Memory
• Minimum amount of Disk Space
• Required packages

OEL 7

Oracle® Linux Installation Guide for Release 7 referred me to Oracle® Linux Release Notes for Oracle Linux 7 for installation requirements.

According to 1.1 System Requirements,:

…A minimum of 2 logical CPUs and 1 GB of memory per logical CPU is recommended. Although the minimum disk space required for installation is 1GB, a minimum of 5 GB is recommended.

I think two (2) CPUs and consequently 2 GB of memory is excessive for a client installation. I will start with one (1) CPU while keeping the recommendation of 1 GB of memory in mind. However, I will go with the recommendation of 5 GB for disk space.

Oracle Client

According to 2.2.4 Server Memory Minimum Requirements, I need at least 256 MB of RAM.

According to 2.2.3.1 Disk Space Requirements for Linux x86-64, I need at least 1.8 GB of disk space.

JDeveloper

I plan to go with Oracle JDeveloper Java because I just want to develop Java applications.

1.5 Verifying Your System Requirements for Installing Oracle JDeveloper refers me to Section 5.7.2, "Oracle JDeveloper Requirements on Linux Operating Systems" which advises 4 GB of RAM and 90 MB for disk for the Java Edition.

This memory requirement makes the VM far too large for my VM farm of 16 GB servers. I will have to go without JDeveloper.

cx_Oracle

Without JDeveloper, I am left with basic programming tools like Python or Java. Since Python is now the trendy language, I will go with the cx_Oracle Python package to do my client programming.

The documentation at Welcome to cx_Oracle's documentation! does not mention any system requirements. I will assume that there is no special requirements.

Summary

It looks I will need the following:

1. One (1) CPU
2. 2 GB of RAM
3. 10 GB of disk
4. 1 NIC
5. Standard firewall settings: SSH

Resource Allocations

The only resource allocations I need are an IP address and a DNS entry. These have allocated as:

• IP Address: 192.168.1.201
• DNS: clifton.yaocm.id.au