搭建DG环境，RMAN duplicate 过程中报ORA-01017错误：http://www.cndba.cn/cndba/dave/article/2994

[oracle@www.cndba.cn admin]$ rman target sys/oracle@cndba_p auxiliary sys/oracle@cndba_s;
Recovery Manager: Release 18.0.0.0.0 - Production on Fri Aug 31 00:54:12 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: 
ORA-01017: invalid username/password; logon denied

根据错误提示，是用户名和密码问题。 http://www.cndba.cn/cndba/dave/article/2994http://www.cndba.cn/cndba/dave/article/2994http://www.cndba.cn/cndba/dave/article/2994

[oracle@www.cndba.cn admin]$ sqlplus dave/oracle@orcl_p

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Aug 31 00:55:42 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4150
Additional information: -784922381
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: ^C

这里首先需要验证用户名和密码是否正确，如果错误可以使用orapwd修改。
Oracle 18c orapwd 命令 OPW-00029 错误说明
https://www.cndba.cn/dave/article/2981http://www.cndba.cn/cndba/dave/article/2994http://www.cndba.cn/cndba/dave/article/2994

如果密码没有问题，那么可能是监听文件中配置错误：http://www.cndba.cn/cndba/dave/article/2994http://www.cndba.cn/cndba/dave/article/2994

[oracle@www.cndba.cn dbs]$ ps -ef|grep smon
oracle   13392  8789  0 15:58 pts/5    00:00:00 grep --color=auto smon
oracle   29261     1  0 15:33 ?        00:00:00 ora_smon_cndba
[oracle@www.cndba.cn dbs]$

也有可能是监听文件中的SID_NAME配置错误。 开始用的是大写的CNDBA，后来改成小写，操作正常。

[oracle@www.cndba.cn admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/18.3.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = cndba)
      (ORACLE_HOME = /u01/app/oracle/product/18.3.0/db_1)
      (SID_NAME = cndba)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 18cDG1)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
  )

[oracle@www.cndba.cn dbs]$ sqlplus dave/oracle@cndba_p

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Aug 31 00:57:36 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。