dbca 建库时连不上ASM

Gooora

系统环境：RHEL6u4 x86_64
数据库软件版本11gR2(112040) x86_64
问题描述：dbca建库到第六步，Can not use ASM for database storage due to following reason
Could not connect ASM due to following error：
ORA-01017:invalid username/password:logon denied
没弹出输入ASMSNMP密码的对话框
dbca的日志在附件中

Gooora

[grid@node1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    node1      
ora.FRA.dg     ora....up.type ONLINE    ONLINE    node1      
ora....ER.lsnr ora....er.type ONLINE    ONLINE    node1      
ora....N1.lsnr ora....er.type ONLINE    ONLINE    node1      
ora.SYSTEM.dg  ora....up.type ONLINE    ONLINE    node1      
ora.asm        ora.asm.type   ONLINE    ONLINE    node1      
ora.cvu        ora.cvu.type   ONLINE    ONLINE    node1      
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    node1      
ora....SM1.asm application    ONLINE    ONLINE    node1      
ora....E1.lsnr application    ONLINE    ONLINE    node1      
ora.node1.gsd  application    OFFLINE   OFFLINE               
ora.node1.ons  application    ONLINE    ONLINE    node1      
ora.node1.vip  ora....t1.type ONLINE    ONLINE    node1      
ora....SM2.asm application    ONLINE    ONLINE    node2      
ora....E2.lsnr application    ONLINE    ONLINE    node2      
ora.node2.gsd  application    OFFLINE   OFFLINE               
ora.node2.ons  application    ONLINE    ONLINE    node2      
ora.node2.vip  ora....t1.type ONLINE    ONLINE    node2      
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    node1      
ora.ons        ora.ons.type   ONLINE    ONLINE    node1      
ora....ry.acfs ora....fs.type ONLINE    ONLINE    node1      
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    node1      

Gooora

双节点的RAC

Maclean Liu(刘相兵

action plan:

id grid
id oracle

Maclean Liu(刘相兵

ODM FINDING:

11.2.0.4 DBCA does not bring up pop-up window to enter password for SYS in ASM which results in ORA:01017 (INVALID USERNAME/PASSWORD; LOGON DENIED) (Doc ID 1597579.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
SYMPTOMS

non-RAC -- 11204 -- HP-UX Itanium (11.31)     <---- It could apply to other platforms or a 'clustered' (RAC) configuration

DBCA does not bring up the ASM Credentail pop-up (below), where one enters the password for ASM's SYS, after selecting ASM for the storage location of the database (step 6/12 - Database File Locations)






Therefore the database creation fails (even when creating the database outside of DBCA -- ie, manually or via sqlplus and using the CREATE DATABASE command)


dbca logs shows:

/oracle/app/oracle/cfgtoollogs/dbca/trace.log_OraDb11g_home3_2013-10-29_11-15-02-AM
[AWT-EventQueue-0] [ 2013-10-29 11:31:07.368 EDT ] [SQLEngine.done:2189] Done called
[AWT-EventQueue-0] [ 2013-10-29 11:31:07.371 EDT ] [ASMUtils.validateASMConnection:265] can not connect ORA-01017: in valid username/password; logon denied
[AWT-EventQueue-0] [ 2013-10-29 11:31:07.372 EDT ] [SQLEngine.done:2189] Done called

Database alert Log shows:

Tue Oct 29 11:31:07 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Errors in file /oracle/app/oracle/diag/rdbms/ctsgold/ctsgold/trace/ctsgold_asmb_9836.trc:
ORA-15055: unable to connect to ASM instance
ORA-01017: invalid username/password; logon denied
  
Database trace file


Trace file /oracle/app/oracle/diag/rdbms/ctsgold/ctsgold/trace/ctsgold_asmb_9836.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/dbhome_1
...
WARNING: failed to start ASMB (connection failed) state=0x1 sid='+ASM' home='/oracle/app/grid/product/11.2.0.4/grid'
ORA-15055: unable to connect to ASM instance
ORA-01017: invalid username/password; logon denied



CAUSE

Several things were tried like suggestions from Note:1269734.1, Note:1177483.1, Note:1468931.1, and even recreating the orapwd file from ASM, but none fix the issue.

Even tried to workaround the improper Job Role Separation (JRS) configuration, but that too did not worked. JRS is an optional feature that allows job separation between the roles of the ASM and the database administrators.

# id grid
uid=110(grid) gid=106(oinstall) groups=107(dba),108(oper),110(asmdba),111(asmoper) <----- 'asmadmin' OS role missing from 'grid'

# id oracle
uid=109(oracle) gid=106(oinstall) groups=107(dba),108(oper),110(asmdba),112(hvri)

# ls -ltra /oracle/app/grid/product/11.2.0.4/grid/bin/oracle
-rwsr-s--x 1 grid oinstall 502885304 Oct 15 15:07 /oracle/app/grid/product/11.2.0.4/grid/bin/oracle

$ ls -ltra /oracle/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 573962880 Oct 15 17:36 /oracle/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle #<--- even with 'oinstall', as the OS group, it did not worked.

$ ls -ltra /dev/rdisk
crw-rw---- 1 oracle dba 13 0x000020 Oct 9 10:41 disk70 # <----- asm disks part of the 'dba' OS group
crw-rw---- 1 oracle dba 13 0x00001b Oct 9 10:42 disk65
crw-rw---- 1 oracle dba 13 0x000016 Oct 9 10:42 disk60
crw-rw---- 1 oracle dba 13 0x000022 Oct 9 10:42 disk72

The cause was improper Job Role Separation (JRS) even the same JRS misconfiguration worked for 11.2.0.2



SOLUTION

The OS role 'asmadmin' was not assigned to the user 'grid' in this case, but other JRS misconfigurations could also lead to this condition.


The fix is not as simple as to create the OS role 'asmadmin' and assign it to 'grid' and relink the gi_home. A full deinstall of the Oracle Homes (db_home first, and then gi_home) is required.


Deinstall the db_home and then the gi_home using the 'deinstall' tool:

===> http://docs.oracle.com/cd/E11882 ... le_sw.htm#HPDBI1332   #<----- this example is for HP-UX and Standalone (ie, non-RAC)
         Oracle® Database Installation Guide
         11g Release 2 (11.2) for HP-UX
         E49316-01
         7 Removing Oracle Database Software
   
Then reconfigure JRS appropriately:

===> http://docs.oracle.com/cd/E11882 ... nstall.htm#BABHHEJD   #<----- this example is for HP-UX and Standalone (ie, non-RAC)
         Oracle® Database Installation Guide
         11g Release 2 (11.2) for HP-UX
         E49316-01
         2.9 Creating Required Operating System Groups and Users

Finally, reinstall and reconfigure the gi_home and then the db_home (including launch DBCA to create the db which then DBCA will bring up the ASM Credentail pop-up).


REFERENCES

BUG:17662103 - DBCA THROWS ORA:01017: INVALID USERNAME/PASSWORD; LOGON DENIED

Gooora

找到问题了
问题出在
oracle 加入的是asmadmin组没加入 asmdba 组

shpcwjq

[root@rac1 ~]# id oracle
uid=502(oracle) gid=1001(oinstall) 组.1001(oinstall),1002(dba),1003(oper),1006(asmdba)
[root@rac1 ~]# id grid
uid=503(grid) gid=1001(oinstall) 组1001(oinstall),1002(dba),1003(oper),1004(asmadmin),1005(asmoper),1006(asmdba)
我也是这种情况，我加入的是asmdba组，但是也不行