Errors Caused by Oracle user group errors

I have read many friends who have started to pay attention to 11gr2 and started to start cluster of 11gr2. Today I met another friend who encountered an error in installing 11gr2.

 

This friend deployed the standalone grid infrastructure. Since it uses grid infrastructure, ASM is the first choice for database storage. Grid infrastructure is successfully installed. The status is as follows:

 

[Grid @ rac11g1 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. Data. DG ora... Up. type online rac11g1
Ora... er. lsnr ora... er. type online rac11g1
Ora. ASM ora. ASM. type online rac11g1
Ora.css D. type online rac11g1
Ora. diskmon ora... on. type online rac11g1

 

Although the crs_xxxx series commands are no longer recommended in 11gr2, The crs_xxxx series is used in 10 Gb. The best method in 11gr2 is

 

[Grid @ rac11g1 ~] $ Crsctl stat res-T
--------------------------------------------------------------------------------
Name target State server state_details
--------------------------------------------------------------------------------
Local resources
--------------------------------------------------------------------------------
Ora. Data. DG
Online online rac11g1
Ora. listener. lsnr
Online online rac11g1
Ora. ASM
Online online rac11g1 started
--------------------------------------------------------------------------------
Cluster resources
--------------------------------------------------------------------------------
Ora.css d
1 online rac11g1
Ora. diskmon
1 online rac11g1

 

Grid infrastructure is OK. The problem is that after the database is installed, dbca is used to create a database.

 

When creating a database in dbca, there is a problem when selecting the target directory of the database file. If you use ASM for storage, select a diskgroup.

 

However, the diskgroup list is empty.

 

From the ora. data. from the perspective of DG, there is already a data diskgroup In the ASM instance that is online, so the ASM instance is correct. Why is there no option here? If so, the steps after dbca cannot be performed. What is the problem.

 

Analyze the data.

 

Here is the dbca database, and the log is the dbca log. to quickly diagnose faults, we must be familiar with various logs. In this way, the cause of the error can be found. Here, the dbca log is under export toollogs/dbca.

 

Where an error is found

[AWT-EventQueue-0] [00:15:18. 970 CST] [asmutils. loaddiskgroups: 713] ORA-01031: insufficient privileges

Obviously, it is a permission issue. Check the user group of an Oracle user

[Oracle @ rac11g1 lib] $ ID
Uid = 501 (Oracle) gid = 501 (oinstall) groups = 501 (oinstall), 502 (DBA), 503 (asmadmin)

 

Here asmadmin is sysasm. Here it should be asmdba, not SysAdmin.

 

Use the root user to modify the Oracle user group

[Root @ rac11g1 ~] # Usermod-G oinstall, DBA, asmdba Oracle

 

[Root @ rac11g1 ~] # ID Oracle
Uid = 501 (Oracle) gid = 501 (oinstall) groups = 501 (oinstall), 502 (DBA), 504 (asmdba)

Start dbca and you can see diskgroup,

 

For the differences between these groups, see Hunter's installation documentation.

Http://www.oracle.com/technology/global/cn/pub/articles/hunter-rac11gr2-iscsi-2.html

 

 

Oracle Technology Forum
Http://www.oraforum.com