Purpose
This tutorial
illustrates how Automatic Storage Management (ASM) can be implemented on a
small scale (as a confidence-building exercise).
Time to Complete
Approximately 60 minutes
This tutorial covers the
following topics:
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Viewing Screenshots
Place the cursor over this icon to load
and view all the screenshots for this tutorial. (Caution: This action loads all
screenshots simultaneously, so response time may be slow depending on your
Internet connection.)
Note: Alternatively, you can place the cursor over an
individual icon in the following steps to load and view only the screenshot
associated with that step. You can hide an individual screenshot by clicking
it.
Automatic Storage Management (ASM) provides a vertical integration
of the file system and the volume manager which is specifically built for
Oracle database files. This example illustrates how to configure ASM for a
single database instance.
Use the Database Configuration Assistant (DBCA) for configuring ASM, which includes creating and
starting an ASM instance and creating a disk group with two "disks".
Then you test the installation by confirming that:
- All relevant Windows Services
are started
- You can query the +ASM instance in SQL*Plus
- You can use your ASM installation by creating a
tablespace and a table with a row in the ORCL instance
Enterprise Manager can
display information about the ASM instance. To do so, modify Enterprise Manager
with the Enterprise Manager Configuration Assistant (emca). Finally, test the reconfigured Enterprise
Manager Database Console.
Note: This tutorial is a
prerequisite for the Managing Automatic Space Management Disk Groups tutorial.
On your database server,
there is no ASM instance running. You decide to create one, as well as a disk
group. The disk group uses "disks" in form of existing unformatted
partitions of 196 MB. Before a disk can be used by a disk group, its header has
to be stamped. Then you decide to create a test tablespace in SQL*Plus, to
confirm that you have access to the +ASM instance. You also want to use Enterprise Manger as a tool to
manage ASM, so you need to reconfigure it.
Before starting this
tutorial, you should:
|
1.
|
|
|
2.
|
|
|
3.
|
Prepare disk groups
|
To install ASM, you need
to have one or more unformatted "raw" partitions available. This
tutorial uses partitions on G,
H, I and J of each 196 MB.
Note: Creating disk
partitions is a sensitive operation, which should only be executed by qualified
system administrators. For more information about preparing disk groups for an
Automatic Storage Management installation, see the Oracle Database
Installation Guide 10g Release 2 (10.2) for Microsoft Windows.
To create an ASM instance and a disk group with DBCA, perform the
following steps:
|
1.
|
To start a SQL*Plus
session, select Start > Programs > Oracle - OraDb10g_home1 >
Configuration and Migration Tools > Database Configuration Assistant.
DBCA starts its GUI
interface.
|
|
2.
|
Click Next on the Welcome page.
|
|
3.
|
Select Configure Automatic Storage Management and click Next.
|
|
4.
|
A Database
Configuration Assistant: Warning window informs you of your next steps.
Note your path. You
may see a different path depending on your Oracle home value.
|
|
5.
|
Open a command prompt
window and enter the following command with the path from the previous
window:
e:\oracle\ora10g\bin\localconfig
add
After the batch file
added a CSS service, click the Close icon on the top-right window frame to close the command window.
|
|
6.
|
Now click OK in the Database Configuration Assistant:
Warning window.
|
|
7.
|
Click Next on the Operations page
|
|
8.
|
On the Create ASM
Instance page, enter oracle in the SYS password and Confirm SYS password fields and click Next.
|
|
9.
|
A message appears
informing you that DBCA will create and start the ASM instance. Click OK.
The ASM Instance
Creation window appears, then
the ASM Disk Groups page.
|
|
10.
|
Click Create
New on the ASM Disk Groups
page.
|
|
11.
|
On the Create Disk
Group page, enter DGROUP1 as Disk Group Name. If
you are using disks, which have never been used for ASM, click Stamp Disks.
Alternatively, if you
are using disks, which have been previously used for ASM, you do not need to
stamp their header. Please proceed to step 16.
|
|
12.
|
On the asmtool
operation page, select Add or change label and click Next.
|
|
13.
|
With click and Shift+click, select partitions 6,7,8 and 9 on the Select disks page. If your partitions are stamped for the
first time, they appear with the Status "Candidate device". If the
they have been previously stamped, and the label has been deleted, they
appear with the status "Unstamped ASM device". Click Next.
|
|
14.
|
Click Next on the Stamp disks page.
|
|
15.
|
Click Finish on the Message ASM page.
Wait until the disks
appear on the Create Disk Group page. They have the Header Status PROVISIONED because they are not yet assigned to a disk
group.
|
|
16.
|
On the Create Disk
Group page, select Show All. then select the disks with the \\.\ORCLDISKDATA0 and\\.\ORCLDISKDATA1 path, and click OK.
If you are working
with newly stamped disks, they look like the following screenshot:
If they have been
previously used for ASM, they look like this:
|
|
17.
|
The disk group is
being created and mounted.
|
|
18.
|
Click Finish on the ASM Disk Groups page.
|
|
19.
|
Click No to cexit.
|
To test your ASM
installation, perform the following steps:
|
|
|
|
|
|
|
|
To view your ASM and CSS
services on Windows, perform the following steps:
|
1.
|
To view Windows
Services, select Start > Settings > Control Panel >
Administrative Tools > Services.
|
|
2.
|
Scroll down to the
Oracle services and confirm that the following services are started; if not,
use Actions > Start, to start them: OracleASMService+ASM, OracleCSService,
OracleDBConsoleorcl, OracleOraDb10g_homeTNSListener and OracleServiceORCL.
|
|
3.
|
Click X (the Close icon) on the top-right window
frame, to close the Services window.
|
To view disk group
characteristics, perform the following steps:
|
1.
|
Open a terminal window
and execute the following command:
SET ORACLE_SID=+ASM
|
|
2.
|
To start a SQL*Plus
session, enter:
sqlplus sys/oracle as
sysdba
|
|
3.
|
Execute the following
command to query ASM information:
@c:\wkdir\query
The query.sql file includes the following command:
select name, state,
type, total_mb, free_mb from v$asm_diskgroup;
|
|
4.
|
To exit from your
SQL*Plus session, enter:
exit
|
To use your ASM
installation, create a tablespace and a table with one row in the ORCL instance. Perform the following steps:
|
1.
|
To point to the ORCL instance, enter in a command prompt window:
SET ORACLE_SID=ORCL
|
|
2.
|
To start a SQL*Plus
session, enter:
sqlplus sys/oracle as
sysdba
|
|
3.
|
To create objects in
the ORCL schema, execute the following commands:
@c:\wkdir\create
The create.sql file includes the following commands:
create tablespace tbs1
datafile '+DGROUP1' size 20M;
create table tab1
(col1 number) tablespace tbs1;
insert into tab1
values (-44);
commit;
|
If this is the first
time, that you are creating an ASM instance, you need to reconfigure dbcontrol with the Enterprise Manager Configuration
Utility (emca) untility. This reconfiguration allows you to
access ASM information from Enterprise Manager Database Control. Perform the
following steps:
|
1.
|
Open a terminal window
and execute the following command to stop dbconsole:
emctl stop dbconsole
|
|
2.
|
To recreate the
Enterprise Manager repository, enter the following command:
emca -repos recreate
Provide parameters for
the repository re-creation. Enter at the appropriate prompt:
Database SID: orcl
Listener port number: 1521 Password for SYS user: oracle <the password does not appear > Password for SYSMAN user: oracle <the password does not appear > Do you wish to continue? [yes(Y)/no(N)]: y
Then wait. The
re-creation of the Enterprise Manager repository may take about 15 minutes
depending on your system setup.
|
|
3.
|
To deconfigure dbcontrol, enter the following command:
emca -deconfig
dbcontrol db
Enter the following
values when prompted:
Database SID: orcl
Do you wish to continue? [yes(Y)/no(N)]: y
The deconfiguration is
generally faster than the repository re-creation. The actual time depends on
your system setup.
|
|
4.
|
To reconfigure dbcontrol, enter the following command:
emca -config dbcontrol
db
Provide parameters for
the reconfiguration. Enter the following values when prompted:
Database SID: orcl
Listener port number: 1521 Password for SYS user: oracle <the password does not appear > Password for DBSNMP user: oracle <the password does not appear > Password for SYSMAN user: oracle <the password does not appear >
Enter nothing for the
next questions (just press the Enter key):
Email address for
notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional): ASM ORACLE_HOME [E:\oracle\product\10.2.0\db_1 ]: ASM SID [ +ASM ]: ASM PORT [ 1521 ]: ASM user role [ SYSDBA ]: ASM username [ SYS ]:
Enter at the prompt:
ASM user password: oracle <the password
does not appear >
ASM user password: oracle <the password does not appear > Do you wish to continue? [yes(Y)/no(N)]: y
The actual time for
the reconfiguration depends on your system setup.
|
To test your
reconfiguration, perform the following steps:
|
1.
|
Open your browser and
enter the following URL (Replace <hostname> with your own host name or IP address):
http://<hostname>:1158/em
Enter sys as User Name, oracle as Password, SYSDBA in the Connect As
field, and click Login.
|
|
2.
|
The first time you log
in, the Licensing page appears.
Scroll to the bottom
and click I agree.
|
|
3.
|
The Database home page
appears with the ASM link in the General section.
Note: This tutorial is a
prerequisite for the Managing Automatic Space Management Disk Groups tutorial.
|
In this tutorial, you
learned how to:
|
|
Create an ASM instance
and a disk group
|
|
|
Test your ASM installation
|
|
|
Reconfigure and test
Enterprise Manager as ASM tool
|
Place the cursor over this icon to hide all screenshots.
No comments:
Post a Comment