12c的grid里
sqlplus / as sysdb ok
sqlplus / as sysasm ok
sqlplus sys/sys_pw as sysdba ok
sqlplus sys/sys_pw as sysasm NG
解决法子在这里
http://www.sqlplus.ca/blog/?p=1142
[grid@orasrv ~]$ ls -l $ORACLE_HOME/dbs
total 12
-rw-rw----. 1 grid oinstall 1328 Jan 19 15:41 ab_+ASM.dat
-rw-rw----. 1 grid oinstall 1544 Jan 19 15:41 hc_+ASM.dat
-rw-r--r--. 1 grid oinstall 2992 Feb 3 2012 init.ora
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE TRUE FALSE FALSE FALSE 0
ASMSNMP TRUE FALSE FALSE FALSE FALSE FALSE 0
[grid@orasrv ~]$ srvctl config asm -a
ASM home: <CRS home>
Password file: +DG_GRID/orapwasm
ASM listener: LISTENERASM
Spfile: +DG_GRID/ASM/ASMPARAMETERFILE/REGISTRY.253.865375963
ASM diskgroup discovery string: /dev/raw/*
ASM is enabled.
ASM is individually enabled on nodes:
ASM is individually disabled on nodes:
我的orapwasm缺是有的。sys也已经有了 SYSAS =true,想不通。
后来,connect / as sysasm后修改sys密码,alter user sys identified by oracle居然过了。
莫非asm实例的sys密码还有两份?一份给sysdba一份给sysasm?莫名其妙。
没有评论:
发表评论