Please, be advised, that follow article:-
http://www.oracle-base.com/articles/...RawDevices.php
will cause +ASM instance and prod ASM database to be installed in THE SAME ORACLE_HOME.
The last is not recommended by Oracle Inc. for 10gR2.
Per OTN :-
Installer should be used for initial +ASM instance creating , then everything is going to be fine
with starting LISTENER and registering +ASM instance with it.
More over there is pretty straight forward procedure the same for 10.1.0.2 and 10.2.0.1
which will result same configuration as article mentioned above.
+ASM instance will be created during installer run ( without leaving OUI environment) and utilized in the same OUI session for ASM production database creation.
Compare with instructions at oracle-base.com:-
Database Creation
Before continuing with the database creation, check the listener is up and the ASM instance has registered with it.
Start the listener using the following command.
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2006 14:35:46
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener .log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(POR T=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 29-APR-2006 14:35:47
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen er.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
$
The ASM instance is not registered, so we can force the registration by doing the following.
$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Apr 29 14:37:06 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr oduction
With the Partitioning, OLAP and Data Mining options
$
Checking the status of the listener shows that the ASM instance is now registered.
$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2006 14:37:32
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 29-APR-2006 14:35:47
Uptime 0 days 0 hr. 1 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen er.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
Brief extract from OTN manuals may be found at:-
http://librenix.com/?inode=7376
http://bderzhavets.blogspot.com/2005...tation-on.html
Ongoing discussion with Tim:-
http://oradot.com/node/33