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. For Companies:Free
Database health check, for your database installation. One months free
database support, for you, as a proof of concept. For individuals:Refer
me to a company for a database support contract.=>
I will then give you 10% of the monthly contract value, for the duration of the
contract. Plus when the contract is extended or renewed you will still
get 10% of the monthly contract value, until I no longer support the company,
sometime in the future.=>
This 10% is my marketing budget, so if you refer me to a company I will give
you my marketing budget. Now that is probably the best deal you will ever
get for a referral.Contact: devantierf@gmail.com Oracle Grid
Infrastructure – Part 1Oracle Grid Infrastructure for a standalone server provides
support for the Oracle database, including volume management, File system
support, and automatic restart capabilities.
If you are going to use Oracle Automatic Storage Management (ASM) or
Oracle Restart, then you must must install Oracle Grid Infrastructure, before
you create the database. Oracle 11.2 Grid Infrastructure includes two infrastructure
products into a single set of binaries, that is ASM and Oracle Restart. ASM is Oracles Volume Manager as well as a
file system that supports both single instance Oracle database’s, as well as
Oracle Real Application Clusters (RAC).
ASM is Oracles recommended storage management solution, and is the
superior alternative to conventional volume managers, file systems, and raw
devices. Oracle Restart improves the availability of Your Oracle database
11.2 installation.=> In the case of a hardware or software failure, Oracle
Restart will automatically start all of the Oracle components. ASM, Oracle NET Listener, database services,
and the Database instance.=> Oracle Restart will start the Oracle components in the
proper order when the database host or server is restarted. => Oracle Restart will run a periodic check to monitor the
status of the Oracle components. If a
check fails for whatever reason, the the component is shut down and restarted. If you are going to use Oracle ASM 11.2 and or Oracle restart, then
you must install Oracle Grid Infrastructure for a standalone server, before you
install and create the database. You can
also manually register the database with Oracle Restart after you have created
the database. Remember that Oracle Restart
is only used in single instance or non-clustered environments. Requirements for Oracle Grid Infrastructure
InstallationYou will need to meet certain minimal requirements, before
you can install Oracle Grid Infrastructure 11.2. Memory, Disk space, and the configuration of
the environment are important. Memory
RequirementsThe memory requirements for Oracle
11.2 for a standalone server for Oracle Grid Infrastructure.=> minimal of 1.5 GB of
RAM for the Oracle Grid Infrastructure.
Plus a minimal of 1 GB of RAM for the Oracle Database, if you install a
database as well. That comes to an
abosolute minimal of 2.5GB. Oracle recommends that you
should have at least 4GB of RAM available if you are going to install Oracle
Grid Infrastructure and an Oracle Database.
Remember that if you install 4GB of RAM, a portion of that RAM will be
reserved or used for management overhead, so to have a clear 4GB of RAM, you
need a little bit more than 4GB of RAM.$ grep MemTotal /proc/meminfoMemTotal: 1020876 kB As you can see in this case,
I need to install more memory, before I can continue with the
installation. You also need to take into
account your settings for HugePages in Linux, when you determine how much RAM
you need to install. HugePages allocates
non-swappable memory for large page tables, using memory mapped files. The Memory allocated to HugePages is lost for
other purposes, so you will need to deduct the amount of memory allocated to
HugePages, in order to determine your available RAM. This adjusted RAM is then used to calculate your
optimal swap space.
Of
course you must start off by checking what your configured swap space is:$
grep SwapTotal
/proc/meminfoSwapTotal: 2064380 kB You will need to refer to the
Operating System documentation for the details on configuring additional swap
space. Tot display your RAM and SWAP
space configuration you can type in “free”.$
free total used free
shared buffers cachedMem: 1020876 646860
374016 0 31048
305976-/+
buffers/cache: 309836 711040Swap: 2064380 0
2064380 You will notice that the RAM
and SWAP space do not seem to be optimally configured. However because the relationship between RAM
and SWAP keep changing under different load conditions, you will need to take a
number of readings, before you have a fairly accurate reading. If you really want to optimize your RAM/SWAP
relationship, then you can contact your Operating System vendor for additional
guidelines. The guidelines given here
are more general, so the guidelines from the OS vendor will be more optimal. Disk Space
RequirementsYou will need at least 5.5 GB of disk space available, and at least 1GB
of space in the “/tmp” directory.$ df -k /tmpFilesystem 1K-blocks Used Available Use% Mounted on/dev/mapper/VolGroup-lv_root 51606140 6023284
42961416 13% /So you can see that there is sufficient space available in the /tmp
directory.If there was not enough space available, then you could delete unneeded
files from the /tmp directory.When you set the Oracle User’s environment, remember to set the TMP and
TMPDIR variables. If necessary you can extend the file system that contains the /tmp
directory. You may need to contact the
system administrator for advice on extending the file system. Configuring the
User’s EnvironmentYou need to set the
environment for the Oracle Grid Infrastructure software owner user’s
environment. Make sure that the path is
set to the Oracle Base directory.$ export
ORACLE_BASE=/u01/app/oracleOracle Restart, and the
Oracle Database will be sharing this same Oracle base directory. In the shell startup file,
you must set the Oracle Grid Infrastructure software owner default file mode
creation mask or the “umask” to 022.
This setting will ensure that the installation creates files with 755
permissions. You need to set ulimit for
file descriptors and processes for the Oracle Grid Infrastructure software
owner. Finally you will set the
DISPLAY variable, so that you can use the OUI GUI for the installation. If you are going to install the Oracle
database in addition to Oracle Grid Infrastructure, then you will need to meet
the pre-requisites for the installation of the database as well. Franz
Devantier,Need
a database health check?devantierf@gmail.com ClassifiedsYear of
the Stem CellDevantier Hosting, from $2.75Host
then Profit GVOGlobal
Domains InternationalCash
in on BannersHot
Link CyclerA
to Z AdBoardAd
ViralizerTraffic Exchange ProfitsEasy DownlinesFast Cash and TrafficSimple SafelistsTraffic Wave - AutoresponderTraffic HooplaBusiness Related
Social Media
|
RAM
|
Swap Space
|
|
Between 1.5 GB and 2 GB
|
1.5 times the size of the
RAM
|
|
Between 2 GB and 16 GB
|
Equal to the size of the
RAM
|
|
More than 16 GB
|
16 GB
|
No comments:
Post a Comment