Get the App
SLTechnology News&Howtos  ›  Database  › 

The ASM disk was not found when DBCA built the library.

Shulou Source: shulou.com Published: 2022-06-01 11:41:15 11月17日 Update

Experimental environment:

Operating system: RedHat 6.4

Database version: Oracle 11.2.0.2.0

When creating a database using DBCA, it was found that the ASM disk group could not be found:

Error troubleshooting:

1. Execute:

/ usr/sbin/oracleasm listdisks

Looking at the execution result, listdisk can display the disk group normally.

2. Switch to grid user, check whether the ASM instance is started, and execute the query

Select group_number,path,mount_status,state from v$asm_disk

Id oracle and id grid

Check to see if oracle users are in the admdba group

4. Permission to view the $ORACLE_HOME/bin/oracle file of oracle and grid users

$ORACLE_HOME/bin/oracle the default permission of this file is 6751 permissions, and there is an s permission. If the s permission disappears, you will not be able to log in to the database through OS authentication.

After examining the problems one by one, we finally found out where the problem lies:

Execute chmod + s oracle to solve the problem

Summary:

The problem that the ASM disk cannot be found in the DBCA library is:

1. Incorrect permission setting for oracle user.

2. ASM instance was not started or diskgroups are not mounted.

3. The diskgroup resources are not online.

4. The permission setting for the asm devices are incorrect.

5. The oracle executable under / bin has incorrect permission settings.

6. The file system for grid home was mounted with option 'nosuid'.

Author: SEian.G

◇ this article is sorted out from the network

◇ article is available at ITPUB: http://blog.itpub.net/31015730/

51CTO: synchronous updates on http://seiang.blog.51cto.com/

◇ article itpub address: http://blog.itpub.net/31015730/viewspace-2137066/

◇ article 51CTO address: http://seiang.blog.51cto.com/10819863/1915404

Tags: Permissions user problem disk data database address location file operating system author instance time version environment system result network error switch Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Shulou Technology Microsoft Huawei OPPO Reno