本文主要是介绍oracle 12.2 ORA-01017,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
oracle 12.2数据库访问ASM时,grid要添加级racdba组,has高可用不有问题,或不数据库需手动方式启动及停止
2018-11-27 13:17:25.620 :CLSDYNAM:1941952256: [ora.train6c.db]{0:0:1213} [start] InstAgent::startInstance 371 throw excp what:ORA-01017: invalid username/password; logon denied
2018-11-27 13:17:25.620 :CLSDYNAM:1941952256: [ora.train6c.db]{0:0:1213} [start] InstAgent::start 500 exception OCIException
2018-11-27 13:17:25.620 :CLSDYNAM:1941952256: [ora.train6c.db]{0:0:1213} [start] ORA-01017: invalid username/password; logon denied
[root@dbbk x86_64]# id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(asmadmin),503(asmdba),504(asmoper),506(dba)
[root@dbbk x86_64]#
[root@dbbk x86_64]#
[root@dbbk x86_64]# usermod -a -G racdba grid
[root@dbbk x86_64]#
[root@dbbk x86_64]# id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(asmadmin),503(asmdba),504(asmoper),506(dba),513(racdba)
[root@dbbk x86_64]#
[root@dbbk x86_64]#
[oracle@dbbk ~]$ srvctl start database -db train6c
[oracle@dbbk ~]$
[oracle@dbbk ~]$
[oracle@dbbk ~]$
[root@dbbk x86_64]# /u01/app/12.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dbbk STABLE
ora.LISTENER.lsnr
ONLINE ONLINE dbbk STABLE
ora.LOG1.dg
ONLINE ONLINE dbbk STABLE
ora.LOG2.dg
ONLINE ONLINE dbbk STABLE
ora.asm
ONLINE ONLINE dbbk Started,STABLE
ora.ons
OFFLINE OFFLINE dbbk STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE dbbk STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE dbbk STABLE
ora.train6c.db
1 ONLINE ONLINE dbbk Open,HOME=/u01/app/o
racle/product/12.2.0
/dbhome_1,STABLE
--------------------------------------------------------------------------------
这篇关于oracle 12.2 ORA-01017的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!