Thursday 14 July 2016

Oracle database installation capacity planning details

Capacity planning is an essentially important career profile that determines the resource demand in current, future. Personnel from infrastructure teams typically server engineers, DBA do take additional responsibility. Tools from popular vendors like CA BMC assists with capacity planning. This can be easily done using proper excel sheet with details on resources needed for the ongoing project, future project, growing trends etc. Now-a-days information is wealth. Bigdata in a way impacts capacity planning directly and indirectly as predictive trends in online space depends on data usage. This internally translates to capacity planning of the project. As a first step lets see what needs to be considered while planning installation of database. Oracle is a popular brand in use and lets take this exmaple
What is needed for installing an Oracle database?
Proper planning, good documentation, scheduling and appropriate execution is needed for proper installation of an oracle database.
What are the factors to be considered during planning of oracle database installation?
We need to make sure that we have adequate hardware resources, operating system resources, proper environment variable settings during planning oracle database installation
What are the environment variables to be set during oracle database installation?
ORACLE_HOME, ORACLE_BASE,ORACLE_SID,ORACLE_UNQNAME are some environment variables to be set during installation. These values should be obtained from system administration team beforehand and needs to be included in planning document
What is the first factor to be considered while planning an installation?
The first step is going to be capacity planning. This involves planning a database in accordance with availability of resources