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 2
Oracle ACFS and
Oracle ADVM Support
Oracle Automatic Storage
Management Cluster File System (ACFS), extends the ASM technology. With ACFS all of your application data is
supported in single instance as well as cluster configurations. ACFS is layered on ASM through the Oracle
Automatic Storage Management Dynamic Volume Manager (ADVM) interface. ACFS and ADVM are supported on Oracle Linux 5
and red Hat Enterprise 5 for Linux x86 and Linux x86-64.
|
Oracle Release
|
Operating System
|
Kernel
|
|
11.2.x
|
Linux x86: Oracle Linux 5 and Red Hat
Enterprise Linux 5
|
2.6.18 or later updates to 2.6.18
|
|
11.2.0.1
|
Linux x86-64: Oracle Linux 5 and Red
Hat Enterprise Linux 5
|
2.6.18 or later updates to 2.6.18
|
|
11.2.0.2
|
Linux x86-64: Oracle Linux 5, Red Hat
Enterprise Linux 5, SUSE Linux Enterprise Server 10 SP3 and later
|
2.6.18 or later updates to 2.6.18
|
|
11.2.0.3
|
Linux x86-64: Oracle Linux 5, Red Hat
Enterprise Linux 5, SUSE Linux Enterprise Server 10 SP3 and later, SUSE Linux
Enterprise Server 11 SP1
|
2.6.18 or later updates to 2.6.18
Oracle Unbreakable
Enterprise Kernel 2.6.32-100.34.1 and later updates to 2.6.32-100
|
|
11.2.0.3
|
Linux x86-64: Oracle Linux 6 (with
Oracle Unbreakable Enterprise Kernel)
|
Oracle Unbreakable
Enterprise Kernel 2.6.32-100.34.1 and later updates to 2.6.32-100
|
Security
Enhanced Linux (SELinux) is not supported on ACFS file systems.
Oracle recommends
that you create Oracle data files in Oracle ASM disk groups. Oracle does not support data files on ACFS
file systems. Of course ACFS is an available
option when you have configured Oracle ASM.
Also Oracle Restart does not
support ACFS resources on all platforms.
Oracle ACFS drivers must still be manually loaded and unloaded. Once Oracle ASM is running, Oracle ACFS file
systems must be manually mounted and unmounted.
Registered Oracle ACFS file systems are noted in the ACFS mount
registry, and are mounted when ACFS starts up.
The Oracle ACFS database home file systems can be managed in the same
way.
Managing Disk
Groups for Older Database Versions
In Oracle 11.2, Oracle ASM is
installed with Oracle Restart. Prior to
11.2 Database Configuration Assistant (DBCA) was used to perform administrative
tasks on Oracle ASM.
Migrating
Existing Oracle Automatic Storage Management Instances
Firstly you must shut down
all databases and applications using an existing Oracle ASM instance, before
starting with the upgrade. You can use
Oracle Automatic Storage Management Configuration Assistant (ASMCA), to upgrade
your existing ASM instance to a ASM 11.2 instance. Using ASMCA you can configure disk groups,
Oracle ASM volumes and Oracle ASM file systems.
If
during the installation of your Grid Infrastructure and Oracle ASM, ASMCA
detects that there is a prior version of ASM installed in another Oracle ASM
home. Then once you have finished
installing the ASM 11.2 binaries, you can then use ASMCA to upgrade the
existing Oracle ASM instance.
Oracle Automatic
Storage Management Installation Considerations
Prior to Oracle 11.2, ASM was
installed as part of the Oracle Database Installation. With Oracle 11.2, Oracle ASM is installed as
part of the Oracle Grid Infrastructure installation, which can be installed for
a standalone server or for a cluster.
If you want to upgrade an
existing ASM installation, then you first do the Oracle Grid Infrastructure
Upgrade, and then the ASM upgrade. If
you decide to use ASM instead of file systems for your database installation,
then you must first do an Oracle Grid Infrastructure installation, before you
start your Oracle Database Installation.
When you install Oracle Grid
Infrastructure for a Standalone Server Installation, Oracle Automatic Storage
Management Configuration Assistant (ASMCA), is also installed. To install, and configure ASM instances, you
must run the ASMCA GUI utility. You also
use ASMCA to configure disk groups, volumes, as well as Oracle ACFS. ASMCA can be used as a non-GUI utility,
because it does have a command line interface.
=> You must prepare your
disk partitions to be used for the Oracle ASM disk groups.
=> Make sure that there is
at least one disk that is configured for an Oracle ASM disk group, before you
begin the installation.
=> When you install ASM,
ASMCA will create a separate server parameter file (SPFILE) and password file
for the ASM instance. When the ASM is
installed, then the ASMSNMP schema and user are created.
=> The ASM instance
manages the disk groups, and runs in the Oracle Grid Infrastructure home
directory.
Preparing your
ASM Installation
=> Firstly you need to
define and identify the Storage Requirements for your ASM configuration.
=> Then you will need to
create DAS or SAN disk partitions for ASM
=> Finally you will need to
configure the disks for ASM
From the above you may or may
not need more details on how to proceed.
One important point is to avoid using database identifiers that need to
be quoted. Because we are using a number
of different tools with ASM, there may be a point, where the quoted object
names may not be valid. Fixing this
problem up, could involve renaming the identifiers to non-quoted values. So it is best to start off with non-quoted
identifiers.
Franz
Devantier,
Need
a database health check?
devantierf@gmail.com
Classifieds
No comments:
Post a Comment