I was very used to create ASM instance manually before 11gR2. With 11gR2 we must to install Grid Infrastructure even on sigle instance databases if we’re going to use ASM. In my last installation i had strange errors that i’ll share below. First error was complaining about the password and the log file is:

INFO: Executing ASMCA
INFO: Command /u01/app/oracle/product/11.2.0/grid/bin/asmca -silent -oui_internal -configureASM -diskString '/dev/ORACLE/ASMDISKS/*' -diskGroupName DATA -diskList /dev/ORACLE/ASMDISKS/hostx_asm0,/dev/ORACLE/ASMDISKS/hostx_asm1 -redundancy EXTERNAL
INFO: ... GenericInternalPlugIn.handleProcess() entered.
INFO: ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: ... GenericInternalPlugIn: checking secretArguments.
INFO: ... GenericInternalPlugIn: starting read loop.
INFO: Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
INFO: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
INFO: End of argument passing to stdin
INFO: Read:
INFO: Read: Configuring ASM failed with the following message:
INFO: Read: Adding Monitor user failed. The following error occured:
INFO: Read: ORA-00922: missing or invalid option
INFO: Read:
INFO: Read:
INFO: Completed Plugin named: Automatic Storage Management Configuration Assistant
INFO: Automatic Storage Management Configuration Assistant failed.
INFO: Automatic Storage Management Configuration Assistant failed.
INFO: ConfigClient.executeToolsInAggregate action performed
INFO: Exiting ConfigClient.executeToolsInAggregate method                                          INFO: Calling event ConfigToolsExecuted

Installer raised error and quit. Because ASM configuration failed, i run” asmca” to create ASM instance. However, asmca also failed to create the instance and raised the same error.
I checked google and found the solution in the OTN forum.
It was because of the ASM sys password that installer asks for. My entry was alphanumeric and this was the problem!! I tried a simple lower case password and magically got rid of this strange error.

But that was not all. This time it wasn’t able to use the ASM disks with the following errors.

ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/ORACLE/ASM/hostx_asm0' matches no disks
ORA-15014: location '/dev/ORACLE/ASM/hostx_asm0' is not in the discovery set

 I was familiar with these errors. What i know was two reasons may cause this.
  • Misconfigured ”asm_diskstring” parameter: If wildcard was not set correctly, this errors may occur. I tried some different discovery paths but no chance :(
  • Not empty ASM disks as stated on the following doc.

“Disk Is not Discovered in ASM, Diskgroup Creation Fails with Ora-15018 Ora-15031 Ora-15014 [ID 431013.1]
Use the option FORCE of the "create diskgroup" or "alter diskgroup add disk" to enforce overriding the previous content of the disk.
If it really doesn't work, then in very last option :
Use dd to clean up the disk header of all the disks that are not discovered by the ASM instance.” 

This also didn’t work. I checked the headers and disks were all empty.

Then i remember the strange error about the ASM sys password and thought if this may be related with the entries (disk path, name etc.) that i write on the asmca screen. Maybe what i see on the screen was not same with what oracle see :)

Then decided to use silent installation on the command line to be sure (and hoping) that this is not the cause. And the result is below:

bash-3.2$ ./asmca -silent -configureASM -sysAsmPassword oracle -asmsnmpPassword oracle -diskString '/dev/ORACLE/ASM/*' -diskGroupName DATA -disk '/dev/ORACLE/ASM/hostx_asm0' -redundancy external
ASM created and started successfully.
DiskGroup DATA created successfully.

7 Responses so far.

  1. uhesse says:

    Pardon me if this is too obvious, but isn't the diskstring different in your 2 examples? First it reads /dev/ORACLE/ASM/*, second reads /Dev/ORACLE/ASM/* with a capital D

  2. Hi Uwe,
    It's all blogger's fault to capitilize "dev"s. :)
    They were all lower case when i edit the post. I have some trouble to communicate with the computers these days:)

    I fixed the post, thanks for noticing.


  3. I really enjoyed reading is g your post. Thank you for sharing so nice and helpful ideas to readers who do not have to face this problem again in their project
    Oracle SQL

  4. Anonymous says:

    Hi! I am a digital marketer. The previous seo guy working for my client left a spammy comment at your blog with the username Ascencion Rana which links to my client's site.
    Such comments are or might cause serious damage to my client's site with respect to SEO which is why I am request you here by to remove it asap.
    If you don't remove it by 11:59 pm, Pacific Standard Time, 3rd January 2014, we will have use Google's Disavow Tool to get back-link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment. Thanks in advance for your cooperation.

  5. very informative article.And very well explained about different protocols.keep posting like good content posts.For more details please visit our website.

    Oracle Fusion Training Institute

  6. ERP says:

    ERPTREE is a leading oracle fuison HCM Training Institute. we offer this course through online we have great experience in succeeding students through online courses. we can calculate our performance through their honest comments in our sites in supporting our services. we have referral program so candidates can earn money through referral. you can share your live experience with other can generate you some money.

    Oracle fusion HCM Online Training

    Oracle Fusion HCM Training

  7. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor
    lead live training in Oracle Fusion Financials online Training , World Class Virtual Instructor led training on Oracle fusion Financials Training. We have industry expert trainer. We provide Training Material and Software Support. calfre has successfully conducted 100000+ trainings in India, USA, UK, Australlia,
    Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.

DOAG 2016

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -