DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ASM using ASMLib and Raw Devices per oracle-base.com

Threaded View

  1. #1
    Join Date
    Aug 2005
    Posts
    16

    ASM using ASMLib and Raw Devices per oracle-base.com


    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
    Last edited by dbaxps; 05-12-2006 at 01:01 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width