怪异的ORA-01017错误

郑全

准备使用dg技术单机往rac进行数据同步

rac一台机器上建立了静态监听:

[oracle@rac03 dbs]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-SEP-2016 19:05:11

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                19-SEP-2016 17:07:39
Uptime                    0 days 1 hr. 57 min. 34 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/base/diag/tnslsnr/rac03/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.221)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.103)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "newdg" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

[dbserver1::/u01/app/oracle/product/11.2.0/db_1/dbs]$   sqlplus /nolog
c
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 19 16:12:33 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL>   conn sys/sztech2016@192.168.10.221:1521/orcl as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


大家一般遇到这个错误,都认为是密码错误，我也不例外，我重建了口令文件，问题依旧，把单机的口令文件拷贝过来，都不行，有人说数字要用双引号引上，我也试了。
在多次尝试后，才发现，这个监听的实例名字，是orcl，而我这里是rac，实例名为orcl1，看来问题应该找到，修改监听名字为orcl1后，问题解决。




SQL>  conn sys/sztech2010@192.168.10.221:1521/orcl as sysdba
Connected.