 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 5 -
Automatic Storage Management
Guru Conversation for the
Senior DBA
Refer to Linux documentation on adding a new
disk using fdisk, and adding entries in the /etc/fstab file
as root. The server will
have to be rebooted for the new disk to be visible in the
operating system. Once the disk
is added to Linux and
used for ASM files with DBCA,
the following errors may be
encountered: ORA-15018, diskgroup cannot be created;
ORA-15059, invalid device type for ASM disk. These errors have been
reported only on Linux platforms, and can be rectified by creating
files instead of real devices.
Assuming an
80 GB disk is added to a Linux server. Also assume that when it was
used one of the previously mentioned ORA errors was generated.
The solution is to create new files to be used by ASM as free
devices instead of real disks.
The following steps could
be attempted as an oracle user or as a root
user. If using root,
permissions may have to be
changed on the files to be seen by ASM. Veteran DBAs with
Linux experience may know how to run many of these individual
commands in a single step.
Step 1 - Create new files using dd
command. If the complete
space out of the last disk is not achieved, reduce the
count to 8000000.)
$dd
if=/dev/zero of=file_dsk1 bs=1k count=10000000
$dd if=/dev/zero of=file_dsk2 bs=1k count=1000000
$dd if=/dev/zero of=file_dsk3 bs=1k count=10000000
$dd if=/dev/zero of=file_dsk4 bs=1k count=10000000
$dd if=/dev/zero of=file_dsk5 bs=1k count=10000000
$dd if=/dev/zero of=file_dsk6 bs=1k count=10000000
$dd if=/dev/zero of=file_dsk7 bs=1k count=10000000
$dd if=/dev/zero of=file_dsk8 bs=1k count=10000000
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
