在配置11G DG的时候,尝试远程连接报错
[oracle@fahsdb152 dbs]$ sqlplus "sys/oracle@dgfahsdb as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 8 15:34:09 2023
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
结合网上的博文,排除掉listener.ora 、tnsnames.ora及防火墙的错误后
确认了是密码文件的问题,在将密码文件主库传到备库以后,忘了改名
[oracle@fahsdb152 dbs]$ ls
hc_fahsdb.dat init.ora orapwfahsdb spfilefahsdb.ora
[oracle@fahsdb152 dbs]$ mv orapwfahsdb orapwdgfahsdb
[oracle@fahsdb152 dbs]$ ls
hc_fahsdb.dat init.ora orapwdgfahsdb spfilefahsdb.ora
将名字改对后,连接成功。