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

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