Solution to Oracle11g + ASMDBCA database creation Problems

After the ASM instance is installed and started properly, the ASM disk group can detect it. Oracle software is installed normally. Then, when DBCA creates a database, select the

After the ASM instance is installed and started properly, the ASM disk group can detect it. Oracle software is installed normally. Then, when DBCA creates a database, select the

Environment: AIX 6.1, Oracle11g ASM

After the ASM instance is installed and started properly, the ASM disk group can detect it.

Oracle software is installed normally.

Then, when creating a database in DBCA, select the ASM disk until the file storage is selected, and the disk group is not displayed on the graphic interface,

Enter manually + datadg to start prompting ORA-12705 error, solution:

ORA-12705: Cannot access NLS data files or invalid environment specified.

Solution: set the following two environment variables correctly.

Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Export ORA_NLS10 =/u01/app/oracle/product/11.2.0/dbhome_1/nls/data

After the above problem is solved, the disk still cannot be detected. manually enter the ASM address and the following error is prompted:

Can not connect to asm due to following error: ORA-01031: insufficient privileges

Solution:

Here I will add my oracle users to the asmdba group.
At the beginning, the two users were like this.
[Root @ FINAPROD/] # id oracle
Uid = 901 (oracle) gid = 901 (oinstall) groups = 903 (region), 902 (dba), 904 (asmadmin)
[Root @ FINAPROD/] # id grid

Uid = 1100 (grid) gid = 901 (oinstall) groups = 902 (dba), 904 (asmadmin), 905 (asmdba), 906 (asmoper)

After modification:

[Root @ FINAPROD/] # id oracle
Uid = 901 (oracle) gid = 901 (oinstall) groups = 903 (region), 902 (dba), 904 (asmadmin), 905 (asmdba)
[Root @ FINAPROD/] # id grid
Uid = 1100 (grid) gid = 901 (oinstall) groups = 902 (dba), 904 (asmadmin), 905 (asmdba), 906 (asmoper)

The above two questions have left me around for a long time and I will record them for reference.

However, there may be many problems with the ASM Disk not found. I am only one of them.

Recommended reading:

How to change the password of ASM sys

How to copy data files in ASM to the Operating System

Restoration After all Oracle 11g rac asm disks are lost

Oracle 11g from entry to proficient in PDF + CD source code

Installing Oracle 11g R2 using RHEL6 ASM

Oracle 10g manual creation of the ASM Database

Solutions to various problems after installing Oracle 11gR2 in Ubuntu 12.04 (amd64)

How to change the sys password of Oracle 10g ASM