November 17 2015

DG里报错ORA-16191

DGMGRL> ADD DATABASE sbdb AS CONNECT IDENTIFIER IS sbdb MAINTAINED AS PHYSICAL;
Error: ORA-01017: invalid username/password; logon denied

这个时候查看alert.log

Error 1017 received logging on to the standby
————————————————————
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
————————————————————
PING[ARC2]: Heartbeat failed to connect to standby ‘sbdb’. Error is 16191.

 

解决方法:

[oracle@ucjmh dbs]$ ls
dr1orcl.dat dr2orcl.dat hc_orcl.dat init.ora initsbdb.ora lkSBDB orapwsbdb spfileorcl.ora
dr1sbdb.dat dr2sbdb.dat hc_sbdb.dat initorcl.ora lkORCL orapworcl snapcf_orcl.f spfilesbdb.ora
[oracle@ucjmh dbs]$ cp orapworcl orapwsbdb
[oracle@ucjmh dbs]$ ls
dr1orcl.dat dr2orcl.dat hc_orcl.dat init.ora initsbdb.ora lkSBDB orapwsbdb spfileorcl.ora
dr1sbdb.dat dr2sbdb.dat hc_sbdb.dat initorcl.ora lkORCL orapworcl snapcf_orcl.f spfilesbdb.ora
[oracle@ucjmh dbs]$

 

不知道为什么 真是奇怪 这个文件明明也是刚创建的



Copyright 2019. All rights reserved.

Posted 2015年11月17日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *