dbca 建库时连不上ASM
系统环境：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的日志在附件中
$ 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 双节点的RAC action plan:
id grid
id oracle 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
[ 2013-10-29 11:31:07.368 EDT ] Done called
[ 2013-10-29 11:31:07.371 EDT ] can not connect ORA-01017: in valid username/password; logon denied
[ 2013-10-29 11:31:07.372 EDT ] 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_01/install.112/e49316/remove_oracle_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_01/install.112/e49316/pre_install.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 找到问题了
问题出在
oracle 加入的是asmadmin组没加入 asmdba 组 # id oracle
uid=502(oracle) gid=1001(oinstall) 组.1001(oinstall),1002(dba),1003(oper),1006(asmdba)
# id grid
uid=503(grid) gid=1001(oinstall) 组1001(oinstall),1002(dba),1003(oper),1004(asmadmin),1005(asmoper),1006(asmdba)
我也是这种情况，我加入的是asmdba组，但是也不行
页:
[1]