Datasheet

Working with the ASM Instance

EXERCISE 1.1

Creating an ASM Instance with the DBCA.

To create the ASM instance with the DBCA, do the following:

1. Start the Oracle DBCA.

2. The DBCA presents a list of options for you to choose from. Select Conﬁgure Auto-

matic Storage Management and click Next.

3. The DBCA then prompts you for the SYS password for the new ASM instance to be

created. Enter the password for the

SYS account.

4. Oracle then creates the ASM instance. A new window appears giving you the option

to create new disk groups. You can choose to create disk groups (we will cover that

shortly) or you can click Finish to complete the ASM instillation.

5. The name of the resulting instance will be +ASM. You can log into the ASM instance

from SQL*Plus, as shown in this example:

C:\Documents and Settings\Robert>Set ORACLE_SID=+ASM

C:\Documents and Settings\Robert>Sqlplus sys/Robert as sysasm

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 14 19:55:33 2008

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

With the Partitioning, OLAP and Data Mining options

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

+asm

When we logged into the ASM instance, we did so using the SYSASM

role. This role is much like the SYSDBA role when logging into a database

and should be used when logging into an ASM instance for administrative

purposes.

Creating the ASM Instance Manually

Manual creation of an ASM instance is fairly straightforward. If you have ever manually

created a database, then manually creating an ASM instance should be easy for you. To

manually create an ASM instance, you would follow these steps:

1. Create directories for the ASM instance.

2. Create the instance parameter file.

95134c01.indd 5 1/28/09 9:43:40 AM