Tuesday, July 23, 2013

Oracle Database Preinstallation – Part 2



Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 


I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.
Contact: Franz

Oracle Database Preinstallation – Part 2
System Architecture
Here we are just going to verify that the system architecture can run the software.
$ uname –m
Now you need to crosscheck with the Oracle documentation, being especially careful with regards to versions.  If things do not match up exactly here, then you will not be able to have a successful install.  Typically you will need to give these findings back to business or management.

Disk Space Requirements
Below are the minimal requirements for installing the Oracle database 11.2.
=> 1GB of space in the /tmp directory
$ df –h /tmp
If there is not enough space, then you need to address this issue, before continuing.  You can address this issue by deleting unnecessary files form the /tmp directory.  You may consider resizing the /tmp directory.  When you configure Oracle, make sure that you set the TMP and TMPDIR environment variables to appropriate values.

Depending on the installation type, there would be different space requirements, for example:
Installation Type
Requirements for Software Files in GB
Enterprise edition
3.95
Standard Edition
3.88
Installation Type
Disk Space for Data Files in GB
Enterprise edition
1.7
Standard Edition
1.5
Installation Type
Requirements for Software Files in GB
Enterprise edition
4.35
Standard Edition
4.22
Installation Type
Disk Space for Data Files in GB
Enterprise edition
1.7
Standard Edition
1.5


The bottom half is the specific requirements for Linux x86-64.  Each OS will have slightly different requirements.

Before you start the installation you should determine the amount of free space on the system.
$ df –h

Don’t forget that additional free disk space is required on your file system or ASM disk group, if you are using the fast recovery area, and automated backups.  Make sure that you have enough space for this configuration, because otherwise the system can potentially hang when it runs out of space.  It is designed to hang, so that the integrity of the data is protected, rather than availability by default.  Think of it this way, not too much point in having things available if the data that you see has been corrupted or compromised.  Rather have too much space allocated for the fast recovery area to start with.

Display Requirements
The minimum resolution for Oracle Database 11.2 is quite high.  The tools will not work on a Display resolution of less than 1024 X 768.  Perhaps a good idea to make sure that you have a decent screen or monitor, before you even start your pre-installation checks.

Franz Devantier,
Need a database health check?
devantierf@gmail.com

Classifieds


No comments:

Post a Comment