To start a SQL*Plus session, select Start > Programs > Oracle - OraDb10g_home1 > Configuration and Migration Tools > Database Configuration Assistant.

DBCA starts its GUI interface.

Click Next on the Welcome page.

Select Configure Automatic Storage Management and click Next.

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.

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.

Now click OK in the Database Configuration Assistant: Warning window.

Click Next on the Operations page

On the Create ASM Instance page, enter oracle in the SYS password and Confirm SYS password fields and click Next.

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.

Click Create New on the ASM Disk Groups page.

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.

On the asmtool operation page, select Add or change label and click Next.

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.

Click Next on the Stamp disks page.

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.

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:

The disk group is being created and mounted.

Click Finish on the ASM Disk Groups page.

Click No to cexit.

To view Windows Services, select Start > Settings > Control Panel > Administrative Tools > Services.

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.

Click X (the Close icon) on the top-right window frame, to close the Services window.

Open a terminal window and execute the following command:

SET ORACLE_SID=+ASM

To start a SQL*Plus session, enter:

sqlplus sys/oracle as sysdba

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;

To exit from your SQL*Plus session, enter:

exit

To point to the ORCL instance, enter in a command prompt window:

SET ORACLE_SID=ORCL

To start a SQL*Plus session, enter:

sqlplus sys/oracle as sysdba

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;

Open a terminal window and execute the following command to stop dbconsole:

emctl stop dbconsole

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.

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.

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.

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.

The first time you log in, the Licensing page appears.

Scroll to the bottom and click I agree.

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.